R12: AP: Payments Workbench Error: ORA-06502 PL/SQL: Numeric Or Value Error with Brazilian Localizations

(Doc ID 2215866.1)

Last updated on JANUARY 05, 2017

Applies to:

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

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 = 9999999, Payment_num = 1, Check_date = DD-MON-YY, sys_auto_calc_int_flag = Y, auto_calculate_interest_flag = Y, Amount_remaining = -999.99, Discount_taken = 0, Discount_available = 0, Currency_code = BRL)
while performing the following operation:
Get the interest invoice Num

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