Tuesday, 6 February 2018

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_nameUser ID of the user submitting the report. Like Which fusion User running this report
xdo_user_rolesRoles assigned to the user submitting the report. Like from Which role this report is running.
xdo_user_report_oracle_langReport language from the user's account preferences.
xdo_user_report_localeReport locale from the user's account preferences.
xdo_user_ui_oracle_langUser interface language from the user's account preferences.
xdo_user_ui_localeUser 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


 

0 comments:

Post a Comment