My Oracle Support Banner

Missing Transfer Type Dimension Table In RI( Retail Insights) (Doc ID 2405382.1)

Last updated on MARCH 16, 2019

Applies to:

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


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.


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.




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

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