Last updated on SEPTEMBER 26, 2016
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 188.8.131.52.0 and later
Oracle Fusion Global Human Resources - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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.
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