Get Session Details for BIP Report

We can use below session variables to get the session details like username, user roles etc in runtime.

Sample Requirement: BIP report should fetch only details/records related to his person number.

Step 1: Navigate to Analytics area and create a sample BIP report.

                SELECT

            :xdo_user_name,

            person_id,

            person_number,

            start_date

       FROM

            per_all_people_f papf,per_users fu

       WHERE

            fu.person_id=papf.person_id

            and lower(fu.username) = :xdo_user_name

Step 2: Now click on the data view and you can able to see only records related to login user.

We can also use this concept while calling a report from UI/Navigator page.

Below are the other sessions scripts which we can make use of it as per the requirement.

        select

            :xdo_user_name as USER_ID,

            :xdo_user_roles as USER_ROLES,

            :xdo_user_report_oracle_lang as REPORT_LANGUAGE,

            :xdo_user_report_locale as REPORT_LOCALE,

            :xdo_user_ui_oracle_lang as UI_LANGUAGE,

            :xdo_user_ui_locale as UI_LOCALE

        from dual

Note: We always need to use lower case in where clause while matching with :xdo

        Eg:  lower(fu.username) = :xdo_user_name