R12: AP/IBY: Removing Invoice from Payment Process Request Causes the Build Program to Fail with Error: 'Failed Build Pymts - Unexpected Error'
Last updated on FEBRUARY 26, 2018
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.
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'.
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: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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms