Incorrect Type for ITEM Column In FM_FRECLASS_STG Table
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.
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.
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