RDE Job Configuration

RDE programs have many configuration options available in the C_ODI_PARAM_VW table in the Control & Tactical Center. These must be reviewed prior to running RDE jobs. For any RDE job having an incremental flag below, the associated jobs in the RI/AIF DATA batch schedule also have incremental flags that must be updated at the same time. Having the RDE and AIF DATA flags be out of sync can result in data loss.

In addition to these parameters, it is also important to understand the MFCS settings relating to data purging and configure them accordingly before using RDE to extract data. Because RDE runs only at the end of the day after MFCS has started a nightly cycle, it is critical that no table in MFCS is set to purge data immediately (purge days <= 1). It is best if all purge-related MFCS settings are extended far enough so that, even if an RDE batch is missed for a day or two, there will not be any data lost due to MFCS nightly purge programs.

One MFCS setting in particular, EDI_REV_DAYS, must be updated to be high enough so that there is no chance of purging old order revisions while they might still receive updates that RDE needs to extract. We recommend changing this value to be at least 30 days (or longer, if you have any processes that might update an order 30+ days after initially closing it). The associated purchase order purge setting, ORDER_HISTORY_MONTHS, must also be more than a month out.

Scenario	Parameter	Usage
GLOBAL	RPM_PROMO_EVENT_LEVEL	Enable (set to Y) if using legacy RPM on-premise functionality.
GLOBAL	RETURN_REASON_CAT_CODE	Merchandising code type for customer return reason codes.
GLOBAL	RTVR_REASON_CAT_CODE	Merchandising code type for RTV reason codes.
GLOBAL	WHOLESALE_CHANNEL	Identify whether there is a wholesale channel setup in Merchandising.
GLOBAL	ITEM_GRP1_IS_INCREMENTAL	Controls whether item attributes are incremental or full snapshots on the daily load.
GLOBAL	RMS_VERS_CHECK	Controls the behavior of code that is linked to a specific Merchandising version.
GLOBAL	RA_INV_WAC_IND	Controls the inventory cost calculation in RDE. When set to Y it will use Weighted Average Cost (WAC) as the item cost for all items. When set to N it will dynamically load Merchandising valuation methods set per department or item and apply them, choosing from average cost, unit cost, and retail-based cost.
GLOBAL	RA_INV_TAX_IND	Controls the calculation and removal of tax amounts from retail valuation of stock on hand and on-order amounts. When set to N, only simple VAT (SVAT) calculations are supported and non-VAT items are left as-is. When set to Y, the system dynamically loads Merchandising global tax and VAT information and applies it by item/location.
SDE_RETAILINVRECEIPTSFACT	VWH_NO_ALC_RCPTS	Specify a type of warehouse that cannot receive allocations in the feed to RI. Converts the allocations to normal transfer receipts. Uses codes from VWH_TYPE column in Merchandising.
SDE_RETAILINVRECEIPTSFACT	STORE_NO_ALC_RCPTS	Specify a type of store that cannot receive allocations in the feed to RI. Converts the allocations to normal transfer receipts.
SDE_RETAILITEMDIMENSION	IS_INCREMENTAL	Controls whether the product dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILITEMLOCATIONRANGEDIMENSION	IS_INCREMENTAL	Controls whether the product location range dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILITEMSUPPLIERDIMENSION	IS_INCREMENTAL	Controls whether the supplier-item dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILSUBSTITUTEITEMDIMENSION	IS_INCREMENTAL	Controls whether the substitute-item dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILITEMLOCATIONDIMENSION	IS_INCREMENTAL	Controls whether the product location attribute dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILITEMLOCCFADIMENSION	IS_INCREMENTAL	Controls whether the product location CFAS dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILSUPPCFADIMENSION	IS_INCREMENTAL	Controls whether the supplier CFAS dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILLOCATIONCFADIMENSION	IS_INCREMENTAL	Controls whether the location CFAS dimension is a full snapshot or incremental changes only for the daily load.
SDE_RETAILITEMCFADIMENSION	IS_INCREMENTAL	Controls whether the product CFAS dimension is a full snapshot or incremental changes only for the daily load.

The flags that impact the incremental/full load behavior for the AIF DATA jobs linked to RDE jobs are also provided below and should be configured at the same time.

Scenario	Parameter	Usage
SIL_ITEMDIMENSION	IS_INCREMENTAL	Controls whether the product dimension is a full snapshot or incremental changes only for the daily load.
SIL_RETAILITEMCFADIMENSION	IS_INCREMENTAL	Controls whether the product CFAS dimension is a full snapshot or incremental changes only for the daily load.
SIL_RETAILITEMLOCCFADIMENSION	IS_INCREMENTAL	Controls whether the product location CFAS dimension is a full snapshot or incremental changes only for the daily load.
SIL_RETAILLOCATIONCFADIMENSION	IS_INCREMENTAL	Controls whether the location CFAS dimension is a full snapshot or incremental changes only for the daily load.
SIL_RETAILSUPPCFADIMENSION	IS_INCREMENTAL	Controls whether the supplier CFAS dimension is a full snapshot or incremental changes only for the daily load.
SIL_RETAILSUBSTITUTEITEMDIMENSION	IS_INCREMENTAL	Controls whether the substitute item dimension is a full snapshot or incremental changes only for the daily load.
SIL_RETAILPROMOTIONDIMENSION	RI_INCREMENTAL_IND	Controls whether the promotion dimension is a full snapshot or incremental changes only for the daily load.