File Based Loader (FBL) Error: The Parent Assignment Must Include a Date-Effective Update With the Effective Start Date of the Assignment Child Record (Doc ID 2085204.1)

Last updated on SEPTEMBER 06, 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 via FBL, the following errors occur:

1. JBO-26092 oracle.jbo.AlreadyLockedException: JBO-26092: Failed to lock the record in table PER_ALL_ASSIGNMENTS_M with key oracle.jbo.Key[100000000123456 2008-10-04 2008-10-04 1 N], another user holds the lock

2. The parent assignment must include a date-effective update with the effective start date 2015-06-01 of the assignment child record 100000000123456

3. PER-1531415 Changes to the person legislative data exist before the proposed start date of the work relationship

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


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