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

Last updated on NOVEMBER 10, 2016

Applies to:

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

Symptoms

While processing a PPR (payment process request R12) , 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 5000

Below is the error message in Log file:

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 167
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

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