OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how we can identify current organisation id in the case of multi org environment.

Home » Applications » Oracle Fusion Apps & E-Business Suite » how we can identify current organisation id in the case of multi org environment.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how we can identify current organisation id in the case of multi org environment. [message #180816]

Wed, 05 July 2006 07:12

yedla.harsha@gmail.com
Messages: 4
Registered: July 2006

Junior Member

hai

how we can find current org id in the case of multi org environment.

thanking you sir,
Y.HarshaVardhan.

Report message to a moderator

Re: how we can identify current organisation id in the case of multi org environment. [message #180824 is a reply to message #180816]

Wed, 05 July 2006 07:31

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

TO_NUMBER(RTRIM(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))

See MetaLink note 130339.1.

Report message to a moderator

Re: how we can identify current organisation id in the case of multi org environment. [message #180878 is a reply to message #180824]

Wed, 05 July 2006 11:48

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

Or simply:

FND_GLOBAL.ORG_ID.

--
Aleksander Dragnes

[Updated on: Wed, 05 July 2006 11:49]

Report message to a moderator

Re: how we can identify current organisation id in the case of multi org environment. [message #180977 is a reply to message #180878]

Thu, 06 July 2006 02:45

konka_kiran
Messages: 56
Registered: May 2006
Location: Bangalore

Member

Hi,

Try to use

= $Profile$.Org_id if you want to access at the run time, through Forms Personalization/Custom.pll

or

v = fnd_profile.name_in('Org_id') or fnd_profile.Value('Org_id')
in the script.

Regards,
Kiran

Report message to a moderator

Previous Topic:	Leave of Absence (SSHR)
Next Topic:	rage key flexfields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 12:54:38 CDT 2024