My Oracle Support Banner

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 FEBRUARY 04, 2019

Applies to:

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


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.