You are browsing the archive for Oracle Warehouse Management.

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

Warehouse Management Profile Options

Oracle Warehouse Management Profile Options

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
WMS_EPC_SASN_COL WMS: EPC ASN Serial import column
WMS_EPC_ENCODING WMS: EPC Generation Encoding
WMS_IGNORE_EQUIPMENT WMS: Ignore Equipment
WMS_LABEL_FOR_CYCLE_COUNT WMS: Label Printing for Cycle Count
WMS_SYNCHRONOUS_TCPIP_LABEL_REQUEST_DELAY WMS: Synchronous TCP/IP label request delay
WMS_ALLOW_MIXED_STATUS WMS: Allow Mixed Statuses in an LPN
WMS_DEPLOYMENT_MODE WMS: Deployment Mode
WMS_LABEL_FILE_PREFIX WMS: Label file prefix
WMS_EXPRESS_RETURN WMS: Express Returns
WMS_PUTAWAY_ONLINE WMS: Online Putaway
WMS_SUGGESTION_STALE_PERIOD WMS: Suggestion Stale Period
WMS_PRINT_MODE WMS: Label Print Mode
WMS_SUBINV_LOCATOR_DELIMITER WMS: Subinventory/Locator Delimiter
WMS_BARCODE_FONT_NAME WMS: Barcode Font Name
WMS_BARCODE_TYPE WMS: Barcode Type
WMS_SEQUENCE_PICKS_ACROSS_WAVES WMS:Sequence Picks Across Waves
WMS_CB_DEFAULT_SOURCE_TYPE WMS: Default Source Type for Control Board
WMS_ASSIGN_TASK_TYPE WMS: Assign Task Types
WMS_RFID_USER WMS: RFID User
WMS_LABEL_OUTPUT_DIRECTORY WMS: Label output directory
WMS_ITEM_REVISION_DELIMITER WMS: Item/Revision Delimiter
WMS_PO_LINE_DELIMITER WMS: PO Number/Line Delimiter
WMS_EPC_LASN_COL WMS: EPC ASN LPN import column