SIL_RetailLoadControlSeedData Loads W_GLOBAL_CURR_G Table Incorrect. (Doc ID 1926500.1)

Last updated on APRIL 13, 2016

Applies to:

Oracle Retail Merchandising Insights - Version 13.3.1 to 13.3.7 [Release 13.3]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Analytics (RA) 13.3.X, the seed data for W_GLOBAL_CURR_G is not in the correct order. The result of this is a NULL DEFAULT_LOC_RATE_TYPE which causes all base and global amounts to be NULL in the aggregate tables.

In addition, SIL_RetailLoadControlSeedData inserts invalid values including GLOBAL4_CURR_CODE.


Steps to Reproduce:

  1. Run the package SIL_RetailLoadControlSeedData.
  2. Observe that the value for DEFAULT_LOC_RATE_TYPE is NULL, and the GLOBAL4_CURR_CODE value is invalid (in the sample case, 'Corporate') in the table W_GLOBAL_CURR_G.

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