Item Warehouse

RWMS is responsible for communicating items that reside in a forward picking/forward case picking location to a third-party SKU profiling system for the purposes of warehouse optimization.

RWMS item information can be published in one of two ways. The first is through a Distribution Center (DC) Profiling support function provided within RWMS. The second is through a series of item related event triggers that result in the item data being sent. These event triggers include:

• Modification or Deletion of an optimized and published item/SKU (item has sku_optimized and sku_opt_published flags set to ‘Y’).
• Modification or Deletion of an optimized and published SKU’s supplier information.
• Modification or Deletion of an optimized and published SKU’s supplier country information.
• Modification or Deletion of an optimized and published SKU’s supplier country DIM information.
• Creation, Modification, or Deletion of an optimized and published SKU’s association to a forward picking/case picking location.
• First association of an optimized SKU to an appointment.
• First association of an optimized SKU to a allocation.

The information sent to the third-party system for add or modify requests includes: item header information, item supplier information, item supplier country information, and item supplier country DIM information. Deletes of item information will include only the DC Destination ID (from location) and the item id for the item being deleted.

Message Type	XSD
ItemWHCre	ItemWHDesc.xsd
ItemWHMod	ItemWHDesc.xsd
ItemWHDel	ItemWHRef.xsd

Disclaimer: This document is a general data mapping and reference guide for data coming in and out of Oracle Retail application systems via RIB messages; it is not meant to give detailed information about every possible data scenario.