You are browsing the archive for WMS.

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

Oracle WMS Forms

Oracle Warehouse Management Forms:

FORM SHORT CODE ORACLE FORM NAME
WMSDPTZN Define Department-Zone Relationships
WMSRLWUF View WMS Rule Where Used
WMSRULEF Define WMS Rules
WMSSTASF Assign WMS Strategies to Business Objects
WMSSTGDF Define WMS Strategies
WMSSTSOF Define WMS Strategy Search Order
WMSSTWUF View WMS Strategy Where Used
WMSDKASN Dock Assignment
WMSCTLBD WMS Control Board
WMSSTGLN Dock Door to Staging Lane Assignment
WMSLABEL Define Label Formats
WMSBFLTP Assign Label Types to Business Flows
WMS_PUTAWAY Mobile Put Away
WMS_TASKS Mobile WMS Task Dispatching
WMS_PACKUNPACK Mobile WMS Pack/Unpack
WMS_BULKPACK Mobile WMS Bulk Pack
WMSLABHS Label History
WMSDEVHS Device Requests History
WMSRLSIM WMS Rule Simulation
WMSDEVDF Define Devices
WMSDEVBE Assign Devices
WMSPRIPS Printer IP Address Setup
WMSPACWB Packing Workbench
WMSOPDFN Define Operation Plan
WMSZONES Define Zones
WMSUISTP Pick Load Page Setup
WMSTSKFL Task Filter Setup
WMSXDCRT Define WMS Crossdock Criteria
WMSCSLBL Define Custom SQL Fields
WMSTTATT User Task Type Attributes
WMSWVPWC Create Wave
WMSWVPDB Wave Dashboard
WMSWVPWB Wave Workbench
WMSWVPPW Plan Wave Setup
WMSWVPTP Task Release Setup
WMSRLTRC WMS Rule Execution Trace
WMS_LPN_MASS_MOVE_FORM Mobile WMS LPN Mass Move Form
WMS_STAGING_MOVE Mobile WMS Staging Move Form
WMS_CONS_INQUIRY_FORM Mobile WMS Consolidation Inquiry Form
WMSRLWBF WMS Rules Workbench