My Oracle Support Banner

Create Workrelationship Is In Error (Doc ID 2708388.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

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

Symptoms

On : 11.13.20.04.0 version, Global Human Resources

When attempting to Create WR
the following error occurs.

ERROR
-----------------------
Code : 29000
Severity : SEVERITY_ERROR
Exception Class Name : java.sql.SQLIntegrityConstraintViolationException
Fault Payload :
faultName: {{http://xmlns.oracle.com/apps/hcm/employment/core/transactionApprovalService/}ServiceException}
messageType: {{http://xmlns.oracle.com/adf/svc/errors/}ServiceException}
parts: {{
ServiceErrorMessage=29000JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.jbo.DMLException, msg=JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO PER_ETHNICITIES(ETHNICITY_ID,PERSON_ID,BUSINESS_GROUP_ID,LEGISLATION_CODE,ETHNICITY,PRIMARY_FLAG,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)".SEVERITY_ERROR29000JBO-29000: Unexpected exception caught: oracle.jbo.DMLException, msg=JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO PER_ETHNICITIES(ETHNICITY_ID,PERSON_ID,BUSINESS_GROUP_ID,LEGISLATION_CODE,ETHNICITY,PRIMARY_FLAG,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)".SEVERITY_ERROR26041JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-26041. Please contact service provider on details.SEVERITY_ERRORORA-01400: cannot insert NULL into (???)
SEVERITY_ERRORjava.sql.SQLIntegrityConstraintViolationExceptionoracle.jbo.DMLExceptionDML_INSERTJBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-26041. Please contact service provider on details.oracle.jbo.JboExceptionoracle.jbo.JboException}
cause: {null}




Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.