My Oracle Support Banner

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.


On :  12.1.3 version, Pmt PayReports PBatch & Prepay

When attempting to process payment through payment workbench the following error occurs.

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>

The issue has the following business impact:
Due to this issue, users cannot process payment


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
 Standard Patching Process
 Patch Wizard
 Have more questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.