My Oracle Support Banner

R12 Concurrent program Settle Netting Batch Completing In Error ORA-06502 (Doc ID 2202962.1)

Last updated on NOVEMBER 23, 2021

Applies to:

Oracle Payables - Version 12.1.1 and later
Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
R12 The program : 'Settle Netting Batch' is completing in error for AP invoices with future discount date.
"Settle Netting Batch-Batch ID 12892
ORA-06502: PL/SQL: numeric or value error occurred in
_Netting_Payment <-- Netting Settlement Process


On : 12.2.5 version, Accounting Issues in AP

Settle Netting Batch is completing in Error

Settle Netting Batch-Batch ID xxxx

ORA-06502: PL/SQL: numeric or value error occurred in
AP_PAYMENT_PUBLIC_PKG.Create_Netting_Inv_Payment<-AP_PAYMENT_PUBLIC_PKG.Create_Netting_Payment with parameters ( P_check_id = xxx P_payment_type_flag = N P_payment_method = NETTING P_bank_account_id = xxxx P_bank_account_num = P_bank_account_type = P_bank_num = P_check_date = xxxx P_period_name = xxx P_currency_code = USD P_base_currency_code = USD P_checkrun_id = xxxx P_exchange_rate = 1 P_exchange_rate_type = Corporate P_exchange_date = 09-OCT-16 P_set_of_books_id = xx P_last_updated_by = xx P_last_update_login = xxx )
while performing the following operation:
Create Invoice Payments Start


The issue can be reproduced at will with the following steps:
1. Submit 'Generate Netting Batch' with Netting Agreement Parameter as NULL(for all netting agreements).
2. The program : Settle Netting Batch, completes in error.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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