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.


Error when trying to pay an invoice

APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error occurred in
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


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