Oracle® Retail Merchandising and WMS Cloud Implementation Guide Release 19.3.000 F44101-03 |
|
Previous |
Next |
The tables below shows a summary of how certain inventory history codes from WMS Cloud are mapped to Merchandising. In some cases, activity codes are only conditionally updating Merchandising, based on various factors in processing in WMS Cloud.
Note: For all mappings below, in cases where more than one purchase order number is present in an activity code record (comma delimited list) from WMS and it is to be used in processing in the integration with Merchandising, the first purchase order number listed in the record will be used. |
Table C-1 Receipts (PO and Stock Order)
WMS Cloud | Merchandising | Comments | ||
---|---|---|---|---|
Lock Code | Qty Used | Update SOH? | Update Unavail? | |
Activity Code 1 - Container Received |
||||
No |
Adj Qty |
Yes |
No |
Receipt into available inventory |
Current/Previous ERP Buckets |
Adj Qty |
Yes |
Yes |
Receipt into unavailable inventory |
Activity Code 4 - Inventory Adjusted pre-verification |
||||
Current/Previous ERP Buckets |
Adj Qty |
Yes |
Yes |
If the reason code is RUA and there is a PO number in the transaction, this will be mapped as a receiver unit adjustment. Otherwise, it will be mapped as an inventory adjustment. |
Table C-2 Stock Order Status
WMS Cloud | Merchandising | Comments | ||
---|---|---|---|---|
Lock Code | Qty Used | Update SOH? | Update Unavail? | |
Activity Code 10 - Container Detail Packed |
||||
Orig Qty |
No |
No |
Increases distro quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, no update to Merchandising, only Order Broker (or 3rd party OMS). |
|
Activity Code 11 - Container Packed |
||||
Orig Qty |
No |
No |
Increases distro quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, no update to Merchandising, only Order Broker (or 3rd party OMS). |
|
Activity Code 12 - Order Detail Shorted |
||||
Adj Qty |
No |
No |
Increases cancel quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, no update to Merchandising, only Order Broker (or OMS). Note: if the activity code has a ref value 2 = 91, this is ignored by the integration; this is used for internal WMS processing only. |
|
Activity Code 27 - Order Cancellation |
||||
Adj Qty |
No |
No |
Increases cancel quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, no update to Merchandising, only Order Broker (or OMS). Note: if the activity code has a ref value 2 = 91, this is ignored by the integration; this is used for internal WMS processing only. |
|
Activity Code 31 - OB Container Modified |
||||
Adj Qty |
No |
No |
Decreases distro quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, Order Broker will move the order line back to Accepted status based on this status update. |
|
Activity Code 32 - OB Container Cancelled |
||||
Adj Qty |
No |
No |
Decreases distro quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, Order Broker will move the order line back to Accepted status based on this status update. |
|
Activity Code 54 - Container Detail Picked |
||||
Orig Qty |
No |
No |
Increases distro quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, no update to Merchandising, only Order Broker (or OMS). |
|
Activity Code 85 - Order Detail Status Change |
||||
Adj Qty |
No |
No |
Increases selected quantity on transfer/allocation only. No impact to inventory in Merchandising. If a customer order, no update to Merchandising, only Order Broker (or 3rd party OMS). |
Table C-3 Inventory Adjustments
WMS Cloud | Merchandising | Comments | ||
---|---|---|---|---|
Lock Code | Qty Used | Update SOH? | Update Unavail? | |
Activity Code 2 - Container Consumed |
||||
Adj Qty |
Yes |
|||
Activity Code 4 - Inventory Adjusted pre-verification |
||||
Current/Previous ERP Buckets |
Adj Qty |
Yes |
Yes |
If the reason code is RUA and there is a PO number in the transaction, this will be mapped as a receiver unit adjustment (see Receipts above). Otherwise, it will be mapped as an inventory adjustment. |
Activity Code 17 - Inventory Adjusted post-verification |
||||
Current/Previous ERP Buckets |
Adj Qty |
Yes |
||
Activity Code 19 - Inventory Adjustment Cycle Count Active |
||||
Adj Qty |
Yes |
|||
Activity Code 22 - Lock Container - Before ASN Verification |
||||
Current/Previous ERP Buckets |
Orig Qty |
Increase |
||
Activity Code 23 - Lock Container - After ASN Verification |
||||
Current/Previous ERP Buckets |
Orig Qty |
Increase |
||
Activity Code 24 - Unlock Container - Before ASN Verification |
||||
Current/Previous ERP Buckets |
Orig Qty |
Decrease |
||
Activity Code 25 - Unlock Container - After ASN Verification |
||||
Current/Previous ERP Buckets |
Orig Qty |
Decrease |
||
Activity Code 29 - Create Allocatable Container |
||||
Adj Qty |
Increase |
Only processed if the Inventory History reason code is not RMA and the order number is null. |
||
Activity Code 30 - Create Unallocatable Container |
||||
Current/Previous ERP Buckets |
Adj Qty |
Increase |
Increase |
Only processed if the order number is null. |
Activity Code 49 - Lock Active |
||||
Current/Previous ERP Buckets |
Orig Qty |
Yes |
||
Activity Code 50 - Unlock Active |
||||
Current/Previous ERP Buckets |
Orig Qty |
Yes |
||
Activity Code 53 - Cycle Count - Reserve SKU Counted |
||||
Current/Previous ERP Buckets |
Adj Qty |
Yes |
||
Activity Code 65 - Lock OBLPN |
||||
Current/Previous ERP Buckets |
Orig Qty |
Yes |