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
Messages: 4
Registered: November 2006
Location: Faridabad
Junior Member
Dear Sir,

How to set Org_Id

I hv use syntax


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

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
Messages: 241
Registered: February 2005
Location: Oslo, Norway
Senior Member

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
Messages: 18
Registered: July 2006
Location: Chenna
Junior Member

You can use this following to set org_id

Previous Topic: PA.PA_LOOKUPS 11.0.3 to 11i upgrade
Next Topic: Concurrent programm request error
Goto Forum:

Current Time: Fri Oct 28 16:42:38 CDT 2016

Total time taken to generate the page: 0.07401 seconds