Exception Occurred When Performing Document Validation - ORA-12899: value too large for column "AP
(Doc ID 1907585.1)
Last updated on AUGUST 11, 2022
Applies to:
Oracle Payables - Version 12.1.3 and later Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Pmt PayReports PBatch & Prepay
When attempting to process payment through payment workbench the following error occurs.
ERROR ----------------------- IBY_VALIDATIONSETS_PUB.initDocDataForPPR : IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL err msg: ORA-12899: value too large for column IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets : IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:ORA-12899: value too large for column "AP IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : Exception occured when validating documents. Document validation will be aborted and no docu IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : SQLCODE: 1 IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment : SQLERRM: User-Defined Exception IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : ENTER IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : Payment request id: xxxx IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : Retrieving document errors .. IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : No document errors were generated. IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : Retrieving payment errors .. IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : No payment errors were generated. IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : Retrieving payment instruction errors .. IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : No payment instruction errors were generated. IBY_DISBURSE_SINGLE_PMT_PKG.retrieve_transaction_errors : Transaction error list populated with 0 errors.the errors here>
BUSINESS IMPACT ----------------------- The issue has the following business impact: Due to this issue, users cannot process payment
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!
