The Oracle Warehouse Management system (WMS) is a component of Oracle’s Supply Chain
Management and Manufacturing solution. It spans the areas of warehouse resource management,
warehouse configuration, task management, advanced pick methodologies, and value added services.
Oracle WMS optimizes the material handling business processes for warehouses, manufacturing
facilities, and distribution centers. Oracle WMS supports both paper-based and automated
environments with material handling systems and radio frequency (RF) hand-held computers. To
optimize the order fulfillment process, Oracle WMS provides advanced distribution processes, such as
value-added services, cross docking, order assembly postponement, and resource and task
Management. Oracle WMS also provides an easy-to-use interface for mobile, wireless hand-held
computers. Mobility, process automation, and bar code scanning greatly improve the efficiency of the
Supply Chain Logistics business processes.
WMS supports below process supply chain Inventory Management Components
Prerequisite for above process:
A]Oracle Warehouse Management Setup Overview
Setup for Oracle WMS is divided into the following sections:
1.0 -Warehouse setup
1.1– Setting up warehouse organizations
1.2– Setting up warehouse-related sub inventory parameters
1.3– Setting up warehouse-related locator parameters
1.4– Setting up dock door-to-staging lane relationships
2.0 -Material setup
2.1– Setting up item attributes
2.2– Setting up material statuses
2.3– Setting up lot and serial attributes
3.0-Task management setup
3.1– Setting up resources
3.2– Setting up or verifying equipment items
3.3– Setting up equipment resources
3.4– Setting up warehouse task types
3.5– Setting up departments
3.6– Setting up task type assignment rules
4.0- Labeling setup
4.1– Defining label formats
4.2– Associating label types to business flows
4.3– Setting up label format assignment rules
5.0-Cost group setup
5.1– Defining inventory cost groups
5.2– Specifying the default cost group in the Organization Parameters window
5.3- Setting up cost group rules
6.0- Inbound logistics setup
6.1– Setting up receiving parameters
6.2-Setting up put away rules
7.0-Outbound logistics setup
7.1– Setting up cartonization
7.2- Defining pick methodologies
7.3-Setting up pick wave rules
7.4-Defining shipping parameters
1.0-Warehouse setup
1.1 Setting up warehouse organizations
Define Ware house Organization/Location
Navigation: Inventory, ALA AMERICAS > Setup>Organizations
WMS Enabled field should be checked in. Once checked it cannot be revoked, It ensures other
functionality of Oracle WMS will be enable for this org
1.2 Setting up warehouse-related sub inventory parameters
Navigation: Distributed Warehouse Superuser: Warehouse Configuration>warehouses > Sub
Inventories
LPN Controlled: Should be checked in for handling LPN’s. Handheld devices facilitates inventory
management through LPN transactions through this SI
Enable Cartonization: Helps the WMS SI to identify Cartons based on quantity, weight, volume,
etc.
Like wise other parameters when checked in enable this Sub Inventory to support
1.3– Setting up warehouse-related Locator parameters
Define Storage Type (Doors and Lanes)
Navigation: Distributed Warehouse Superuser: Warehouse Configuration>warehouses > Stock
Locators
We can have multiple types of Locator based on the use. We can establish relation b/w these
locators
Define Storage Section and Storage Bins
Navigation: Distributed Warehouse Superuser: Warehouse Configuration>warehouses > Stock
Locators
1.4 Setting up dock door-to-staging lane relationships
Navigation: Distributed Warehouse Superuser: Warehouse Configuration>warehouses >Dock
Door to Staging Lanes
The Oracle WMS has extended the subinventory definition with the following additional parameters:
■ Material status
■ Default cost group
■ LPN controlled option
■ Cartonization flag
■ Pick UOM
■ Default locator status
3.0■ Task management setup
3.1– Setting up resources
Navigation: Setup>Transaction Setup>Inventory Transactions>Source types
When Type is selected as Person Employees can be assigned to the Resource
3.2– Setting up or verifying equipment items
When you set up an Item as Equipment Check Equipment in Physical attribute tab
3.3– Setting up equipment resources
When Type is selected as Machine , Equipment’s can be assigned to Resource
3.4– Setting up warehouse task types
Navigation: Standard Operation
3.5– Setting up departments
Navigation: Department
3.6– Setting up task type assignment rules
Navigation: WMS Rule
Note: Label
Format Assignment rules have return values. When WMS executes this rule, it returns the value AA09–if all of the
rule’s restrictions are met–that represents the label format for the LPN Content label
4.0■ Labeling setup
The WMS supports the following label types:
■ Materials label: The Material label provides information about an item ,including the item’s lot information,.
■ Serial label: The Serial label provides information specific to a serial of an item.
■ LPN label: The LPN label provides information about the License Plate Number
■ LPN Contents label: The LPN Contents label provides information about the LPN and its contents. You typically
use this label to identify LPNs as they travel throughout the warehouse.
■ LPN Summary label: The LPN Summary label provides information about the LPN and a summary view of its
contents. The LPN is exploded and all of its contents are summarized. That is, if an LPN contains multiple LPNs,
then all of the contents of all the nested LPNs will be summed by Item, Revision, and Lot on this label.
Example of a Label Type called LPN Content:
4.1-Defining Label formats
Navigation: Define Label Types
Define Label fields for each Label type
After you set up label formats, you must associate them to the specific warehouse business flow
where you want to use them. The far left vertical column lists the warehouse-related business
flow. The number in parenthesis ( ) indicates the business flow code number that is needed when
defining Rules Engine format based rules. Yes, indicates that the system can generate the label
type for that business flow. No means that the system does not generate that label type for the
business flow.
4.2– Associating label types to business flows
Navigation: Assign Label types to Business flow
4.3– Setting up label format assignment rules
Navigation: WMS Rules
5.0. ■ Cost group setup
For Project Manufacturing Organization Cost Group assignment rule will not work
5.1– Defining inventory cost groups- Not covered as part of WMS
5.2– Specifying the default cost group in the Organization Parameters window-Not Covered as part of WMS
5.3– Setting up cost group rules
6.0■ Inbound logistics setup
Inbound setup involves setting up and defining the receiving options that you need to receive
material or items into your warehouse. Inbound setup also requires that you set up the
appropriate put away rules
The WMS requires that you receive items into an LPN, using a hand-held mobile device or
desktop telnet session. The system does not support receiving from a standard Oracle
Applications form or window.
6.1– Setting up receiving parameters
Navigation: Receiving Options
For Receipt Number option WMS only support Automatic
6.2– Setting up put away rules
Navigation: WMS Rules
● Restriction Tab:. On the Restrictions tab, you specify the business objects, their related parameters, and the
restrictions of the rule. Each line in corresponds to a restriction. You use the AND and OR operators to join
multiple lines of restrictions.
● Sort Criteria : It helps to impose an Order on the Criteria that meet the restrictions
● Consistency Tab: It ensures that all allocation must have a common criteria. Eg Excellent quality ,Good
Quality, Average Quality
7.0 Outbound logistics setup
7.1– Setting up cartonization
1. Enable Cartonization
2. Define Cartonization Groups
Navigation: Categories window /Category Codes
3. Assign Cartonization Group to Catonization Category set
You must assign cartonization groups to the following two category sets:
■ Contained item, which represents items that are packed
■ Container item, which represents the actual container, such as a box, or pallet into which items are
packed.
Navigation: Categories Sets
4. Define Container Items
Navigation : Master Item: Physical attributes
5. Assign Containers to Cartonization group
Select Categories from the Tools menu, to open the Category Assignment window.
6. Define Contained Item Physical Charetreristic: Same Steps as shown above
7. Assign Contained Item to a Cartonization Group : Same Steps as shown above
7.2 – Defining pick methodologies
Pick methodologies refer to the different ways that you might select to fulfill a group of orders.
For example, you might select to pick an order by itself, or to pick multiple orders at the same
time.
Oracle WMS supports the following pick methodologies:
■ Order picking: The system assigns picks for one order at a time to a user. Thus,when a user
accepts a task for the first line on a sales order, all other picking tasks associated with that order
are automatically assigned to the user as well, regardless of the task type or subinventory.
■ Cluster picking: The system dispatches tasks line by line, regardless of the subinventories in
which those tasks are picked from or to whom the line on the order has been dispatched to.
■ Zone picking: The system assigns picks for a given order in a given subinventory to a user.
Thus, if a user accepts a task for the first line on a sales order, all other lines on that order that are
sourced from that subinventory are assigned to the user.
■ Bulk picking: The system groups tasks to pick the same items that are sourced from the same
subinventory and locator, so that the user only sees one task that might represent picks for
several orders.
■ Paper-based picking: Users pick according to a paper pick slip that is printed at pick release.
This enables a user to dispatch tasks to themselves when working in a paper-assisted
environment.
■ Pick and Pass picking: LPNs are generated by the system during cartonization and the labels
are printed prior to picking. Thus, in order to pick, the user scans the LPN, and is dispatched the
picking task that is associated with that LPN. The user can then "pass" the LPN to the next user
or continue picking all material for the LPN and will not be prompted to drop the LPN in the
staging lane until all of the lines have been picked
7.3– Setting up pick wave rules
Navigation : WMS Rules
Explaining License Plate Numbers (LPN) Management
An LPN in Oracle WMS is any object that exists in a location and holds items. Although LPNs
are associated with containers, they do not need to represent a physical entity, such as a box.
Following LPN concepts are covered below
■ Viewing LPNs
In the Material Workbench, you can view the attributes of a particular LPN
Navigation : Material’s Work Bench
To view LPN’s with Mobile User Interface
1. Log into the mobile user interface under the
Warehouse Management responsibility.
2. From the Whse Mgmt menu, select Inquiry.
3. From the Inquiry menu, select the LPN option.
4. In the LPN field, enter the LPN or select it from the
list of values.
5. Select Find LPN.
As shown in the figure, the system displays the LPN
and provides you with options to view the LPN
contents and LPN details
■ Generating LPNs
You can generate LPNs
using one of the
following methods:
■ Submit a concurrent
request to generate a
group of LPNs
Generate LPN’s using
Mobile device
Generate LPNs using the mobile device
LPNs can be generated at their point of use in mobile
receipt and task forms. When the cursor is in the LPN
field, press Generate (Ctrl+G) to automatically
generate the LPN
The figure provides an example of an LPN generated
for a PO Receipt
■ Maintaining LPNs
Following LPN activities can be done using Mobile devices
■ Packing LPNs:
Login to Mobile devices and Navigate to Pack
LPN. Generate a new LPN or enter an
Existing LPN to pack items into it. Select the
subinventory and Locator of the existing item
to be packed. Select the item number to be
packed. The UOM will populate with the item.
Enter the quantity of the item to be packed.
Select <More>pack more items, or select
<Pack> to pack this LPN
■ Unpacking LPNs:
You can unpack items from an existing LPN
or you can unpack an LPN within another
LPN.
Navigate to Unpack LPN. Select the LPN
number that you want to unpack items or
LPNs from. Select either the LPN number that
you want to unpack or the Item number that
you want to unpack from your LPN. Select the
quantity to unpack. Select <Unpack> to
complete the transaction.
View the Transaction Success message
■ Consolidating LPNs:
You can consolidate an existing LPN (residing within
inventory) with another existing LPN (residing within
inventory) or you can consolidate an existing LPN
(residing within inventory) with a newly generated LPN.
Navigate to Consolidate LPN Screen. Select an existing
LPN as the Parent LPN. Select an existing LPN as the Next
LPN. Select <More> to add more LPNs to the parent, or
select <Merge> to complete the consolidation.
Go to Inquiry and see the Consolidated LPN’s in the Outer
LPN
■ Splitting LPNs:
You can split an existing LPN into multiple LPNs.Navigate to Split LPN.
Select the LPN that you want to split an item from. Select the LPN that you
are moving your item into. Select the quantity. Select <Save/Next> to
continue with another split, or select <Split> to complete this transaction
■ Updating LPNs:
You can update attributes of LPN including Weight, UOM, volume content,
Container Item. Navigate to Update LPN
Performing Inventory Transactions with LPN
■ Miscellaneous issues
Miscellaneous Receipts
■ Sub inventory transfers
■ Direct inter-organization transfers
If not already logged into the organization, select the organization from which you want to perform the transfer.
Discrete Manufacturing (WIP JOBS)-Transactions through WMS/MSCA
Flow Chart description through Screen Shots
Create a Job-3302
Status of the Job -Released
Two Components are associated to
the Assembly Item
Assembly Item: MIKEMAKEITEM
Component 1-MIKE TEST
Component2-MIKETEST2
Routing Details: We have 2 Sequence for the Assembly Item; i.e. 10, 20
With 2 operation’s each-Queue, Run, To Move
Log in to MSCA
Navigate to Manufacturing> Assy &
Material Txn>Material
Txn>Issue>Select Organization
The two components
MIKETEST& MIKETEST2 is
being issued to the Job 3302
in two Issue Transactions
Select the OP Seq 10 to issue
the components
Provide Sub Inventory &
Location Information where
the Components are to be
issued
F2 and go back to Main
Menu. Navigate to Move
Assy. Select the Job 3302 to
be moved. Move the
Assembly from
10 Queue
10 Run
The above MSCA Transaction
can be viewed through View
Transaction form in WMS
Keep Moving the Assembly
in the below sequence
10 Queue
10 Run
10 To Move
20 Queue
20 Run
20 To Move
Validate and Check all the
MSCA Move Transactions on
the View Move Transaction
from Manufacturing
Responsibility
Mo the assembly is
completely moved through
the Routing
Navigate to Complete
Assy>Complete
Select the Job 3302 to be
completed.
Assembly Item details will be
populated
Select the Sub Inventory,
Locator and Quantity to drop
this Job
Explaining License Plate Numbers (LPN) Management
An LPN in Oracle WMS is any object that exists in a location and holds items. Although LPNs
are associated with containers, they do not need to represent a physical entity, such as a box.
Following LPN concepts are covered below
■ Viewing LPNs
In the Material Workbench, you can view the attributes of a particular LPN
Navigation : Material’s Work Bench
To view LPN’s with Mobile User Interface
1. Log into the mobile user interface under the
Warehouse Management responsibility.
2. From the Whse Mgmt menu, select Inquiry.
3. From the Inquiry menu, select the LPN option.
4. In the LPN field, enter the LPN or select it from the
list of values.
5. Select Find LPN.
As shown in the figure, the system displays the LPN
and provides you with options to view the LPN
contents and LPN details
■ Generating LPNs
You can generate LPNs
using one of the
following methods:
■ Submit a concurrent
request to generate a
group of LPNs
Generate LPN’s using
Mobile device
Generate LPNs using the mobile device
LPNs can be generated at their point of use in mobile
receipt and task forms. When the cursor is in the LPN
field, press Generate (Ctrl+G) to automatically
generate the LPN
The figure provides an example of an LPN generated
for a PO Receipt
■ Maintaining LPNs
Following LPN activities can be done using Mobile devices
■ Packing LPNs:
Login to Mobile devices and Navigate to Pack
LPN. Generate a new LPN or enter an
Existing LPN to pack items into it. Select the
subinventory and Locator of the existing item
to be packed. Select the item number to be
packed. The UOM will populate with the item.
Enter the quantity of the item to be packed.
Select <More>pack more items, or select
<Pack> to pack this LPN
■ Unpacking LPNs:
You can unpack items from an existing LPN
or you can unpack an LPN within another
LPN.
Navigate to Unpack LPN. Select the LPN
number that you want to unpack items or
LPNs from. Select either the LPN number that
you want to unpack or the Item number that
you want to unpack from your LPN. Select the
quantity to unpack. Select <Unpack> to
complete the transaction.
View the Transaction Success message
■ Consolidating LPNs:
You can consolidate an existing LPN (residing within
inventory) with another existing LPN (residing within
inventory) or you can consolidate an existing LPN
(residing within inventory) with a newly generated LPN.
Navigate to Consolidate LPN Screen. Select an existing
LPN as the Parent LPN. Select an existing LPN as the Next
LPN. Select <More> to add more LPNs to the parent, or
select <Merge> to complete the consolidation.
Go to Inquiry and see the Consolidated LPN’s in the Outer
LPN
■ Splitting LPNs:
You can split an existing LPN into multiple LPNs.Navigate to Split LPN.
Select the LPN that you want to split an item from. Select the LPN that you
are moving your item into. Select the quantity. Select <Save/Next> to
continue with another split, or select <Split> to complete this transaction
■ Updating LPNs:
You can update attributes of LPN including Weight, UOM, volume content,
Container Item. Navigate to Update LPN
Performing Inventory Transactions with LPN
■ Miscellaneous issues
Miscellaneous Receipts
■ Sub inventory transfers
■ Direct inter-organization transfers
If not already logged into the organization, select the organization from which you want to perform the transfer.
