17 AIP to RO Interfaces

This chapter describes the AIP to Oracle Retail Replenishment Optimization (RO) interfaces.

Measures

The following sections detail the measures needed for communication between AIP and RO.

STR_AIP_DATA

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Lead Time	Contains the number of days the source takes to deliver the item once the order is released from AIP. Lead time is an integer for a SKU/store.
Measure	Review Time	Review time is the number of days until the next receipt becomes available. This field contains the longest review time found within a certain time period. Review time is an integer for a SKU/store.
Measure	Pack Size	Contains the preferred ordering pack size when ordering the SKU to the store.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
Korn Shell Script	aip_export_to_ro.sh	not applicable	On request

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	AIP	Target Object Type	Fixed-length Text File or Comma Separated Values File
Source Object Type	RPAS measures	Target Object Name	STR_AIP_DATA.[txt csv]
Source Object Name	sr0_lt, sr0_rt, sr0_ordpkz	Target Object Load Intersection	str_item
Required/Optional	Optional	Target Object Load Intersection	str_item

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
STR_	Unique store identifier	1	20
SKU_	Unique SKU identifier	21	20
sr0_lt	Lead Time	41	10
sr0_rt	Review Time	51	10
sr0_ordpkz	Store Ordering Pack Size	61	10

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
STR	Unique store identifier	String	"1001 "
ITEM	Unique item identifier	String	"123456 "
gleadtime_	GLEADTIME_	Real	"3.0000 "
greview_time_	GREVIEW_TIME_	Real	"14.0000 "
gpacksize	GPACKSIZE_	Real	"24.0000 "

Formatting Conditions

None.

Example of STR_AIP_DATA.txt file:

"1001                123456              3.0000    14.0000   24.0000   "

Example of STR_AIP_DATA.csv file:

"1001,123456,3.0000,14.0000,24.0000"

WH_AIP_DATA

AIP can be configured to export warehouse supply-chain information. However, few optimization systems can optimize warehouse replenishment. Refer to the Oracle Retail Replenishment Optimization guides and the retailer's specific implementation to determine if warehouses can be optimized.