My Oracle Support Banner

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 and later
Information in this document applies to any platform.



In, OBIA - 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

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