Home » Applications » Oracle Fusion Apps & E-Business Suite » How to set org_id in apps
How to set org_id in apps [message #203945] Fri, 17 November 2006 00:41 Go to next message
naveenverma
Messages: 4
Registered: November 2006
Location: Faridabad
Junior Member
Dear Sir,

How to set Org_Id

I hv use syntax

begin
fnd_client_info.set_org_context(10);
end;

select * from fnd_user;

then this will show only record for org_id 10.

But this is not showing of 10 , this is showing records for all org_id.

Thanx & Rgds

Naveen
Re: How to set org_id in apps [message #203999 is a reply to message #203945] Fri, 17 November 2006 05:12 Go to previous messageGo to next message
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
Senior Member
Naveen,

Not all applications in the Oracle E-Business Suite have multi-org functionality, the Oracle Application Library is one of those without.

FND_USER is table and not a view on top of a a multi-org table and as such you would not expect the query to return rows belonging to only one organisation.

Generally, multi-org tables have names ending with "_ALL", have a corresponding view with the same name without the "_ALL"-suffix and have a column named "ORG_ID".

If you have set the application context correctly you should only get rows for your organisation when you query the view. Use FND_GLOBAL.APPS_INITIALIZE to set the application context. See the Oracle Application Developer's Guide, Chapter 30 FNDSQF Routine APIs for details on the FND_GLOBAL API.

For information about multiple organisations in the Oracle E-Business Suite you should take a look at the Multiple Organizations in Oracle Applications manual.

--
Aleksander Dragnes
Re: How to set org_id in apps [message #204010 is a reply to message #203945] Fri, 17 November 2006 05:33 Go to previous message
Rajkumar_mj
Messages: 18
Registered: July 2006
Location: Chenna
Junior Member
Naveen

You can use this following to set org_id

Begin
dbms_application_info.set_client_info(org_id);
end;
Previous Topic: PA.PA_LOOKUPS 11.0.3 to 11i upgrade
Next Topic: Concurrent programm request error
Goto Forum:
  


Current Time: Fri Dec 09 00:21:53 CST 2016

Total time taken to generate the page: 0.28917 seconds