Oracle Retail Knowledge Base

Initial setup - C_ODI_PARAM

14 min read

Context

C_ODI_PARAM is the ODI configuration table that drives how AIF_DATA extracts and loads data. This note seeds it for a brand new environment, before the first batch is ever run. It is part of AIF Initial Setup process and runs once per implementation.

These values are client specific

The values below are the P&C configuration: euro currency, English as the primary language with German added in Initial setup - W_LANGUAGES_G, a calendar starting 2015-01-01, and a particular set of planning and flex fact levels. They are a worked example, not a universal default. Review every value against the client’s requirements before running anything.

Configuration

Connect through APEX, or navigate AI FOUNDATION CLOUD SERVICE > TOP LEFT MENU > Tasks > Control and Tactical Center > Manage Configurations > select the table C_ODI_PARAM.

The statements are grouped by purpose below. Within each group the order does not matter, and the groups are independent of each other.

Parameters

Global environment

10 parameters.

-- PO_EXCHANGE_DT_TYPE
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'A'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'PO_EXCHANGE_DT_TYPE';
 
-- ANCHOR_TO_YEARS
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '3'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'ANCHOR_TO_YEARS';
 
-- CURRENCY_CODE
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'EUR'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'CURRENCY_CODE';
 
-- GIFT_CARD_TENDER_TYPE_ID
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '1'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'GIFT_CARD_TENDER_TYPE_ID';
 
-- HIST_ZIP_FILE
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'RAP_DATA_HIST.zip'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'HIST_ZIP_FILE';
 
-- LANGUAGE_CODE
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'EN'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'LANGUAGE_CODE';
 
-- LY_SHIFT_TYPE
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'SHIFT'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'LY_SHIFT_TYPE';
 
-- RTVR_REASON_CAT_CODE
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'RTVR'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RTVR_REASON_CAT_CODE';
 
-- SAME_STORES
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'SAME_STORES';
 
-- START_OF_YEAR_MONTH
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'JANUARY'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'START_OF_YEAR_MONTH';
Calendar

3 parameters.

-- END_DT - Based on MFCS calendar
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '20351230'
where
	p.SCENARIO_NAME = 'SIL_DAYDIMENSION'
	and p.PARAM_NAME = 'END_DT';
 
-- START_DT - Based on MFCS calendar
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '20070101'
where
	p.SCENARIO_NAME = 'SIL_DAYDIMENSION'
	and p.PARAM_NAME = 'START_DT';
 
-- WEEK_START_DT_VAL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '2'
where
	p.SCENARIO_NAME = 'SIL_DAYDIMENSION'
	and p.PARAM_NAME = 'WEEK_START_DT_VAL';
Item differentiators

18 parameters.

-- COLOR (SDE_RETAILCOLORDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'C'
where
	p.SCENARIO_NAME = 'SDE_RETAILCOLORDIMENSION'
	and p.PARAM_NAME = 'COLOR';
 
-- COLOR (SDE_RETAILDOMAINMEMBERLKUP)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'C'
where
	p.SCENARIO_NAME = 'SDE_RETAILDOMAINMEMBERLKUP'
	and p.PARAM_NAME = 'COLOR';
 
-- COLOR (SDE_RETAILITEMDIFFDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'C'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMDIFFDIMENSION'
	and p.PARAM_NAME = 'COLOR';
 
-- FABRIC (SDE_RETAILDOMAINMEMBERLKUP)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'FAB'
where
	p.SCENARIO_NAME = 'SDE_RETAILDOMAINMEMBERLKUP'
	and p.PARAM_NAME = 'FABRIC';
 
-- FABRIC (SDE_RETAILITEMATTRDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'FAB'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMATTRDIMENSION'
	and p.PARAM_NAME = 'FABRIC';
 
-- FABRIC (SDE_RETAILITEMDIFFDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'FAB'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMDIFFDIMENSION'
	and p.PARAM_NAME = 'FABRIC';
 
-- FLAVOR (SDE_RETAILDOMAINMEMBERLKUP)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'F'
where
	p.SCENARIO_NAME = 'SDE_RETAILDOMAINMEMBERLKUP'
	and p.PARAM_NAME = 'FLAVOR';
 
-- FLAVOR (SDE_RETAILITEMATTRDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'F'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMATTRDIMENSION'
	and p.PARAM_NAME = 'FLAVOR';
 
-- FLAVOR (SDE_RETAILITEMDIFFDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'F'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMDIFFDIMENSION'
	and p.PARAM_NAME = 'FLAVOR';
 
-- SCENT (SDE_RETAILDOMAINMEMBERLKUP)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'SC'
where
	p.SCENARIO_NAME = 'SDE_RETAILDOMAINMEMBERLKUP'
	and p.PARAM_NAME = 'SCENT';
 
-- SCENT (SDE_RETAILITEMATTRDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'SC'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMATTRDIMENSION'
	and p.PARAM_NAME = 'SCENT';
 
-- SCENT (SDE_RETAILITEMDIFFDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'SC'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMDIFFDIMENSION'
	and p.PARAM_NAME = 'SCENT';
 
-- SIZE (SDE_RETAILDOMAINMEMBERLKUP)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'S'
where
	p.SCENARIO_NAME = 'SDE_RETAILDOMAINMEMBERLKUP'
	and p.PARAM_NAME = 'SIZE';
 
-- SIZE (SDE_RETAILITEMATTRDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'S'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMATTRDIMENSION'
	and p.PARAM_NAME = 'SIZE';
 
-- SIZE (SDE_RETAILITEMDIFFDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'S'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMDIFFDIMENSION'
	and p.PARAM_NAME = 'SIZE';
 
-- STYLE (SDE_RETAILDOMAINMEMBERLKUP)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'STY'
where
	p.SCENARIO_NAME = 'SDE_RETAILDOMAINMEMBERLKUP'
	and p.PARAM_NAME = 'STYLE';
 
-- STYLE (SDE_RETAILITEMATTRDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'STY'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMATTRDIMENSION'
	and p.PARAM_NAME = 'STYLE';
 
-- STYLE (SDE_RETAILITEMDIFFDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'STY'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMDIFFDIMENSION'
	and p.PARAM_NAME = 'STYLE';
CFA visibility

5 parameters.

-- ITEM_CFA_VISIBILTY
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '0'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'ITEM_CFA_VISIBILTY';
 
-- ITEM_LOC_CFA_VISIBILTY
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '0'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'ITEM_LOC_CFA_VISIBILTY';
 
-- LOC_CFA_VISIBILTY
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '0'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'LOC_CFA_VISIBILTY';
 
-- MCAL_DAY_CFA_VISIBILTY
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '1'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'MCAL_DAY_CFA_VISIBILTY';
 
-- SUPS_CFA_VISIBILTY
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '0'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'SUPS_CFA_VISIBILTY';
Initial load flags

19 parameters.

-- INV_FULL_LOAD_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_RETAILINVPOSITIONFACT'
	and p.PARAM_NAME = 'INV_FULL_LOAD_IND';
 
-- IS_INCREMENTAL (SIL_RETAILSUBSTITUTEITEMDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_RETAILSUBSTITUTEITEMDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SIL_ITEMDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_ITEMDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SIL_TIMEOFDAYDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_TIMEOFDAYDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SIL_RETAILITEMCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_RETAILITEMCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SIL_RETAILITEMLOCCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_RETAILITEMLOCCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SIL_RETAILLOCATIONCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_RETAILLOCATIONCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SIL_RETAILSUPPCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_RETAILSUPPCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILITEMDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILITEMLOCATIONRANGEDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMLOCATIONRANGEDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILITEMSUPPLIERDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMSUPPLIERDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILSUBSTITUTEITEMDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILSUBSTITUTEITEMDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILITEMLOCATIONDIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMLOCATIONDIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILITEMLOCCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMLOCCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILSUPPCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILSUPPCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILLOCATIONCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILLOCATIONCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- IS_INCREMENTAL (SDE_RETAILITEMCFADIMENSION)
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SDE_RETAILITEMCFADIMENSION'
	and p.PARAM_NAME = 'IS_INCREMENTAL';
 
-- PO_FULL_LOAD_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'SIL_RETAILPOONORDERFACT'
	and p.PARAM_NAME = 'PO_FULL_LOAD_IND';
 
-- RI_BOH_SEEDING_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAILINVPOSITIONFACT'
	and p.PARAM_NAME = 'RI_BOH_SEEDING_IND';
Dimension seeding

8 parameters.

-- RI_MIS_CASHIER_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_EMPLOYEEDIMENSION'
	and p.PARAM_NAME = 'RI_MIS_CASHIER_REQ_IND';
 
-- RI_MIS_COHEAD_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAIL_COHEADDIMENSION'
	and p.PARAM_NAME = 'RI_MIS_COHEAD_REQ_IND';
 
-- RI_MIS_COLINE_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAILCOLINEDIMENSION'
	and p.PARAM_NAME = 'RI_MIS_COLINE_REQ_IND';
 
-- RI_MIS_COUPON_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAILCOUPONDIMENSION'
	and p.PARAM_NAME = 'RI_MIS_COUPON_REQ_IND';
 
-- RI_MIS_CUSTOMER_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAILCUSTOMERDIMENSION'
	and p.PARAM_NAME = 'RI_MIS_CUSTOMER_REQ_IND';
 
-- RI_MIS_DISC_TYPE_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAILDISCOUNTTYPEDIMENSION'
	and p.PARAM_NAME = 'RI_MIS_DISC_TYPE_REQ_IND';
 
-- RI_MIS_PROMO_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAILPROMODIMENSION'
	and p.PARAM_NAME = 'RI_MIS_PROMO_REQ_IND';
 
-- RI_MIS_STOCK_CNT_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_SEEDSTOCKCOUNTDIMENSION'
	and p.PARAM_NAME = 'RI_MIS_STOCK_CNT_REQ_IND';
Flex facts

15 parameters.

-- RI_FLEXFACT1_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT1_ATTR_LEVEL';
 
-- RI_FLEXFACT1_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT1_CAL_LEVEL';
 
-- RI_FLEXFACT1_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'COMPANY'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT1_ORG_LEVEL';
 
-- RI_FLEXFACT1_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ITEM'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT1_PROD_LEVEL';
 
-- RI_FLEXFACT1_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT1_SUPP_LEVEL';
 
-- RI_FLEXFACT2_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT2_ATTR_LEVEL';
 
-- RI_FLEXFACT2_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'DAY'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT2_CAL_LEVEL';
 
-- RI_FLEXFACT2_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'LOCATION'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT2_ORG_LEVEL';
 
-- RI_FLEXFACT2_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT2_PROD_LEVEL';
 
-- RI_FLEXFACT2_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT2_SUPP_LEVEL';
 
-- RI_FLEXFACT4_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT4_ATTR_LEVEL';
 
-- RI_FLEXFACT4_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'DAY'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT4_CAL_LEVEL';
 
-- RI_FLEXFACT4_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'LOCATION'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT4_ORG_LEVEL';
 
-- RI_FLEXFACT4_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT4_PROD_LEVEL';
 
-- RI_FLEXFACT4_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_FLEXFACT4_SUPP_LEVEL';
Planning levels

35 parameters.

-- RI_PLAN1_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN1_ATTR_LEVEL';
 
-- RI_PLAN1_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN1_CAL_LEVEL';
 
-- RI_PLAN1_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'CHANNEL_COUNTRY'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN1_ORG_LEVEL';
 
-- RI_PLAN1_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'SBC'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN1_PROD_LEVEL';
 
-- RI_PLAN1_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN1_SUPP_LEVEL';
 
-- RI_PLAN2_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN2_ATTR_LEVEL';
 
-- RI_PLAN2_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN2_CAL_LEVEL';
 
-- RI_PLAN2_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'CHANNEL_COUNTRY'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN2_ORG_LEVEL';
 
-- RI_PLAN2_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'DEPT'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN2_PROD_LEVEL';
 
-- RI_PLAN2_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN2_SUPP_LEVEL';
 
-- RI_PLAN3_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN3_ATTR_LEVEL';
 
-- RI_PLAN3_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN3_CAL_LEVEL';
 
-- RI_PLAN3_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'LOCATION'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN3_ORG_LEVEL';
 
-- RI_PLAN3_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'DEPT'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN3_PROD_LEVEL';
 
-- RI_PLAN3_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN3_SUPP_LEVEL';
 
-- RI_PLAN4_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN4_ATTR_LEVEL';
 
-- RI_PLAN4_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN4_CAL_LEVEL';
 
-- RI_PLAN4_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'LOCATION'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN4_ORG_LEVEL';
 
-- RI_PLAN4_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'CMP'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN4_PROD_LEVEL';
 
-- RI_PLAN4_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN4_SUPP_LEVEL';
 
-- RI_PLAN5_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN5_ATTR_LEVEL';
 
-- RI_PLAN5_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN5_CAL_LEVEL';
 
-- RI_PLAN5_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'LOCATION'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN5_ORG_LEVEL';
 
-- RI_PLAN5_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ITEM'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN5_PROD_LEVEL';
 
-- RI_PLAN5_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLAN5_SUPP_LEVEL';
 
-- RI_PLANFC1_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC1_ATTR_LEVEL';
 
-- RI_PLANFC1_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC1_CAL_LEVEL';
 
-- RI_PLANFC1_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'LOCATION'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC1_ORG_LEVEL';
 
-- RI_PLANFC1_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ITEM'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC1_PROD_LEVEL';
 
-- RI_PLANFC1_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC1_SUPP_LEVEL';
 
-- RI_PLANFC2_ATTR_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC2_ATTR_LEVEL';
 
-- RI_PLANFC2_CAL_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'WEEK'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC2_CAL_LEVEL';
 
-- RI_PLANFC2_ORG_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'LOCATION'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC2_ORG_LEVEL';
 
-- RI_PLANFC2_PROD_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ITEM'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC2_PROD_LEVEL';
 
-- RI_PLANFC2_SUPP_LEVEL
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'ALL'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PLANFC2_SUPP_LEVEL';
Data retention and behaviour

12 parameters.

-- RA_INV_TAX_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RA_INV_TAX_IND';
 
-- RA_INV_WAC_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RA_INV_WAC_IND';
 
-- RA_SLS_TAX_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RA_SLS_TAX_IND';
 
-- RI_CLOSED_PO_HIST_DAYS
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '30'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_CLOSED_PO_HIST_DAYS';
 
-- RI_GEN_PROD_RECLASS_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_GEN_PROD_RECLASS_IND';
 
-- RI_INT_ORG_DS_MANDATORY_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_INT_ORG_DS_MANDATORY_IND';
 
-- RI_INV_HIST_DAYS
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '91'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_INV_HIST_DAYS';
 
-- RI_INVAGE_REQ_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'SIL_RETAILINVPOSITIONFACT'
	and p.PARAM_NAME = 'RI_INVAGE_REQ_IND';
 
-- RI_ITEM_REUSE_AFTER_DAYS
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '0'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_ITEM_REUSE_AFTER_DAYS';
 
-- RI_ITEM_REUSE_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'N'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_ITEM_REUSE_IND';
 
-- RI_LOC_CLOSE_AFTER_DAYS
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = '15'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_LOC_CLOSE_AFTER_DAYS';
 
-- RI_PROD_DS_MANDATORY_IND
update c_odi_param p
set
	p.CHANGE_ON_DT = sysdate,
	p.param_value = 'Y'
where
	p.SCENARIO_NAME = 'GLOBAL'
	and p.PARAM_NAME = 'RI_PROD_DS_MANDATORY_IND';

Reference

Graph View

Backlinks