Fusion Compensation: Salary: Restricting Access To Confidential Salary Data In BI Publisher Report Using Fusion Security Roles (Doc ID 2474116.1)

Last updated on JUNE 08, 2022

Applies to:

Goal

We have identified the following tables and fields to house confidential compensation and payroll-related data for personnel. We have created a report in BI Publisher that pulls this information.

We anticipate creating two security roles in Fusion - Report Viewer Confidential and Report Viewer.

If a user running a BI Publisher report that access for e.g: CMP_SALARY table and SALARY_AMOUNT field and does not have the Report Viewer Confidential role in Fusion, we would like the SALARY_AMOUNT field to be not displayed in the BI Publisher report.

What is Oracle's recommendation solution for reporting security around this requirement? Can this be achieved using Fusion security roles with specific data security privileges or this requires custom VPD policy design?

CMP_SALARY
CMP_SALARY_COMPONENTS
CMP_SALARY_BASES

PAY_ALL_PAYROLLS_F
PAY_REL_GROUPS_DN
PAY_ASSIGNED_PAYROLLS_DN
PAY_PAYMENT_TYPES
PAY_ORG_PAY_METHODS_F
PAY_ORG_PAY_METHOD_USAGES_F
PAY_PERSON_PAY_METHODS_F
PAY_PEOPLE_GROUPS
PAY_ELEMENT_TYPES_F
PAY_ELEMENT_INPUT_VALUES_F
PAY_ELEMENT_LINKS_F
PAY_ELEMENT_ENTRY_VALUES_F
PAY_ELEMENT_ENTRIES_F
PER_RATE_VALUES_F
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.