Data Steward Dashboard Not Working As Expected , Item Report Shows With Item Location Marked as Incomplete

(Doc ID 2347081.1)

Last updated on JANUARY 20, 2018

Applies to:

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

Symptoms

Data Steward Dashboard is not displaying results as expected.


Pre-Requisites:
Data Setup and requirements are as follows:

RMS_OI_SYSTEM_OPTIONS.DS_SHOW_INCOMP_ITEM_LOC = R

RMS_OI_SYSTEM_OPTIONS.DS_SHOW_INCOMP_ITEM_UDA = R
We are overriding UDA to be Not Required for some departments.

Let's say DEPT 604 is to be overridden for UDA's.
RMS_OI_DEPT_OPTIONS.DS_SHOW_INCOMP_ITEM_UDA = N for DEPT 604.
RMS_OI_DEPT_OPTIONS.DS_SHOW_INCOMP_ITEM_LOC = NULL for DEPT 604.

Steps To Recreate:

1.Create an Item, associate one or more locations to the item and approve the item.

2. The item shows up in the Data Steward Incomplete Item Report with Item Location marked as incomplete even though Locations are associated to the item.

Note: If you switch the values for RMS_OI_DEPT_OPTIONS.DS_SHOW_INCOMP_ITEM_UDA = N for DEPT 604 to RMS_OI_DEPT_OPTIONS.DS_SHOW_INCOMP_ITEM_UDA = R for DEPT 604 the Dashboard shows Item Location as completed.


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