Error "ORA-06502: Number Precision Too Large" When Consuming RTV Message

(Doc ID 2309108.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Retail Fiscal Management - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

Error "ORA-06502: PL/SQL: erro: number precision too large numeric or value error returned by program unit FM_EXIT_NF_CREATION_SQL.PROCESS_RTV_BALANCE" occurs when a RTV [Return To Vendor] message is consumed through RTV API (RMSSUB_RTV.CONSUME) in a Brazil localized environment.

The issue occurs when the RTV_ID field has more than 10 characters.

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