Incorrect Type for ITEM Column In FM_FRECLASS_STG Table (Doc ID 2286838.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

In FM_FRECLASS_STG table the type for the column is defined incorrectly to NUMBER(30).In RMS data model, item Ids are VARCHAR2(25), as in the ITEM_MASTER table.

Some of the item numbers can have multiple left zeros [Example: 000019813456], such items are not being properly handled in the fiscal reclassification process due to the inconsistency.

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