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'.
Last updated on AUGUST 05, 2016
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 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|
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|
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