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. |
To Access these variables in fusion reports you need to user : and then System variable name in your SQL query.