R12: AP/IBY: Removing Invoice from Payment Process Request Causes the Build Program to Fail with Error: 'Failed Build Pymts - Unexpected Error' (Doc ID 2055601.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Payments - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

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

Created a payment process request and the user tried to remove one of the invoice(not payment), build payment process error out and the log contain error message 'BUILD PROGRAM ERROR - CANNOT COMPLETE PAYMENT RE-CREATION'.

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

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.

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