oracle warehouse management n.
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle Warehouse Management PowerPoint Presentation
Download Presentation
Oracle Warehouse Management

Loading in 2 Seconds...

play fullscreen
1 / 24

Oracle Warehouse Management - PowerPoint PPT Presentation

  • Uploaded on

Oracle Warehouse Management. Dave Herring – Lion Apparel, Inc. Brian Pellot – Pelley Consulting, LLC Overview. Project Status and Background WMS Basics LPN Concepts and Processing Task Processing Rules Engine Key Learnings Wrap-up.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Oracle Warehouse Management' - damian-house

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle warehouse management

Oracle Warehouse Management

Dave Herring – Lion Apparel, Inc.

Brian Pellot – Pelley Consulting, LLC

  • Project Status and Background
  • WMS Basics
  • LPN Concepts and Processing
  • Task Processing
  • Rules Engine
  • Key Learnings
  • Wrap-up
background and project status
Background and Project Status
  • 100 years plus
  • World’s largest maker of protective clothing
  • Turn-out gear, helmets, boots ...
background and project status1
Background and Project Status
  • Implementing OM, Configurator, Inventory, Quality, BOM, WIP, Cost, AR and WMS
  • Starting second round of system testing
  • Planning to go-live March, 2004
wms basics
WMS Basics
  • WMS augments other modules’ functionality (Inv, Shipping, WIP, Quality)
  • Additional responsibility and set of forms plus forms from the other modules
  • Rules engine – Core of WMS functionality
  • Mobile Web Applications(MWA), Mobile Supply Chain Apps (MSCA) – Handheld/RF ready interface
wms basics mwa
WMS Basics - MWA
  • Mobile Web Applications
  • Intended for handheld, RF devices
  • Device Evaluation and Selection
  • Many are portable PCs with other capabilities
  • Easily integrated with flexible setups in the application
wms basics mwa1
WMS Basics - MWA

Transactions entered through a Telnet session

  • Receiving/Putaway
  • Shipping
  • LPN transactions
  • Physical/Cycle Counting
  • Standard inventory transactions
  • WIP Moves and Material Transactions
  • Inquiry Screens
wms basics mwa2
WMS Basics - MWA

Data can be entered, scanned or selected.

Think about the amount of information to be entered(keyed) through the handheld.

Subinventory Transfer

lpn concepts and processing
LPN Concepts and Processing
  • License Plate Number – unique identifier for a group of items/instances
  • Like a box, crate, truck, basket, pallet, vat, tank, etc.
  • LPNs can contain other LPNs, boxes in boxes, boxes in trucks
  • Pack, consolidate, unpack
  • Herring’s law of packing (with regards to Newton)
lpn concepts and processing1
LPN Concepts and Processing




Transfer the

Truck LPN

(one transaction)

lpn concepts and processing2
LPN Concepts and Processing

Receive the

Truck LPN

(one transaction)



task processing
Task Processing
  • Tasks are actions performed in the warehouse. Putaway, pick
  • Tasks assigned to WH resources (people and machines)
  • Rules engine assigns correct task to correct resources
task processing1
Task Processing


Joe in a Forklift

Alice on Foot

Betty in Crane

Task List

Pick 2 smiles

Pick 3 circles

Putaway LPN X

Pick 4 bolts

Rules Engine

Task assignment, progress and efficiency can be directed and monitored through a control board.

task processing2
Task Processing

Control Board used to monitor and manager tasks on the


rules engine
Rules Engine
  • Core of WMS is the Rules Engine
  • Drives the functionality
rules engine1
Rules Engine

Dave’s first thoughts…

“Rules, we don’t need no stinking rules”

rules engine2
Rules Engine
  • Uses Rules, Strategies and Assignments to:
    • Assign Tasks
    • Allocate Material to Move Order (pick waves)
    • Assign Cost Groups (inventory accounting)
    • Direct Putaways
    • Drive label printing
rules engine3
Rules Engine
  • Example Rules
    • If item to be putaway has a category of Frozen Goods and is larger than 200lbs, place in subinventory Bulk Frozen Goods
    • Pick material for customer X from a Grade A lot
    • Put internal order receipts in FG subinventories
rules engine4
Rules Engine
  • This is very flexible but can be difficult to achieve the desired result
  • Some programming experience is necessary
rules engine5
Rules Engine

Example Rule:

These quickly get complex and technical.

key learnings
Key Learnings
  • WMS is fairly immature
    • Bugs
    • Seemingly logical functionality is not available
  • Much of the functionality only available in MWA
    • LPNs
    • Pick confirmation by tasks
key learnings1
Key Learnings
  • Once you go WMS, you have to use the WMS methods.
    • Cost groups – they have to be used as assigned through the engine.
    • Locator Control must be turned on
    • Pick confirm must be manual and use tasks.
    • Receiving must be done in MWA
  • A Lot of Setup
    • Cartonization
    • Directed putaway by weight or volume
key learnings2
Key Learnings
  • Rules Engine requires functional and technical help
  • Open interfaces do support much of the functionality for extensions. However, only briefly documented.
  • Some features are difficult to implement since all information must be entered through MWA