Build Program Error Unique Constraint (FUSION.IBY_DOCS_PAYABLE_VAL_GT_U1) Violated (Doc ID 2777188.1)

Last updated on JUNE 14, 2021

Applies to:

Symptoms

When attempting to create a Payment Process Request the following error occurs.

ERROR
-----------------------

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 (FUSION.IBY_DOCS_PAYABLE_VAL_GT_U1) violated.
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: SQLCODE: -1.
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: ORA-00001: unique constraint (FUSION.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 89149.
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_SUBMIT_PUB_PKG.submit_payment_process_request: EXIT .

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.