Retrieving org id through unix shell

[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_I D or you can try using the below standard functions:

FND_PROFILE.VAL UE('ORG_ID');

Connect to SQL from UNIX,get the ORG ID after setting the environment using FND_GLOBAL.APPS _INITIALIZE(v_U SER_ID,v_RESP_I D, v_RESP_APPL_ID) ;