| Oracle® Retail Merchandising and WMS Cloud Implementation Guide Release 19.0 F25718-02 |
|
 Previous |
 Next |
| Oracle® Retail Merchandising and WMS Cloud Implementation Guide Release 19.0 F25718-02 |
|
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-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 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 |
Only processed if the Inventory History reason code in WMS is not null, and if the module name is rf.inbound.cwrfdirectconsumelpn. |
||
|
Activity Code 4 - Inventory Adjusted pre-verification |
||||
|
Adj Qty |
Yes |
If the Inventory History module name in WMS is IbContainerView and the reason code is not null, then the processing is as shown here. If the module name is rf.inbound.cwrfcreatelpn, see below. Otherwise, this code is not processed. |
||
|
Current/Previous ERP Buckets |
Adj Qty |
Yes |
If the Inventory History module name in WMS is rf.inbound.cwrfcreatelpn the processing is as shown here. The Previous/Current ERP Buckets are used as the From/To Dispositions in Merchandising. If the module name is IbContainerView, see above. Otherwise, this code is not processed. |
|
|
Activity Code 17 - Inventory Adjusted post-verification |
||||
|
Current/Previous ERP Buckets |
Adj Qty |
Yes |
Only processed if the Inventory History module name in WMS is rf.inbound.IbContainerView. The Previous/Current ERP Buckets are used as the From/To Dispositions in Merchandising. |
|
|
Activity Code 19 - Inventory Adjustment Cycle Count Active |
||||
|
Adj Qty |
Yes |
Only processed if the Inventory History reason code in WMS is not null, and if the module name is ActiveInventoryView, CCAdjustmentHdrView or rf.inbound.cwrfcyclecountlocn. |
||
|
Activity Code 22 - Lock Container - Before ASN Verification |
||||
|
Current/Previous ERP Buckets |
Orig Qty |
Increase |
Only processed if the Inventory History module name in WMS is rf.inbound.cwrfcyclecountlocn or CCAdjustmentHdrView. The Previous/Current ERP Buckets are used as the From/To Dispositions in Merchandising. |
|
|
Activity Code 23 - Lock Container - After ASN Verification |
||||
|
Current/Previous ERP Buckets |
Orig Qty |
Increase |
Only processed if the Inventory History module name in WMS is one of
The Previous/Current ERP Buckets are used as the From/To Dispositions in Merchandising. |
|
|
Activity Code 24 - Unlock Container - Before ASN Verification |
||||
|
Current/Previous ERP Buckets |
Orig Qty |
Decrease |
Only processed if the Inventory History module name in WMS is one of
The Previous/Current ERP Buckets are used as the From/To Dispositions in Merchandising. |
|
|
Activity Code 25 - Unlock Container - After ASN Verification |
||||
|
Current/Previous ERP Buckets |
Orig Qty |
Decrease |
Only processed if the Inventory History module name in WMS is one of
The Previous/Current ERP Buckets are used as the From/To Dispositions in Merchandising. |
|
|
Activity Code 29 - Create Allocatable Container |
||||
|
Adj Qty |
Increase |
Only processed if the Inventory History reason code in WMS is not RMA and not null, and if the module name is rf.inbound.cwrfcreatelpn. |
||
|
Activity Code 30 - Create Unallocatable Container |
||||
|
Yes |
Adj Qty |
Increase |
Increase |
Only processed if the Inventory History reason code in WMS is no RMA and not null, and if the module name is rf.inbound.cwrfcreatelpn. |
|
Activity Code 53 - Cycle Count - Reserve SKU Counted |
||||
|
Current/Previous ERP Buckets |
Adj Qty |
Yes |
No conditions for processing this type. The Previous/Current ERP Buckets are used as the From/To Dispositions in Merchandising. |
|
|
Activity Code 63 - Lock Update Pre-Verification LPN |
||||
|
Yes (Ref Value 1) |
Orig Qty |
Decrease |
Only processed if the Inventory History module name in WMS is one of
|
|
|
Activity Code 64 - Lock Update Post-Verification LPN |
||||
|
Yes (Ref Value 1) |
Orig Qty |
Decrease |
Only processed if the Inventory History module name in WMS is one of
|
|
