My Oracle Support Banner

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

Last updated on JANUARY 31, 2018

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.


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(
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(
at oracle.apps.iby.util.OAAttachmentServerUtilsWrapper.saveAttachment(
at oracle.apps.iby.scheduler.FDExtractAndFormatting.saveFormatOutput(
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(
at oracle.apps.fnd.cp.request.Run.main(
## Detail 0 ##
java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.SYS_xxxxx) violated


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




To view full details, 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 a vibrant support community of peers and Oracle experts.