My Oracle Support Banner

Build Program Error - Cannot Validate Documents and ORA-01422 (Doc ID 1281024.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.
IBYBUILD: Build Payments


Symptoms

The Build Payment program finishes with error:
BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS

The fnd log shows:
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Payment profile is compatible with payment format for document id: <ID>
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Bank Acct Id field is: <ID> for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Payee Id field is: <ID> for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Bank Acct is not present at supplier site level
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: ORA-01422: exact fetch returns more than requested number of rows
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: Exception occured when validating documents. Document validation will be aborted and no document statuses will be committed for payment request <ID>
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: SQLCODE: 1
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: SQLERRM: User-Defined Exception
IBY_DISBURSE_UI_API_PUB_PKG.unlock_pmt_entity: ENTER
IBY_DISBURSE_UI_API_PUB_PKG.unlock_pmt_entity: Input params - object id: <ID>, object type: PAYMENT_REQUEST
IBY_DISBURSE_UI_API_PUB_PKG.unlock_pmt_entity: Returning success response ..
IBY_DISBURSE_UI_API_PUB_PKG.unlock_pmt_entity: EXIT
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: EXIT

So the key to the error is the ORA-01422 error

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
Cause
Solution
References


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