Fusion Global HR: HR2HR Interface Workrelationship Load Errors JBO-27024

(Doc ID 1535955.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

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


Load Co-Existence Data

When attempting to load work relationship data from EBS via HR2HR, the following errors occur:

JBO-27024 oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.RowValException, msg=JBO-27024: Failed to validate a row with key oracle.jbo.Key[1000000123456 4712-12-31 Y 1 2007-01-29 ] in WorkTermsVO_Assignment_WorkTermsVOToAssignmentVO_AssignmentVO 64
PER-1530203 A person can have only one active primary work relationship. 39
PER-1530231 The RangeStartDate attribute is invalid. Enter a valid value. 96
PER-1530236 The person already has a work relationship of this type with this legal employer. 71
PER-1530245 You cannot update the legal employer value. 14
PER-1531252 You must designate one of the existing secondary work relationships as primary before terminating the primary work relationship. 1

The issue can be reproduced at will with the following steps:
1. Ran HR2HR interface in EBS and published the file to Fusion(Rel4)
2. Logged in to Fusion.
3. Navigator>data exchange > load HCM > Schedule > selected the work relationship file and submitted the program.


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