C Appendix: Standard Exports

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.

C

Appendix: Standard Exports

Assortment Planning Cloud Service provides multiple standard exports that retailers can use to integrate with other systems that need AP Plan data. It also exports new Placeholder items and new Product Attributes that can be used to interface them to their source systems.

For more information related to extracted measures, the approval process, and the administration process related to exports, see the Oracle Retail Assortment Planning Cloud Service User Guide . For more details about executing the export using Online Administration Tools using the Admin task Export Data, see the Oracle Retail Assortment Planning Cloud Service Administration Guide .

Assortment Planning Cloud Service Exports

This section lists the different Assortment Planning Cloud Service standard exports and the list of measures exported. All exported files will be in CSV format. A few exports are available for export only if the particular solution is enabled.

In APCS, Assortment Plans are approved at the Style-Color/Week/Store level, but before export, those approved plans are spread down to the Item/Week/Store level for Item Plan level exports.

Assortment Plan

Export Set Name: Assortment Plan

Export Set: ap_apcp

Exported File: ap_apcp_plan.txt

Export Criteria: All approved Assortment Plans for all un-elapsed time periods.

Table C-1 Assortment Plan Export Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
sku	Item
stor	Store
APCPSlsU	AF Cp Sales U	real	Total
APCPSlsR	AF Cp Sales R	real	Total
APCPSlsC	AF Cp Sales C	real	Total
APCPINT	AF Cp Intent	string	Total
APCPSTA	AF Cp Status	string	Total

Item Flow Plan

Export Set Name: Item Flow Plan

July 1, 2026 Appendix C-1 of C-4

Appendix C Assortment Planning Cloud Service Exports

Export Set: ap_ipcp

Exported File: ap_ipcp_plan.txt

Export Criteria: All approved Item Flow Plans for all un-elapsed time periods.

Table C-2 Item Flow Plan Export Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
skup	Item
stor	Store
ISCPSls1U	IF Cp Sales U	real	Total
ISCPSls1R	IF Cp Sales R	real	Total
ISCPSls1C	IF Cp Sales C	real	Total
ISCPEOPU	IF Cp EOP U	real	Total
ISCPEOPR	IF Cp EOP R	real	Total
ISCPEOPC	IF Cp EOP C	real	Total
ISCPRcptU	IF Cp Receipts U	real	Total
ISCPRcptR	IF Cp Receipts R	real	Total
ISCPRcptC	IF Cp Receipts C	real	Total
ISCPBuyQtyU	IF Cp Buy Qty U	real	Total
ISCPBuyQtyR	IF Cp Buy Qty R	real	Total
ISCPBuyQtyC	IF Cp Buy Qty C	real	Total

New Place-holder Items

Export Set Name: New Place-holder Items

Export Set: ph_item

Exported File: as_new_item.txt

Export Criteria: All newly created placeholder items which are not formalized. It also exports additional product rollup information for that item.

Table C-3 New Place-holder Items Export Measures

Measure	Measure Label	Data Type	Aggregation Type
sku	Item
DRDVPSKUL	Place-holder Item Label	String
DRDVPSKUPT	Style-Color Identifier	String
DRDVPSKUPL	Style-Color Label	String
DRDVPSKUGT	Style-Color Label	String
DRDVPSKUGL	Style Identifier	String
DRDVPSCLST	Style Label	String
DRDVPSCLSL	Subclass Identifier	String
DRDVPCLSST	Subclass Label	String

July 1, 2026 Appendix C-2 of C-4

Appendix C Assortment Planning Cloud Service Exports

Table C-3 (Cont.) New Place-holder Items Export Measures

Measure	Measure Label	Data Type	Aggregation Type
DRDVPCLSSL	Class Identifier	String
DRDVPDEPTT	Class Label	String
DRDVPDEPTL	Department Identifier	String
DRDVPDEPTL	Department Label	String

New Item - Product Attributes

Export Set Name: New Item - Product Attributes

Export Set: ph_patt

Exported File: ap_new_patt.txt

Export Criteria: All Item - Product Attribute association for newly created product attributes in Assortment Planning.

Table C-4 New Item - Product Attributes Export Measures

Measure	Measure Label	Data Type	Aggregation Type
sku	Item
patt	Product Attribute	String
ADDVPrdAttT	Product Attribute Value	String

New Product Attributes

Export Set Name: New Product Attributes

Export Set: ph_patr

Exported File: ap_new_patr.txt

Export Criteria: All newly created placeholder product attribute/attribute values which are not formalized.

Table C-5 New Placeholder Product Attribute Export Measures

Measure	Measure Label	Data Type	Aggregation Type
patv	Prod Attribute value	String
DRDVPHPRDATVL	Prod Attribute Value Label	String
DRDVPHPRDATTT	Product Attribute	String
DRDVPHPRDATTL	Product Attribute Label	String
DRDVPHPRDATTB	New Prod Attribute Flag	Boolean

Export to Allocation

Export Set Name: Export to Allocation

July 1, 2026 Appendix C-3 of C-4

Appendix C Assortment Planning Cloud Service Exports

Export Set: af_alloc

Exported File: ap_to_alloc.txt

Export Criteria: Approved Receipt Quantities for Allocation

Table C-6 Export to Allocation Measures

Measure	Measure Label	Data Type	Aggregation Type
week	Week
skup	Style/Color
stor	Store
APDVWeek2DayTx	EOW Date	real	Total
APDVStyleLblTx	Style Label	real	Total
APDVColorTx	Color Code	real	Total
APCPRcptU	Cp Receipts U	real	Total

Note

For Allocation, the standard exported file is further formatted as plitpt.0l (for Style/ Color) files by the batch process by calling the custom function ap_exp_alloc.

July 1, 2026 Appendix C-4 of C-4

---

In this guide

• Guide: Assortment Planning Cloud Service Implementation Guide
• Previous: B Appendix: RMFCS Integration
• Next: D Appendix: Application Specific Custom Functions, Procedures, and Expressions