R12:AP: Payment Process Request Error "ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small"
(Doc ID 2994156.1)
Last updated on DECEMBER 20, 2023
Applies to:
Oracle Payments - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Build Program in the Payment Process Requests fails with the following errors
IBY_PAYGROUP_PUB.insertDocIntoPayment:SQL err msg: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
IBY_PAYGROUP_PUB.insertDocIntoPayment:IBY_PAYGROUP_PUB.insertDocIntoPayment:Exception while inserting Doc into Payment
IBY_PAYGROUP_PUB.performDocumentGrouping:SQL code: -6502
IBY_PAYGROUP_PUB.performDocumentGrouping:SQL err msg: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
IBY_PAYGROUP_PUB.performDocumentGrouping:IBY_PAYGROUP_PUB.performDocumentGrouping:Exception when PerformingDocument Grpuping.
IBY_PAYGROUP_PUB.insertDocIntoPayment:IBY_PAYGROUP_PUB.insertDocIntoPayment:Exception while inserting Doc into Payment
IBY_PAYGROUP_PUB.performDocumentGrouping:SQL code: -6502
IBY_PAYGROUP_PUB.performDocumentGrouping:SQL err msg: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
IBY_PAYGROUP_PUB.performDocumentGrouping:IBY_PAYGROUP_PUB.performDocumentGrouping:Exception when PerformingDocument Grpuping.
The issue can be reproduced at will with the following steps:
1. Create an invoice, validate and approve
2. Submit a payment process request
3. Wait for build program to complete
Invoices can not be paid due to the error
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 |