This content has been marked as final. Show 3 replies
In order to fetch any FND_PROFILE or FND_GLOBAL values you need to initialize apps
Check the following MOS note
fnd_global.apps_initialize(user, resp_id,resp_application_id) begin fnd_global.apps_initialize(0,20420,1); dbms_output.PUT_LINE (FND_PROFILE.VALUE('ORG_ID')); dbms_output.PUT_LINE (FND_PROFILE.VALUE('USER_ID')); dbms_output.PUT_LINE (FND_PROFILE.VALUE('USERNAME')); end;
How To Set the Applications Context (FND_GLOBAL.APPS_INITIALIZE) [ID 209185.1]
Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.
Information about concurrent requests that have been run is already stored in table FND_CONCURRENT_REQUESTS - information includes the user id and responsibility used to launch the concurrent request
For that I created a table as USER_INFO which has a column called USERNAME.Why do you have to create a new table/column if you can find the same information from FND_CONCURRENT_REQUESTS and FND_USER tables?
You can check the value of REQUESTED_BY column in FND_CONCURRENT_REQUESTS table and link it with USER_ID column in FND_USER and get the USER_NAME from the FND_USER table.