R12: IBY: Payment Instruction Ends in Error: JBO-26048: Constraint and ORA-00001: unique constraint violated
(Doc ID 1342126.1)
Last updated on SEPTEMBER 26, 2024
Applies to:
Oracle Payments - Version 12.1.1 and laterOracle Payables - Version 12.2.8 to 12.2.8 [Release 12.2]
Oracle Payables - Version 12.2.13 to 12.2.13 [Release 12.2]
Information in this document applies to any platform.
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
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
| Symptoms |
| Cause |
| Solution |
| References |