New Member

[cookiejar]

I am Crystal report developer that uses Oracle as my database. I am not an ORACLE developer. I am a novice. I have been tasked to get the user-id of the user that's generating a report. We store the user_id in a Users table. We need to get the user-id of the person generating the report and match it with the user_id stored in the table.. Is there a way to do this?

" saw this repy in one of your forum:

The below query would give you the APPS LOGON USER ID:

SELECT apps.fnd_profil e.value('USER_I D') FROM dual)

You could place this in before report trigger and check who is executing this report."

I tired running the SELECT apps.fnd_profil e.value('USER_I D') FROM dual in TOAD but encountered an error: ORA-00904: "APPS"."FND_PRO FILE"."VALUE": invalid identifier

I don't know if I am using the correct syntax or if I have the access authority to run this command since I am not an administrator. I am not sure if this is the correct approach to my solution.

[Parul Bagadia]

USER_ID should be your column-name i.e. attribute in your table; unless this is true you cant use it in value

[cookiejar]

I am a complete novist, so excuse by ignorance. The user_id is a field in one of our tables named USERS. This user_id is generated by a Web application and is inserted into this table. So, the SELECT apps.fnd_profil e.value('USER_I D') FROM dual would not work since, the user_id is an entry created by a web application versus Oracle, right?