Session variables are used frequently in BI Publisher when the reports are being exposed to employees to add data security on top of the existing query.
We need to write query to pull only the logged in user information and for this we will use the session variable. Apart from this user, there are many other session variables and we are going to look at them now.
Logged in User Person ID – HRC_SESSION_UTIL.get_user_personid
Logged in User Username – :xdo_user_name
Logged in User Username – FND_GLOBAL.USER_NAME
Logged in User GUID – fnd_global.user_guid
Logged in User SessionID – userenv(‘sessionid’)
Logged in User Language – USERENV (‘LANG’)
Logged in User Business Group – fnd_profile.value(‘PER_BUSINESS_GROUP_ID’)
You can add these to the SQL Query as per your requirement and get appropriate results.
If you have any questions, please feel free to reach out to me by posting in comments section.
If you are interested in learning Fusion Technical tools go through this post
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM