Export Active Assortments to AI Foundation
In the APCS template version, the customer can plan active assortments for an assortment period and those details can be exported to AI Foundation at the Item/Store 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, then this interface will run as part of the weekly batch.
Interface Name: AP_ACTIVE_ASSORT_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_KEY |
Varchar2(80) |
Product Identifier |
SKU |
|
LOC_KEY |
Varchar2(80) |
Location Identifier |
STOR |
|
PROD_LEVEL |
Varchar2(80) |
The product hierarchy level the data is for CMP, DIV, GRP, DEPT, CLS, SBC, STYLE, STYLE_COLOR, and SKU. |
ITEM |
|
LOC_LEVEL |
Varchar2(80) |
The location hierarchy level data is for COMPANY, CHAIN, AREA, REGION, DISTRICT, and LOCATION. |
LOCATION |
|
ACTIVE_START_DATE |
Date |
Active Assortment Start Date |
BPDBSRTD |
|
ACTIVE_END_DATE |
Date |
Active Assortment End Date |
BPDBENDD |