My Oracle Support Banner

23B Fusion HCM Data Loader: Worker AssignmentExtraInfo Load Error "No Parent Employment Terms or Assignment Record Exists For the EFF Record" (Doc ID 2954356.1)

Last updated on AUGUST 03, 2023

Applies to:

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


After upgrade to Release 23B, when attempting to load Worker HCM Data Loader (HDL) file with Assignment Extra Information records the following error occurs:


PER_EMCOR_NO_PARENT_WT_ASG: PER-1531646 No parent employment terms or assignment record exists for the EFF record. Correct the data and load again.


The issue can be reproduced at will with the following steps:

1. Attempt to load Worker.dat that contains Assignment EIT records without corresponding date effective Assignment records in the database or in the dat file.
Attempt to load Worker.dat that contains Assignment EIT records for those Assignments with an existing mismatch between Assignment EIT records and Assignment records.

2. Encounter the error message above


Upgrade to Release 23B.


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.