Some Inventory Receipts Tables Are Not Loaded, but Are Yet Present in OBIEE Reports Dashboard (Doc ID 1668874.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Retail Merchandising Insights - Version 13.2.4 to 13.2.7 [Release 13.2]
Oracle Retail Merchandising Insights - Version 13.3 to 13.3.7 [Release 13.3]
Oracle Retail Merchandising Insights - Version 14.0 to 14.0.1 [Release 14.0]
Information in this document applies to any platform.
Checked for relevance as on 30-MAR-17

Symptoms

In Oracle Retail Analytics (RA) 13.2.x, some inventory receipts tables are not loaded, but are still present in the OBIEE Reports Dashboard (RPD).  Because of this, OBIEE reports attempt to pull data from these tables and result in "NO RESULT".

The following tables are not loaded by the base RA batch, but are present in OBIEE RPD:
   W_RTL_INVRC_DP_WK_A
   W_RTL_INVRC_DP_DY_A
   W_RTL_INVRC_CL_WK_A
   W_RTL_INVRC_CL_DY_A


Steps to Recreate:

1. Run the OBIEE report and select the listed columns:
    Item As Was, Business Calendar, Inventory Receipts, Class Fiscal Date, and Receipts Qty
2. Note the returned message: "No Result".

 

Changes

 

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