Export Assortment Plans to Retail Insights
Approved plans from APCS can be exported to Retail Insights within RAP integration. The APCS template version allows creating and exporting plans at the week/store/style-color level for both different versions. Plans for different versions can be exported to Retail Insights on a weekly basis. It exports all the approved plans for the unelapsed periods. With the AP non-template version, customers can create a different level of plans and they can also configure various metrics. The interface staging table in Retail Sights contains more metrics columns and various flex columns. The customer can update and configure the interface.cfg mappings to export additional columns that can be used by Retail Insights.
For more details about the list of columns available in the Retail Insights Interface Staging table if the customer plans to use extensibility or use the non-template version to send additional data, see the Oracle Retail Insights Implementation Guide. This guide contains only the mapped columns for the APCS template version.
This plan is one table for one level and uses the VERSION_NUM to differentiate different versions for the same level of data, such as WP and CP versions, for exporting both the OP and CP versions of the approved Assortment Plan.
Only AP_PLAN2_EXP is used by the AP template version to export plans at the Style-Color/Store/Week level. The AP_PLAN1_EXP table and interface is still available for non-template version customers if they want to customize and do exports at the Item/Store/Week level.
Interface Name: AP_PLAN2_EXP
- Plan Level: Style-Color/Store/Week
- Plan Version: AF CP
- Plan Version Number: 2
- Export Filter: APCS_APCPEXPORTB
| Table Column | Table Column | Data Type | Nullable | Comments | AP Fact Mapping |
|---|---|---|---|---|---|
| RUN_ID | Interface Run Identifier | Number(10) | N | The export Run ID as obtained from the RAP_INTF_UTIL | |
| PROD_KEY | Product Dimension | VARCHAR2(80) | N | Dimension STYL from PROD | APCS_APHDPSKUGT |
| LOC_KEY | Location Dimension | VARCHAR2(80) | N | Dimension STOR from LOC | |
| CLND_KEY | Calendar Dimension | VARCHAR2(80) | N | Dimension WEEK from CLND | |
| PROD_DH_ATTR | Attribute Dimension for RI | VARCHAR2(80) | N | Color Attribute | APCS_APHDPCOLORT |
| SUPPLIER_NUM | Supplier Dimension for RI | VARCHAR2(80) | N | Defaulted to -1 | |
| CAL_DATE | Last Day of Week | Date | N | Last Date of CLND_KEY as Date | APCS_APHDPWKED |
| VERSION_NUM | Version Number | Number(10) | N | Defaulted to 2 | |
| PROD_LEVEL | Product Level | VARCHAR2(80) | Defaulted to COLOR | ||
| LOC_LEVEL | Location Level | VARCHAR2(80) | Defaulted to LOCATION | ||
| FLEX1_CHAR_VALUE | Style-Color Id | VARCHAR2(80) | Dimension SKUP from PROD | ||
| SLS_QTY | AF Cp Sales U | NUMBER(20,4) | APCS_APCPSLSU | ||
| SLS_RTL_AMT | AF Cp Sales R | NUMBER(20,4) | APCS_APCPSLSR | ||
| SLS_COST_AMT | AF Cp Sales C | NUMBER(20,4) | APCS_APCPSLSC | ||
| ASRT_INTENT | AF Cp Item Intent | VARCHAR2(80) | APCS_APCPINTENTT | ||
| ASRT_STATUS | AF Cp Item Status | VARCHAR2(80) | APCS_APCPSTATUST | ||
| ASRT_FLAG | AF Cp Option Assorted | VARCHAR2(80) | APCS_APCPASRTSKUPB | ||
| ASRT_COUNT | AF Cp Option Assorted Count | NUMBER(18,4) | APCS_APCPASRTSKUPCT | ||
| PLAN_START_DATE | AF Cp Week Start | DATE | APCS_APCPSRTD | ||
| PLAN_END_DATE | AF Cp Week End | DATE | APCS_APCPENDD |
- Plan Level: Style-Color/Store/Week
- Plan Version: AF WP
- Plan Version Number: 3
- Export Filter: APCS_APWPEXPORTB
| Table Column | Table Column | Data Type | Nullable | Comments | AP Fact Mapping |
|---|---|---|---|---|---|
| RUN_ID | Interface Run Identifier | Number(10) | N | The export Run ID as obtained from the RAP_INTF_UTIL | |
| PROD_KEY | Product Dimension | VARCHAR2(80) | N | Dimension STYL from PROD | APCS_APHDPSKUGT |
| LOC_KEY | Location Dimension | VARCHAR2(80) | N | Dimension STOR from LOC | |
| CLND_KEY | Calendar Dimension | VARCHAR2(80) | N | Dimension WEEK from CLND | |
| PROD_DH_ATTR | Attribute Dimension for RI | VARCHAR2(80) | N | Color Attribute | APCS_APHDPCOLORT |
| SUPPLIER_NUM | Supplier Dimension for RI | VARCHAR2(80) | N | Defaulted to -1 | |
| CAL_DATE | Last Day of Week | Date | N | Last Date of CLND_KEY as Date | APCS_APHDPWKED |
| VERSION_NUM | Version Number | Number(10) | N | Defaulted to 3 | |
| PROD_LEVEL | Product Level | VARCHAR2(80) | Defaulted to COLOR | ||
| LOC_LEVEL | Location Level | VARCHAR2(80) | Defaulted to LOCATION | ||
| FLEX1_CHAR_VALUE | Style-Color Id | VARCHAR2(80) | Dimension SKUP from PROD | ||
| SLS_QTY | AF Wp Sales U | NUMBER(20,4) | APCS_APWPSLSU | ||
| SLS_RTL_AMT | AF Wp Sales R | NUMBER(20,4) | APCS_APWPSLSR | ||
| SLS_COST_AMT | AF Wp Sales C | NUMBER(20,4) | APCS_APWPSLSC | ||
| ASRT_INTENT | AF Wp Item Intent | VARCHAR2(80) | APCS_APWPINTENTT | ||
| ASRT_STATUS | AF Wp Item Status | VARCHAR2(80) | APCS_APWPSTATUST | ||
| ASRT_FLAG | AF Wp Option Assorted | VARCHAR2(80) | APCS_APWPASRTSKUPB | ||
| ASRT_COUNT | AF Wp Option Assorted Count | NUMBER(18,4) | APCS_APWPASRTSKUPCT | ||
| PLAN_START_DATE | AF Wp Week Start | DATE | APCS_APWPSRTD | ||
| PLAN_END_DATE | AF Wp Week End | DATE | APCS_APWPENDD |
- Plan Level: Style-Color/Store/Week
- Plan Version: IF CP
- Plan Version Number: 4
- Export Filter: APCS_ISCPEXPORTB
| Table Column | Table Column | Data Type | Nullable | Comments | AP Fact Mapping |
|---|---|---|---|---|---|
| RUN_ID | Interface Run Identifier | Number(10) | N | The export Run ID as obtained from the RAP_INTF_UTIL | |
| PROD_KEY | Product Dimension | VARCHAR2(80) | N | Dimension STYL from PROD | APCS_APHDPSKUGT |
| LOC_KEY | Location Dimension | VARCHAR2(80) | N | Dimension STOR from LOC | |
| CLND_KEY | Calendar Dimension | VARCHAR2(80) | N | Dimension WEEK from CLND | |
| PROD_DH_ATTR | Attribute Dimension for RI | VARCHAR2(80) | N | Color Attribute | APCS_APHDPCOLORT |
| SUPPLIER_NUM | Supplier Dimension for RI | VARCHAR2(80) | N | Defaulted to -1 | |
| CAL_DATE | Last Day of Week | Date | N | Last Date of CLND_KEY as Date | APCS_APHDPWKED |
| VERSION_NUM | Version Number | Number(10) | N | Defaulted to 4 | |
| PROD_LEVEL | Product Level | VARCHAR2(80) | Defaulted to COLOR | ||
| LOC_LEVEL | Location Level | VARCHAR2(80) | Defaulted to LOCATION | ||
| FLEX1_CHAR_VALUE | Style-Color Id | VARCHAR2(80) | Dimension SKUP from PROD | ||
| SLS_QTY | IF Cp Sales U | NUMBER(20,4) | APCS_ISCPSLS1U | ||
| SLS_RTL_AMT | IF Cp Sales R | NUMBER(20,4) | APCS_ISCPSLS1R | ||
| SLS_COST_AMT | IF Cp Sales C | NUMBER(20,4) | APCS_ISCPSLS1C | ||
| EOH_COST_AMT | IF Cp EOP C | NUMBER(20,4) | APCS_ISCPEOPC | ||
| EOH_RTL_AMT | IF Cp EOP R | NUMBER(20,4) | APCS_ISCPEOPR | ||
| EOH_QTY | IF Cp EOP U | NUMBER(20,4) | APCS_ISCPEOPU | ||
| INVRC_COST_AMT | IF Cp Rcpt C | NUMBER(20,4) | APCS_ISCPRCPTC | ||
| INVRC_RTL_AMT | IF Cp Rcpt R | NUMBER(20,4) | APCS_ISCPRCPTR | ||
| INVRC_QTY | IF Cp Rcpt U | NUMBER(20,4) | APCS_ISCPRCPTU | ||
| BUY_QTY | IF Cp Buy Qty U | NUMBER(20,4) | APCS_ISCPBuyQtyU | ||
| BUY_RTL_AMT | IF Cp Buy Qty R | NUMBER(20,4) | APCS_ISCPBuyQtyR | ||
| BUY_COST_AMT | IF Cp Buy Qty C | NUMBER(20,4) | APCS_ISCPBuyQtyC | ||
| PLAN_START_DATE | IF Cp Week Start | DATE | APCS_ISCPSRTD | ||
| PLAN_END_DATE | IF Cp Week End | DATE | APCS_ISCPENDD |
- Plan Level: Style-Color/Store/Week
- Plan Version: IF WP
- Plan Version Number: 5
- Export Filter: APCS_ISWPEXPORTB
| Table Column | Table Column | Data Type | Nullable | Comments | AP Fact Mapping |
|---|---|---|---|---|---|
| RUN_ID | Interface Run Identifier | Number(10) | N | The export Run ID as obtained from the RAP_INTF_UTIL | |
| PROD_KEY | Product Dimension | VARCHAR2(80) | N | Dimension STYL from PROD | APCS_APHDPSKUGT |
| LOC_KEY | Location Dimension | VARCHAR2(80) | N | Dimension STOR from LOC | |
| CLND_KEY | Calendar Dimension | VARCHAR2(80) | N | Dimension WEEK from CLND | |
| PROD_DH_ATTR | Attribute Dimension for RI | VARCHAR2(80) | N | Color Attribute | APCS_APHDPCOLORT |
| SUPPLIER_NUM | Supplier Dimension for RI | VARCHAR2(80) | N | Defaulted to -1 | |
| CAL_DATE | Last Day of Week | Date | N | Last Date of CLND_KEY as Date | APCS_APHDPWKED |
| VERSION_NUM | Version Number | Number(10) | N | Defaulted to 4 | |
| PROD_LEVEL | Product Level | VARCHAR2(80) | Defaulted to COLOR | ||
| LOC_LEVEL | Location Level | VARCHAR2(80) | Defaulted to LOCATION | ||
| FLEX1_CHAR_VALUE | Style-Color Id | VARCHAR2(80) | Dimension SKUP from PROD | ||
| SLS_QTY | IF Wp Sales U | NUMBER(20,4) | APCS_ISWPSLS1U | ||
| SLS_RTL_AMT | IF Wp Sales R | NUMBER(20,4) | APCS_ISWPSLS1R | ||
| SLS_COST_AMT | IF Wp Sales C | NUMBER(20,4) | APCS_ISWPSLS1C | ||
| EOH_COST_AMT | IF Wp EOP C | NUMBER(20,4) | APCS_ISWPEOPC | ||
| EOH_RTL_AMT | IF Wp EOP R | NUMBER(20,4) | APCS_ISWPEOPR | ||
| EOH_QTY | IF Wp EOP U | NUMBER(20,4) | APCS_ISWPEOPU | ||
| INVRC_COST_AMT | IF Wp Rcpt C | NUMBER(20,4) | APCS_ISWPRCPTC | ||
| INVRC_RTL_AMT | IF Wp Rcpt R | NUMBER(20,4) | APCS_ISWPRCPTR | ||
| INVRC_QTY | IF Wp Rcpt U | NUMBER(20,4) | APCS_ISWPRCPTU | ||
| BUY_QTY | IF Wp Buy Qty U | NUMBER(20,4) | APCS_ISWPBuyQtyU | ||
| BUY_RTL_AMT | IF Wp Buy Qty R | NUMBER(20,4) | APCS_ISWPBuyQtyR | ||
| BUY_COST_AMT | IF Wp Buy Qty C | NUMBER(20,4) | APCS_ISWPBuyQtyC | ||
| PLAN_START_DATE | IF Wp Week Start | DATE | APCS_ISWPSRTD | ||
| PLAN_END_DATE | IF Wp Week End | DATE | APCS_ISWPENDD |
- Plan Level: Style-Color/Store/Week
- Plan Version: Rec Opt
- Plan Version Number: 6
- Export Filter: APCS_ARDBEXPORTB
| Table Column | Table Column | Data Type | Nullable | Comments | AP Fact Mapping |
|---|---|---|---|---|---|
| RUN_ID | Interface Run Identifier | Number(10) | N | The export Run ID as obtained from the RAP_INTF_UTIL | |
| PROD_KEY | Product Dimension | VARCHAR2(80) | N | Dimension STYL from PROD | APCS_APHDPSKUGT |
| LOC_KEY | Location Dimension | VARCHAR2(80) | N | Dimension STOR from LOC | |
| CLND_KEY | Calendar Dimension | VARCHAR2(80) | N | Dimension WEEK from CLND | |
| PROD_DH_ATTR | Attribute Dimension for RI | VARCHAR2(80) | N | Color Attribute | APCS_APHDPCOLORT |
| SUPPLIER_NUM | Supplier Dimension for RI | VARCHAR2(80) | N | Defaulted to -1 | |
| CAL_DATE | Last Day of Week | Date | N | Last Date of CLND_KEY as Date | APCS_APHDPWKED |
| VERSION_NUM | Version Number | Number(10) | N | Defaulted to 5 | |
| PROD_LEVEL | Product Level | VARCHAR2(80) | Defaulted to COLOR | ||
| LOC_LEVEL | Location Level | VARCHAR2(80) | Defaulted to LOCATION | ||
| FLEX1_CHAR_VALUE | Style-Color Id | VARCHAR2(80) | Dimension SKUP from PROD | ||
| SLS_QTY | Rec Sales Potential U | NUMBER(20,4) | APCS_ARDBSLSPOTU | ||
| SLS_RTL_AMT | Rec Sales Potential R | NUMBER(20,4) | APCS_ARDBSLSPOTR | ||
| SLS_COST_AMT | Rec Sales Potential C | NUMBER(20,4) | APCS_ARDBSLSPOTC | ||
| ASRT_FLAG | Rec Option Assorted | VARCHAR2(80) | APCS_ARDBASRTSK |