Fusiob Global HR:- Assignment Alternate Parent Surrogate ID Failed (Doc ID 2052562.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

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

Goal

On : 11.1.9.2.0 version, HCM Data Loader

Assignment alternate Parent Surrogate ID failed

The usage of Alternate User Key attribute for parent surrogate Ids in the assignment section fails for the specific case described here after.
The WorkTermsNumber cannot not replace the WorkTermsAssignmentId in some specific cases even if the WorkTermsAssignmentId/workTermsNumber already exist in Fusion.


For the second employee I'm changing the assignment and workTerms EFFECTIVE_START_DATE and/or EFFECTIVE_END_DATE of the workterms and assignment HIRE and the ASG_UPDATE rows.
It is written in the documentation provided by Oracle in the Assignment section that the WorkTermsAssignmentId can be replaced by the Alternate User Key attribute WorkTermsNumber for this parent surrogate Ids.
The WorkTermsAssignmentId and/or the WorkTermsNumber exists while I'm performing the load. I would assume that the WorkTermsNumber can replace the WorkTermsAssignmentId as specified.
It is not the case, the load is rejected with the following error :
  The corresponding date effective record in the WorkTerms for date 2015-07-10, action HIRE, and effective sequence 1 is missing for the Assignments.
  Work terms records are required when you create or update assignments.
If I replace the WorkTermsNumber column by the WorkTermsAssignmentId data is properly loaded.
 

Solution

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