R12: AP/IBY: BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS, ORA-00001: unique constraint (APPS.IBY_DOCS_PAYABLE_VAL_GT_U1) violated (Doc ID 2128143.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

Build Payments concurrent program failing in the Document Validation step while processing check batches.
The following is seen in the failed Build Payments concurrent logfile.

ERROR
-----------------------
BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
Error Message:BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
.
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 4: Document Validation
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+----------------------------------------------------------------------------------------------------+
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 <REQ_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
Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request.

After enabling FND Debug (see Doc ID 1320736.1 for steps), further details is seen in the log:

IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 4: Document Validation

IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:Enter initDocDataForPPR
IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:Process Type is:STANDARD
Enter:TIMESTAMP:: iby.plsql.IBY_FD_EXTRACT_GEN_PVT.Get_FP_TaxRegistration:: 
...
IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:Exit initDocDataForPPR
IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL code: -1
IBY_VALIDATIONSETS_PUB.initDocDataForPPR: IBY_VALIDATIONSETS_PUB.initDocDataForPPR:SQL err msg: ORA-00001: unique constraint (APPS.IBY_DOCS_PAYABLE_VAL_GT_U1) violated
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:ORA-00001: unique constraint (APPS.IBY_DOCS_PAYABLE_VAL_GT_U1) violated
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 <REQ_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
Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request.

Changes

Cause

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