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')
0