Go to primary content
Oracle® Retail Merchandising and WMS Cloud Implementation Guide
Release 22.1.201.0
F54717-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

C Appendix - Activity Codes

Activity Code Mappings

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