File Based Loader (FBL) Error: The Parent Assignment Must Include a Date-Effective Update With the Effective Start Date of the Assignment Child Record
Last updated on SEPTEMBER 06, 2017
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 220.127.116.11.0 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms