My Oracle Support Banner

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 FEBRUARY 18, 2020

Applies to:

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


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


“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)'.”


To view full details, sign in with your My Oracle Support account.

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

In this Document

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