Getting Error ORA-06502 on Spanish Transfer Forms (Doc ID 2291705.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Retail Merchandising System - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

When trying to create a transfer the below error message appears on screen only in Spanish language, on the forms (FNSOB, TSFCAT and TSFPAT) the field is limited to 30 characters but in table CODE_DETAIL the field CODE_DESC is longer in Spanish language.

Error

"ORA-06502: PL/SQL: numeric or value error"


Steps To Reproduce:

1.Inventario-Transferencia   (Transfer screen)
Accion: Nueva (New)
Tipo: Solicitud Manual (Type Manual)

Aceptar button (Accept)
fill some fields and chose Artículos (Items)
2.Note the above error

Changes

 

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