Fusion BIP : How to get current logged in user in report

I would like to share a very small topic, yet very useful in Fusion reports space.

Many times we want to query records/ transactions related to the logged in user. (i.e, the user who is currently running the report ).

For this we can use the below query :

SQL>> select SYS_CONTEXT( 'USERENV', 'CLIENT_IDENTIFIER' )  from dual;


Happy learning and sharing,
Srikanth