How to use profile value in report integration in Oracle Apps

Sometimes we need to display the username of the user who ran the concurrent program. USER_ID is stored in Profile Values.

Let's see how is it used...


How to integrate a report (RDF) with Oracle Apps

Go to Parameters Window..

Other profile Values which are commonly used are.. ORG_ID, PER_PERSON_ID, RESP_ID etc


Use the following code to use in report.

Create a Formula Column and use the code below.

    p_user_name varchar2(200);

begin

    select user_name into p_user_name from fnd_user where user_id = :P_USER_ID;

   

    return p_user_name ||' On ' || to_char(sysdate,'DD-MON-RRRR HH24:MI:SS');

   

Exception when others then return null;

Kindly provide your feedback.

Leave a comment for any query.