Fusion Apps, HCM, OTBI, No Data Found In "Compensation - Salary Details Real Time" Subject Area Due to Security Custom Roles, How To Edit Security Custom Roles to Have Data Acces in "Compensation - Salary Details Real Time" Subject Area (Doc ID 1943327.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Goal

Cloud, HCM, R8, OTBI - "Compensation - Salary Details Real Time" Subject Area.

Our customer was encountering an issue with a custom created security profile,
the date were not retrieved in OTBI and the HCM Analyst View All data role couldn't be allocated due to security limitations.

Description from our of the issue customer:
"I have created an OTBI report to fetch the Salary information of employees in the system but I did not get any data.
I cross verified with the application data and found the salary is present in the application.
I am attaching the Query log and the application snapshot.
Is there any other Subject Area available to see the salary information? I need a report with all the active employees and their Salary information ASAP."

 

The issued SQL that did not returned the salary details is the following:

-------------------- SQL Request, logical request hash:
ad7ba14
set variable LOGLEVEL = 2;SELECT
   0 s_0,
   "Compensation - Salary Details Real Time"."Location"."Internal Location Code" s_1,
   "Compensation - Salary Details Real Time"."Location"."Worker Location Name" s_2,
   "Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Name" s_3,
   "Compensation - Salary Details Real Time"."Worker"."Employee Name" s_4,
   "Compensation - Salary Details Real Time"."Worker"."Person Number" s_5,
   "Compensation - Salary Details Real Time"."Salary"."Annualized Salary" s_6,
   "Compensation - Salary Details Real Time"."Salary"."Current Salary" s_7
FROM "Compensation - Salary Details Real Time"
ORDER BY 1, 6 ASC NULLS LAST, 5 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 4 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

 
 From the Where clause of the issued query there can be seen that the user has insufficient data privileges
 -> please notice the "AND ((( 1 = 2 )))) V173852892 "  in the where clause

 

(SELECT V434716625.INTERNAL_LOCATION_CODE AS C43874321,         V515242473.LOCATION_NAME AS C165225419,         V173852892.SALARY_BASIS_NAME AS C382006839,..
...
FROM (SELECT SalaryPEO.ASSIGNMENT_ID,         SalaryPEO.SALARY_ID,         SalaryPEO.DATE_FROM,         SalaryPEO.DATE_TO,         SalaryPEO.SALARY_AMOUNT,         SalaryBasesPEO.SALARY_BASIS_ID AS SALARY_BASIS_ID1,         SalaryBasesPEO.SALARY_BASIS_CODE,         SalaryBasesPEO.SALARY_ANNUALIZATION_FACTOR,  
...

WHERE (SalaryPEO.SALARY_BASIS_ID = SalaryBasesPEO.SALARY_BASIS_ID AND SalaryBasesPEO.SALARY_BASIS_ID = SalaryBasesTLPEO.SALARY_BASIS_ID AND SalaryBasesPEO.INPUT_VALUE_ID = InputValueTranslationPEO.INPUT_VALUE_ID(+) AND SalaryPEO.ASSIGNMENT_ID = AssignmentPEO.ASSIGNMENT_ID AND ( DATE'2014-08-08'  BETWEEN AssignmentPEO.EFFECTIVE_START_DATE AND AssignmentPEO.EFFECTIVE_END_DATE)) AND ((( 1 = 2 )))) V173852892

 

 

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