![Page 1: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/1.jpg)
Oracle Warehouse Management
Dave Herring – Lion Apparel, [email protected]
Brian Pellot – Pelley Consulting, LLC
![Page 2: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/2.jpg)
Overview Project Status and Background WMS Basics LPN Concepts and Processing Task Processing Rules Engine Key Learnings Wrap-up
![Page 3: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/3.jpg)
Background and Project Status
100 years plus World’s largest
maker of protective clothing
Turn-out gear, helmets, boots ...
![Page 4: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/4.jpg)
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
![Page 5: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/5.jpg)
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
![Page 6: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/6.jpg)
WMS Basics - MWAMobile 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
![Page 7: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/7.jpg)
WMS Basics - MWATransactions entered through a Telnet session Receiving/Putaway Shipping LPN transactions Physical/Cycle Counting Standard inventory transactions WIP Moves and Material Transactions Inquiry Screens
![Page 8: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/8.jpg)
WMS Basics - MWA
Subinventory Transfer
Data can be entered, scanned or selected.
Think about the amount of information to be entered(keyed) through the handheld.
![Page 9: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/9.jpg)
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)
![Page 10: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/10.jpg)
LPN Concepts and Processing
Items
Pack Consolidate Transfer the Truck LPN(one transaction)
![Page 11: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/11.jpg)
LPN Concepts and Processing
Un-Pack
Receive theTruck LPN(one transaction)
Un-Pack
![Page 12: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/12.jpg)
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
![Page 13: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/13.jpg)
Task Processing
Task ListPick 2 smilesPick 3 circlesPutaway LPN XPick 4 bolts
Rules Engine
ResourcesJoe in a Forklift
Alice on Foot
Betty in Crane
Task assignment, progress and efficiency can be directed and monitored through a control board.
![Page 14: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/14.jpg)
Task Processing
Control Board used to monitor and manager tasks on the floor.
![Page 15: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/15.jpg)
Rules Engine Core of WMS is
the Rules Engine Drives the
functionality
![Page 16: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/16.jpg)
Rules Engine
Dave’s first thoughts…
“Rules, we don’t need no stinking rules”
![Page 17: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/17.jpg)
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
![Page 18: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/18.jpg)
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
![Page 19: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/19.jpg)
Rules Engine
This is very flexible but can be difficult to achieve the desired result
Some programming experience is necessary
![Page 20: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/20.jpg)
Rules Engine
Example Rule:These quickly get complex and technical.
![Page 21: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/21.jpg)
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
![Page 22: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/22.jpg)
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
![Page 23: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/23.jpg)
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
![Page 24: Oracle Warehouse Management Dave Herring – Lion Apparel, Inc. Daveh@lionapparel.com Brian Pellot – Pelley Consulting, LLC Bpellot@earthlink.net](https://reader036.vdocuments.us/reader036/viewer/2022062404/5518c04a550346991f8b5558/html5/thumbnails/24.jpg)
Questions
?