Build Program Error - Cannot Validate Documents and ORA-01422

(Doc ID 1281024.1)

Last updated on OCTOBER 03, 2017

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 says:
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Payment profile is compatible with payment format for document id: 625606
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Bank Acct Id field is: 14028 for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Payee Id field is: 19979 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 34228
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: 34228, 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

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