Plan Exports to Retail Insights

Approved plans from MFPCS can be exported to Retail Insights within RAP integration. Retail Insights allows getting four levels of plans for different versions. The MFP template version allows creating four levels of plans, Merch Plan (OP, CP), Merch Target (TG), Location Plan (OP, CP), and Location Target Plan (TG). All those plans and their different versions can be exported to Retail Insights on a weekly basis. Since MFP non-template versions can create a different level of plans and also can configure various metrics, the interface staging table in Retail Sights contains the same set of columns and various flex columns.

For more details about the list of columns available in the Retail Insights Interface Staging table if the customer plans to use extensibility or use the non-template version to send additional data, see the Oracle Retail Insights Implementation Guide. This guide contains only the mapped columns for the MFP template version for each level of plans.

The following table shows the list of interfaces in RAP to export the plan data from MFP to RI:

Interface	Interface and Table Name	Interface Type
Merch Plan Export	MFP_PLAN1_EXP	Data Exporter
Merch Target Plan Export	MFP_PLAN2_EXP	Data Exporter
Location Plan Export	MFP_PLAN3_EXP	Data Exporter
Location Target Plan Export	MFP_PLAN4_EXP	Data Exporter

Note: If Retail/Cost is denoted, that metric will have value only if that version of MFP is implemented from the template, otherwise that value will be always exported as zero.

If LPO Integration is enabled in the Admin workbook, the additional export of MFP_PLAN6_EXP will also be exported to RI; that will be used by LPO for getting Approved Markdown Budgets from MFP at the subclass/store/week level.