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 |
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 |
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 |
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 |
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. |