SeedDataLoad to W_XACT_TYPE_D Does Not Have Entries for N and B Tran Types

(Doc ID 2145156.1)

Last updated on JUNE 03, 2016

Applies to:

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

Goal

SeedDataLoad of the W_XACT_TYPE_D table has only a few entries in column W_XACT_TYPE_CODE (e.g., 'P', 'I', 'R', 'C').   However, SIL_RetailInventoryTransferFactLoad is checking for entries 'N' (Transfers Out) and 'B' (Book Transfers Out).
 
N and B entries are missing in the seed data load (W_XACT_TYPE_DS.dat file).  Does the user need to populate N and B manually, which is extending to the base?

Solution

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