R12: AP: Payments Workbench Error: ORA-06502 PL/SQL: Numeric Or Value Error with Brazilian Localizations (Doc ID 2215866.1)

Last updated on MARCH 04, 2019

Applies to:

Symptoms

Error when trying to pay an invoice

APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error occurred in
ap_calculate_interest<-AP_PAY_IN_FULL_PKG.GET_SINGLE_PAYMENT_AMOUNT<-AP_PAY_IN_FULL_PKG.AP_GET_CHECK_AMOUNT<-APXPAWKB
with parameters (Invoice_id = xxxx, Payment_num = 1, Check_date = DD-MON-YY, sys_auto_calc_int_flag = Y, auto_calculate_interest_flag = Y, Amount_remaining = -zzzz, Discount_taken = 0, Discount_available = 0, Currency_code =yyyy)
while performing the following operation:
Get the interest invoice Num

Cause

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