| How to set org_id in apps [message #203945] |
Fri, 17 November 2006 00:41  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
