[dev2008]

Hi,
I am using a shell to retrieve the org_id of the operating unit from oracle. is there any particular syntax for org_id like u have REQID for concurrent request?

Can anyone help me with this?

Thanks

[amitpatel66]

You can fetch the value from the profile $PROFILE$.ORG_ID or you can try using the below standard functions:

FND_PROFILE.VALUE('ORG_ID');

Connect to SQL from UNIX,get the ORG ID after setting the environment using FND_GLOBAL.APPS_INITIALIZE(v_USER_ID,v_RESP_ID, v_RESP_APPL_ID);