A Appendix: Integration with MFP Cloud Service

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.

A

Appendix: Integration with MFP Cloud Service

Assortment Planning Cloud Service can be integrated with MFP Cloud Service to interface the Plan data. This appendix provides details about the integration.

APCS needs MFPCS data to use Merchandise Financial Planning data as a target to align with final assortments. If both MFPCS and APCS are co-deployed in the same environment and both are using the GA version, then all integrated MFPCS measures will be readily available in APCS. When plans are approved in MFPCS, it will be readily available in APCS. No separate batch or integration is needed to interface the MFP Plan data.

Integration with MFP Cloud Service

The following table shows the list of measures shared between MFPCS and APCS preconfigured applications. All the ML measures are at the Week/Sub-Class/Store level and the LP measures are at the Week/Department/Store level. ML measures are directly used in the AP planning process templates but LP (Location Plan) measures are used only in the batch process which spreads Warehouse data to the location level if the customer uses the option to spread using Location Plan from MFP instead of last year actuals.

MFP Cloud Service to Assortment Planning Cloud Service

MFP Measure	MFPCS Label	APCS Label	File Name
mlcpeopc	ML Cp EOP C	MFP CP EOP C	mfp_mpcp.csv.ovr
mlcpeopr	ML Cp EOP R	MFP CP EOP R	mfp_mpcp.csv.ovr
mlcpeopu	ML Cp EOP U	MFP CP EOP U	mfp_mpcp.csv.ovr
mlcprcptc	ML Cp Receipts C	MFP CP Receipts C	mfp_mpcp.csv.ovr
mlcprcptr	ML Cp Receipts R	MFP CP Receipts R	mfp_mpcp.csv.ovr
mlcprcptu	ML Cp Receipts U	MFP CP Receipts U	mfp_mpcp.csv.ovr
mlcprtn1r	ML Cp Returns Reg+Promo R	MFP CP Returns Reg+Promo R	mfp_mpcp.csv.ovr
mlcprtn1u	ML Cp Returns Reg+Promo U	MFP CP Returns Reg+Promo U	mfp_mpcp.csv.ovr
mlcprtn2r	ML Cp Returns Clr R	MFP CP Returns Clear R	mfp_mpcp.csv.ovr
mlcprtn2u	ML Cp Returns Clr U	MFP CP Returns Clear U	mfp_mpcp.csv.ovr
mlcpsls1r	ML Cp Sales Reg+Promo R	MFP CP Sales Reg+Promo R	mfp_mpcp.csv.ovr
mlcpsls1u	ML Cp Sales Reg+Promo U	MFP CP Sales Reg+Promo U	mfp_mpcp.csv.ovr
mlcpsls2r	ML Cp Sales Clr R	MFP CP Sales Clr R	mfp_mpcp.csv.ovr
mlcpsls2u	ML Cp Sales Clr U	MFP CP Sales Clr U	mfp_mpcp.csv.ovr
mlcpslsc	ML Cp Sales C	MFP CP Sales Reg+Promo C	mfp_mpcp.csv.ovr
mlwpooadjc	ML Wp On Order Adj C	MFP WP On Order Adj C	mfp_otb.csv.rpl
mlwpooadjr	ML Wp On Order Adj R	MFP WP On Order Adj R	mfp_otb.csv.rpl
mlwpooadju	ML Wp On Order Adj U	MFP WP On Order Adj U	mfp_otb.csv.rpl

July 1, 2026 Appendix A-1 of A-2

Appendix A Integration with MFP Cloud Service

MFP Measure	MFPCS Label	APCS Label	File Name
mlwpotbc	ML Wp OTB C	MFP WP OTB C	mfp_otb.csv.rpl
mlwpotbr	ML Wp OTB R	MFP WP OTB R	mfp_otb.csv.rpl
mlwpotbu	ML Wp OTB U	MFP WP OTB U	mfp_otb.csv.rpl
lplaeopc	Ap EOP C	LP AP EOP C	mfp_lpap.csv.ovr
lplapeopr	Ap EOP R	LP AP EOP R	mfp_lpap.csv.ovr
lplapeopu	Ap EOP U	LP AP EOP U	mfp_lpap.csv.ovr
lplaprcptc	Ap Receipts C	LP AP Receipts C	mfp_lpap.csv.ovr
lplaprcptr	Ap Receipts R	LP AP Receipts R	mfp_lpap.csv.ovr
lplaprcptu	Ap Receipts U	LP AP Receipts U	mfp_lpap.csv.ovr
lplaprtnr	Ap Returns R	LP AP Returns R	mfp_lpap.csv.ovr
lplaprtnu	Ap Returns U	LP AP Returns U	mfp_lpap.csv.ovr
lplaslsc	Ap Sales C	LP AP Sales C	mfp_lpap.csv.ovr
lplaslsr	Ap Sales R	LP AP Sales R	mfp_lpap.csv.ovr
lplaslsu	Ap Sales U	LP AP Sales U	mfp_lpap.csv.ovr

If the customer is using their own customized MFP, they can provide the MFP Plan data in csv file format with the measures grouped by File Name as defined in the above table interface with headers as the measure names.

July 1, 2026 Appendix A-2 of A-2

---

In this guide

• Guide: Assortment Planning Cloud Service Implementation Guide
• Previous: 3 RAP Integration
• Next: B Appendix: RMFCS Integration