My Oracle Support Banner

Variable in SIL_RETAILINVPOSITIONFACT Is Misplaced and Is Thus Used Before Being Properly Initialized (Doc ID 1604559.1)

Last updated on NOVEMBER 13, 2018

Applies to:

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

Symptoms

In the interface SIL_RETAILINVPOSITIONFACT of Retail Merchandising Analytics (RA), the variable RA_BUSINESS_CURRENT_DT_WID is misplaced.  It is being used in previous steps before it gets initialized in the interface.


Steps to Reproduce:

1. Execute the job ./invildsil.ksh and check the operator log.
2. Open interface SIL_RETAILINVPOSITIONFACT.
3. Check Step 8: "RA_INV_POS_CUR_PART_FIRST_DT_WID".  You will find that this step uses RA_BUSINESS_CURRENT_DT_WID to refresh based on the following:
   Refresh Variable RA_BI.RA_INV_POS_CUR_PART_FIRST_DT_WID:
   select NVL(MAX(from_value),1)
   from RADM01.W_RTL_PARTITION_MAP_G
   where table_name = 'W_RTL_INV_IT_LC_DY_F'
   and from_value <= TO_NUMBER('#RA_BI.RA_BUSINESS_CURRENT_DT_WID')

4. Note that RA_BUSINESS_CURRENT_DT_WID is not refreshed until step 11 of the interface.  Thus, the variable RA_BUSINESS_CURRENT_DT_WID is used before being initialized.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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