R12: IBY/AP: Format Payment Instructions with Text Output Errors with 'JBO-26048: Constraint "SYS_C0036531" violated' and 'ORA-00001'
(Doc ID 2830595.1)
Last updated on SEPTEMBER 18, 2024
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
The process Format Payment Instructions with Text Output (IBY_FD_PAYMENT_FORMAT_TEXT) errors with:
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,ORACLE_CHARSET,FILE_FORMAT) VALUES (:1,:2,:3,:4,:5,:6)".;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:728)
at oracle.apps.iby.util.OAAttachmentServerUtilsWrapper.saveAttachment(OAAttachmentServerUtilsWrapper.java:88)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.saveFormatOutput(FDExtractAndFormatting.java:517)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:466)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:278)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
## Detail 0 ##
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPLSYS.SYS_C0036531) violated
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:728)
at oracle.apps.iby.util.OAAttachmentServerUtilsWrapper.saveAttachment(OAAttachmentServerUtilsWrapper.java:88)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.saveFormatOutput(FDExtractAndFormatting.java:517)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:466)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:278)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
## Detail 0 ##
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPLSYS.SYS_C0036531) violated
Steps to Reproduce
1. Login to Payments Responsibility
2. Initiate a Payments Process Request (PPR)
3. Observe that the IBY_FD_PAYMENT_FORMAT_TEXT process fails with above errors
Changes
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 |
| Changes |
| Cause |
| Solution |