How to get User Run time system information in Oracle Fusion Reports

How to get User Run time system information in Oracle Fusion Reports


In Oracle Apps R12 reports , we can easily get the user information through Profile option like USER_ID, RESP_ID but in Oracle Fusion to get the user information , we need to use fusion system variables as below

System Variables                    Variables Description

xdo_user_name	User ID of the user submitting the report. Like Which fusion User running this report
xdo_user_roles	Roles assigned to the user submitting the report. Like from Which role this report is running.
xdo_user_report_oracle_lang	Report language from the user's account preferences.
xdo_user_report_locale	Report locale from the user's account preferences.
xdo_user_ui_oracle_lang	User interface language from the user's account preferences.
xdo_user_ui_locale	User interface locale from the user's account preferences.

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.


To Access these variables in fusion reports you need to user : and then System variable name in your SQL query.

Like

Select  :xdo_user_name
              :xdo_user_roles
From Dual




If you want to see Other OAF Related Posts , Please visit Below URL.https://rpforacle.blogspot.in/2013/03/oaf_10.html



If you want to see  Oracle Fusion Related Posts , Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-fusion-learning-tutorial.html

If you want to Learn Oracle Workflow Builder, Please visit Below URL.

https://rpforacle.blogspot.in/2018/01/oracle-workflow-learning-tutorial-1.html