Oracle® Retail Demand Forecasting Cloud Service Implementation Guide Release 23.1.101.0 for Windows F76812-02 |
|
Previous |
Next |
The Retail Demand Forecasting (RDF) solution is built on top of the Planning Data Store (PDS) and is integrated with Retail Science (RSP) and Retail Insights (RI) with in the Retail Analytical Platform (RAP). All three solutions (RSP, RI, PDS) within RAP can share data using RAP Data Exchange (RDX) using RAP interfaces. RDF gets the foundation data from RI and forecast from RSP through RDX. RDF being an extensible solution, retailers can customize the interface using the interface.cfg
file to map dimensions and facts from the RAP interface tables. For additional information refer to the Retail Predictive Application Server Cloud Edition Implementation Guide.
Following is the pre-defined grouping of interfaces available in the RDF template version within RAP integration:
Organization Hierarchy from RMF CS using Retail Insights (RI)
Product Attribute Hierarchy from RMF CS using Retail Insights (RI)
Table 5-1 lists the interface grouping for Product Hierarchy from RMF CS using Retail Insights (RI).
Table 5-1 Product Hierarchy from RMF CS using Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
W_PDS_PRODUCT_D |
ITEM |
SKU |
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 |
Table 5-2 lists the interface grouping for Organization Hierarchy from RMF CS using Retail Insights (RI).
Table 5-2 Organization Hierarchy from RMF CS 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 |
|
STORE_FORMAT |
SFMT |
|
STORE_CLASS |
STCL |
|
LOC_NAME |
||
DISTRICT_NAME |
||
REGION_NAME |
||
AREA_NAME |
||
CHAIN_NAME |
||
CO_NAME |
||
STORE_FORMAT_NAME |
||
STORE_CLASS_DESCRIPTION |
Table 5-3 lists the interface grouping for Calendar Hierarchy from RMF CS using Retail Insights (RI).
Table 5-4 lists the interface grouping for Product Attribute Hierarchy from RMF CS using Retail Insights (RI).
Table 5-5 lists the interface grouping for Item Attributes from Retail Insights (RI).
Table 5-6 lists the interface grouping for Sales Data from Retail Insights (RI)
Table 5-6 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 |
Table 5-7 lists the interface grouping for Offer Hierarchy from Science (RSP).
Table 5-8 lists the interface grouping for Offer Details from Science (RSP).
Table 5-9 lists the interface grouping for Offer Sales Details from Science (RSP).
Table 5-10 lists the interface grouping for Reward Type Hierarchy from Science (RSP).
Table 5-11 lists the interface grouping for Group Hierarchy from Science (RSP).
Table 5-12 lists the interface grouping for Group Level Hierarchy from Science (RSP).
Table 5-13 lists the interface grouping for Product Attribute Weight from Science (RSP).
Table 5-14 lists the interface grouping for Forecast Import from Science (RSP).
Table 5-14 Forecast Import from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_FCST_DEMAND_DTL_CAL_EXP |
FCST_DATE_FROM |
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_QTY |
rdf_sysfrcst_CF_ |
|
EVENT_PEAK_QTY |
rdf_syspeak_CF_ |
|
EVENT_CLND |
rdf_eventfut_CF_ |
|
PRICE_DISC_PERCENT |
rdf_prcdiscfut_CF_ |
|
rdf_rserunid_CF_ (Filter) |
RUN_ID |
|
BASELINE_FCST_QTY (Filter) |
Note:
|
Table 5-15 lists the interface grouping for Base Demand Import from Science (RSP)
Table 5-15 Base Demand Import from Science (RSP)
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:
|
Table 5-16 lists the interface grouping for Approved Base Demand Import from Science (RSP).
Table 5-16 Approved Base Demand Import from Science (RSP)
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_QTY |
rdf_appchosenlevel_CF_ |
|
rdf_rserunid_CF_ (Filter) |
RUN_ID |
|
APPR_BASE_DEMAND_QTY (Filter) |
Note:
|
Table 5-17 lists the interface grouping for Preprocessed Sales Import from Science (RSP).
Table 5-17 Preprocessed Sales Import from Science (RSP)
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_SLS_QTY |
rdf_totadjsls_CF_ |
|
rdf_rserunid_CF_ (Filter) |
RUN_ID |
|
PREPROCESSED_SLS_QTY (Filter) |
Note:
|
Table 5-18 lists the interface grouping for Flex Group Import from Science (RSP).
Table 5-18 Flex Group Import from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_FLEX_GROUP_SET_EXP |
NAME |
GLVL |
RUN_TYPE_KEY |
rdf_glvl2flvl |
|
DESCR |
rdf_glvldesc |
|
DESCR (Filter) |
||
VW_GRP_LABELTXT |
NAME |
GRPD |
FLEX_GROUP_SET_NAME |
GLVL |
|
DESCR |
rdf_grplabeltxt_CF_ |
|
DESCR (Filter) |
||
VW_GRP_POSASSIGN |
PROD_EXT_KEY |
llc_frcst_CF_:PROD |
LOC_EXT_KEY |
llc_frcst_CF_:LOC |
|
FLEX_GROUP_SET_NAME |
GLVL |
|
FLEX_GROUP_NAME |
rdf_grpassignpos_CF_ |
|
FLEX_GROUP_NAME (Filter) |
Note:
|
Table 5-19 lists the interface grouping for Export Run Type Batch Setting.
Table 5-20 lists the interface grouping for Approved Forecast Export.
Table 5-20 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:
|
Table 5-21 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-21 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) |
Note:
|
Table 5-22 exports the preprocess indicators that could be loaded or calculated through extensibility.
Table 5-22 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:
|
Table 5-23 exports the promo aggregation profile per RUN TYPE. The intersect of this measure is defined in the RDF plug-in and also in the RSE_FCST_RUN_TYPE_CONFIG table.
Table 5-23 Agg/Spread Profile Export: Promo Aggregation Profile
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_PROMO_AGG_PROF_EXP |
DOW_KEY |
csl_aggprof_CF_:CLND |
PROD_EXT_KEY |
csl_aggprof_CF_:PROD |
|
LOC_EXT_KEY |
csl_aggprof_CF_:LOC |
|
PROMO_AGG_PROFILE |
rdf_promoaggprof_CF_ |
|
BOP_DATE |
rdf_promoaggdate_CF_ |
|
rdf_promoaggprof_CF_ (Filter) |
Note:
|
Table 5-24 exports the forecast spread profile per RUN TYPE. The intersection of this measure is defined in the RDF plug-in and also in the RSE_FCST_RUN_TYPE_CONFIG table.
Table 5-24 Agg/Spread Profile Export: Forecast Spread Profile
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_FCST_SPD_PROF_EXP |
DOW_KEY |
llc_sprdprof_CF_:CLND |
PROD_EXT_KEY |
llc_sprdprof_CF_:PROD |
|
LOC_EXT_KEY |
llc_sprdprof_CF_:LOC |
|
FCST_SPREAD_PROFILE |
rdf_basespreadprof_CF_ |
|
BOP_DATE |
rdf_basespreaddate_CF_ |
|
rdf_basespreadprof_CF_ (Filter) |
Note:
|
Table 5-25 exports the groups for a group set.
Table 5-25 Flex Group Assignment Export: Group Set
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_FLEX_GROUP_EXP |
NAME |
GRPD |
FLEX_GROUP_SET_NAME |
GLVL |
|
RDF_FLEX_GROUP_EXP |
rdf_grplabeltxt_CF_ |
|
rdf_grplabeltxt_CF_ (Filter) |
Table 5-26 exports the actual PROD/LOC group assignments.
Table 5-26 Flex Group Assignment Export: Group Assignments
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_FLEX_GROUP_PROD_LOC_EXP |
PROD_EXT_KEY |
llc_frcstTS_CF_:PROD |
LOC_EXT_KEY |
llc_frcstTS_CF_:LOC |
|
FLEX_GROUP_SET_NAME |
GLVL |
|
FLEX_GROUP_NAME |
rdf_grpassignpos_CF_ |
|
rdf_grpassignpos_CF_ (Filter) |
Note:
|
Table 5-27 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-27 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 |
|
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) |