capturing user id

[vamsioracle]

Hi


Is it possible to capture the user id who is logging into Apps and running the report.

I have a rdf. I want to capture the person running this report. I tried using fnd_profile.val ue(user_id), but it was giving an error.

Error: "fnd_profil e should be declared".

Vamsi

[amitpatel66]

Follow this steps:

1. In the concurrent program, create one invisible parameter of type number.
2. set its default type to profile
3. set its default value to user_id
4. Capture this user_id in your rdf user parameter.

OR

1. In the concurrent program, create one invisible parameter of type number.
2. set its default type to sql statement
3. set its default value to - select fnd_global.user _id from dual
4. Capture this user_id in your rdf user parameter.

Hope this helps!!