Home » Applications » Oracle Fusion Apps & E-Business Suite » FND_PROFILE.VALUE('ORG_ID') yields no value, USERENV('CLIENT_INFO') gives value
FND_PROFILE.VALUE('ORG_ID') yields no value, USERENV('CLIENT_INFO') gives value [message #351627] Wed, 01 October 2008 15:04 Go to next message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
I tried using the following

SELECT fnd_profile.value('ORG_ID') from dual;
to get the org_id in TOAD/SQL PLus but it yields 0 everytime.

But when i use

SELECT USERENV('CLIENT_INFO') from dual;

it gives me the output as 291


I did the following before running the above queries

begin
   dbms_application_info.set_client_info('291');
end;


Please let me know whats the issue.

[Updated on: Wed, 01 October 2008 15:05]

Report message to a moderator

Re: FND_PROFILE.VALUE('ORG_ID') yields no value, USERENV('CLIENT_INFO') gives value [message #353120 is a reply to message #351627] Sat, 11 October 2008 11:21 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Is anyone stopping you to read the Forum Guide
Quote:
8. Not able to see the profile option values from Back end SQL tools? Have a look at link1 and link2?
By
Vamsi
Previous Topic: APP-FND-01206
Next Topic: Personal profile Options
Goto Forum:
  


Current Time: Sun Dec 11 06:17:53 CST 2016

Total time taken to generate the page: 0.08631 seconds