Grade Rate DFF Not Showing Expected Results In OTBI

(Doc ID 2340402.1)

Last updated on JANUARY 24, 2018

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR
---------------
 When the column is used, instead of returning one values per employee, it insteads returns values for all the Legislations.

EXPECTED BEHAVIOR
-----------------------
This shows retrieve only one value per employee

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use the below logical SQL and check the data in

set variable LOGLEVEL = 2,DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1, ENABLE_DIMENSIONALITY=1;SELECT
  0 s_0,
  "Compensation - Salary Details Real Time"."Worker Legislation"."Territory Code" s_1,
  "Compensation - Salary Details Real Time"."Worker"."Employee Name" s_2,
  "Compensation - Salary Details Real Time"."Worker"."Person Number" s_3,
  "Workforce Management - Grade Rate Real Time"."Grade Rate Details"."Legislative Data Group" s_4,
  "Workforce Management - Grade Rate Real Time"."Grade Rate Details"."Name" s_5,
  "Workforce Management - Grade Rate Real Time"."Grade Rate Details"."PER_RATES_DF_SOCIAL_CHARGES_" s_6,
  "Workforce Management - Grade Rate Real Time"."Grade"."Grade Name" s_7,
  "Compensation - Salary Details Real Time"."Salary"."Annualized Salary" s_8,
  "Workforce Management - Grade Rate Real Time"."Grade Rate"."Rate Value Count" s_9
FROM "Workforce Management - Grade Rate Real Time" WHERE
(("Compensation - Salary Details Real Time"."Worker"."Person Number" = '10024') AND ("Grade"."Grade Name" IS NOT NULL))
ORDER BY 1, 4 ASC NULLS LAST, 3 ASC NULLS LAST, 2 ASC NULLS LAST, 7 ASC NULLS
LAST, 5 ASC NULLS LAST, 6 ASC NULLS LAST, 8 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

2. Check the data

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users see all data, which should not be the case.

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