Legislative Data Group-based Security secures data via the Payroll dimension using Legislative Data Group 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 Legislative Data Group List) AU BI Data |
Compensation Analyst (secured by Legislative Data Group List) AU BI Duty |
Compensation Manager (secured by Legislative Data Group List) AU BI Data |
Compensation Manager (secured by Legislative Data Group List) AU BI Duty |
Payroll Manager (secured by Legislative Data Group List) AU BI Data |
Payroll Manager (secured by Legislative Data Group List) AU BI Duty |
Initialization Blocks
The Legislative Data Group list values are determined at user sign-on via one or more Initialization Blocks:
Table 4-1 Initialization Blocks
Variable Name | Initialization Block Name |
---|---|
HR_SEC_LDG_CMPALYST_LIST |
Not applicable, this is a multi source variable population see below. |
HR_SEC_LDG_CMPALYST_LIST____EBS |
HR - Compensation Analyst - Legislative Data Group List (EBS). |
HR_SEC_LDG_CMPALYST_LIST____PSFT_NA |
HR - Compensation Analyst - Legislative Data Group List (PeopleSoft North American Payroll). |
HR_SEC_LDG_CMPALYST_LIST____PSFT_GP |
HR - Compensation Analyst - Legislative Data Group List (PeopleSoft Global Payroll). |
HR_SEC_LDG_CMPMGR_LIST |
Not applicable, this is a multi source variable population see below. |
HR_SEC_LDG_CMPMGR_LIST____EBS |
HR - Compensation Manager - Legislative Data Group List (EBS). |
HR_SEC_LDG_CMPMGR_LIST____PSFT_NA |
HR - Compensation Manager - Legislative Data Group List (PeopleSoft North American Payroll). |
HR_SEC_LDG_CMPMGR_LIST____PSFT_GP |
HR - Compensation Manager - Legislative Data Group List (PeopleSoft Global Payroll). |
HR_SEC_LDG_LIST____FUSN |
HR - Payroll Manager - Legislative Data Group List (Fusion). |
HR_SEC_LDG_PYRLMGR_LIST |
Not applicable, this is a multi source variable population see below. |
HR_SEC_LDG_PYRLMGR_LIST____EBS |
HR - Payroll Manager - Legislative Data Group List (EBS). |
HR_SEC_LDG_PYRLMGR_LIST____PSFT_NA |
HR - Payroll Manager - Legislative Data Group List (PeopleSoft North American Payroll). |
HR_SEC_LDG_PYRLMGR_LIST____PSFT_GP |
HR - Payroll Manager - Legislative Data Group List (PeopleSoft Global Payroll). |