R12:AP/IBY: Build Payments Program Completed With Error (Doc ID 2590897.1)

Last updated on JANUARY 31, 2025

Applies to:

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

Symptoms

Unable to build Payments

Build Program failed with error "ORA-01426: numeric overflow"

A FND Debug Log of the execution of the Funds Disbursement Build Program shows the following:

Error Message:BUILD PROGRAM ERROR - CANNOT CREATE PAYMENTS
Request completed in error.
Done roll back changes.
An error occurred. Roll back any changes.
.....................
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-01426: numeric overflow
sid:5758799: IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-01426: numeric overflow
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -1426
sid:5758799: IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -1426
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when building payments. Payment creation will be aborted and no payments will be committed for payment request 461
sid:5758799: IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when building payments. Payment creation will be aborted and no payments will be committed for payment request 461
IBY_PAYGROUP_PUB.createPayments:IBY_PAYGROUP_PUB.createPayments:Exception while creating payments
sid:5758799: IBY_PAYGROUP_PUB.createPayments:IBY_PAYGROUP_PUB.createPayments:Exception while creating payments

Steps to reproduce:

Log into Oracle Applications using a Payments responsibility.
Go to Payment manager
(N) Payment Manager > Home
Submit a new Payment Process Request (PPR)
Open the Requests
(N) View > Requests
Review the Build Payments (IBYBUILD) concurrent request fired for the PPR submitted.
See the program failed and the log has the error described.