R12: AP/IBY: Removing Invoice from Payment Process Request Causes Build Payments to Fail (Doc ID 2055601.1)

Last updated on AUGUST 02, 2024

Applies to:

Symptoms

Process a Payment Process Request (PPR), stop after build and remove some of the invoices from PPR.
Try to continue the PPR, it fails with
  Exception occurred when re-building payments. Payment creation will be aborted and no payments will be committed for payment request

Re-build payment request fail with 'Failed Build Payments - Unexpected Errors'

The following in seen in the request log:

ERROR
-----------------------
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 267693
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

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