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

Last updated on MAY 03, 2023

Applies to:

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

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