0 votes
in Technology by (326k points)

How to get the Oracle Fusion application information’s in the BIP reports?

1 Answer

0 votes
by (326k points)
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.
...