Error with Fusion Integration Interface FT_EXTRACT (Doc ID 2122303.1)

Last updated on MAY 10, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

9.1 version, Integration Broker/Messaging

ACTUAL BEHAVIOR
---------------
Issues with Fusion Interface FT_EXTRACT

While loading HR data, an Error was Generated "Date-Effective Records Cannot have Gaps Between the Effective End Date of one Record and Effective Start Date of the Next Record." Error is Thrown Due to Invalid Data in Extract, causing Date Gaps and  a Wrong Effective Sequence/flag values. Attaching person numbers with error.

The above issue is documented in Bug 22558129


EXPECTED BEHAVIOR
-----------------------
Users should be able to run the FT_EXTRACT without errors


BUSINESS IMPACT
-----------------------
The issue has the following business impact: The Integration between Fusion and HCM HR was Stopped.

Due to this issue, Users are Unable to Complete the Integration.

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