Fusion Global HR: Not Able To Load Employee Data Using Spreadsheet Loader JBO-27024 And PersonEthnicityVO (Doc ID 1597381.1)

Last updated on JULY 14, 2015

Applies to:

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

Symptoms

When attempting to use Spreadsheet Loader to Create Workers, the following error occurs:

oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.RowValException, msg=JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000005989520 ] in PersonEO_Ethnicity_PersonVOToPersonEthnicityVO_PersonEthnicityVO

The issue can be reproduced at will with the following steps:
1. Navigator-Data Exchange - initiate Data Load - create worker.
2. Once file is downloaded, add employee data to the file, make sure you enter correct Ethnicity for the Legislation
3. Then upload the file. Copy the Batch Name.
4. Again navigate to Navigator- Data Exchange - Batch Load
5. Search the batch with copied Batch Name in step 2
6. Run the batch .
7. Check for the errors


Cause

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