| Oracle® Retail Advanced Inventory Planning Implementation Guide Release 15.0 E71753-02 |
|
 Previous |
 Next |
| Oracle® Retail Advanced Inventory Planning Implementation Guide Release 15.0 E71753-02 |
|
Previous |
Next |
In addition to the RIB, as explained in Chapter 16, "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
Data Element Details
| Data Type | Data Element Name | Data Description |
|---|---|---|
| Text File | Allocations | New Allocations |
Extracting Program Details
| Program Type | Program Name | Schema File | Program Frequency |
|---|---|---|---|
| RETL | ord_exp_alloc_out.sh | ord_exp_alloc.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 | allocation.dat.1 |
| Source Object Name | ALLOCATION, ALLOC_MFQUEUE, NON_CONTENTS_ORDER, STOCKING_POINT, STORE, COMMODITY_MAPPING, SYSTEM_PARAMETERS | 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 | ALLOC_MFQUEUE.allocation_number | Allocation Number | 1 | 12 |
| 2 | ALLOCATION.inbound_txn_no or NON_CONTENTS_ORDER.order_number | Order Number | not applicable | 12 |
| 3 | ALLOCATION.inbound_txn_type | Order Type | not applicable | 1 |
| 4 | COMMODITY_MAPPING.rms_sku_number | Unique SKU identifier | not applicable | 25 |
| 5 | STOCKING_POINT.stocking_point_number | Unique Warehouse identifier | not applicable | 10 |
| 6 | STORE.store_code or STOCKING_POINT.STOCKINT_POINT_NUMBER | Unique destination identifier | not applicable | 10 |
| 7 | 'W' or 'S' | Destination Location Type-S for Store, W for Warehouse | not applicable | 1 |
| 8 | DECODE(COMMODITY_MAPPING.rms_pack_quantity, 0, ALLOCATION.quantity*cm.pack_size, ALLOCATION.quantity) | Quantity Allocated | not applicable | not applicable |
| 9 | ALLOCATION.delivery_date | In Store Date | not applicable | not applicable |
Field Level Mapping - Target
| # |
Target Data Field Name | Target Field Description | Field Data Type | Condition/Format |
|---|---|---|---|---|
| 1 | ALLOC_NO | Unique Allocation Identifier | String | 10000| |
| 2 | ORDER_NO | Unique Order Identifier | String | 42321| |
| 3 | ORDER_TYPE | Unique Order type Identifier | String | A (allocation)|or N (non-contents)| |
| 4 | ITEM | Unique Identifier of the SKU to be allocated | String | 1100000| |
| 5 | FROM_LOC | Unique Warehouse identifier with any AIP prefixes removed | String | 1000| |
| 6 | TO_LOC | Unique identifier for the Store or Warehouse destination with any AIP prefixes removed | String | 2000| |
| 7 | TO_LOC_TYPE | Destination Location Type-S for Store, W for Warehouse | String | S| or W| |
| 8 | QTY_ALLOCATED | Quantity Allocated | Float | 28| |
| 9 | IN_STORE_DATE | In Store Date | Date | 20100428| |
Filtering Conditions
All prefixes added by AIP are removed.
Example of allocation.dat.1 extract file format:
10000|1000|W|2000|20100428|||1100000|28|0x0A
