You are browsing the archive for Oracle Warehouse Management.

LPN Statuses

Transaction: LPN Statuses
Transaction form code:
Module: Oracle Shipping

Description:
LPN is an acronym for License Plate Number. LPN is a virtual entity of grouping together, often they could represent a physical box/container. Advantage of LPN is to do mass transactions. Once LPN is created any transaction performed on LPN automatically affects all the lines/good it holds thus avoid multiple transactions manually for each line.

LPN can have different statuses:

  • Staged/Pick Confirmed
  • Loaded to Dock
  • Loaded in Staging

LPN functionality is available only through Oracle Warehouse Management System (WMS) module.

Warehouse Management Concurrent Programs

Oracle Warehouse Management System Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
PURGE_WMS Purge WMS History Tables
WMSDEVRR Resubmit Device Requests
WMSASNI WMS ASN DISCREPANCY REPORT
WMSSTCON Consolidation Report
WMSPRPUT Pre-generate Putaway Suggestions
WMS_GENERATE_LPN Generate LPN
PREPACK Prepacking Container at WIP
WMSGRULE Generate all enabled WMS rules
WMSLCPUP Update Locator Capacity
WMSSCHS Scheduled Shipment Report for Direct Shipping
WMSSCHS1 Scheduled Shipment Report for Direct Shipping
WMSCPTYR Warehouse Space Utilization Report
PURGE_WMS1 Purge WMS History tables
WMSRCAPI Register Custom API’s
WMSGCAPI Generate Custom API System Packages
WMSBLKPR Create bulk pick tasks after pick release
WMSTARCM Archive WMS Tasks
WMSTARCW Archive WMS Tasks Worker
WMSTUARM Un-Archive WMS Tasks
WMSTUARW Un-Archive WMS Tasks Worker
WMS_LMS_STANDARDIZE Program to Standardize Non-Standardized Lines
WMS_LMS_COPY_ACTUALS Program to copy actual timings to expected timings
WMSCBTAC Warehouse Control Board – Manage Tasks
WMS_LMS_PURGE_TXNS Program to purge Labor Tracked Transactions
WMS_LMS_PURGE_SETUP_HISTORY Program to Purge Labor Setup History Records
WMS_LMS_LABOR_PRODUCTIVITY Program for processing the data for Labor Productivity Analysis
WMS_LMS_EXP_RES_REQ Program to process data for Expected Resource Requirement Analysis
WMS_LMS_CALC_ACTUALS Concurrent Program to calculate Actual Timings
WMSCDEXP Concurrent Program that finds crossdock window exception
WMSSTCON_XML Consolidation Report
WMSCPTYR_XML Warehouse Space Utilization Report (XML)
WMSSCHS1_XML Scheduled Shipment Report for Direct Shipping
WMSASNI_XML WMS ASN DISCREPANCY REPORT
WMSDKOTM Synchronize Dock Doors with Transportation Management
WMSALREMO Allocate Replenishment Move Order
WMSDYREPL Pull Replenishment
WMSPUREPL Push Replenishment
WMS_LAUNCH_TASK_RELEASE Launch Task Release
WMS_WP_PROGRESS Concurrent Program to track wave completion status
WMS_WP_EXCEPTIONS Wave Planning – Catch Exceptions
PLAN_WAVE_CP Wave Planning Plan Wave
RELEASE_BATCH_CP Wave Planning Release Wave
WMS_WAVE_PLANNING Wave Planning Initiate Process
WMSWPRBS Wave Planning: Rule Based Planning
WMSPALOC WMS post-allocation processing
WMSPALOC_SUB WMS post-allocation processing: sub-request

Warehouse Management Descriptive Flex Fields

Oracle WMS module DFF list:

DFF View DFF CODE NAME DFF name
WMS_DEPARTMENT_SUBINVENTOR_DFV WMS_DEPARTMENT_SUBINVENTORIES Department Zone cross reference
WMS_RESTRICTIONS_DFV WMS_RESTRICTIONS Restrictions Flexfield
WMS_RULES_B_DFV WMS_RULES Rules Flexfield
WMS_SORT_CRITERIA_DFV WMS_SORT_CRITERIA Sort Criteria Flexfield
WMS_STRATEGIES_B_DFV WMS_STRATEGIES Strategy Flexfield
WMS_STRATEGY_ASSIGNMENTS_DFV WMS_STRATEGY_ASSIGNMENTS Strategy Assignments Flexfield
WMS_STRATEGY_MEMBERS_DFV WMS_STRATEGY_MEMBERS Strategy Members Flexfield
WMS_TASK_FILTER_DTL_DFV WMS Task Filter Source WMS Task Filter Source
WMS_TASK_FILTER_B_DFV WMS Task Filters WMS Task Filters
WMS_PAGE_TEMPLATES_B_DFV WMS Templates WMS Page Templates
WMS_PAGE_TEMPLATE_FIELDS_DFV WMS Templates Fields WMS Page Template Fields
WMS_ZONES_B_DFV WMS_ZONES Zones
WMS_BFLOW_LABEL_TYPE_DFV WMS_BFLOW_LBTYPE_DFF Business Flow – Label Type Association Flexfield
WMS_LABEL_FIELD_VARIABLES_DFV WMS_LABEL_FIELDVARS_DFF Label Field Variable Flexfield
WMS_LABEL_FORMATS_DFV WMS_LABEL_FORMATS_DFF Label Format Flexfield
WMS_LICENSE_PLATE_NUMBERS_DFV WMS_LICENSE_PLATE_NUMBERS WMS License Plate Numbers