Incorrect Type for ITEM Column In FM_FRECLASS_STG Table
(Doc ID 2286838.1)
Last updated on FEBRUARY 22, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document