5 RAP Integration

Mirror of Oracle documentation

Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Interfaces Available in the IPOCS-Demand Forecasting / IPOCSLifecycle Allocation and Replenishment Template

Following is the pre-defined grouping of interfaces available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment template version within RAP integration:

• Product Hierarchy from RMFCS using Retail Insights (RI)

• Organization Hierarchy from RMFCS using Retail Insights (RI)

• Calendar Hierarchy from RMFCS using Retail Insights (RI)

• Product Attribute Hierarchy from RMFCS using Retail Insights (RI)

• Supplier Hierarchy from RMFCS using Retail Insights (RI)

• Item Attributes from Retail Insights (RI)

• Sales Data from Retail Insights (RI)

• Pack Assortment from Retail Insights (RI)

• Inventory Data from Retail Insights (RI)

• Replenishment Attributes from Retail Insights (RI)

• Offer Hierarchy from Science (AIF)

• Offer Details from Science (AIF)

• Offer Sales Details from Science (AIF)

• Reward Type Hierarchy from Science (AIF)

• Product Attribute Weight from Science (AIF)

• Forecast Import from Science (AIF)

• Base Demand Import from Science (AIF)

• Approved Base Demand Import from Science (AIF)

• Preprocessed Sales Import from Science (AIF)

• Export Run Type Batch Setting

• Approved Forecast Export

• Forecast Parameters Export

• New Item Parameters Export

Product Hierarchy from RMFCS using Retail Insights (RI)

Table 5-1 lists the interface grouping for Product Hierarchy from RMFCS using Retail Insights (RI).

Table 5-1 Product Hierarchy from RMFCS using Retail Insights (RI)

RDX Table	RDX Field Name	PDS Field Mapping
W_PDS_PRODUCT_D	ITEM	SKU

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-1 (Cont.) Product Hierarchy from RMFCS using Retail Insights (RI)

RDX Table	RDX Field Name	PDS Field Mapping
	ITEM_PARENT_DIFF	SKUP
	ITEM_PARENT	SKUG
	SUBCLASS_ID	SCLS
	CLASS_ID	CLSS
	DEPT	DEPT
	GROUP_NO	PGRP
	DIVISION	DVSN
	COMPANY	CMPP
	SUPPLIER	VNDR
	ITEM_DESC
	ITEM_PARENT_DIFF_DESC
	ITEM_PARENT_DESC
	SUB_NAME
	CLASS_NAME
	DEPT_NAME
	GROUP_NAME
	DIV_NAME
	CO_NAME
	SUP_NAME
	PACK_FLG (Filter)	PCKFLGVAL

Organization Hierarchy from RMFCS using Retail Insights (RI)

Table 5-2 lists the interface grouping for Organization Hierarchy from RMFCS using Retail Insights (RI).

Table 5-2 Organization Hierarchy from RMFCS using Retail Insights (RI)

RDX Table RDX Field Name	PDS Field Mapping
W_PDS_ORGANIZATION_D LOCATION	STOR
DISTRICT	DSTR
REGION	REGN
AREA	CHNL
CHAIN	CHAN
COMPANY	COMP
LOC_TYPE	LOCT
STORE_FORMAT	SFMT
STORE_CLASS	STCL
LOC_NAME

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-2 (Cont.) Organization Hierarchy from RMFCS using Retail Insights (RI)

RDX Table RDX Field Name	PDS Field Mapping
DISTRICT_NAME
REGION_NAME
AREA_NAME
CHAIN_NAME
CO_NAME
LOC_TYPE_NAME
STORE_FORMAT_NAME
STORE_CLASS_DESCRIPTION

Calendar Hierarchy from RMFCS using Retail Insights (RI)

Table 5-3 lists the interface grouping for Calendar Hierarchy from RMFCS using Retail Insights (RI).

Table 5-3 Calendar Hierarchy from RMFCS using Retail Insights (RI)

Interface Name Interface Field Name	PDS Field Mapping
W_PDS_CALENDAR_D DAY	DAY
WEEK	WEEK
MNTH	MNTH
QRTR	QRTR
HALF	HALF
YEAR	YEAR
WOYR	WOYR
DOW	DOW
DAY_LABEL
WEEK_LABEL
MNTH_LABEL
QRTR_LABEL
HALF_LABEL
YEAR_LABEL
WOYR_LABEL
DOW_LABEL

Note

The W_PDS_CALENDAR interface is populated from an internal view ‘VW_CLND_HIER’ from where the labels are added.

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Product Attribute Hierarchy from RMFCS using Retail Insights (RI)

Table 5-4 lists the interface grouping for Product Attribute Hierarchy from RMFCS using Retail Insights (RI).

Table 5-4 Product Attribute Hierarchy from RMFCS using Retail Insights (RI)

Interface Name	Interface Field Name	PDS Field Mapping
W_PDS_UDA_D	PROD_ATTR_VALUE	PATV
	PROD_ATTR	PATT
	PROD_ATTR_VALUE_DESC
	PROD_ATTR_DESC

Note

The W_PDS_UDA_D interface is populated from an internal view ‘VW_PATR_HIER’ where in the attribute hierarchy data is pulled in from the following RDX tables by concatenating all of them as product attributes:

• W_PDS_UDA_D

• W_PDS_DIFF_D

• W_PDS_SUPPLIER_D

• W_PDS_BRAND_D

It also concatenates the product attribute name with the product attribute values using ‘_’ to make the product attribute values unique. The Product Attribute name for Supplier (W_PDS_SUPPLIER_D) is used as ‘supp’ and Brand (W_PDS_BRAND_D) is used as ‘brnd’.

Only Product attributes with UDA_TYPE_CODE as ‘LV’ from W_PDS_UDA_D are included in the view.

Supplier Hierarchy from RMFCS using Retail Insights (RI)

Table 5-5 lists the interface grouping for Supplier Hierarchy from RMFCS using Retail Insights (RI).

Table 5-5 Interface Grouping for Supplier Hierarchy from RMFCS using Retail Insights (RI)

RDX Table	RDX Field Name	PDS Field Mapping
W_PDS_SUPPLIER_D	SUPPLIER	SUPP
W_PDS_SUPPLIER_D	SUP_NAME

Item Attributes from Retail Insights (RI)

Table 5-6 lists the interface grouping for Item Attributes from Retail Insights (RI).

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-6 Item Attributes from Retail Insights (RI)

Interface Name	Interface Field Name	PDS Field Mapping
W_PDS_PRODUCT_ATTR_D	ITEM	SKU
	PROD_ATTR	PATT
	PROD_ATTR_VALUE	RDF_PRDATTT

Note

The W_PDS_PRODUCT_ATTR_D is populated from an internal view ‘VW_PATR_DATA’ from where the item attribute mapping is pulled in from the RDX table W_PDS_PRODUCT_ATTR_D and SUPPLIER, BRAND_NAME, DIFF_1, DIFF_2, DIFF_3, DIFF_4 fields from W_PDS_PRODUCT_D table.

Sales Data from Retail Insights (RI)

Table 5-7 lists the interface grouping for Sales Data from Retail Insights (RI)

Table 5-7 Sales Data from Retail Insights (RI)

RDX Table	RDX Field Name	PDS Field Mapping
W_PDS_GRS_SLS_IT_LC_WK_A	EOW_DATE	WEEK
	ITEM	SKU
	LOCATION	STOR
	SALES_UNITS	RDF_RSAL
	SLS_TYPE (FILTER)	R
	EOW_DATE	WEEK
	ITEM	SKU
	LOCATION	STOR
	SALES_UNITS	RDF_PSAL
	SLS_TYPE (FILTER)	P
	EOW_DATE	WEEK
	ITEM	SKU
	LOCATION	STOR
	SALES_UNITS	RDF_CSAL
	SLS_TYPE (FILTER)	C
	EOW_DATE	WEEK
	ITEM	SKU
	LOCATION	STOR
	SALES_UNITS	RDF_OSAL
	SLS_TYPE (FILTER)	O
	EOW_DATE	WEEK
	ITEM	SKU

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-7 (Cont.) Sales Data from Retail Insights (RI)

RDX Table	RDX Field Name	PDS Field Mapping
	LOCATION	STOR
	SALES_UNITS	RDF_SSAL
	SLS_TYPE (FILTER)	S

Note

RDF_SSAL refers to warehouse outbound shipment sales. To include these sales, refer to the Gross Sales Mapping section in the Data Processing and Transformations chapter of the Oracle Retail Analytics and Planning Implementation Guide .

Pack Assortment from Retail Insights (RI)

Table 5-8 lists the interface grouping for Pack Assortment from Retail Insights (RI).

Table 5-8 Pack Assortment from Retail Insights (RI)

RDX Table	RDX Field Name	PDS Field Mapping
W_PDS_PRODUCT_PACK_D	PACK_ITEM	SKU
	COMP_ITEM	SKUR
	PACK_QTY	RDF_LPPMPCKSKUASSU

Inventory Data from Retail Insights (RI)

The following tables list the interface grouping for Inventory Data from Retail Insights (RI).

Table 5-9 Inventory Data from Retail Insights (RI)

Interface Name	Source Table in RDX RDX Field Name	PDS Field Mapping	Comment
VW_LIP_INV_D	W_PDS_INV_IT_L DAY_DATE	DAY
ATA	C_WK_A ITEM	SKU
	LOCATION	STOR
	INV_CO_RSV_QTY	RDF_LPINCUSTO RDRESU
	INV_CO_BO_RSV_ QTY	RDF_LPINCUSTO RDBCKU
	INV_SOH_QTY	LPINONHANDU

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-9 (Cont.) Inventory Data from Retail Insights (RI)

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
		INV_IN_BOOK_QTY	LPINBOOKEDU	INV_IN_BOOK_QTY = INV_CO_RSV_QTY + INV_TSF_RESV_QT Y + INV_RTV_RESV_QT Y

Note

In-transit contains units that have been marked for transfer or allocation and have already left the source location, but not yet received at the destination (in-transit to destination location)

Table 5-10 In-transit from RI Transfer Table

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_INTRNS_T	W_PDS_TSF_IT_	DELIVERY_DATE	DAY
SF	LC_DY_F	ITEM	SKU
		TO_LOC	STOR
		IN_TRANSIT_TSF	RDF_LPININTRN STSFU	IN_TRANSIT_TSF = sum(SHIP_QTY) - sum(RECEIVED_QT Y)

Table 5-11 In-transit from RI Allocation

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_INTRNS_A	W_PDS_ALC_IT_	IN_STORE_DATE	DAY
LC	LC_DY_F	ITEM	SKU
		TO_LOC	STOR
		IN_TRANSIT_ALC	RDF_LPININTRN SALCU	IN_TRANSIT_ALC = sum(TRANSFERRE D_QTY) - sum(RECEIVED_QT Y)

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Note

On Order-in contains units that have been marked for transfer or allocation and have not yet left the source location.

Table 5-12 On Order-in from RI Transfer

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_ONORDIN	W_PDS_TSF_IT_	DELIVERY_DATE	DAY
_TSF	LC_DY_F	ITEM	SKU
		TO_LOC	STOR
		ON_ORDER_IN_TS F	RDF_LPINONOR DINTSFU
Table 5-13 O	n Order-in from R	INV_CO_BO_RSV_ QTY I Allocation	RDF_LPINCUSTO RDBCKU	ON_ORDER_IN_TS F = sum(TSF_QTY) - sum(SHIP_QTY)
Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_ONORDIN	W_PDS_ALC_IT_	IN_STORE_DATE	DAY
_ALC	LC_DY_F	ITEM	SKU
		TO_LOC	STOR
		ON_ORDER_IN_AL C	RDF_LPINONOR DINALCU	ON_ORDER_IN_AL C = sum(ALLOCATED_Q TY) - sum(TRANSFERRE D_QTY)

Table 5-13 On Order-in from RI Allocation

Table 5-14 PO Allocation Map

Interface Name	Source Table in RDX RDX Field Name	PDS Field Mapping	Comment
VW_PO_ALC_	W_PDS_ALC_IT_ IN_STORE_DATE	DAY
MAP	LC_DY_F ITEM	SKU
	TO_LOC	STOR
	ORDER_NO	PON
	ALLOC_NO	RDF_LPINPOALC MAPS

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-15 On Order-in PO: From Supplier to Warehouse Only

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_ONORDIN _PO	W_PDS_PO_ONO RD_IT_LC_DY_F	ESTIMATED_INSTO CK_DATE	DAY
		ITEM	SKU
		TO_LOC	STOR
		ORDER_NO	PON
		PO_ONORD_QTY	RDF_LPPMONOR DINPOU

Table 5-16 On Order-in Unallocated PO

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_ONORDIN _TSF	W_PDS_PO_ONO RD_IT_LC_DY_F	ESTIMATED_INSTO CK_DATE	DAY
	W_PDS_ALC_IT_	ITEM	SKU
	LC_DY_F	TO_LOC	STOR
		ORDER_NO	PON
		UN_ALLOCATED_P O_QTY	RDF_LPPMONOR DUNALCPOU	UN_ALLOCATED_P O_QTY = PO_ONORD_QTY - ALLOCATED_QTY

Table 5-17 On Order-out Transfer: What Is Going out of Source Location That Is Not Attached to a PO

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_ONORDO	W_PDS_TSF_IT_	DELIVERY_DATE	DAY
UT_TSF	LC_DY_F	ITEM	SKU
		FROM_LOC	STOR
		ON_ORDER_OUT_T SF	RDF_LPINONOR DOUTTSFU	ON_ORDER_OUT_T SF = sum(TSF_QTY) - sum(SHIP_QTY)

Table 5-18 On Order-out Allocation: What is Going out of Source Location That is Attached to a PO

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
VW_ONORDO	W_PDS_ALC_IT_	IN_STORE_DATE	DAY
UT_ALC	LC_DY_F	ITEM	SKU
		FROM_LOC	STOR

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-18 (Cont.) On Order-out Allocation: What is Going out of Source Location That is Attached to a PO

Interface Name	Source Table in RDX	RDX Field Name	PDS Field Mapping	Comment
		ON_ORDER_OUT_A LC	RDF_LPINONOR DOUTALCU	ON_ORDER_OUT_A LC = sum(ALLOCATED_Q TY) - sum(TRANSFERRE D_QTY)

Replenishment Attributes from Retail Insights (RI)

Table 5-19 lists the interface grouping for Replenishment Attributes from Retail Insights (RI).

Table 5-19 Replenishment Attributes from Retail Insights (RI)

RDX Table	RDX Field Name	PDS Field Mapping
W_PDS_REPL_ATTR_IT_LC_	ITEM	SKU
D	LOCATION	STOR
	REPL_PRES_STOCK	LPINDSPQU

Offer Hierarchy from Science (AIF)

Table 5-20 lists the interface grouping for Offer Hierarchy from Science (AIF).

Table 5-20 Offer Hierarchy from Science (AIF)

RDX Table RDX Field Name	PDS Field Mapping
RSE_OFFER_HIER_EXP OFFER_ID	OFFD
PROMO_ID	PRMD
CAMPAIGN_ID	CAMD
OFFER_ID	OFFA
CAMPAIGN_ID	CAMA
OFFER_LABEL
PROMO_LABEL
CAMPAIGN_LABEL
OFFER_ALIAS
CAMPAIGN_ALIAS

Offer Details from Science (AIF)

Table 5-21 lists the interface grouping for Offer Details from Science (AIF).

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-21 Offer Details from Science (AIF)

RDX Table	RDX Field Name	PDS Field Mapping
RSE_OFFER_DTL_EXP	OFFER_ID	OFFD
	OFFER_START_DT	OFFSTARTDT
	OFFER_END_DT	OFFENDDT
	REWARD_TYPE_ID	REWARDTYPE

Offer Sales Details from Science (AIF)

Table 5-22 lists the interface grouping for Offer Sales Details from Science (AIF).

Table 5-22 Offer Sales Details from Science (AIF)

RDX Table RDX Field Name	PDS Field Mapping
RSE_OFFER_SALES_EXP PROD_EXT_KEY	SKU
LOC_EXT_KEY	STOR
OFFER_ID	OFFD
OFFER_SALES_QTY	OFFERSLS
EFFECTIVE_DISCOUNT_PCT	EFFDISCOUNT

Reward Type Hierarchy from Science (AIF)

Table 5-23 lists the interface grouping for Reward Type Hierarchy from Science (AIF).

Table 5-23 Reward Type Hierarchy from Science (AIF)

RDX Table	RDX Field Name	PDS Field Mapping
RSE_REWARD_TYPE_HIER_EXP	REWARD_TYPE_ID	RDTP
	REWARD_TYPE_LABEL

Product Attribute Weight from Science (AIF)

Table 5-24 lists the interface grouping for Product Attribute Weight from Science (AIF).

Table 5-24 Product Attribute Weight from Science (AIF)

RDX Table RDX Field Name	PDS Field Mapping
RSE_ATTR_WGT_EXP PROD_EXT_KEY	CLSS
LOC_EXT_KEY	CHNL
PROD_ATTR_GRP_EXT_KEY	PATT
ATTR_WGT	PATTWGT
CUSTSEG_EXT_KEY
CLS

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-24 (Cont.) Product Attribute Weight from Science (AIF)

RDX Table	RDX Field Name	PDS Field Mapping
	AREA

Forecast Import from Science (AIF)

Table 5-25 lists the interface grouping for Forecast Import from Science (AIF).

Table 5-25 Forecast Import from Science (AIF)

RDX Table	RDX Field Name	PDS Field Mapping
RSE_FCST_DEMAND_DTL_CAL_EXP	FCST_DATE_FRO M	llc_frcst_CF_:CLND
	PROD_EXT_KEY	llc_frcst_CF_:PROD
	LOC_EXT_KEY	llc_frcst_CF_:LOC
	BASELINE_FCST_ QTY	rdf_sysbaseline_CF_
	DEMAND_FCST_Q TY	rdf_sysfrcst_CF_
	EVENT_PEAK_QT Y	rdf_syspeak_CF_
	EVENT_CLND	rdf_eventfut_CF_
	PRICE_DISC_PER CENT	rdf_prcdiscfut_CF_
	rdf_rserunid_CF_ (Filter)	RUN_ID
	BASELINE_FCST_ QTY (Filter)

Note

• llc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level

• llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level

• llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level

Base Demand Import from Science (AIF)

Table 5-26 lists the interface grouping for Base Demand Import from Science (AIF)

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-26 Base Demand Import from Science (AIF)

RDX Table RDX Field Name	PDS Field Mapping
RSE_FCST_DEMAND_DTL_EXP PROD_EXT_KEY	llc_frcstTS_CF_:PROD
LOC_EXT_KEY	llc_frcstTS_CF_:LOC
BASE_DEMAND_QTY	rdf_basedemand_CF_
PRICE_ELASTICITY	rdf_priceelas_CF_
rdf_rserunid_CF_ (Filter)	RUN_ID
BASE_DEMAND_QTY (Filter)

Note

• llc_frcstTS_CF_:PROD —refers to Product dimension of the corresponding forecast level

• llc_frcstTS_CF_:LOC —refers to Location dimension of the corresponding forecast level

Approved Base Demand Import from Science (AIF)

Table 5-27 lists the interface grouping for Approved Base Demand Import from Science (AIF).

Table 5-27 Approved Base Demand Import from Science (AIF)

RDX Table	RDX Field Name	PDS Field Mapping
RSE_FCST_APPR_BASE_DMD_EXP	PROD_EXT_KEY	llc_frcstTS_CF_:PROD
	LOC_EXT_KEY	llc_frcstTS_CF_:LOC
	APPR_BASE_DEMAND_Q TY	rdf_appchosenlevel_CF_
	rdf_rserunid_CF_ (Filter)	RUN_ID
	APPR_BASE_DEMAND_Q TY (Filter)

Note

• llc_frcstTS_CF_:PROD —refers to Product dimension of the corresponding forecast level

• llc_frcstTS_CF_:LOC —refers to Location dimension of the corresponding forecast level

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Preprocessed Sales Import from Science (AIF)

Table 5-28 lists the interface grouping for Preprocessed Sales Import from Science (AIF).

Table 5-28 Preprocessed Sales Import from Science (AIF)

RDX Table RDX Field Name	PDS Field Mapping
RSE_FCST_DEMAND_SRC_EXP DATE_FROM	llc_frcst_CF_:CLND
PROD_EXT_KEY	llc_frcst_CF_:PROD
LOC_EXT_KEY	llc_frcst_CF_:LOC
STOCKOUT_IND	rdf_outageind_CF_
LOST_SLS_QTY	rdf_outageadj_CF_
OUTLIER_IND	rdf_outlierind_CF_
OUTLIER_SLS_QTY	rdf_outlieradj_CF_
PROMO_SLS_QTY	rdf_depromoadj_CF_
CLR_SLS_QTY	rdf_deprice_CF_
PREPROCESSED_SL S_QTY	rdf_totadjsls_CF_
rdf_rserunid_CF_ (Filter)	RUN_ID
PREPROCESSED_SL S_QTY (Filter)

Note

• l lc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level

• llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level

• llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level

Export Run Type Batch Setting

Table 5-29 lists the interface grouping for Export Run Type Batch Setting.

Table 5-29 Export Run Type Batch Setting

RDX Table	RDX Field Name	PDS Field Mapping
RDF_RUN_TYPE_PARM_EXP	RDF_RUN_TYPE_KEY	v
	ENABLE_NEW_ITEM	rdf_runnewitem_CF
	ENABLE_FORECAST	rdf_runfrcst_CF_

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Approved Forecast Export

Table 5-30 lists the interface grouping for Approved Forecast Export.

Table 5-30 Approved Forecast Export

RDX Table RDX Field Name	PDS Field Mapping
RDF_APPR_FCST_CAL_EXP	llc_frcst_CF_:CLND
PROD_EXT_KEY	llc_frcst_CF_:PROD
LOC_EXT_KEY	llc_frcst_CF_:LOC
BOP_DATE	rdf_bopdate_CF_
APPR_BASELINE_FCST	rdf_appbaseline_CF_
APPR_DEMAND_FCST	rdf_appfrcst_CF_
APPR_CUMINT	rdf_appcumint_CF_
	rdf_exportmask_CF_ (Filter)

Note

• llc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level

• llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level

• llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level

Forecast Parameters Export

Table 5-31 exports the basic forecast parameters like Forecast Start Date, Forecast End Date and History length (used to calculate base demand) at the RUN TYPE intersection.

Table 5-31 Forecast Parameters Export: Basic Forecast Parameters

RDX Table RDX Field Name	PDS Field Mapping
RDF_FCST_PARM_EXP PROD_EXT_KEY	llc_frcstTS_CF_:PROD
LOC_EXT_KEY	llc_frcstTS_CF_:LOC
FCST_HIST_LENGTH	rdf_hislen_CF_
FCST_START_DATE	rdf_frcststartdt_CF_
FCST_END_DATE	rdf_frcstenddt_CF_
	rdf_expfcstmaskts_CF_ (Filter)

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Note

• llc_frcstTS_CF_:PROD —refers to Product dimension of the corresponding forecast level

• llc_frcstTS_CF_:LOC —refers to Location dimension of the corresponding forecast level

Table 5-32 exports the preprocess indicators that could be loaded or calculated through extensibility.

Table 5-32 Forecast Parameters Export: Preprocess Indicators

RDX Table RDX Field Name	PDS Field Mapping
RDF_FCST_PARM_CAL_EXP	llc_frcst_CF_:CLND
PROD_EXT_KEY	llc_frcst_CF_:PROD
LOC_EXT_KEY	llc_frcst_CF_:LOC
BOP_DATE	rdf_bopdate_CF_
USER_OVERRIDE	rdf_totadjslsovr_CF_
PPS_OUTAGE_IND	rdf_outageind_CF_
PPS_OUTLIER_IND	rdf_outlierind_CF_
	rdf_expparmask_CF_ (Filter)

Note

• llc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level

• llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level

• llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level

New Item Parameters Export

Table 5-33 exports the strategy to be applied to generate forecast for new items and new stores. These parameters are applicable for all Run Types that have ENABLE_NEW_ITEM field set to TRUE in the RDF_RUN_TYPE_PARM_EXP table.

Table 5-33 New Item Parameters Export

RDX Table	RDX Field Name	PDS Field Mapping
RDF_NIT_PARM_EXP	PROD_EXT_KEY	NIT_SKUSTR_INTX:PROD
	LOC_EXT_KEY	NIT_SKUSTR_INTX:LOC

Interfaces Available in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Template

Table 5-33 (Cont.) New Item Parameters Export

RDX Table	RDX Field Name	PDS Field Mapping
	NIT_SKUSTR_INTX:PROD	PROD_HIER_LEVEL
	NIT_SKUSTR_INTX:LOC	LOC_HIER_LEVEL
	NIT_SUB_METHOD	rdf_fcpsubm
	NIT_ROS_USER_IN	rdf_fcpros
	NIT_LIKE_ITEM	rdf_nitapplkitm1
	NIT_LIKE_STOR	rdf_nstapplkstr1
	ADJUSTMENT_FACTOR	rdf_fcpadj
		rdf_fcpsubm (Filter)

---

In this guide

• Guide: IPOCS-Demand Forecasting and IPOCS-LAR Implementation Guide
• Previous: IPOCS-Lifecycle Allocation and Replenishment Extensibility
• Next: 6 IPOCS-Lifecycle Allocation and Replenishment Flat File Exports

Related chapters

• 3 RAP Integration — Assortment Planning Cloud Service Implementation Guide · shares AREA_NAME, ATTR_WGT, BRAND_NAME, CHAIN_NAME
• 1 APCS Batch Task Administration — Assortment Planning Cloud Service Administration Guide · shares W_PDS_CALENDAR_D, W_PDS_ORGANIZATION_D, W_PDS_PRODUCT_D, W_PDS_UDA_D
• 14 Control and Tactical Center — AI Foundation Implementation Guide · shares ADJUSTMENT_FACTOR, APPR_BASELINE_FCST, APPR_BASE_DEMAND_QTY, APPR_CUMINT
• 2 Implementation Considerations — IPOCS-Demand Forecasting and IPOCS-LAR Implementation Guide · shares NIT_SKUSTR_INTX, W_PDS_BRAND_D, W_PDS_SUPPLIER_D
• 3 RAP Integration — Merchandise Financial Planning Cloud Service Implementation Guide · shares AREA_NAME, CHAIN_NAME, CLASS_ID, CLR_SLS_QTY
• 6 Scheduled Integration — Inbound and Outbound Integration Guide · shares AREA_NAME, BRAND_NAME, CHAIN_NAME, CLASS_ID