Variable in SIL_RETAILINVPOSITIONFACT Is Misplaced and Is Thus Used Before Being Properly Initialized
(Doc ID 1604559.1)
Last updated on MARCH 16, 2019
Applies to:Oracle Retail Merchandising Insights - Version 13.2.4 and later
Information in this document applies to any platform.
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:
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.
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