Oracle Fusion OTBI: Filter on the 'Assignment Status Type' with values like 'Active', 'Inactive' or 'Suspended', the 'Enterprise Hire Date' returns with the wrong 'Enterprise Hire Date'.

(Doc ID 2163704.1)

Last updated on AUGUST 05, 2016

Applies to:

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


On : version, Technology Management - Reports/Analytics

Report is not pulling data consistently

You create a report to capture, among other things, the "Enterprise Hire Date". This is is happening for employees who were rehired. 

Anytime the you try to use a filter on the 'Assignment Status Type' with values like 'Active', 'Inactive' or 'Suspended', the 'Enterprise Hire Date' will return with the wrong date.

However, if you remove the filter for the 'Assignment Status Type', the report will return the correct 'Enterprise Hire Date'.
Here is an example:
Person Number 110344 was originally hired on 06/28/1999. Then was rehired on 03/16/2015
When the report is run without a filter on 'Assignment Status Type', the report returns two rows showing the correct hire date as follows:

Assignment Status Type Type Enterprise Person Number


06/28/1999 110344
Inactive 06/28/1999 110344

However, when report is run with a filter of (Assignment Status Type in ('Active', Suspended')), the result is:

Assignment Status Type  Enterprise Hire Date Person Number
Active 03/16/2015 110344




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