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

Last updated on NOVEMBER 18, 2016

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.
Error:
"Settle Netting Batch-Batch ID 12892
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 <-- Netting Settlement Process

Symptoms

On : 12.2.5 version, Accounting Issues in AP

Settle Netting Batch is completing in Error


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




STEPS
-----------------------
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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate netting batches.

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