Export Assortment Periods for Location Clustering to AI Foundation

In the APCS template version, the customer can define the Assortment periods at pre-defined product levels (DEPT). Assortment Periods are date ranges to plan the assortments; it can vary for different product levels. The customer can export the defined Assortment Periods by enabling the Boolean measure Export Period for Clustering at the Assortment Period level.

In order to import and use this data from AI Foundation, during implementation, some initial setups need to be done in the AI Foundation platform. For more details, see the Oracle Retail Analytics and Planning Integration Implementation Guide.

The following table shows the interface tables and column details from APCS in RDX used for the interface and the corresponding mapping of columns in APCS. Only mapped columns are used by the APCS template version. If RAP integration is enabled and if Enable RSE Cluster Integration is set to true, then this interface will run as part of the weekly batch.

Interface Name: AP_ASSORT_PERIOD_EXP

Table Column	Data Type	Comments	Dimension / Measure / Value Mapping
RUN_ID	Number(10)	The export Run ID as obtained from the RAP_INTF_UTIL.
PROD_LEVEL	Varchar2(80)	The product hierarchy level the data is for CMP, DIV, GRP, DEPT, CLS, SBC, STYLE, STYLE_COLOR, and SKU.	DEPT
PROD_KEY	Varchar2(80)	Product Identifier	DEPT
LOC_LEVEL	Varchar2(80)	The location hierarchy level data is for COMPANY, CHAIN, AREA, REGION, DISTRICT, and LOCATION.	COMPANY
LOC_KEY	Varchar2(80)	Location Identifier	COMP
ASSORT_PERIOD_KEY	Varchar2(80)	Assortment Period Key	BPER
ASSORT_PERIOD_START_DATE	Date	Assortment Period Start Date	BCDVSRTD
ASSORT_PERIOD_END_DATE	Date	Assortment Period End Date	BCDVENDD
EXT_NAME	Varchar2(80)	External Cluster Name	BCDVCLUSTERT
CLUSTER_DESCR	Varchar2(255)	Cluster Description	BCDVPRDL