My Oracle Support Banner

R12:AP: Build failed with: CANNOT COMPLETE PAYMENT RE-CREATION (Doc ID 1357344.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Payables - Version 12.0.3 and later
Information in this document applies to any platform.

Symptoms

While processing a PPR, stop after build and remove some of the invoices from PPR. Try to continue the PPR, the re-build is erring with Unexpected Errors.

Exception occured when re-building payments. Payment creation will be aborted and no payments will be committed for payment request

Below is the error message in Log file:

BUILD PROGRAM ERROR - CANNOT COMPLETE PAYMENT RE-CREATION

IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Payment service request x is a duplicate. Skipping insert of documents

IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:

IBY_PAYGROUP_PUB.populatePmtTable:Enter
IBY_PAYGROUP_PUB.applyPaymentValidationSets:SQL code: 100
IBY_PAYGROUP_PUB.applyPaymentValidationSets:SQL err msg: ORA-01403: no data found
IBY_PAYGROUP_PUB.applyPaymentValidationSets:IBY_PAYGROUP_PUB.applyPaymentValidationSets:Exception while performing applyPaymentValidationSets
IBY_PAYGROUP_PUB.createPayments:SQL code: 100
IBY_PAYGROUP_PUB.createPayments:SQL err msg: ORA-01403: no data found
IBY_PAYGROUP_PUB.createPayments:IBY_PAYGROUP_PUB.createPayments:Exception while creating payments
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when re-building payments. Payment creation will be aborted and no payments will be committed for payment request x
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: 100
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-01403: no data found
Build program error: Exception occured when attempting to re-create payments from the documents payable of the provided payment service request.

 

Bank does not allow 0 payments and the error in validation table says:

Document payable was failed because its parent payment was failed
Document payable was failed because its parent payment was failed
Zero amount payment not allowed for the internal bank account used.

 

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.