Export Assortment Groups to AI Foundation
In the APCS template version, the customer can define the Assortment Groups at pre-defined product levels (DEPT). Assortment Groups are a unique combination of Assortment Period and Associated Location Clusters defined in the Assortment Period Setup workbook. That is used by AI Foundation in order to Optimize Sales data and calculate Option Counts and Sales Potential data that is later used by the AP solution custom menu’s using web service calls.
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 daily/weekly batch.
Interface Name: AP_ASSORT_GROUP_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. | |
|
LOC_HIER_LEVEL |
Varchar2(30) |
The location hierarchy level data is for COMPANY, CHAIN, AREA, REGION, DISTRICT, and LOCATION. | LOCATION |
|
PROD_HIER_LEVEL |
Varchar2(30) |
The product hierarchy level the data is for CMP, DIV, GRP, DEPT, CLS, and SBC. | DEPT |
|
LOC_EXT_KEY |
Varchar2(80) |
The external id of the location. | STOR |
|
PROD_EXT_KEY |
Varchar2(80) |
The external id of the product hierarchy. | DEPT |
|
EFF_START_DATE |
Date |
The starting date which the cluster is effective. |
APCS_BGDVSRTD |
|
EFF_END_DATE |
Date |
The ending date for which the cluster is effective. |
APCS_BGDVENDD |
|
ASSORT_PERIOD_ID |
Varchar2(80) |
Assort Period Id used in AP. |
BPER |
|
ASSORT_PERIOD_LABEL |
Varchar2(255) |
Assort Period User Label. |
APCS_BGDVPRDL |
|
ASSORT_GROUP_ID |
Varchar2(80) |
Unique Id to group Product/Assort Period/Cluster Grouping based on Approval Date. |
APCS_BGDVPRDT |
|
ASSORT_PROD_LEVEL |
Varchar2(80) |
The product hierarchy level for Assortment Strategy. |
SBC |
|
CLUSTER_ID |
Varchar2(80) |
Unique identifier for the cluster. |
APCS_BGDVSTRCLUST |
|
CLUSTER_LABEL |
Varchar2(255) |
A descriptive name/label for the cluster used in AP. |
APCS_BGDVSTRCLUSL |