Data Files
A broad and detailed data set is required to use the capabilities of APCS to its fullest.
The following tables describe the data files (measures) needed, load intersection, data type, file name, required/optional, and expected data source details. In the Data Source column, RI means any Data Warehouse or equivalent/RMS and those data are readily available from RAP integration, RSP means data from AI Foundation which is also available as part of RAP integration, Internal means any retailer internal system or the data using data files, and Admin means either data can be directly set up by an administration user or can be loaded as files.
Load Data Set
All data loads in batch after the initial domain build are done by scheduling batch tasks in Online Administration Tools. This information specifies which Load Set the user needs to use to load that particular data file while scheduling the Online Administration Tool Tasks. For more details, see the Oracle Retail Assortment Planning Cloud Service Administration Guide.
Table 2-1 Assortment Planning Cloud Service Measure List - Details 1
| Measure Name | Measure Label | Data Type | Load Intersection | File Name | Agg Type | Required or Optional? | Data Source |
|---|---|---|---|---|---|---|---|
|
drtyeop1c |
Ty EOP Reg+Promo C |
real |
week_sku_stor |
eopx.csv.ovr |
pet |
Required |
RI |
|
drtyeop1r |
Ty EOP Reg+Promo R |
real |
week_sku_stor |
eopx.csv.ovr |
pet |
Required |
RI |
|
drtyeop1u |
Ty EOP Reg+Promo U |
real |
week_sku_stor |
eopx.csv.ovr |
pet |
Required |
RI |
|
drtyeop2c |
Ty EOP Clr C |
real |
week_sku_stor |
eopx.csv.ovr |
pet |
Required |
RI |
|
drtyeop2r |
Ty EOP Clr R |
real |
week_sku_stor |
eopx.csv.ovr |
pet |
Required |
RI |
|
drtyeop2u |
Ty EOP Clr U |
real |
week_sku_stor |
eopx.csv.ovr |
pet |
Required |
RI |
|
drtynslsclrc |
Ty Net Sales Clear C |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslsclrr |
Ty Net Sales Clear R |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslsclru |
Ty Net Sales Clear U |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslsproc |
Ty Net Sales Promo C |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslspror |
Ty Net Sales Promo R |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslsprou |
Ty Net Sales Promo U |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslsregc |
Ty Net Sales Reg C |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslsregr |
Ty Net Sales Reg R |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtynslsregu |
Ty Net Sales Reg U |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnclrc |
Ty Return Clear C |
real |
week_sku_stor |
rtn.csv.ovr |
total |
Required |
RI |
|
drtyrtnclrr |
Ty Return Clear R |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnclru |
Ty Return Clear U |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnproc |
Ty Return Promo C |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnpror |
Ty Return Promo R |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnprou |
Ty Return Promo U |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnregc |
Ty Return Reg C |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnregr |
Ty Return Reg R |
real |
week_sku_stor |
nsls.csv.ovr |
total |
Required |
RI |
|
drtyrtnregu |
Ty Return Reg U |
real |
week_sku_stor |
rtn.csv.ovr |
total |
Required |
RI |
|
drtyooc |
Ty On Order C |
real |
week_sku_stor |
oo.csv.ovr |
total |
Required |
RI |
|
drtyoor |
Ty On Order R |
real |
week_sku_stor |
oo.csv.ovr |
total |
Required |
RI |
|
drtyoou |
Ty On Order U |
real |
week_sku_stor |
oo.csv.ovr |
total |
Required |
RI |
|
drtyporcptc |
Ty PO Receipt C |
real |
week_sku_stor |
rcpt.csv.ovr |
total |
Required |
RI |
|
drtyporcptr |
Ty PO Receipt R |
real |
week_sku_stor |
rcpt.csv.ovr |
total |
Required |
RI |
|
drtyporcptu |
Ty PO Receipt U |
real |
week_sku_stor |
rcpt.csv.ovr |
total |
Required |
RI |
|
drtytraninbc |
Ty Transfers In Book C |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytraninbr |
Ty Transfers In Book R |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytraninbu |
Ty Transfers In Book U |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytraninic |
Ty Transfers In ICT C |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytraninir |
Ty Transfers In ICT R |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytraniniu |
Ty Transfers In ICT U |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytraninr |
Ty Transfers In R |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Required |
RI |
|
drtytraninc |
Ty Transfers In C |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Required |
RI |
|
drtytraninu |
Ty Transfers In U |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Required |
RI |
|
drtytranoutbc |
Ty Transfers Out Book C |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytranoutbr |
Ty Transfers Out Book R |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytranoutbu |
Ty Transfers Out Book U |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytranoutic |
Ty Transfers Out ICT C |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytranoutir |
Ty Transfers Out ICT R |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytranoutiu |
Ty Transfers Out ICT U |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Optional |
RI |
|
drtytranoutr |
Ty Transfers Out R |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Required |
RI |
|
drtytranoutu |
Ty Transfers Out U |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Required |
RI |
|
drtytranoutc |
Ty Transfers Out C |
real |
week_sku_stor |
tranx.csv.ovr |
total |
Required |
RI |
|
drtyicmkdr |
TY Inter-Company Markdown R |
real |
week_sku_stor |
ic_mkd.csv.ovr |
total |
Optional |
RI |
|
drtyicmkur |
TY Inter-Company Markup R |
real |
week_sku_stor |
ic_mkd.csv.ovr |
total |
Optional |
RI |
|
drtywfslsr |
TY W/F Sales R |
real |
week_sku_stor |
wfms.csv.ovr |
total |
Optional |
RI |
|
drtywfslsu |
TY W/F Sales U |
real |
week_sku_stor |
wfms.csv.ovr |
total |
Optional |
RI |
|
drtywfslsc |
TY W/F Sales C |
real |
week_sku_stor |
wfms.csv.ovr |
total |
Optional |
RI |
|
drtywfrtnr |
TY W/F Returns R |
real |
week_sku_stor |
wfms.csv.ovr |
total |
Optional |
RI |
|
drtywfrtnu |
TY W/F Returns U |
real |
week_sku_stor |
wfms.csv.ovr |
total |
Optional |
RI |
|
drtywfrtnc |
TY W/F Returns C |
real |
week_sku_stor |
wfms.csv.ovr |
total |
Optional |
RI |
|
drdvprdattt |
Product Attribute - Item Level |
string |
sku_patt |
drdvprdattt.csv.ovr |
mode_pop |
Required |
RI |
|
drdvppatvt |
RMS Product Attribute Value |
string |
patv |
drdvppatvt.csv.ovr |
mode_pop |
Required |
RI |
|
drtyudab |
TY RMS UDA |
Boolean |
patt |
drtyudab.csv.ovr |
or |
Required |
RI |
|
addvlocopnd |
Location Open Date |
date |
stor |
stor_a.csv.ovr |
ambig_pop |
Required |
RI |
|
addvlocendd |
Location Close Date |
date |
stor |
stor_a.csv.ovr |
ambig_pop |
Required |
RI |
|
addvlocrefd |
Location Refurbish Date |
date |
stor |
stor_a.csv.ovr |
ambig_pop |
Required |
RI |
|
addvloctypet |
Location Type |
string |
stor |
stor_a.csv.ovr |
ambig_pop |
Required |
RI |
|
drtypclsst |
TY RMS Class Display Id |
string |
sku |
prod_a.csv.ovr |
ambig_pop |
Required |
RI |
|
drtypsclst |
TY RMS Sub-Class Id |
string |
sku |
prod_a.csv.ovr |
ambig_pop |
Required |
RI |
|
addvlocattt |
Location Attribute |
string |
stor_satt |
addvlocattt.csv.ovr |
mode_pop |
Required |
Admin |
|
adlylagwt |
LY Week Map |
string |
week |
adlylagwt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvprdattb |
Class - Product Attribute Eligibility |
Boolean |
clss_patt |
addvprdattb.csv.ovr |
or |
Optional |
Admin |
|
addvslscrvv |
Sales Curve % |
real |
woyr_scls_chnc_cnum |
addvslscrvv.csv.ovr |
total |
Optional |
Admin |
|
addvslsprcc |
Override Cost |
real |
skup_stor |
addvslsprc.csv.ovr |
max_pop |
Optional |
Admin |
|
addvslsprcr |
Override Retail Price |
real |
skup_stor |
addvslsprc.csv.ovr |
max_pop |
Optional |
Admin |
|
addvslswgtu |
Sales Weight U |
real |
chnc_spl2 |
addvstrcwgt.csv.ovr |
average_pop |
Optional |
Admin |
|
addvslswgtr |
Sales Weight R |
real |
chnc_spl2 |
addvstrcwgt.csv.ovr |
average_pop |
Optional |
Admin |
|
addvslswgtar |
Sales Weight AUR |
real |
chnc_spl2 |
addvstrcwgt.csv.ovr |
average_pop |
Optional |
Admin |
|
addvgmwgtr |
Gross Margin Weight R |
real |
chnc_spl2 |
addvstrcwgt.csv.ovr |
average_pop |
Optional |
Admin |
|
addvgmwgtrp |
Gross Margin Weight R % |
real |
chnc_spl2 |
addvstrcwgt.csv.ovr |
mode_pop |
Optional |
Admin |
|
drdvstrclust |
Loaded Location Cluster |
string |
week_dept_stor |
drdvstrclus.csv.ovr |
mode_pop |
Optional |
AI Foundation |
|
drdvstrclusl |
Loaded Location Cluster Label |
string |
week_dept_stor |
drdvstrclus.csv.ovr |
mode_pop |
Optional |
AI Foundation |
|
drdvsrtd |
Start Date |
date |
week_dept_stor |
drdvstrclus.csv.ovr |
ambig_pop |
Optional |
AI Foundation |
|
drdvendd |
End Date |
date |
week_dept_stor |
drdvstrclus.csv.ovr |
ambig_pop |
Optional |
AI Foundation |
|
fcdvsls1u |
Fcst Sales Reg+Promo U |
real |
week_scls_stor |
fcst_scls.csv.ovr |
total |
Optional |
AI Foundation |
|
fcdvsls1r |
Fcst Sales Reg+Promo R |
real |
week_scls_stor |
fcst_scls.csv.ovr |
total |
Optional |
AI Foundation |
|
fctyfcpmu |
Fcst Pre-Season Sales U |
real |
week_sku_stor |
fcst.csv.ovr |
total |
Required |
AI Foundation |
|
fctyfcimu |
Fcst In-Season Sales U |
real |
week_sku_stor |
fcst.csv.ovr |
total |
Required |
AI Foundation |
|
fctyfcpmr |
Fcst Pre-Season Sales R |
real |
week_sku_stor |
fcst.csv.ovr |
total |
Required |
AI Foundation |
|
fctyfcimr |
Fcst In-Season Sales R |
real |
week_sku_stor |
fcst.csv.ovr |
total |
Required |
AI Foundation |
|
mlcpeopc |
MFP Loaded CP EOP C |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
pet |
Required |
MFP |
|
mlcpeopr |
MFP Loaded CP EOP R |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
pet |
Required |
MFP |
|
mlcpeopu |
MFP Loaded CP EOP U |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
pet |
Required |
MFP |
|
mlcprcptc |
MFP Loaded CP Receipts C |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcprcptr |
MFP Loaded CP Receipts R |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcprcptu |
MFP Loaded CP Receipts U |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcprtn1r |
MFP Loaded CP Returns Reg+Promo R |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcprtn1u |
MFP Loaded CP Returns Reg+Promo U |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcprtn2r |
MFP Loaded CP Returns Clear R |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcprtn2u |
MFP Loaded CP Returns Clear U |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcpsls1r |
MFP Loaded CP Sales Reg+Promo R |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcpsls1u |
MFP Loaded CP Sales Reg+Promo U |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcpsls2r |
MFP Loaded CP Sales Clr R |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcpsls2u |
MFP Loaded CP Sales Clr U |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlcpslsc |
MFP Loaded CP Sales Reg+Promo C |
real |
week_scls_stor |
mfp_mpcp.csv.ovr |
total |
Required |
MFP |
|
mlwpooadjc |
MFP Loaded WP On Order Adj C |
real |
week_scls_stor |
mfp_otb.csv.rpl |
total |
Required |
MFP |
|
mlwpooadjr |
MFP Loaded WP On Order Adj R |
real |
week_scls_stor |
mfp_otb.csv.rpl |
total |
Required |
MFP |
|
mlwpooadju |
MFP Loaded WP On Order Adj U |
real |
week_scls_stor |
mfp_otb.csv.rpl |
total |
Required |
MFP |
|
mlwpotbc |
MFP Loaded WP OTB C |
real |
week_scls_stor |
mfp_otb.csv.rpl |
total |
Required |
MFP |
|
mlwpotbr |
MFP Loaded WP OTB R |
real |
week_scls_stor |
mfp_otb.csv.rpl |
total |
Required |
MFP |
|
mlwpotbu |
MFP Loaded WP OTB U |
real |
week_scls_stor |
mfp_otb.csv.rpl |
total |
Required |
MFP |
|
lplaeopc |
LP AP EOP C |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
pet |
Optional |
MFP |
|
lplaeopr |
LP AP EOP R |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
pet |
Optional |
MFP |
|
lplaeopu |
LP AP EOP U |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
pet |
Optional |
MFP |
|
lplarcptc |
LP AP Receipts C |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
lplarcptr |
LP AP Receipts R |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
lplarcptu |
LP AP Receipts U |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
lplartnr |
LP AP Returns R |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
lplartnu |
LP AP Returns U |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
lplaslsu |
LP AP Sales U |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
lplaslsr |
LP AP Sales R |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
lplaslsc |
LP AP Sales C |
real |
week_dept_stor |
mfp_ lpap.csv.ovr |
total |
Optional |
MFP |
|
addvpskugt |
Rename Style Id |
string |
skug |
addvpskugt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvpskupt |
Rename Style/Color Id |
string |
skup |
addvpskugt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvpskut |
Rename Item Id |
string |
sku |
addvpskugt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvskuimgt |
Item Image |
string |
sku |
addvskuimgt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvskupimgt |
Style-Color Image |
string |
skup |
addvskupimgt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvskugimgt |
Style Image |
string |
skug |
addvskugimgt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvsclsimgt |
Sub-Class Image |
string |
scls |
addvsclsimgt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvpatvimgt |
Product Attribute Value Image |
string |
patv |
addvpatvimgt.csv.ovr |
mode_pop |
Optional |
Admin |
|
addvpattimgt |
Product Attribute Image |
string |
patt |
addvpattimgt.csv.ovr |
mode_pop |
Optional |
Admin |
| drdvslsprcr | Item Initial Retail Price | real | sku | drdvslsprc.csv.ovr | avg_pop |
Optional |
AI Foundation |
| drdvslsprcc | Item Initial Cost | real | sku | drdvslsprc.csv.ovr | avg_pop |
Optional |
AI Foundation |
|
drdvskuimgt |
Item Image Name |
string |
sku |
drdvskuimg.csv.ovr |
mode_pop |
Optional |
AI Foundation |
|
drdvskuimgl |
Item Image Address |
string |
sku |
drdvskuimg.csv.ovr |
mode_pop |
Optional |
AI Foundation |
| addvppattt | Rename Product Attribute | string | patt | addvppattt.csv.ovr | mode_pop | Optional | Admin |
| addvppavt | Rename Product Attribute Value | string | patv | addvppatvt.csv.ovr | mode_pop | Optional | Admin |
All measure files that need to be loaded as data files need to be grouped based on the File Name. The files should contain the header for the measures to be loaded and it should be in .csv format. Measures within a file can be grouped in any order as long as the header column is specified correctly. If a measure is optional in a file, the customer can ignore that measure and group the remaining measures which are available for the customer.
Example:
In following example, the customer is using RAP integration and only grouping the data that is not coming in RAP (or RI) in a file for which customer has the data.
File Name: tranx.csv.ovr
Base Intersection: week/sku/stor
Data Type: real
week,sku,stor,drtyroyalr,drtymiscadju,drtymiscadjr,drtycogsr w01_2021,100000,1000,30.96,31.52,0,0 w02_2021,100000,1000,169.13,112.61,1,37.85 w03_2021,100000,1000,233.54,50.26,1,35.09