Oracle® Retail Merchandising and WMS Cloud Implementation Guide Release 22.1.201.0 F54717-01 |
|
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.
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 |
Yes |
No |
Receipt into available inventory |
Current/Previous ERP Buckets |
Adj |
Yes |
Yes |
Receipt into unavailable inventory |
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 |
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 |
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 |
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 |
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 29 - Create Allocatable Container |
||||
Adj Qty |
No |
No |
When this type of activity code is recorded and includes the order number in the record, it will be used to decrease the distro quantity on a transfer/allocation only in Merchandising; there is no impact to reserved inventory. If a customer order, Order Broker will move the order line back to Accepted status based on this status update. If no order number is in the record, it will be mapped as an inventory adjustment (see below). |
|
Activity Code 54 - Container Detail Picked |
||||
Orig |
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). |
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 |
|
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. If there is a value in the order number, then this will be mapped to the Stock Order Status message (see above). |
||
Activity Code 30 - Create Unallocatable Container |
||||
Current/Previous ERP Buckets |
Adj Qty |
Increase |
Increase |
|
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 |