Payroll-based Security secures data via the Payroll dimension using Payroll list variable, with associated data roles and security filter[s] which are applied at the physical SQL level as IN (a, b, c,...) statement.
How to Choose and Assign the Duty Role
Each Oracle BI Applications Duty Role grants access to one or more subject areas, and is a member of at least one data security role.
You need to map a source role/responsibility to one or more Oracle BI Applications duty roles. See How to Define New Groups and Mappings for Users and BI Roles.
HR Data Role to Duty Role Mapping
The following are applicable to Department security.
Data (Security) Role | Duty Role |
---|---|
Compensation Analyst (secured by Payroll List) AU BI Data |
Compensation Analyst (secured by Payroll List) AU BI Duty |
Compensation Manager (secured by Payroll List) AU BI Data |
Compensation Manager (secured by Payroll List) AU BI Duty |
Payroll Manager (secured by Payroll List) AU BI Data |
Payroll Manager (secured by Payroll List) AU BI Duty |
Initialization Blocks
The Payroll list values are determined at user sign-on via one or more Initialization Blocks:
Variable Name | Initialization Block Name |
---|---|
HR_SEC_PYRL_CMPALYST_LIST |
Not applicable, this is a multi source variable population see below. |
HR_SEC_PYRL_CMPALYST_LIST____EBS |
HR - Compensation Analyst – Payroll List (EBS). |
HR_SEC_PYRL_CMPALYST_LIST____PSFT_NA |
HR - Compensation Analyst - Payroll List (PeopleSoft North American Payroll). |
HR_SEC_PYRL_CMPALYST_LIST____PSFT_GP |
HR - Compensation Analyst - Payroll List (PeopleSoft Global Payroll). |
HR_SEC_PYRL_CMPMGR_LIST |
Not applicable, this is a multi source variable population see below. |
HR_SEC_PYRL_CMPMGR_LIST____EBS |
HR - Compensation Manager - Payroll List (EBS). |
HR_SEC_PYRL_CMPMGR_LIST____PSFT_NA |
HR - Compensation Manager - Payroll List (PeopleSoft North American Payroll). |
HR_SEC_PYRL_CMPMGR_LIST____PSFT_GP |
HR - Compensation Manager - Payroll List (PeopleSoft Global Payroll). |
HR_SEC_PYRL_LIST____FUSN |
HR - Payroll Manager – Payroll List (Fusion). |
HR_SEC_PYRL_PYRLMGR_LIST |
Not applicable, this is a multi source variable population see below. |
HR_SEC_PYRL_PYRLMGR_LIST____EBS |
HR - Payroll Manager - Payroll List (EBS). |
HR_SEC_PYRL_PYRLMGR_LIST____PSFT_NA |
HR - Payroll Manager - Payroll List (PeopleSoft North American Payroll). |
HR_SEC_PYRL_PYRLMGR_LIST____PSFT_GP |
HR - Payroll Manager - Payroll List (PeopleSoft Global Payroll). |