Missing Transfer Type Dimension Table In RI( Retail Insights).

(Doc ID 2405382.1)

Last updated on JUNE 07, 2018

Applies to:

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

Symptoms

There is no Transfer Type Dimension Table in RI which is used in the fact table of inventory transfer for the lookup.
As per the document of RI, the transfer type lookup is to be done in W_XACT_TYPE_D which only holds the data for pricing type and has four rows for P - Promotion, R - Regular, I - Intercompany and C - Clearance.

Steps:

1. Check the data in W_XACT_TYPE_D. There are only four rows for P, R, I , C.
2. Check the ODI code for Inventory Transfer fact It is looking up in the table W_XACT_TYPE_D for the code B - Book Transfer, N - Normal Transfer and I - Intercompany transfer. Lookup fails.
3. There is missing W_TSF_TYPE_D table which actually should hold B - Book Transfer, N - Normal Transfer and I - Intercompany transfer in 3 rows.

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