My Oracle Support Banner

Fusion Global HR: JBO-26048: Constraint "HR_DOCUMENTS_OF_RECORD_PK" Error - Manage Document Records (Doc ID 2991832.1)

Last updated on DECEMBER 11, 2023

Applies to:

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


When adding a Document record to an employee and submitting for approval, the following error is seen in the transaction log:

JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.jbo.DMLConstraintException, msg=JBO-26048: Constraint "HR_DOCUMENTS_OF_RECORD_PK" is violated during post operation "Insert" using SQL statement "INSERT INTO HR_DOCUMENTS_OF_RECORD(DOCUMENTS_OF_RECORD_ID,PERSON_ID,ASSIGNMENT_ID,ENTERPRISE_ID,DOCUMENT_TYPE_ID,DOCUMENT_NAME,COMMENTS,DEI_ATTRIBUTE_CATEGORY,DEI_INFORMATION_CATEGORY,OBJECT_VERSION_NUMBER,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE,DOCUMENT_CODE,CREATION_SOURCE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17)".

The error does not occur to all the transactions.


The issue can be reproduced at will with the following steps:

1. Add a document of record to an employee > Submit.
2. Navigate to Tools > Transaction Console.
3. Open the transaction and review the diagnostic log.




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

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