R12: IBY: Payment Instruction Ends in Error: JBO-26048: Constraint and ORA-00001: unique constraint violated (Doc ID 1342126.1)

Last updated on APRIL 23, 2024

Applies to:

Symptoms

The Format Payment Instruction log file shows the error:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.DMLConstraintException: JBO-26048: Constraint "SYS_C0036531" violated during post operation:"Insert" using SQL Statement "INSERT INTO FND_LOBS(FILE_ID,FILE_NAME,FILE_CONTENT_TYPE,FILE_DATA,FILE_FORMAT) VALUES (:1,:2,:3,:4,:5)".;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:711)
at oracle.apps.iby.util.OAAttachmentServerUtilsWrapper.saveAttachment(OAAttachmentServerUtilsWrapper.java:73)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.saveFormatOutput(FDExtractAndFormatting.java:469)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:421)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:251)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:141)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
## Detail 0 ##
java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.SYS_xxxxx) violated

OR

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPLSYS.SYS_xxxxx) violated

Cause

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