File Based Loader Error JBO-26041: Failed To Post Data To Database During "INSERT INTO PER_PERSONS"
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 22.214.171.124.0 and later
Oracle Fusion Global Human Resources - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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
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