OBIA 11g HR - Duplicate Data being shown in report when Person Number is not used
(Doc ID 2617701.1)
Last updated on DECEMBER 24, 2019
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.2 and later
Information in this document applies to any platform.
In, OBIA 188.8.131.52.2 - HR Module, Out of the box
Created a OBIEE report using the columns below:
Person Last name, Fiscal Year, Fiscal Month, Time in Job (Days), Time in Job (Years), Length of Service in Days, Length of Service in Years.
This report does not include the person number or employee number. This results in the number for Time in Job( Days) is either getting doubled or tripled. When the person number in the report the numbers are correct.
Following are the queries generated in both the cases.
Case 1: Below tables are using in the query generated when the person number is used in the report, which is correct.
Is this a bug or expected issue?
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