Item Reclassification in RMS Does Not Reflect in SIM for Child Items
Last updated on MARCH 29, 2017
Applies to:Oracle Retail Store Inventory Management - Version 13.2.4 to 13.2.9 [Release 13.2]
Oracle Retail Store Inventory Management - Version 14.0 to 14.0.3 [Release 14.0]
Oracle Retail Store Inventory Management - Version 13.1 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.
When Store Inventory Management (SIM) is integrated with Retail Merchandising System (RMS), if a transaction level item is reclassified in RMS by changing its merchandise hierarchy, the hierarchy changes are not getting updated in SIM for the child items. In RMS, the change is applied to both the transaction level item and the child items.
Steps to Reproduce:
- Check the hierarchy for a transaction item and its children items in RMS and SIM.
- Reclassify the transactional item to another DEPT CLASS SUBCLASS (for example, change the SUBCLASS).
- Run the RMS batch program "reclsdly".
- A Retail Integration Bus (RIB) modification message is published correctly from RMS.
- Check the items:
In RMS: select * from ITEM_MASTER where ITEM in (item_id, child_id); (check the DEPT CLASS SUBCLASS values)
In SIM: select * from AS_ITM where ID_ITM in (item_id, child_id); (check ID_STRC_MR value)
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