capturing user id

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.value(user_id), but it was giving an error.

Error: "fnd_profile should be declared".

Vamsi

re: capturing user id

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!!