FBL Work Relationship Load Process Status Paused Batch System Error (Doc ID 2020406.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When attempting to load work relationship, the following error occurs.
Process status is showing as "Paused"
Batch status is failing with a system error

-- Error
 HRC_DE_BLOAD_GAP: Date-effective records cannot have gaps between the effective end date of one record and effective start date of the next record.
Complete data not provided for certain records or Data mismatch. Data File -F_WORK_TERMS_VO.dat Check the log file for data discarded

HRC-1035325 The parent assignment must include a date-effective update with the effective start date 2015-04-01 of the assignment child record 100000002002415.
HRC-1035200 Other work relationship records for this person have failed. Other work relationship records for this person have failed in this batch or a work relationship loaded previously was not found in Oracle Fusion.

 -- Steps
The issue can be reproduced at will with the following steps.
Data Exchange / Load Data for Coexistence / Import = Enter parameters

-- Business Impact
The issue has the following business impact:
Due to this issue, users cannot load work relationship data for mock conversion.

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