OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » using FND_PROFILE.GET to get values via sql environment (merged 2)

Home » Applications » Oracle Fusion Apps & E-Business Suite » using FND_PROFILE.GET to get values via sql environment (merged 2) (OS-Windows XP oracle 6i)

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

using FND_PROFILE.GET to get values via sql environment (merged 2) [message #423541]

Fri, 25 September 2009 04:33

shasha
Messages: 2
Registered: September 2009

Junior Member

No Message Body

Report message to a moderator

Re: using FND_PROFILE.GET to get values via sql environment [message #423544 is a reply to message #423541]

Fri, 25 September 2009 04:46

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Is this a SQL or PL/SQL question? If yes explain it.

Regards
Michel

Report message to a moderator

Re: using FND_PROFILE.GET to get values via sql environment [message #423547 is a reply to message #423541]

Fri, 25 September 2009 04:51

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

Senior Member

Check Oracle Applications Forum Guide for "Not able to see the profile option values from back end SQL tools?"

By
Vamsi

Report message to a moderator

Can FND_PROFILE.GET('business group id') value be got through sql plus or toad [message #423558 is a reply to message #423541]

Fri, 25 September 2009 05:33

shasha
Messages: 2
Registered: September 2009

Junior Member

--Get the business group id and the concurrent request id in variables
FND_PROFILE.GET('PER_BUSINESS_GROUP_ID',gv_business_group_id);
gv_req_id := fnd_profile.VALUE ('CONC_REQUEST_ID');

We get value of business group id by submitting concurrent program.Is it possible to get value for the same through TOAD or SQL environment?

Report message to a moderator

Previous Topic:	Building a Customer information form
Next Topic:	technical knowlege of apps

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 05 21:51:16 CDT 2024