File Based Loader Error JBO-26041: Failed To Post Data To Database During "INSERT INTO PER_PERSONS" (Doc ID 1561729.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

Load batch data completed with errors

When using FBL to upload HCM data, able to transfer the zip file to ftp_inbox and invoke the Inbound Loader Process and the file got registered.
After loading batch data, the zip file is shown and the number of records are also available.
When submiting, it shows the Batch Status as Complete with Errors and got the following error in the Failed Tab.

oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO PER_PERSONS(PERSON_ID,BUSINESS_GROUP_ID,START_DATE,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)".

Error stack shows:
## Detail 0 ## java.sql.SQLException: ORA-28115: policy with check option violation at oracle.jdbc.driver




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