9 RMS Integration and Data Mapping

This chapter describes integration between AIP and Oracle Retail Merchandising System (RMS).

RMS to AIP Data

There are two types of data that RMS can provide to AIP:

• Hierarchy Data

• Measure Data

Hierarchy Data

Table 9-1 lists the hierarchy files that AIP can receive from RMS.

Table 9-1 Hierarchy Files

File Name	Description	Source
loc.txt	Location Hierarchy	RMS-partial (†)
item.txt	Item Hierarchy (Product Hierarchy)	RMS-partial (*)
splr.txt	Supplier Hierarchy	RMS
whse.txt	Warehouses	RMS-partial (*)
clnd.csv.dat	Calendar Hierarchy	RMS

(†) RMS delivers only some fields in the location hierarchy. See"File Format" for details.

(*) These hierarchies go through a merge process with AIP-Oracle data prior to being fully loaded into AIP-RPAS.

File Format

The Retail Extraction, Transformation, and Loading (RETL) tool, through the RMS-AIP Transformation scripts, provides AIP with the file format displayed in Table 9-2.

Note: Customers who do not have RETL are required to provide files with this same format.

Table 9-2 Location Hierarchy File Name: loc.txt

Data Entry	Start	Width	Source
Store	1	20	RMS
Store Description	21	150	RMS
Site	171	20	RMS
Site Description	191	120	RMS
Region	311	20	RMS
Region Description	331	120	RMS
Zone	451	20	RMS
Zone Description	471	120	RMS
Chain	591	20	RMS
Chain Description	611	120	RMS
Company	731	20	RMS
Company Description	751	120	RMS
TV Region	871	4	External
TV Region Description	875	24	External
Weather Region	899	4	External
Weather Region Description	903	24	External
Market Region	927	4	External
Market Region Description	931	24	External
Store Format	955	20	RMS
Store Format Description	975	40	RMS

Note: RMS does not provide Weather Region, TV Region, or Market Region data in its extract. The RMS-AIP transformation script stubs these fields (positions and labels) with a 0 value. If customers want to use these dimensions, they need to add a custom step between RMS transforms and aip_batch to use them. RMS can provide a store format; however, it is an optional value in RMS. Store Format is not optional in AIP and should be set appropriately in RMS to prevent errors in AIP.

Table 9-3 Item Hierarchy (Product Hierarchy) File Name: item.txt

Data Entry	Start	Width	Source
AIP SKU	1	20	RMS /This is the forecasted, selling SKU.
Order Multiple	21	4	RMS
Pack Quantity	25	4	RMS
RMS SKU	29	20	RMS
RMS SKU Description	49	250	RMS/ The description must not contain the pipe character due to its use as a field delimiter in the flat files loaded within AIP.
Segment	299	20	RMS
Segment Description	319	120	RMS
Sub-Category	439	20	RMS
Sub-Category Description	459	120	RMS
Category	579	20	RMS
Category Description	599	120	RMS
Super-Category	719	20	RMS
Super-Category Description	739	120	RMS
Business Unit	859	20	RMS
Business Unit Description	879	120	RMS
Company	999	20	RMS
Company Description	1019	120	RMS
SKU Type	1139	20	RMS
SKU Type Description	1159	100	RMS

The item.txt file maps as follows:

1. The RMS SKU to the AIP SKU.

2. The Pack Quantity and Order Multiple to the AIP SKU-pack size. AIP processing code creates a mapping table (measure) to tie the RMS SKU to the AIP SKU pack size and uses this mapping method to send data back to RMS using the RMS SKU.

3. The Pack Quantity must be Null, and the Order Multiple equal to the AIP SKU-pack size.

Note: While RMS can extract pack items, AIP does not support RMS Formal Packs. All item-related data must be for the forecasted, selling SKU.

Mapping Table

Table 9-4 is used for mapping the RMS SKU to the AIP SKU pack size. This information is sent in the item.txt file as shown in Table 9-3.

Table 9-4 Mapping Table: (Examples)

RMS SKU	Order Multiple	Pack Quantity	AIP SKU Pack Size
300	1	(null)	300_1
303	6	(null)	300_6

Note: RMS truncates fractional pack sizes before sending the data to AIP, as AIP cannot handle fractional pack sizes.

Table 9-5 Supplier Hierarchy File Name: splr.txt

Data Entry	Start	Width	Source
Supplier	1	20	RMS
Supplier Description	21	240	RMS

Table 9-6 Warehouse Hierarchy File Name: whse.txt

Data Entry	Start	Width	Source
Warehouse Chamber	1	20	DM-Online
Warehouse Chamber Description	21	150	DM-Online
Warehouse	171	20	RMS
Warehouse Description	191	150	RMS

Note: RMS sends warehouse chamber values equal to warehouse values.

Table 9-7 Calendar Hierarchy File Name: clnd.csv.dat

Data Entry	Source
Day	RMS
Day Label	AIP
DOFP	AIP
DOFP Label	AIP
DOFN	AIP
DOFN Label	AIP
DOW	RMS
90 DOW Label	AIP
DOS	RMS
DOS Label	AIP
Week	RMS
Week Label	AIP
WOS	AIP
WOS Label	AIP
WOY	AIP
WOY Label	AIP
UMC	AIP
UMC Label	AIP
Month	RMS
Month Label	AIP
MOY	AIP
MOY Label	AIP
Quarter	RMS
Quarter Label	AIP
Year	RMS
Year Label	AIP

Note: See Chapter 7, "AIP Calendar Hierarchy" for a detailed file format of the calendar hierarchy.

Measure Data

AIP receives the following measure files from RMS:

Table 9-8 RMS Measure Files

File Name	Description	Source
dmx_dscdt_.txt	Corporate Discontinuation Date	RMS
dmx_vadprdasc.txt	Value-Added Commodity Association	RMS
dmx_prdspllks.txt	Commodity-Supplier Links	RMS
dmx_dirspl.txt	Direct Suppliers	RMS
sr0_curinv_[1..n].txt	Store-on-hand inventory (used to be historical inv)	RMS
sr0_it_.txt	Store In-transits	RMS
sr0_oo_.txt	Store On-orders	RMS
sr0_prdlfe.txt	Store Product Life	RMS
wr1_curinv.txt	Current WH Inventory (on hand)	RMS
wr1_oo_.txt	Warehouse On-orders	RMS
wr1_it_.txt	Warehouse In-transits	RMS
wr1_aiw.txt	Warehouse Allocations in the Well	RMS
wr1_tiw.txt	Warehouse Transfers in the Well	RMS
wh_type.txt	Warehouse Type	RMS
sr0_dayslsld.txt	Daily Sales	RMS
received_qty.txt	RMS received quantity	RMS*
closed_order.txt	RMS closed orders	RMS*
dm0_ofseffdt_.txt	Off-Sale Effective Date	RMS
dm0_onseffdt_.txt	On-Sale Effective Date	RMS
ippckindi.txt	Simple Pack Indicator	RMS
rmse_aip_future_delivery_order.schema.txt	Future Delivery Order	RMS*
rmse_aip_future_delivery_tsf.schema.txt	Future Delivery Transfer	RMS*
rmse_aip_future_delivery_alloc.schema.txt	Future Delivery Allocation	RMS*

Note: The files, with an *, are files coming from RMS to AIP-Oracle and are not loaded into AIP-RPAS.

Note on File Formats

Two sets of file formats for the data listed in Table 9-8, "RMS Measure Files" follow in tables located in these sections:

Section	Description
"File Formats"	Describes the format the data have after the RMS-AIP Transformation scripts have completed. For more information about the RMS-AIP Transformation process, refer to the Oracle Retail Advanced Inventory Planning Operations Guide, Chapter 5, ”AIP Interfaces and Transformation Scripts.”
"File Format Including Mapping to AIP-RPAS Measure Format"	Describes the mapping between the RMS-AIP Transformation output format and the RPAS measure format. AIP-RPAS batch scripts contain logic to transform the data into the RPAS measure loadable format.

When moving an integration data source from RMS to a non-RMS external system, as described in Chapter 6, "AIP-RPAS Configurations", it is assumed that the RMS-AIP Transformation process will not be run. Therefore, it is your responsibility to create the data files in the RPAS measure loadable format, as described in the second set of file format tables, "File Format Including Mapping to AIP-RPAS Measure Format". The AIP Field, Start and Width columns make up the RPAS measure loadable format.

File Formats

The Retail Extraction, Transformation, and Loading (RETL) tool provides AIP with the file formats listed in the following tables.

Note: Customers who do not have RETL are required to provide files with these same formats.

Corporate Discontinuation Date Data

Table 9-9 File Name: dmx_dscdt_.txt

Field Name	Type	Start	Width	Source/Comments
RMS SKU (Promotional)	String	1	20	RMS RMS sends today's date. AIP sets the ranging status at all supply locations to pending-deranged as well as initializes the stop-receiving-dates at all warehouses.
Order Multiple	String	21	4
Corporate Discontinuation Date	YYYYMMDD	25	8

Value-Added Commodity Association

Table 9-10 File Name: dmx_vadprdasc.txt

Field Name	Type	Start	Width	Source/Comments
RMS SKU (child)	String	1	20	RMS
Order Multiple	String	21	4
RMS SKU (parent)	String	25	20
Order Multiple	String	45	4

Commodity-Supplier Links

Table 9-11 File Name: dmx_prdspllks.txt

Field Name	Type	Start	Width	Source/Comments
Supplier	String	1	20	RMS
RMS SKU	String	21	20
Order Multiple	String	41	4
SKU Supplier Links	Boolean	45	1

Direct Suppliers

Table 9-12 File Name: dmx_dirspl.txt

Field Name	Type	Start	Width	Source/Comments
Supplier	String	1	20	RMS
Direct Supplier	Boolean	21	1

Store Current Inventory Data

Table 9-13 File Name: sr0_curinv_[1..n].txt

Field Name	Type	Start	Width	Source/Comments
Store	String	1	20	RMS Order Multiple value is always one (1).
RMS SKU	String	21	20
Store current inventory	Float	41	8

Note: RMS can also send the Store Current Inventory file in partitions. For example, AIP interface code can handle sr0_curinv_[1..n].txt, where n is the partition number. The data will always arrive from RMS RETL extract with at least one partition, namely, sr0_curinv_1.txt.

Store In-transits Data

Table 9-14 File Name: sr0_it_.txt

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS
Store	String	10	20
RMS SKU	String	30	20
Order Multiple	String	50	4
Store In-transits	Float	54	8

Store On-orders Data

Table 9-15 File Name: sr0_oo_.txt

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS RMS will send today's date with sum of all previous number of days values.
Store	String	10	20
RMS SKU	String	30	20
Order Multiple	String	50	4
Store On-orders	Float	54	8

Store Product Life Data

Table 9-16 File Name: sr0_prdlfe.txt

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS
RMS SKU	String	10	20
Order Multiple	String	30	4
Store Product Life	Float	34	8

Current Warehouse Inventory Data

Table 9-17 File Name: wr1_curinv.txt

Field Name	Type	Start	Width	Source/Comments
Warehouse	String	1	20	RMS
RMS SKU	String	21	20
Order Multiple	String	41	4
Current Warehouse Inventory	Float	45	8

On-orders Data

Table 9-18 File Name: wr1_oo_.txt

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS RMS will send today's date with sum of all previous number of days values.
Supplier	String	10	20
Warehouse	String	30	20
RMS SKU	String	50	20
Order Multiple	String	70	4
On-orders	Float	74	8

In-transit Data

Table 9-19 File Name: wr1_it_.txt

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS
Supplier	String	10	20
Warehouse	String	30	20
RMS SKU	String	50	20
Order Multiple	String	70	4
In-transit	Float	74	8

Allocations in the Well Data

Table 9-20 File Name: wr1_aiw.txt

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS RMS sends today's date with the sum of all previous number of days values.
Warehouse	String	10	20
RMS SKU	String	30	20
Order Multiple	String	50	4
Allocations in the Well	Float	54	8

Transfers in the Well Data

Table 9-21 File Name: wr1_tiw.txt

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS RMS sends today's date with the sum of all previous number of days values.
Warehouse	String	10	20
RMS SKU	String	30	20
Order Multiple	String	50	4
Transfers in the Well	Float	54	8

Daily Sales Data

Table 9-22 File Name: sr0_dayslsld

Field Name	Type	Start	Width	Source/Comments
Day	DYYYYMMDD	1	9	RMS
Store	String	10	20
RMS SKU	String	30	20
Daily Sales	Float	50	8

RMS Received Quantity Data

Table 9-23 File Name: received_qty.txt

Field Name	Type	Start	Width	Source/Comments
Order Number	Integer	1	10	RMS
Order Type	String	11	1
RMS SKU	String	12	25
Order Multiple	Integer	37	8
Pack Quantity	Integer	45	8
Store	Integer	53	10
Warehouse	Integer	63	10
Received Date	Date	73	8
Quantity	Integer	81	8

RMS Closed Orders Data

Table 9-24 File Name: closed_order.txt

Field Name	Type	Start	Width	Source/Comments
Order Number	Integer	1	10	RMS
Order Type	String	11	1

Off-Sale Effective Date

Table 9-25 File Name: dm0_ofseffdt_.txt

Field Name	Type	Start	Width	Source/Comments
Store	String	1	20	RMS
RMS SKU	String	21	20
Order Multiple	String	41	4
Off-Sale effective Date	Date	45	8

On-Sale Effective Date

Table 9-26 File Name: dm0_onseffdt_.txt type

Field Name	Type	Start	Width	Source/Comments
Store	String	1	20	RMS
RMS SKU	String	21	20
Order Multiple	String	41	4
On-Sale effective Date	Date	45	8

Future Delivery Order

Table 9-27 File Name: rmse_aip_future_delivery_order.schema.txt

Field Name	Type	Start	Width	Comments
TRANSACTION_NUM	Integer	1	12	RMS
DAY	String	13	9
SUPPLIER	Integer	15	20
LOC	Integer	35	20
ITEM	String	56	20
ORDER_MULTIPLE	String	76	6
PO_QTY	String	82	8
LOC_TYPE	String	90	1

Future Delivery Transfer

Table 9-28 File Name: rmse_aip_future_delivery_tsf.schema.txt

Field Name	Type	Start	Width	Comments
TRANSACTION_NUM	Integer	1	12	RMS
DAY	String	13	9
SUPPLIER	Integer	15	20
LOC	Integer	35	20
ITEM	String	56	20
ORDER_MULTIPLE	String	76	6
TSF_QTY	String	82	8
IN_TRANSIT_TSF_QTY	String	90	8
ON_ORDER_TSF_QTY	String	98	8
LOC_TYPE	String	106	1
TSF_TYPE	String	107	6

Future Delivery Allocation

Table 9-29 File Name: rmse_aip_future_delivery_alloc.schema.txt

Field Name	Type	Start	Width	Comments
TRANSACTION_NUM	Integer	1	12	RMS
DAY	String	13	9
SUPPLIER	Integer	15	20
LOC	Integer	35	20
LOC_TYPE	String	55	1
ITEM	String	56	20
ORDER_MULTIPLE	String	76	6
IN_TRANSIT_ALLOC_QTY	String	82	8
ON_ORDER_ALLOC_QTY	String	90	8

File Format Including Mapping to AIP-RPAS Measure Format

Corporate Discontinuation Date Data

Table 9-30 File Name: dmx_dscdt_.txt

RMS Field	Start	Width	AIP Field	Start	Width
RMS SKU	1	20	Commodity-Pack Size	1	20
Order Multiple	21	4
Corp Disc. date	25	8	Corp. Disc. Date	21	8

Value-Added Association

Table 9-31 File Name: dmx_vadprdasc.txt

RMS Field	Start	Width	AIP Field	Start	Width
RMS SKU (child)	1	20	SKU (child)		20
Order Multiple	21	4
RMS SKU (parent)	25	20	SKU (parent)	21	24
Order Multiple	45	4

Commodity Supplier Links

Table 9-32 File Name: dmx_prdspllks.txt

RMS Field	Start	Width	AIP Field	Start	Width
Supplier	1	20	Supplier	1	20
RMS SKU	21	20	Commodity-Pack Size	21	20
Order Multiple	41	4
SKU Supplier Links	45	1	Commodity-Supplier Links	41	1

Banded Item Association

Table 9-33 File Name: dmx_bndprdasc.txt

RMS Field	Start	Width	AIP Field	Start	Width
RMS SKU (child)	1	20	SKU (child)	1	20
Order Multiple	21	4
RMS SKU (parent)	25	20	SKU (parent)	21	24
Order Multiple	45	4

Direct Suppliers

Table 9-34 File Name: dmx_dirspl.txt

RMS Field	Start	Width	AIP Field	Start	Width
Supplier	1	20	Supplier	1	20
Direct Supplier	21	1	Direct Supplier	21	1

Store Current Inventory Data

Table 9-35 File Name: sr0_curinv_[1..n].txt

RMS Field	Start	Width	AIP Field	Start	Width
Store	1	20	Store	1	20
RMS SKU	21	20		21	20
Store current inventory	41	8	Store Current Inventory	41	8

Store In-transit Data

Table 9-36 File Name: sr0_it_.txt

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
Store	10	20	Store	10	20
RMS SKU	30	20	SKU	30	20
Order Multiple	50	4
Store In-transits	54	8	Store Intransits	50	8

Store On-orders Data

Table 9-37 File Name: sr0_oo_.txt

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
Store	10	20	Store	10	20
RMS SKU	30	20	SKU	30	20
Order Multiple	50	4
Store Orders	54	8	Store Orders	50	8

Store Product Life Data

Table 9-38 File Name: sr0_prdlfe.txt

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
RMS SKU	10	20	SKU	10	20
Order Multiple	30	4
Store Product Life	34	8	Store Product Life	30	8

Current Warehouse Inventory Data

Table 9-39 File Name: wr1_curinv.txt

RMS Field	Start	Width	AIP Field	Start	Width
Warehouse	1	20	Warehouse	1	20
RMS SKU	21	20	Commodity-Pack Size	21	20
Order Multiple	41	4
Current Warehouse Inventory	45	8	Current Warehouse Inventory	41	8

On-orders Data

Table 9-40 File Name: wr1_oo_.txt

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
Supplier	10	20	Supplier	10	20
Warehouse	30	20	Warehouse	30	20
RMS SKU	50	20	Commodity-Pack Size	50	20
Order Multiple	70	4
On-orders	74	8	On-orders	70	8

In-transit Data

Table 9-41 File Name: wr1_it_.txt

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
Supplier	10	20	Supplier	10	20
Warehouse	30	20	Warehouse	30	20
RMS SKU	50	20	Commodity-Pack Size	50	20
Order Multiple	70	4
In-transit	74	8	In-transit	70	8

Allocations in the Well Data

Table 9-42 File Name: wr1_aiw.txt

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
Warehouse	10	20	Warehouse	10	20
RMS SKU	30	20	Commodity-Pack Size	30	20
Order Multiple	50	4
Allocations in the Well	54	8	Allocations in the Well	50	8

Transfers in the Well Data

Table 9-43 File Name: wr1_tiw.txt

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
Warehouse	10	20	Warehouse	10	20
RMS SKU	30	20	Commodity-Pack Size	30	20
Order Multiple	50	4
Transfers in the Well	54	8	Transfers in the Well	50	8

Daily Sales Data

Table 9-44 File Name: sr0_dayslsld

RMS Field	Start	Width	AIP Field	Start	Width
Day	1	9	Day	1	9
Store	10	20	Store	10	20
RMS SKU	30	20	SKU	30	20
Daily Sales	50	8	Daily Sales	50	8

On-Sale Effective Date

Table 9-45 File Name: dm0_onseffdt_.txt

RMS Field	Start	Width	AIP Field	Start	Width
Store	1	20	Store	1	20
RMS SKU	21	20	SKU	21	20
Order Multiple	41	4
On-Sale Effective Date	45	8	On-Sale Effective Date	41	8

Off-Sale Effective Date

Table 9-46 File Name: dm0_ofseffdt_.txt

RMS Field	Start	Width	AIP Field	Start	Width
Store	1	20	Store	1	20
RMS SKU	21	20	SKU	21	20
Order Multiple	41	4
Off-Sale Effective Date	45	8	On-Sale Effective Date	41	8

Simple Pack Indicator

Table 9-47 File Name: ippckindi.txt

Field Name	Type	Start	Width	Comments
ITEM	String	1	20	RMS
ORDER_MULTIPLE	Integer	21	4
SIMPLE_PACK_IND	String	25	1

RMS RETL Extract and RMS-AIP Transformation Overview

AIP requires that the following text files must be processed from an external merchandising system:

• Closed POs

• Item Sale

• Item Supplier

• Location Mapping

• Received Qty

• Store Current Inv

• Store Product Life

• Substitute Items

• Supplier

• Warehouse Current Inv

• Warehouse

• Item

• Calendar

• Daily Sales

The Oracle Retail Merchandising Batch Schedule, and Oracle Retail Merchandising System Operations Guide, Volume 1 - Batch Overviews and Designs, detail the RMS RETL Extract scripts are used to extract the data from various tables in RMS. These extracts are processed by the RMS-AIP Transformation scripts to generate the data.

Mapping Overview

Some of the data RMS RETL Extracts generate require transformation by an RMS-AIP Transform Script. The RMS RETL Extracts and the RMS-AIP Transform Scripts that transform them are listed in Table 9-48. Some of these RMS RETL Extracts are input to multiple transform scripts to create different AIP input files. All of the transformations are for data files that are loaded into AIP-RPAS.

Note: The RMS-AIP Transform Scripts and RMS RETL Extracts listed in Table 9-48 correspond to the names of the files for RMS 13.0/13.1 integration. These names will differ for other versions of RMS. Refer to the Oracle Retail Advanced Inventory Planning Operations Guide, chapter on ”AIP Interfaces and Transformation Scripts,” for details.

Table 9-48 RMS 13.0/13.1 RETL Extracts

AIP-RPAS Required File	RMS-AIP Transform Script	RMS RETL Extracts
clnd.csv.dat	aipt_clnd.ksh	date_format_preference.txt last_day_of_week.txt rmse_rpas_clndmstr.dat
dmx_vadprdasc.txt	aipt_sub_items_rms13.ksh	rmse_aip_item_master.dat rmse_aip_item_supp_country.dat rmse_aip_substitute_items.dat
dmx_dscdt_.txtitem.txt	aipt_item_rms13.ksh	dmx_bndprdasc.txt rmse_aip_item_master.dat rmse_aip_item_retail.dat rmse_aip_item_supp_country.dat rmse_aip_merchhier.dat rmse_aip_purged_item.dat
loc.txt	aipt_orghier_rms13.ksh	rmse_aip_orghier.datrmse_aip_store.dat
sr0_dayslsld.txt	aipt_sr0_dayslsld_rms13.ksh	rmse_rpas_daily_sales.dat
sr0_it_.txt sr0_oo_.txt wr1_aiw.txt wr1_it_.txt wr1_oo_.txt wr1_tiw.txt	aipt_future_delivery_rms13.ksh	rmse_aip_alloc_in_well.dat rmse_aip_future_delivery_alloc.dat rmse_aip_future_delivery_order.dat rmse_aip_future_delivery_tsf.dat rmse_aip_store.dat rmse_aip_tsf_in_well.dat rmse_aip_wh.dat rmse_aip_wh.txt
sr0_prdlfe.txt	aipt_str_prd_life_rms13.ksh	rmse_aip_item_loc_traits.dat rmse_aip_item_master.dat rmse_aip_store.dat rmse_aip_item_supp_country.dat
whse.txt	aipt_rename.ksh	rmse_aip_wh.txt
wh_type.txt	aipt_rename.ksh	rmse_aip_wh_type.txt

RMS-AIP Transform Scripts

The RMS-AIP Transform Scripts reside in $RPAS_HOME/bin directory. In addition to the required RMS RETL Extract files for input, the RMS-AIP Transform scripts depend on two sets of file format schemas. The input schemas match the RMS RETL Extracts and are bundled with the RMS installation. The outputs schemas match the AIP-RPAS Required Files and are bundled with the AIP installation.

Some of the data are extracted from RMS in the format required by AIP. These do not require transformation by the RMS-AIP Transformation scripts.

• closed_order.txt

• dmx_dirspl.txt

• dmx_prdspllks.txt

• received_qty.txt

• splr.txt

• sr0_curinv_[1..n].txt

• wr1_curinv.txt

Some of the data extracted by the RMS RETL Extract Scripts are not used by AIP. These extracts are:

• rmse_aip_item_supp_country_reject_ord_mult.txt

• rmse_aip_suppliers.dat

Note: The on sale/off sale files, dm0_onseffdt_.txt and dm0_ofseffdt_.txt, are no longer loaded from external systems. Instead, they are loaded by RMS. These files are not present in external directory, but are copied to INTERFACE_RMS_DIR/input by the aipt_move.sh script.

Technical Details of Load Process

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