Fusion Apps OTBI Compensation Subject Area Data Role Security - Line Manager view when they also have HR Analyst Role (Doc ID 1676491.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

HCM OTBI data security - End user has two roles, they are both a Line Manager (Supervisor) and an HR Analyst

How can this person limit the data just for his team, rather than seeing all the employees for his role as HR Analyst

Detail:

“Looking to create an OTBI analysis using the 'Compensation - Workforce Compensation Real Time' subject area and I want to be able to view the data as a Manager for reports in Manager's hierarchy only.

In the 'Workforce Management - Work Assignment Real Time' Subject area this is possible by using the 'Assignment Manager' folder to ensure only data for reports that sit in manager's hierarchy is visible.

Is there an equivalent folder in this Compensation subject area too? I have tried using the 'Compensation Manager' folder, however this returns data for all employees (for example if the user in question has a HR role as well as a Manager role). I have also tried a cross subject area analysis using the 'Workforce Management - Work Assignment Real Time' subject area with Manager Name in criteria (from Assignment Manager folder) but leaves me with the following error: 'Odbc driver returned an error (SQLExecDirectW)'.”
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms