Fusion Apps OTBI : Unable to analyze Compensation - Workforce Compensation Real Time The specified criteria did not result in any data - security roles (Doc ID 1684176.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.7.0.0 and later
Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT INFORMATION
------------------------------------
Fusion HCM Cloud 11.1.7 - Compensation OTBI

EXPECTED BEHAVIOR

3 CUSTOM analyses ***which were working in the past****, for this user should continue to work

ERROR OR UNEXPECTED BEHAVIOR
-----------------------------------------------
All HR partners with Compensation Manager roles who have Data Security Roles which use Department trees cannot access these reports.
Message :
The specified criteria did not result in any data

STEPS
--------------
User  is connected to Fusion Applications
He has navigated to Reports and Analytics pane
he has attempted to execute an OTBI Analysis called

"Salary Review"

The analysis returns no data, an informational message is displayed.


BUSINESS IMPACT
------------------------
User unable to finalize our Salary Review due to lack of reports for the HR Managers. This is severe since we must deliver data to payroll for payroll processing in due
time for April payouts in April.

Other Information
----------------------
1. Tree column flattening and row flattening have been done (and redone)
2. User  has the following Job/Data Roles
All Users
Employee
Compensation Manager_000 x
Compensation Manager_000 y
Compensation Manager_000 z
Compensation Manager_000 a
Compensation Manager_000 b
and 3 more similar

3. Recent changes to security roles /profiles:

- No changes has been made to the standard role Employee
- No changes has been made to the standard inherited role Compensation Manager
- So no changed duty role
- No changes has been made to Data roles that is using the  inherited role Compensation Manager
- No changes has been made to the Persons Security Profiles that are linked to the Data Roles
- No changes has been made to the organizational Security Profiles that are linked to the Persons Security Profiles, except for one organizational Security Profile.

This organizational Security Profile has been updated twice, first one time that an department has been added in the section Secure by Organization List, then a second time that the check-box Secure by Organization List has been un-checked. Attched is a screenshot of how it looks now. The updates must probably have been done2-4 weeks ago.

4.  Trees are updated approx every 3 weeks,the typical change are that a Department is added into the Department Tree structure. After the  Department Tree structure has been updated the structure is On-Line ,Audited, Flattened and set to status Active again. This has been done several times  successfully with no affect on the analyses.

5. logical SQL (analysis definition) as follows:

SELECT
  0 s_0,
  "Compensation - Workforce Compensation Real Time"."Compensation Components"."Component Name" s_1,
  "Compensation - Workforce Compensation Real Time"."Compensation Person Details"."Date Of Birth" s_2,
  "Compensation - Workforce Compensation Real Time"."Compensation Person Salary Details"."Base Salary Currency" s_3,
  "Compensation - Workforce Compensation Real Time"."Compensation Person Worksheet Details"."Work Sheet Manager Name" s_4,
  "Compensation - Workforce Compensation Real Time"."Compensation Plan Cycles"."Cycle Display Name" s_5,
  "Compensation - Workforce Compensation Real Time"."Compensation Plan Details"."Plan Name" s_6,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment1" s_7,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment10" s_8,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment11" s_9,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment12" s_10,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment13" s_11,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment14" s_12,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment15" s_13,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment2" s_14,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment23" s_15,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment24" s_16,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment25" s_17,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment26" s_18,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment27" s_19,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment29" s_20,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment37" s_21,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment38" s_22,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment39" s_23,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment49" s_24,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment5" s_25,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment6" s_26,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment7" s_27,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment8" s_28,
  "Compensation - Workforce Compensation Real Time"."Custom Columns"."Custom Segment9" s_29,
  "Compensation - Workforce Compensation Real Time"."Department"."Department Name" s_30,
  "Compensation - Workforce Compensation Real Time"."Legal Employer"."Name" s_31,
  "Compensation - Workforce Compensation Real Time"."Worker Legislation"."Territory Short Name" s_32,
  "Compensation - Workforce Compensation Real Time"."Worker"."Employee Name" s_33,
  "Compensation - Workforce Compensation Real Time"."Compensation Components and Rewards"."Compensation Amount" s_34
FROM "Compensation - Workforce Compensation Real Time"
WHERE
(("Compensation - Workforce Compensation Real Time"."Compensation Plan Details"."Plan Name" = 'Salary Review') AND ("Compensation - Workforce Compensation Real

Time"."Compensation Plan Cycles"."Cycle Display Name" = '2014') AND (("Compensation - Workforce Compensation Real Time"."Compensation Components"."Component Name" =

'Salary Increase') OR ("Compensation - Workforce Compensation Real Time"."Compensation Components"."Component Name" = 'Löneökning')))
ORDER BY 1, 7 ASC NULLS LAST, 6 ASC NULLS LAST, 2 ASC NULLS LAST, 33 ASC NULLS LAST, 32 ASC NULLS LAST, 8 ASC NULLS LAST, 9 ASC NULLS LAST, 31 ASC NULLS LAST, 5 ASC

NULLS LAST, 15 ASC NULLS LAST, 30 ASC NULLS LAST, 34 ASC NULLS LAST, 12 ASC NULLS LAST, 3 ASC NULLS LAST, 26 ASC NULLS LAST, 18 ASC NULLS LAST, 4 ASC NULLS LAST, 19

ASC NULLS LAST, 22 ASC NULLS LAST, 23 ASC NULLS LAST, 21 ASC NULLS LAST, 20 ASC NULLS LAST, 13 ASC NULLS LAST, 24 ASC NULLS LAST, 11 ASC NULLS LAST, 10 ASC NULLS LAST,

28 ASC NULLS LAST, 29 ASC NULLS LAST, 27 ASC NULLS LAST, 14 ASC NULLS LAST, 16 ASC NULLS LAST, 17 ASC NULLS LAST, 25 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

Cause

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