15 ORASE Integration

This chapter details the integration between AIP and Oracle Retail Analytic Science Engine (ORASE).

ORASE to AIP Data

AIP receives only measure data from ORASE.

Measure Data

Table 14-1 displays the measure file AIP receives from ORASE.

Table 15-1 Measure File AIP Receives from ORASE

File Name	Description	Source
ipdmdtfrpcti.txt	Demand Transfer Percentage	ORASE

ipdmdtfrpcti.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Demand Transfer Percentage	The percentage of demand that is expected to transfer from a SKU to the substitute in the event of a shortage. The value must be greater than 0.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
script	aip_import_from_science.sh	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	Comma separated text file	Target Object Name	IpDmdTfrPctI
Source Object Name	ipdmdtfrpcti.txt	Target Object Database	data/dmdtfrpct
Required/Optional	Optional	Target Object Load Intersection	str_sku_ssku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
AIP Secondary SKU	SSKU	1	20
Item	SKU_	21	20
Location	STR_	41	20
Demand Percentage	Demand Transfer Percentage	61	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
str	Store	String	"s1000"
sku	SKU	String	"100036035"
ssku	Substitute SKU	String	"100036035"
Value	Demand Transfer Percentage	Real	.28

Formatting Conditions

Value	Prefix (Case Sensitive)
Stores	s

Example of ipdmdtfrpcti.txt extract file format:

s1000 ,100036035,100036040,.28