You are browsing the archive for WMS.

Oracle Warehouse Management System Overview

Oracle Warehouse Management System (WMS) is advanced inventory module with lot of unique features that improves productivity of distribution centers, manufacturing or inventory handling facilities. Oracle WMS supports manual data entry, bar code readers scanning for data entry as well as Radio Frequency Identification (RFID) scanning. WMS can be enabled at Inventory organization level.

Key business processes supported by Oracle WMS:

  • Inbound Logistics (Receiving, supplier returns, corrections)
  • Stocking and internal inventory movements
  • WIP Job assembly completion, component issues
  • Outbound Logistics (pickimg, packing, shipping)
  • Reverse logistics (customer returns)

License Plate Numbers (LPN): LPN is an object carries the location where it is residing and items that are holding. LPN need not be a physical object, it could be logical grouping. LPN simpley a group of items represented systematically. The major advantage of LPN is less number of transactions. Entire LPN can be transacted at once instead of by each line that LPN holds.

Material Status: This is one of the beautiful features of WMS, you can assign status to an item, lot or serial number. Each status is defined with a list of permissble transactions. Eg. if you have status called ‘No Sale’ and set the rules such that shipping is not allowed but all other internal inventory movements are allowed. Material status can enforce this kind of business rules.

Label printing: WMS partially supports this fucntionality. You can define label formats and fields (data) needed, you can associate this with WMS rules to print the label automatically. WMS can generate xml output, but you need a 3rd party label printing/formatting tool to actually print.

Cost groups: This is another major functionality offered by WMS module. In standard Inventory module Inventory valuation accounts are derived by subinventory setups. In WMS based on cost group rules you can have different valuations independent of subinventories.

Putaway Rules: When a matrial is received you need to receive into stock. In a major distribution center it is often complex to know where to store the material. WMS offers putaway rules that can be setup based son business criteria. Eg. If all hazarad material categy must be received into hazardous area then putaway rules can be setup.

WMS Rules engine: WMS rules engine enforces the rules defined for putaway, cost group or label printing. You can simulate the results based on set of rules defined.

Oracle Distributed Warehouse Management System Overview

Oracle Distributed WMS is a new module released in R12 that can support the WMS features in a stand alone system. This architecture is similar to Oracle Advanced Supply Chain Planning system where APS can be implemented as a separate instance. Distributed WMS can also be implemented as separate instance that will collect the data from ERP system and feed the inventory back to ERP system. Distributed WMS can be integrated with non-Oracle ERP systems.

Distributed WMS will be of tremendous help for a customers who need 24 x 7 availability of WMS systems. WMS can still process transactions while ERP system is down. Apart from this it also comes with Light weight Purchasing & Light weight Order Management that supports basic features of OM & PO modules without implementing them fully.

Distributed WMS inbound data collections from ERP:

  • Advanced Shipment Notices (ASN)
  • Purchase Orders
  • Items
  • Customers
  • Suppliers
  • Shipment Requests

Distributed WMS outbound data collections to ERP:

  • PO Receipts
  • Onhand quantities
  • Inventory Adjustments
  • Ship Confirmation

Warehouse Management Tables

Oracle Warehouse Management System (WMS) Tables:

  • WMS_ALLOCATIONS_GTMP
  • WMS_API_HOOKED_ENTITIES
  • WMS_API_HOOK_CALLS
  • WMS_API_HOOK_SIGNATURES
  • WMS_ASN_DETAILS
  • WMS_BFLOW_LABEL_TYPE
  • WMS_BUS_EVENT_DEVICES
  • WMS_CAROUSEL_CONFIGURATION
  • WMS_CAROUSEL_DIRECTIVE_QUEUE
  • WMS_CROSSDOCK_CRITERIA_B
  • WMS_CROSSDOCK_CRITERIA_TL
  • WMS_DB_OBJECTS
  • WMS_DB_OBJECTS_PARENTS
  • WMS_DB_OBJECT_JOINS
  • WMS_DB_OBJECT_REFERENCES
  • WMS_DB_OBJ_REF_MEMBERS
  • WMS_DEPARTMENT_SUBINVENTORIES
  • WMS_DEVICES_B
  • WMS_DEVICES_TL
  • WMS_DEVICE_ASSIGNMENT_TEMP
  • WMS_DEVICE_REQUESTS
  • WMS_DEVICE_REQUESTS_HIST
  • WMS_DIRECT_SHIP_TEMP
  • WMS_DISPATCHED_TASKS
  • WMS_DISPATCHED_TASKS_ARCH
  • WMS_DISPATCHED_TASKS_HISTORY
  • WMS_DISPATCH_TASKS_GTMP
  • WMS_DOCK_APPOINTMENTS_B
  • WMS_DOCK_APPOINTMENTS_TL
  • WMS_DS_CT_WT_GTEMP
  • WMS_ELS_EXP_RESOURCE
  • WMS_ELS_EXP_RESOURCE_GTEMP
  • WMS_ELS_GROUPED_TASKS_B
  • WMS_ELS_GROUPED_TASKS_GTMP
  • WMS_ELS_GROUPED_TASKS_TL
  • WMS_ELS_INDIVIDUAL_TASKS_B
  • WMS_ELS_INDIVIDUAL_TASKS_TL
  • WMS_ELS_NON_TRACKED_USERS
  • WMS_ELS_PARAMETERS
  • WMS_ELS_RATINGS_SETUP
  • WMS_ELS_RESOURCE_SETUP
  • WMS_ELS_TRX_SRC
  • WMS_EPC
  • WMS_EXCEPTIONS
  • WMS_EXCEPTIONS_TEMP
  • WMS_FREIGHT_COST_TEMP
  • WMS_LABEL_FIELDS_B
  • WMS_LABEL_FIELDS_TL
  • WMS_LABEL_FIELD_VARIABLES
  • WMS_LABEL_FORMATS
  • WMS_LABEL_REQUESTS
  • WMS_LABEL_REQUESTS_HIST
  • WMS_LABEL_SET_FORMATS
  • WMS_LICENSE_PLATE_NUMBERS
  • WMS_LOCATIONS_LOCATORS
  • WMS_LPN_CONTENTS
  • WMS_LPN_CONTENTS_INTERFACE
  • WMS_LPN_HISTORIES
  • WMS_LPN_INTERFACE
  • WMS_LPN_PROCESS_TEMP
  • WMS_MATERIAL_TXN_TRACE
  • WMS_MSG_COMPONENTS
  • WMS_MSG_TEMPLATES
  • WMS_OBJECTS_B
  • WMS_OBJECTS_TL
  • WMS_OP_DESTINATION_SEL_APIS
  • WMS_OP_OPERATION_INSTANCES
  • WMS_OP_OPERTN_INSTANCES_ARCH
  • WMS_OP_OPERTN_INSTANCES_HIST
  • WMS_OP_PLANS_B
  • WMS_OP_PLANS_TL
  • WMS_OP_PLAN_DETAILS
  • WMS_OP_PLAN_INSTANCES
  • WMS_OP_PLAN_INSTANCES_ARCH
  • WMS_OP_PLAN_INSTANCES_HIST
  • WMS_ORDERED_TASKS
  • WMS_ORG_HIERARCHY_OBJS
  • WMS_PACKAGING_HIST
  • WMS_PACKING_MATERIAL_GTEMP
  • WMS_PAGE_FIELDS_B
  • WMS_PAGE_FIELDS_TL
  • WMS_PAGE_FIELD_VALUES
  • WMS_PAGE_TEMPLATES_B
  • WMS_PAGE_TEMPLATES_TL
  • WMS_PAGE_TEMPLATE_FIELDS
  • WMS_PARAMETERS_B
  • WMS_PARAMETERS_TL
  • WMS_PRINTER_IP_DEF
  • WMS_PUTAWAY_GROUP_TASKS_GTMP
  • WMS_RESTRICTIONS
  • WMS_RULES_B
  • WMS_RULES_TL
  • WMS_RULE_CONSISTENCIES
  • WMS_RULE_LIST_PACKAGE
  • WMS_RULE_TRACE_HEADERS
  • WMS_RULE_TRACE_LINES
  • WMS_SAVED_QUERIES
  • WMS_SELECTION_CRITERIA_TXN
  • WMS_SERIAL_NUMBERS_TRACE
  • WMS_SHIPPING_TRANSACTION_TEMP
  • WMS_SKIP_TASK_EXCEPTIONS
  • WMS_SORT_CRITERIA
  • WMS_STAGINGLANES_ASSIGNMENTS
  • WMS_STRATEGIES_B
  • WMS_STRATEGIES_TL
  • WMS_STRATEGY_ASSIGNMENTS
  • WMS_STRATEGY_MEMBERS
  • WMS_TASKS_TEMP
  • WMS_TASK_FILTER_B
  • WMS_TASK_FILTER_DTL
  • WMS_TASK_FILTER_TL
  • WMS_TRANSACTIONS_TEMP
  • WMS_TRANSACTION_LOTS_TRACE
  • WMS_TXN_CONTEXT_TEMP
  • WMS_WAVEPLAN_TASKS_TEMP
  • WMS_WSH_WDD_GTEMP
  • WMS_XDOCK_PEGGING_GTMP
  • WMS_XDOCK_SOURCE_ASSIGNMENTS
  • WMS_ZONES_B
  • WMS_ZONES_TL
  • WMS_ZONE_LOCATORS