| Oracle® Retail Advanced Inventory Planning Implementation Guide Release 14.1 E64951-02 |
|
 Previous |
 Next |
| Oracle® Retail Advanced Inventory Planning Implementation Guide Release 14.1 E64951-02 |
|
Previous |
Next |
In addition to the RIB, as explained in Chapter 15, "AIP to RMS Interfaces and Data Mapping", AIP provides a second method of communicating Purchase Order and Transfer information to an order procurement system. It is text file-based and can be used in place of the RIB for communicating Purchase Orders and Transfers created and released in the overnight batch.
|
Note: This process does not currently support any action taken by the user in the Order Management application. |
This is the recommended method of integration when large volumes of Purchase Orders and Transfers are expected to be run each night.
The following sections detail the text files necessary for the process of Purchase Orders and Transfers to the RIB:
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Purchase Orders | New Purchase Orders |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ord_exp_po_out.sh | ord_exp_po.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | AIP | Target Object Type | Delimited Text File |
| Source Object Type | Delimited Text File | Target Object Name | purchase_order_.dat.1 |
| Source Object Name | PO_MFQUEUE, STORE_ORDER, NON_CONTENTS_ORDER, SUPPLIER, STOCKING_POINT, STORE, COMMODITY, COMMODITY_MAPPING | Target Object Database | not applicable |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
| Field Delimiter | | |
||
| Final Delimiter | 0x0A | ||
Field Level Mapping - Source
| # |
Source Fields | Source Field Description | Field Start Position | Maximum Field Length |
|---|---|---|---|---|
| 1 | PO_MFQUEUE.order_number | Order Number | 1 | 10 |
| 2 | SUPPLIER.supplier_code | Unique Supplier Identifier | not applicable | 20 |
| 3 | MIN(STORE_ORDER. DELIVERY_DATE), MIN(NON_CONTENTS _ORDER.DELIVERY_DATE) | Delivery Date | not applicable | not applicable |
| 4 | MAX(STORE_ORDER.
DELIVERY_DATE) MAX(NON_CONTENTS _ORDER.DELIVERY_DATE) |
Delivery Date | not applicable | not applicable |
| 5 | PO_MFQUEUE.STATUS | Order Status | not applicable | 1 |
| 6 | not applicable | S for Store destination, or W for Warehouse destination | not applicable | 1 |
| 7 | STORE.store_code, STOCKING_POINT.stocking _point_number | Unique Identifier for Store or Warehouse destination | not applicable | 20 |
| 8 | COMMODITY_MAPPING.rms_sku_number | Unique SKU identifier | not applicable | 25 |
| 9 | COMMODITY_MAPPING.pack_size, STORE_ORDER.case_volume, NON_CONTENTS_ORDER.quantity, | Case Quantity | not applicable | not applicable |
| 10 | COMMODITY_MAPPING.rms_ order_multiple | Pack Size | not applicable | not applicable |
Field Level Mapping - Target
| # |
Target Data Field Name | Target Field Description | Field Data Type | Condition/Format |
|---|---|---|---|---|
| 1 | ORDER_NO | Unique Order Identifier | String | 10000| |
| 2 | NOT_BEFORE_DATE | Earliest Expected Delivery Date: YYYYMMDD | Date | 20080128| |
| 3 | NOT_AFTER_DATE | Latest Expected Delivery Date: YYYYMMDD | Date | 20080128| |
| 4 | STATUS | Order Status | String | A| |
| 5 | LOCATION_TYPE | Destination Location Type-S for Store, W for Warehouse | String | S| or W| |
| 6 | LOCATION | Unique Identifier for the Destination with any AIP prefixes removed | String | 2000| |
| 7 | ITEM | Unique Identifier of the Product to be Ordered | String | 4000000| |
| 8 | QTY_ORDERED | Order Quantity in Eaches | Decimal | 30| |
| 9 | SUPP_PACK_SIZE | Pack Size | Integer | 6| |
Filtering Conditions
All prefixes added by AIP are removed.
Example of purchase_order.dat.1 extract file format:
10000|20080128|20080128|A|S|2000|4000000|30|60x0A
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Transfers | New Transfers |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ord_exp_tsf_out.sh | ord_exp_tsf.xml | Daily |
Data Source and Target Details
| Data Source Details | Target Data Details | ||
|---|---|---|---|
| Data Origin System | AIP | Target Object Type | Delimited Text File |
| Source Object Type | Delimited Text File | Target Object Name | transfer_order_.dat.1 |
| Source Object Name | PO_MFQUEUE, STORE_ORDER, NON_CONTENTS_ORDER, STOCKING_POINT, STORE, COMMODITY, COMMODITY_MAPPING | Target Object Database | not applicable |
| Required/Optional | Optional | Target Object Load Intersection | not applicable |
| Field Delimiter | | |
Field Delimiter | | |
| Final Delimiter | 0x0A | Final Delimiter | 0x0A |
Field Level Mapping - Source
| # |
Source Fields | Source Field Description | Field Start Position | Maximum Field Length |
|---|---|---|---|---|
| 1 | TSF_MFQUEUE.tsf_number | Transfer Number | 1 | 10 |
| 2 | STOCKING_POINT.stocking_point _number | Unique source Warehouse Identifier | not applicable | 20 |
| 3 | not applicable | S for Store destination, or W for Warehouse destination | not applicable | 1 |
| 4 | STORE.store_code, STOCKING_POINT.stocking _point_number | Unique Identifier for Store or Warehouse destination | not applicable | 20 |
| 5 | MIN(STORE_ORDER. DELIVERY_DATE), MIN(NON_CONTENTS _ORDER.DELIVERY_DATE) | Delivery Date | not applicable | not applicable |
| 6 | not applicable | Routing Code not available in AIP | not applicable | 1 |
| 7 | not applicable | Freight Code not specified in AIP | not applicable | 1 |
| 8 | COMMODITY_MAPPING.rms_sku_number | Unique SKU identifier | not applicable | 25 |
| 9 | COMMODITY_MAPPING.pack_size, STORE_ORDER.case_volume, NON_CONTENTS_ORDER.quantity, | Case Quantity | not applicable | not applicable |
| 10 | COMMODITY_MAPPING.rms_order_multiple | Pack Size | not applicable | not applicable |
Field Level Mapping - Target
| # |
Target Data Field Name | Target Field Description | Field Data Type | Condition/Format |
|---|---|---|---|---|
| 1 | TSF_NO | Unique Transfer Identifier | String | 10000| |
| 2 | FROM_LOC | Unique Warehouse identifier with any AIP prefixes removed | Integer | 1000| |
| 3 | TO_LOC_TYPE | Destination Location Type-S for Store, W for Warehouse | String | S| or W| |
| 4 | TO_LOC | Unique identifier for the Store or Warehouse destination with any AIP prefixes removed | String | 2000| |
| 5 | DELIVERY_DATE | Expected Delivery Date: YYYYMMDD | Date | 20080128| |
| 6 | ROUTING_CODE | An optional Routing Code | String | | |
| 7 | FREIGHT_CODE | An optional Freight Code | String | | |
| 8 | ITEM | Unique Identifier of the Product to be Ordered | String | 4000000| |
| 9 | TSF_QTY | Transfer Quantity in Eaches | Decimal | 30| |
| 10 | SUPP_PACK_SIZE | Pack Size | Integer | 6| |
Filtering Conditions
All prefixes added by AIP are removed.
Example of transfer_order.dat.1 extract file format:
10000|1000|S|2000|20080128|||4000000|30|60x0A
