Forecast Imports from AI Foundation
Forecasts can be generated from AI Foundation (AIF) and imported to MFPCS using RAP integration. AI Foundation can generate different levels of forecasts as needed by different levels of plans. It generates both Pre-Season forecasts (using the Auto-ES Forecast method) and In-Season Forecasts (using the Bayesian Forecast Method). AI Foundation directly gets the actuals and plan data from MFP through RI using RAP integration. Job flows in AI Foundation need to be scheduled to generate the forecast and import the same to MFP. For more details, see the Oracle Retail Analytics and Planning Implementation Guide.
In order to get forecasts from AI Foundation (AIF), during implementation, some initial setups need to be done in the AI Foundation (AIF) platform. For more details, see the Oracle Retail Analytics and Planning Implementation Guide.
The following table shows the interface table column details from AI Foundation in RDX used for the interface.
Interface Name: RSE_FCST_DEMAND_EXP
| Table Column | Data Type | Comments |
|---|---|---|
|
RUN_ID |
Number(10) |
The export Run ID as obtained from the RAP_INTF_UTIL. |
|
CAL_HIER_LEVEL |
Varchar2(30) |
The calendar level data is for Fiscal Year, Fiscal Quarter, Fiscal Period, Fiscal Week, and Fiscal Day. |
|
LOC_HIER_LEVEL |
Varchar2(30) |
The location hierarchy level data is for COMPANY, CHAIN, AREA, REGION, DISTRICT, LOCATION, and CHANNEL_COUNTRY. |
|
PROD_HIER_LEVEL |
Varchar2(30) |
The product hierarchy level the data is for CMP, DIV, GRP, DEPT, CLS, SBC, STYLE, STYLE_COLOR, and SKU. |
|
FCST_DATE_FROM |
Date |
The start date which the forecast is for. |
|
LOC_EXT_KEY |
Varchar2(80) |
The external id of the location. It will use the integration ids as provided to RI (preferably the RMS id, and not an integration id such as AREA~123). |
|
PROD_EXT_KEY |
Varchar2(80) |
The external id of the product hierarchy. It will use the integration ids as provided to RI (preferably the RMS id, and not an integration id such as CLS~123~456~789). |
|
CUSTSEG_EXT_KEY |
Varchar2(80) |
The external id of the customer segment. It will be NULL if not applicable. |
|
FCST_TYPE |
Varchar2(20) |
The type of forecast. PI, NPI (PI=Plan Influenced, PI = Non Plan Influenced) |
|
REG_SLS_QTY |
Number(38,20) |
Regular Sales Units |
|
REG_SLS_AMT |
Number(38,20) |
Regular Sales Amount |
|
PR_SLS_QTY |
Number(38,20) |
Promo Sales Units |
|
PR_SLS_AMT |
Number(38,20) |
Promo Sales Amount |
|
CLR_SLS_QTY |
Number(38,20) |
Clearance Sales Units |
|
CLR_SLS_AMT |
Number(38,20) |
Clearance Sales Amount |
|
REG_PR_SLS_QTY |
Number(38,20) |
Regular and Promo Sales Units |
|
REG_PR_SLS_AMT |
Number(38,20) |
Regular and Promo Sales Amount |
|
SLS_QTY |
Number(38,20) |
Total Sales Units |
|
SLS_AMT |
Number(38,20) |
Total Sales Amount |
|
RET_QTY |
Number(38,20) |
Return Units |
|
RET_AMT |
Number(38,20) |
Return Amount |
The same Interface table contains the forecast data for different levels of plans differentiated by _LEVEL columns within the interface. The single interface run pulls data for different levels of forecasts which are pre-configured. Customers using non-template versions, if using different levels of plans, can use the supported levels in AI Foundation to generate forecasts. The following sections provide the default levels of forecasts exported for the MFPCS template version and their mappings.
Merch Plan Forecasts Mapping
The following table shows the mapping for pre-season and in-season Merch Plan Forecasts.
| Table Column | Mapping for Pre-Season (MPP) | Mapping for In-Season (MPI) |
|---|---|---|
|
CAL_HIER_LEVEL |
Fiscal Week |
Fiscal Week |
|
LOC_HIER_LEVEL |
CHANNEL_COUNTRY |
CHANNEL_COUNTRY |
|
PROD_HIER_LEVEL |
SBC |
SBC |
|
FCST_DATE_FROM |
WEEK |
WEEK |
|
LOC_EXT_KEY |
CHNL |
CHNL |
|
PROD_EXT_KEY |
SCLS |
SCLS |
|
CUSTSEG_EXT_KEY |
NULL |
NULL |
|
FCST_TYPE |
NPI |
PI |
|
CLR_SLS_QTY |
MPWPDmdP2U |
MPWPDmdI2U |
|
CLR_SLS_AMT |
MPWPDmdP2R |
MPWPDmdI2R |
|
REG_PR_SLS_QTY |
MPWPDmdP1U |
MPWPDmdI1U |
|
REG_PR_SLS_AMT |
MPWPDmdP1R |
MPWPDmdI1R |
|
RET_QTY |
MPWPRtnPU |
MPWPRtnIU |
|
RET_AMT |
MPWPRtnPR |
MPWPRtnIR |
Merch Target Plan Forecasts Mapping
The following table shows the mapping for pre-season and in-season Merch Target Plan Forecasts.
| Table Column | Mapping for Pre-Season (MTP) | Mapping for In-Season (MTI) |
|---|---|---|
|
CAL_HIER_LEVEL |
Fiscal Week |
Fiscal Week |
|
LOC_HIER_LEVEL |
CHANNEL_COUNTRY |
CHANNEL_COUNTRY |
|
PROD_HIER_LEVEL |
DEPT |
DEPT |
|
FCST_DATE_FROM |
WEEK |
WEEK |
|
LOC_EXT_KEY |
CHNL |
CHNL |
|
PROD_EXT_KEY |
DEPT |
DEPT |
|
CUSTSEG_EXT_KEY |
NULL |
NULL |
|
FCST_TYPE |
NPI |
PI |
|
CLR_SLS_QTY |
MTWPDmdP2U |
MTWPDmdI2U |
|
CLR_SLS_AMT |
MTWPDmdP2R |
MTWPDmdI2R |
|
REG_PR_SLS_QTY |
MTWPDmdP1U |
MTWPDmdI1U |
|
REG_PR_SLS_AMT |
MTWPDmdP1R |
MTWPDmdI1R |
|
RET_QTY |
MTWPRtnPU |
MTWPRtnIU |
|
RET_AMT |
MTWPRtnPR |
MTWPRtnIR |
Location Plan Forecasts Mapping
The following table shows the mapping for pre-season and in-season Location Plan Forecasts.
| Table Column | Mapping for Pre-Season (LPP) | Mapping for In-Season (LPI) |
|---|---|---|
|
CAL_HIER_LEVEL |
Fiscal Week |
Fiscal Week |
|
LOC_HIER_LEVEL |
LOCATION |
LOCATION |
|
PROD_HIER_LEVEL |
DEPT |
DEPT |
|
FCST_DATE_FROM |
WEEK |
WEEK |
|
LOC_EXT_KEY |
STOR |
STOR |
|
PROD_EXT_KEY |
DEPT |
DEPT |
|
CUSTSEG_EXT_KEY |
NULL |
NULL |
|
FCST_TYPE |
NPI |
PI |
|
SLS_QTY |
LPWPDmdP1U |
LPWPDmdI1U |
|
SLS_AMT |
LPWPDmdP1R |
LPWPDmdI1R |
|
RET_QTY |
LPWPRtnPU |
LPWPRtnIU |
|
RET_AMT |
LPWPRtnPR |
LPWPRtnIR |
Location Target Plan Forecasts Mapping
The following table shows the mapping for pre-season and in-season Location Target Plan Forecasts.
| Table Column | Mapping for Pre-Season (LTP) | Mapping for In-Season (LTI) |
|---|---|---|
|
CAL_HIER_LEVEL |
Fiscal Week |
Fiscal Week |
|
LOC_HIER_LEVEL |
LOCATION |
LOCATION |
|
PROD_HIER_LEVEL |
CMP |
CMP |
|
FCST_DATE_FROM |
WEEK |
WEEK |
|
LOC_EXT_KEY |
STOR |
STOR |
|
PROD_EXT_KEY |
CMPP |
CMPP |
|
CUSTSEG_EXT_KEY |
NULL |
NULL |
|
FCST_TYPE |
NPI |
PI |
|
SLS_QTY |
LTWPDmdP1U |
LTWPDmdI1U |
|
SLS_AMT |
LTWPDmdP1R |
LTWPDmdI1R |
|
RET_QTY |
LTWPRtnPU |
LTWPRtnIU |
|
RET_AMT |
LTWPRtnPR |
LTWPRtnIR |