Import Size Profiles from AI Foundation
Size Profiles can be defined in AI Foundation and can be interfaced to APCS. The previous version of the APCS template version used Size Profiles defined from AIF or the size profiles set at the Admin level within the application. The APCS template version imports size profiles from AIF at the sub-class level. It is used to define Buy Quantity by Size and Receipts by Sizes while planning them.
In order to get Size Profiles 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 table column details from AI Foundation in RDX used for the interface and the corresponding mapping of columns in APCS. Only mapped columns are used by the APCS template version. For complete details of all available columns, see the Oracle Retail Analytics and Planning Integration Implementation Guide. If RAP integration is enabled and Enable RSE Size Profile Integration is set to true, then this interface will run as part of the weekly batch. If integration is enabled, it will use the same interface table data to also load the Size Hierarchy file (SIZH) using the internal view VW_SIZH_HIER and then also load the Size Profile.
The current version of AP is not using the below interface but still kept the details for non-template customers to customize and use the same if they are still using this integration.
Interface Name: RSE_SIZE_PROFILE_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_LEVEL_NAME |
Varchar2(255) |
The location hierarchy level data is for COMPANY, CHAIN, AREA, REGION, DISTRICT, and LOCATION. |
LOCATION |
|
PROD_LEVEL_NAME |
Varchar2(255) |
The product hierarchy level the data is for CMP, DIV, GRP, DEPT, CLS, SBC, STYLE, and STYLE_COLOR. |
SBC |
|
LOC_EXT_KEY |
Varchar2(80) |
The external id of the location. It will use the integration ids as provided to RI (preferably the RMS id, and not an integration id such as AREA~123). |
STOR |
|
PROD_EXT_KEY |
Varchar2(80) |
The external id of the product hierarchy. It will use the integration ids as provided to RI (preferably the RMS id, and not an integration id such as CLS~123~456~789). |
SCLS |
|
SIZE_EXT_ID |
Number(10) |
Size External Identifier |
SIZD |
|
SIZE_PCT_UNITS |
Number(10,5) |
Size Profile Percentage |
DRDVSIZE |
|
USED_BY_AIP |
Varchar2(1) |
Flag to indicate that record is for AIP Y |
PRFP |
|
SIZE_LABEL |
Varchar2(255) |
Size Label |
SIZD_LABEL |
|
SIZE_GROUP_ID |
Varchar2(255) |
Size Group Identifier |
SRNG |
|
SIZE_GROUP_LABEL |
Varchar2(255) |
Size Group Label |
SRNG_LABEL |
Note:
For Size Hierarchy (sizh), the internal view (VW_SIZE_HIER) is defined against the AIF RSE_SIZE_PROFILE_EXP table to get the unique sizes (SIZE_EXT_ID, SIZE_LABEL) and size ranges (SIZE_GROUP_ID and SIZE_GROUP_LABEL) which are marked to be used AP (USED_BY_AIP flag as ‘Y’).
SIZE_EXT_LABEL, also available as part of this view, can be used instead of SIZE_LABEL to get extended labels for sizes from AIF.