My Oracle Support Banner

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 NOVEMBER 27, 2018

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Oracle Human Resources - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

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

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 19046
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, 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 19109
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.

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.