Exception Occurred When Performing Document Validation - ORA-12899: value too large for column "AP

(Doc ID 1907585.1)

Last updated on SEPTEMBER 06, 2016

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: 144499
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms