SIL_RetailLoadControlSeedData Loads W_GLOBAL_CURR_G Table Incorrect.
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.
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:
- Run the package SIL_RetailLoadControlSeedData.
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms