B Appendix: Integration with Oracle Retail Assortment Planning Cloud Service
MFP Cloud Service integrates with Oracle Retail Assortment Planning Cloud Service to export the approved Original (OP) and Current (CP) Plan versions of the Merchandise Plans. It also exports Open to Buy (OTB) data and Last Approved Plan (AP) version of Location Plans. The final set of exported measures remains the same for both MFP Retail and MFP Cost.
The interface can be scheduled to run on a weekly basis by scheduling the respective Exports to Shared Services task in the Online Administration Tools. Exported files will be placed in the cloud Object Storage to be accessed by other applications.
The following tables list the exported measure files.
Exported File: Merch Current Plan
Exported File Name: mfp_mpcp.csv.ovr
Table B-1 MFP Cloud Service Merch Plan - Current Plan Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
week |
Week |
|
|
|
scls |
Sub Class |
|
|
|
chnc |
Channel |
|
|
|
MPCPSLS1U |
Cp Sales Reg + Promo U |
real |
total |
|
MPCPSLS2U |
Cp Sales Clr U |
real |
total |
|
MPCPSLS1R |
Cp Sales Reg + Promo R |
real |
total |
|
MPCPSLS2R |
Cp Sales Clr R |
real |
total |
|
MPCPSLSC |
Cp Sales C |
real |
total |
|
MPCPRCPTU |
Cp Receipts U |
real |
total |
|
MPCPRCPTR |
Cp Receipts R |
real |
total |
|
MPCPRCPTC |
Cp Receipts C |
real |
total |
|
MPCPEOPU |
Cp EOP U |
real |
pet |
|
MPCPEOPR |
Cp EOP R |
real |
pet |
|
MPCPEOPC |
Cp EOP U |
real |
pet |
|
MPCPRTN1U |
Cp Returns Reg + Promo U |
real |
total |
|
MPCPRTN2U |
Cp Returns Clr U |
real |
total |
|
MPCPRTN2R |
Cp Returns Reg + Promo R |
real |
total |
|
MPCPRTN2R |
Cp Returns Clr R |
real |
total |
Exported File: Merch Original Plan
Exported File Name: mfp_mpop.csv.ovr
Table B-2 MFP Cloud Service Merch Plan - Original Plan Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
week |
Week |
|
|
|
scls |
Sub Class |
|
|
|
chnc |
Channel |
|
|
|
MPOPSLS1U |
Op Sales Reg + Promo U |
real |
total |
|
MPOPSLS2U |
Op Clr U |
real |
total |
|
MPOPSLS1R |
Op Sales Reg + Promo R |
real |
total |
|
MPOPSLS2R |
Op Clr R |
real |
total |
|
MPOPSLSC |
Op Sales C |
real |
total |
|
MPOPRCPTU |
Op Receipts U |
real |
total |
|
MPOPRCPTR |
Op Receipts R |
real |
total |
|
MPOPRCPTC |
Op Receipts C |
real |
total |
|
MPOPEOPU |
Op EOP U |
real |
pet |
|
MPOPEOPR |
Op EOP R |
real |
pet |
|
MPOPEOPC |
Op EOP U |
real |
pet |
|
MPOPRTN1U |
Op Returns Reg + Promo U |
real |
total |
|
MPOPRTN2U |
Op Returns Clr U |
real |
total |
|
MPOPRTN1R |
Op Returns Reg + Promo R |
real |
total |
|
MPOPRTN2R |
Op Returns Clr R |
real |
total |
Exported File: Merch Plan OTB
Exported File Name: mfp_otb.csv.rpl
Table B-3 MFP Cloud Service Merch Plan - Open to Buy Export Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
week |
Week |
|
|
|
scls |
Sub Class |
|
|
|
chnc |
Channel |
|
|
|
MPWPOTBU |
Open to Buy U |
real |
total |
|
MPWPOOADJU |
On Order Adj U |
real |
total |
|
MPWPOTBC |
Open to Buy C |
real |
total |
|
MPWPOOADJC |
On Order Ajd C |
real |
total |
Exported File: Location Last Approved Plan
Exported File Name: mfp_lpap.csv.ovr
Table B-4 MFP Cloud Service Merch Plan - Location Last Approved Plan Measures
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
week |
Week |
|
|
|
dept |
Department |
|
|
|
stor |
Store |
|
|
|
LPAPSlsU |
Ap Sales U |
real |
total |
|
LPAPSlsR |
Ap Sales R |
real |
total |
|
LPAPSlsC |
Ap Sales C |
real |
total |
|
LPAPRcptU |
Ap Receipts U |
real |
total |
|
LPAPRcptR |
Ap Receipts R |
real |
total |
|
LPAPRcptC |
Ap Receipts C |
real |
total |
|
LPAPEOPU |
Ap EOP U |
real |
total |
|
LPAPEOPR |
Ap EOP R |
real |
total |
|
LPAPEOPC |
Ap EOP C |
real |
total |
|
LPAPRtnU |
Ap Returns U |
real |
total |
|
LPAPRtnR |
Ap Returns R |
real |
total |