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)
using FND_PROFILE.GET to get values via sql environment (merged 2) [message #423541] Fri, 25 September 2009 04:33 Go to next message
shasha
Messages: 2
Registered: September 2009
Junior Member
No Message Body
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
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 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check Oracle Applications Forum Guide for "Not able to see the profile option values from back end SQL tools?"

By
Vamsi
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 Go to previous message
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?
Previous Topic: Building a Customer information form
Next Topic: technical knowlege of apps
Goto Forum:
  


Current Time: Sun Dec 04 12:38:07 CST 2016

Total time taken to generate the page: 0.06304 seconds