You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there any possibility to get the user name who is executing the report otm

Hi Team,

Is there any known way to reliably fetch the user ID of the person executing a report in otm ?

I am currently using the following SQL to retrieve the user's preferred currency:

sql snippet

SELECT upd.USER_PREFERENCE_VALUE
FROM USER_ACCESS ua
JOIN USER_PREFERENCE_ACCESS upa ON ua.USER_ACCESS_GID = upa.USER_ACCESS_GID
JOIN USER_PREFERENCE up ON up.USER_PREFERENCE_GID = upa.USER_PREFERENCE_GID
JOIN USER_PREFERENCE_D upd ON upd.USER_PREFERENCE_GID = up.USER_PREFERENCE_GID
WHERE ua.GL_USER_GID = SYS_CONTEXT('GLOG_USER_CTX', 'LOG_IN_USER_GID')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!