My Oracle Support Banner

After Reclassification the Stock On Hand Value is Retaining In The Current Table W_RTL_INV_IT_LC_DY_G (Doc ID 2547766.1)

Last updated on SEPTEMBER 29, 2019

Applies to:

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

Symptoms

After reclassification, stock on hand (SOH) value is retaining in the current table.  
Some items in RMS ITEM_LOC_SOH vs RI fact (W_RTL_INV_IT_LC_DY_F) the Stock on hand value is matching, But in RI current table(W_RTL_INV_IT_LC_DY_G) the SOH value is not in sync with ITEM_LOC_SOH. 

Steps to Recreate:

1. Run RDE Batches

prditmsde.ksh
prdhiersde.ksh

Unloader batches
rtluasde.ksh W_PRODUCT_ATTR_DS
rtluasde.ksh W_PRODUCT_DS_TL
rtluasde.ksh W_PROD_CAT_DHS
rtluasde.ksh W_RTL_INV_IT_LC_DY_FS

2. Run RI batches

Loader batches
rtluasil.ksh W_PRODUCT_ATTR_DS
rtluasil.ksh W_PRODUCT_DS_TL
rtluasil.ksh W_PROD_CAT_DHS
rtluasil.ksh W_RTL_INV_IT_LC_DY_FS

prditmsil.ksh
prdhiersil.ksh
prddimlkuptmpplp.ksh

3. To load G and Fact : invildsil.ksh.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.