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


 

Oracle Apps Profile Option Change History SQL Query

Oracle Apps Profile Option Change History SQL Query



select p.profile_option_name SHORT_NAME, n.user_profile_option_name "PROFILE NAME",
decode(v.level_id, 10001, 'Site', 10002, 'Application',
10003, 'Responsibility', 10004, 'User', 10005, 'Server',
10007, 'SERVRESP', 'UnDef') LEVEL_SET,
decode(to_char(v.level_id), '10001', '',
'10002', app.application_short_name, '10003', rsp.responsibility_key,
'10005', svr.node_name, '10006', org.name, '10004', usr.user_name,
'10007', 'Serv/resp', 'UnDef') "CONTEXT", v.profile_option_value VALUE, v.LAST_UPDATE_DATE 
from fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
--and upper(n.user_profile_option_name) like upper('BNE%')
--and trunc(v.LAST_UPDATE_DATE) > trunc(sysdate-170)
and usr.user_id (+) = v.level_value
and rsp.application_id (+) = v.level_value_application_id
and rsp.responsibility_id (+) = v.level_value
and app.application_id (+) = v.level_value
and svr.node_id (+) = v.level_value
and org.organization_id (+) = v.level_value
and v.LAST_UPDATE_DATE is not null
order by last_update_date desc, short_name, level_set;

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