How to get Logged in Persion Id in BIP

user11978217

Summary

How to get Logged in Persion Id in BIP

Content

Hi,

I need to create an LOV parameter where a logged in person can see his related records only. For this purpose i need to access logged in person id when he is viewing that report. 

How to get Logged In Person Id.

Regards,

Zahid Rahim

Daniel Willis

Hey Zahid

Here is an example query that will return some user information.

SELECT
:xdo_user_name AS USER_NAME,
:xdo_user_roles AS USER_ROLES,
:xdo_user_ui_oracle_lang AS USER_UI_LANG,
:xdo_user_report_oracle_lang AS USER_REPORT_LANG,
:xdo_user_ui_locale AS USER_UI_LOCALE,
:xdo_user_report_locale AS USER_REPORT_LOCALE,
:xdo_SAMACCOUNTNAME AS SAMACCOUNTNAME,
:xdo_memberof as MEMBER_OF,
:xdo_primaryGroupID as PRIMARY_GROUP_ID,
:xdo_mail as MAIL
FROM DUAL

Chuck that in a data set and see that the user_name is what you're after and you can use it in your own queries.

- Daniel