11 RDF Integration

This chapter details the integration between AIP and the Oracle Retail Demand Forecasting (RDF) system.

RDF to AIP Data

AIP receives only measure data from RDF.

Measure Data

AIP receives the following measure files from RDF:

File Name	Description	Source
iprdfdtdaltv.txt	RDF Detail Alert	RDF
sr0_rdfdtdmsk.txt	RDF Detail Alert Mask	RDF
sr0_rdfdtdcnt.txt	RDF Detail Alert Count	RDF
sr0_fcterrlvl1.txti	Daily Store Forecast Standard Deviation	RDF
sr0_fcterrlvl2.txt	Weekly Store Forecast Standard Deviation	RDF
isr0_frclvl1_[1..n].txt	Daily Store Demand Forecast	RDF
sr0_frclvl2.txt	Weekly Store Demand Forecast	RDF

Note on File Formats

AIP requires that the file formats of the data files corresponding to the RDF exports have the file formats listed in the following tables.

Technical Details of Load Process

For the technical details of the processing and loading of the forecasting system measure data, refer to the Oracle Retail Advanced Inventory Planning Operations Guide.

iprdfdtdaltv.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	RDF Detail Alert	Contains destination stocking point, SKU, and RDF Detail Alert flag.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File	Target Object Name	iprdfdtdaltv
Source Object Name	iprdfdtdaltv.txt	Target Object Database	data/rdfdtdalt
Required/Optional	Optional	Target Object Load Intersection	dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
STR	Store	1	20
SKU	SKU	21	20
Value	RDF Detail Alert	41	1

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
Dstk	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"100048001 "
Value	RDF Detail Alert	Boolean	"1" NaVal= false

Formatting Conditions

Value	Prefix (Case Sensitive)
Stores	S

Note: The RDF extract will only contain stores even though AIP reads the store into the destination stocking point dimension that can hold warehouses, stores, or suppliers.

Example of iprdfdtdaltv.txt extract file format:

S303 100048001 1S303 100049004 1

sr0_rdfdtdmsk.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	RDF Detail Alert Mask	Contains Store, SKU, and RDF Detail Alert Mask flag.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File	Target Object Name	sr0_rdfdtdmsk
Source Object Name	sr0_rdfdtdmsk.txt	Target Object Database	data/sr0_rdfdtdmsk
Required/Optional	Optional	Target Object Load Intersection	str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
STR	Store	1	20
SKU	SKU	21	20
Value	RDF Detail Alert Mask	41	1

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
STR	Store	String	"S441090 "
SKU	SKU	String	"100048001"
Value	RDF Detail Alert Mask	Boolean	"1" NaVal= false

Formatting Conditions

Value	Prefix (Case Sensitive)
Stores	S

Example of sr0_rdfdtdmsk.txt extract file format:

S441090 100048001 1

S402 100048001 1

sr0_rdfdtdcnt.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	RDF Detail Alert Count	Numeric measure at SKU/store containing the number of alert hits in the RDF Alert.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File	Target Object Name	sr0_rdfdtdcnt
Source Object Name	sr0_rdfdtdcnt.txt	Target Object Database	data/sr0_rdfdtdcnt
Required/Optional	Optional	Target Object Load Intersection	str_sku_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
STR	Store	1	20
SKU	SKU	21	20
Value	RDF Detail Alert Count	41	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
STR	Store	String	"S303 "
SKU	SKU	String	"118525 "
Value	RDF Detail Alert Count	Integer	"5 " NaVal = 0

Formatting Conditions

Value	Prefix (Case Sensitive)
Stores	S

Example of sr0_rdfdtdcnt.txt extract file format:

S303 118525 5

sr0_fcterrlvl1.txti

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Daily Store Forecast Standard Deviation	Contains Store, SKU, and Store Forecast Standard Deviation values.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File	Target Object Name	sr0_fcterrlvl1
Source Object Name	sr0_fcterrlvl1.txt	Target Object Database	data/sr0_fcterrlvl1
Required/Optiona	Optional	Target Object Load Intersection	str_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
STR	Store	1	20
SKU	SKU	21	20
Value	Daily Store Forecast Standard Deviation	41	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
STR	Store	String	"S441090 "
SKU	SKU	String	"100076002 "
Value	Daily Store Forecast Standard Deviation	Real	"1.000000" NaVal = 0

Formatting Conditions

Value	Prefix (Case Sensitive)
Stores	S

Example of sr0_fcterrlvl1.txti extract file format:

S441090 100048001 1.000000

sr0_fcterrlvl2.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Weekly Store Forecast Standard Deviation	Contains Store, SKU, and Store Forecast Standard Deviation values.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File	Target Object Name	sr0_fcterrlvl2
Source Object Name	sr0_fcterrlvl2.txt	Target Object Database	data/sr0_fcterrlvl2
Required/Optional	Optional	Target Object Load Intersection	sku_str_

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
STR	Store	1	20
SKU	SKU	21	20
VALUE	Weekly Store Forecast Standard Deviation	41	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
STR	Store	String	"S441090 "
SKU	SKU	String	"100076002 "
VALUE	Weekly Store Forecast Standard Deviation	Real	"1.000000" NaVal = 0

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of sr0_fcterrlvl2.txt extract file format:

S441090 100048001 1.000000

isr0_frclvl1_[1..n].txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Daily Store Demand Forecast	Contains Day, Store, SKU, and Daily Store Demand Forecast values.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File	Target Object Name	sr0_frclvl1
Source Object Name	sr0_frclvl1_[1..n].txt	Target Object Database	data/sr0_frclvl1
Required/Optional	Optional	Target Object Load Intersection	day_str_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
STR	Store	10	20
SKU	SKU	30	20
VALUE	Daily Store Demand Forecast	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060420"
STR	Store	String	"S411 "
SKU	SKU	String	"100049004 "
VALUE	Daily Store Demand Forecast	Real	"1000 " NaVal = 0

Formatting Conditions

Value	Prefix (Case Sensitive)
Day	D
Stores	S

Note: Although the intersection is at day, AIP is expecting the entire forecast for the week to be on one day of that week. RDF places the week's forecast on the last day of the week.

Example of isr0_frclvl1_[1..n].txt extract file format:

D20060420S411 100049004 1000

Note: The client can partition this data file for space or size considerations. For example: sr0_frclvl1_1.txt sr0_frclvl1_2.txt sr0_frclvl1_3.txt

sr0_frclvl2.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Weekly Store Demand Forecast	Contains Day, Store, SKU, and Weekly Store Demand Forecast.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed Length Text File	Target Object Name	sr0_frclvl2
Source Object Name	sr0_frclvl2_[1..n].txt	Target Object Database	data/sr0_frclvl2
Required/Optional	Optional	Target Object Load Intersection	day_str_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
STR	Store	10	20
SKU	SKU	30	20
Value	Weekly Store Demand Forecast	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
STR	Store	String	"S411 "
SKU	SKU	String	"100044001 "
Value	Weekly Store Demand Forecast	Real	"1000 " NaVal = 0

Formatting Conditions

Value	Prefix (Case Sensitive)
Day	D
Stores	S

Example of sr0_frclvl2.txt extract file format:

D20060401 100044001 1000

Note: You can partition this data file for space or size considerations. For example: sr0_frclvl2_1.txt sr0_frclvl2_2.txt sr0_frclvl2_3.txt