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 CODEORACLE FORM NAME
WMSDPTZNDefine Department-Zone Relationships
WMSRLWUFView WMS Rule Where Used
WMSRULEFDefine WMS Rules
WMSSTASFAssign WMS Strategies to Business Objects
WMSSTGDFDefine WMS Strategies
WMSSTSOFDefine WMS Strategy Search Order
WMSSTWUFView WMS Strategy Where Used
WMSDKASNDock Assignment
WMSCTLBDWMS Control Board
WMSSTGLNDock Door to Staging Lane Assignment
WMSLABELDefine Label Formats
WMSBFLTPAssign Label Types to Business Flows
WMS_PUTAWAYMobile Put Away
WMS_TASKSMobile WMS Task Dispatching
WMS_PACKUNPACKMobile WMS Pack/Unpack
WMS_BULKPACKMobile WMS Bulk Pack
WMSLABHSLabel History
WMSDEVHSDevice Requests History
WMSRLSIMWMS Rule Simulation
WMSDEVDFDefine Devices
WMSDEVBEAssign Devices
WMSPRIPSPrinter IP Address Setup
WMSPACWBPacking Workbench
WMSOPDFNDefine Operation Plan
WMSZONESDefine Zones
WMSUISTPPick Load Page Setup
WMSTSKFLTask Filter Setup
WMSXDCRTDefine WMS Crossdock Criteria
WMSCSLBLDefine Custom SQL Fields
WMSTTATTUser Task Type Attributes
WMSWVPWCCreate Wave
WMSWVPDBWave Dashboard
WMSWVPWBWave Workbench
WMSWVPPWPlan Wave Setup
WMSWVPTPTask Release Setup
WMSRLTRCWMS Rule Execution Trace
WMS_LPN_MASS_MOVE_FORMMobile WMS LPN Mass Move Form
WMS_STAGING_MOVEMobile WMS Staging Move Form
WMS_CONS_INQUIRY_FORMMobile WMS Consolidation Inquiry Form
WMSRLWBFWMS Rules Workbench