OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » FND_PROFILE.VALUE('ORG_ID') yields no value, USERENV('CLIENT

Home » Applications » Oracle Fusion Apps & E-Business Suite » FND_PROFILE.VALUE('ORG_ID') yields no value, USERENV('CLIENT_INFO') gives value

Wed, 01 October 2008 15:04

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]

Sat, 11 October 2008 11:21

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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: Mon Jul 01 12:25:02 CDT 2024