Business Intelligence Publisher Secured List Views

Oracle Business Intelligence Publisher is a set of tools for creating formatted reports based on data models. You can access Business Intelligence Publisher from Business Intelligence Composer or the Business Intelligence Catalog by clicking New from the Report menu.

This topic describes how you can use secured list views to secure access to data in Business Intelligence reports. Some reporting tools combine the data model, layout, and translation in one report file. With that approach, business-intelligence administrators must maintain multiple copies of the same report to support minor changes. By contrast, Business Intelligence Publisher separates the data model, layout, and translation. Therefore, reports can be:

Generated and consumed in many output formats, such as PDF and spreadsheet
Scheduled for delivery to email, printers, and so on
Printed in multiple languages by adding translation files
Scheduled for delivery to multiple recipients

Business Intelligence Publisher Data Security and Secured List Views

When you create a Business Intelligence Publisher data model with physical SQL, you have two options.

You can:

Select data directly from a database table, in which case the data you return isn't subject to data-security restrictions. Because you can create data models on unsecured data, you're recommended to minimize the number of users who can create data models.
Join to a secured list view in your select statements. The data returned is determined by the security profiles that are assigned to the roles of the user who's running the report.

The following tables show, for each database table:

The secured list view
The data security privilege required to report on data in the table, if it's accessed using the secured list view

These duty roles have the privileges shown in the following table:

Absence Management Transaction Analysis
Payroll Transaction Analysis
Vacancy Transaction Analysis
Workforce Transaction Analysis

Table	Secured List View	Data Security Privilege
HR_ALL_ORGANIZATION_UNITS_F	PER_DEPARTMENT_SECURED_LIST_V	Report Department Data
HR_ALL_POSITIONS_F	PER_POSITION_SECURED_LIST_V	Report Position Data
PER_JOBS_F	PER_JOB_SECURED_LIST_V	Report HR Job Data
PER_LOCATIONS	PER_LOCATION_SECURED_LIST_V	Report Location Data
PER_GRADES_F	PER_GRADE_SECURED_LIST_V	Report Assignment Grade Data

Note: PER_JOBS_F, PER_LOCATIONS, and PER_GRADES_F aren't currently secured. The secured list views and privileges for these tables aren't currently used.

These duty roles have the privileges shown in the following table:

Documents of Record Transaction Analysis
Payroll Transaction Analysis
Workforce Transaction Analysis

Table	Secured List View	Data Security Privilege
PER_ALL_PEOPLE_F	PER_PERSON_SECURED_LIST_V	Report Person Data
PER_PERSONS	PER_PUB_PERS_SECURED_LIST_V	Report Person Deferred Data

The Payroll Transaction Analysis duty role has the privileges shown in this table.

Table	Secured List View	Data Security Privilege
HR_ALL_ORGANIZATION_UNITS_F	PER_LEGAL_EMPL_SECURED_LIST_V	Report Legal Employer Data
PER_LEGISLATIVE_DATA_GROUPS	PER_LDG_SECURED_LIST_V	Report Legislative Data Group Data
PAY_ALL_PAYROLLS_F	PAY_PAYROLL_SECURED_LIST_V	Report Payroll Definition Data

The Compensation Transaction Analysis duty role has the privilege shown in this table.

Table	Secured List View	Data Security Privilege
CMP_SALARY	CMP_SALARY_SECURED_LIST_V	Report Salary Data

The Human Resource Analyst job role has the privilege shown in this table.

Table	Secured List View	Data Security Privilege
PER_ALL_ASSIGNMENTS_M	PER_ASSIGNMENT_SECURED_LIST_V	Report Assignment Data

You can find details of the secured list views in the Tables and Views for Oracle HCM Cloud guide on the Oracle Help Center.