Inventory SC_DY/WK_CUR_A Table Shows Missing Data in Some Columns After Reclass Aggregation (Doc ID 1948269.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

The inventory SC_DY/WK_CUR_A table displays missing data in some columns after performin reclass aggregation.

Steps to Recreate:
 

1. Run the jobs invicurswplp.ksh,invicursdplp.ksh,invicurrcsdplp.ksh,invicurrcswplp.ksh.
2. The values of columns
INV_UNIT_RTL_AMT_LCL,
INV_UNIT_RTL_AMT,
INV_UNIT_RTL_AMT_GLOBAL1,
INV_UNIT_RTL_AMT_GLOBAL2,
INV_UNIT_RTL_AMT_GLOBAL3,
INV_AVG_COST_AMT_LCL,
INV_AVG_COST_AMT,
INV_AVG_COST_AMT_GLOBAL1,
INV_AVG_COST_AMT_GLOBAL2,
INV_AVG_COST_AMT_GLOBAL3,
INV_UNIT_COST_AMT_LCL,
INV_UNIT_COST_AMT,
INV_UNIT_COST_AMT_GLOBAL1,
INV_UNIT_COST_AMT_GLOBAL2,
INV_UNIT_COST_AMT_GLOBAL3 for tables W_RTL_INV_SC_DY_CUR_A and W_RTL_INV_SC_WK_CUR_A have null values as those columns are not mapped.†

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