December 24, 2015

Please go through the Setup steps, their significance and the navigation to the setup forms.

Define Profile Options
Define Mobile User ID

System Administration>Security>User>Define

Define Warehouse

Setup>Warehouse Configuration>Warehouses>Define Warehouses

Define Warehouse Parameters

Enable WMS attribute
  • Serial Control
  • Lot Control
  • LPN Control
  • Crossdocking Information
  • Time Zone
  • Default Cycle Count Header
  • Default Picking Rule
  • Default Put away rule
  • Cartonization Options
  • Default pick task type
  • Default replenishment task type
  • Default Move Order Transaction Type
  • Default Move Order issue Task Type
Setup>Warehouse Configuration>Warehouses>Warehouse Parameter

Receiving Options

Setup>Warehouse Configuration>Warehouses>Receiving Parameters

Define Subinventory Attributes

Setup>Warehouse Configuration>Warehouses>Receiving Parameters

Define Stock Locators Attributes

Units, volume, weight, Dimansions, coordinates

Setup>Warehouse Configuration>Warehouses>Stock Locators

Define Dock Door to Staging Lane Relationships

Setup>Warehouse Configuration>Warehouses>Dock Door to Staging Lane Assignments

Define Shipping Networks

Define the required shipping networks between different warehouses also attach the shipping method if needed

Setup>Warehouse Configuration>Warehouses>Shipping Networks

Define Item Attributes for WMS

Lot, Lot Expiration,Serial controlled, Physical attributes and Material Status

Setup>Material Setup>Items>Master Items

Define Material Statuses

You use this form to setup material status codes that enable you to control the movement and usage of material for portions of on-hand inventory that might have distinct differences

Setup>Transaction Setup>Inventory Transactions>Material Status

Define Lot and Serial Attributes

Setup>Material Setup>Lot/Serial Attributes>Lot/Serial Attributes Descriptive Flexfield>Segments

Define Warehouse Resources

Define all resources here Human, Equipment, etc so that accordingly you can assign tasks to these resources

Setup>Warehouse Configuration>Resources>Resources

Define Equipment Items

Equipment, such as forklifts, pallet jacks, and so on are used to perform tasks in a warehouse.  In WMS, you set up equipment as a serialized item and a resource.  
Users sign on to the serial number of the equipment and are dispatched tasks appropriate to that equipment.
  • Define the equipment as an item
  • Define the item as an equipment type 
  • Specify the equipment as serial controlled (predefined)
  • Enter the equipment capacity (optional)
  • Generate serial numbers for the individual pieces of equipment

Setup>Material Setup>Items>Master Items
Setup>Warehouse Configuration>Resources>Equipment

Define Equipment Serial Numbers

Setup>Inventory Management>Material Maintenance>Generate Serial Numbers

Define Departments

Setup>Warehouse Configuration>Departments & Resources>Departments

Define Transaction Reasons

Setup>Transaction Setup>Inventory Transactions>Transaction Reasons

Define Label Formats

You are setting up the data fields that you want the system to include on a particular label

Setup>Warehouse Configuration>Printing>Define Label Formats

Define Associate Label Formats to Business Flows

Setup> Warehouse Configuration>Printing>Assign Label Types to Business Flows

Assign Labels to Printers

Setup> Warehouse Configuration>Printing>Assign Printers to Documents

Define Cost Groups

Setup>Material Setup>Costs>Cost Groups

Define Account Alias

Setup>Transaction Setup>Inventory Transactions>Define Account Aliases

Define Pick Sliationp Grouping Rules

Setup pick slip grouping rules to specify different ways in which a warehouse might choose to fulfill a group of orders

Setup>Warehouse Configuration>Rules>Pick Wave>Pick Slip Grouping

Define Release Sequence Rules

Setup>Warehouse Configuration>Rules>Pick Wave>Release Sequence

Define Release Rules

Setup>Warehouse Configuration>Rules>Pick Wave>Release Rules

Define Container Types

Before you set up cartonization and container items, you should verify that the appropriate container types exist.  Container types represent the codes that you assign to various containers, such as boxes, bins and pallets.  The WMS system comes pre-seeded with a variety of container types but the system also enables you to set up your own

Setup>Material Setup>Items>Container Types

Define Container Items

Containers can be defined as item
Setup>Material Setup>Items>Master Items

Define Cartonization Groups

Inventory class categories can be defined for this
Setup>Material Setup>Items>Categories>Category Codes

Define Cartonization Category Sets

Setup>Material Setup>Items>Categories>Category Sets

Define Container Item Relationship

Setup>Material Setup>Items>Define Container Item Relationship

Define Shipping Parameters

Setup>Warehouse Configuration>Warehouses>Shipping Parameters

Define Task Types

For each unique combination of human and equipment resourses, a new task type should have been defined.

Setup>Warehouse Configuration>Tasks>Standard Task Types

Define Task Type Assignment Rules

To define rules for Cost Group Assignments, Label Format, Pick, Put Away and Task Type assignments.

Setup>Warehouse Configuration>Rules>Warehouse Execution>Rules

Define Warehouse Strategy

A strategy is an ordered sequence of rules that the system uses to fulfill complex business demands. The rules strategy are selected in sequence until the put away or picking task is fully allocated, or until a cost group that meets the restriction is found. When you define strategies, you also specify the date or range of dates on which the strategy is effective. You also specify whether you want the system to execute a strategy, if it can only successfully execute part of that strategy.

Setup>Warehouse Configuration>Rules>Warehouse Execution>Strategies

Define Warehouse Rules Workbench

Add the strategies here in a sequence with required parameter values to execute in required sequence.

Setup>Warehouse Configuration>Rules>Warehouse Execution>Rules Workbench

Define MWA Personalization Framework

To customize any mobile pages, any fileds in there, you can use this to customize
Setup>MWA Personalization Framework
Read More

December 16, 2015

Document Printing

In most of the oracle process, we need documents to be printed.
For example, during shipping, we need pick slip and pack slips to be printed in the warehouse or shipping doc.

Many business do they have multiple printers setup in the warehouse in different zones for the convenience of order fulfillment.

As per the requirement, oracle has given the flexibility to assign printers to the documents.
Below pre-requisites needed for automated document printing
  • Required Document Report needs to be defined and registered in oracle
  • Printer to be used in the warehouse needs to be defined and installed in the network
  • Printer needs to be connected on proper ip in the network

Assigning Printer to the Document

You can assign shipping documents and selected reports to specific printers. For example, you can assign pick slips and pack slips to your warehouse tractor feed printer, your mailing labels to a tractor feed printer stocked with blank labels, and other documents to a laser printer in your order entry office.
You can assign each shipping document and report to a different printer for each user, responsibility, application, or site. If a user or responsibility is not specified, Oracle Order Entry/Shipping uses the printer that you indicate for the application.

Navigate to the Order Management Super user responsibility
Setup --> Shipping --> Documents --> Choose Printer

Expand the Document Option and select the document name for which you want to assign a printer

Here you have multiple flexibility to choose a printer in different level.
You can choose a printer at below levels

  • You can choose from Site, Application, Responsibility, or User
  • If you select Responsibility or User in the Level field, choose the specific name in this field. If you select Site or Application in the Level field Oracle Order Entry/Shipping displays the name of your site, or Oracle Order Entry, and skips to the next field.
  • Select the name of the printer to which you want the shipping document to print.
  • Check the Enabled check box to activate the printer assignment
Do the setup as per your convenience.
Read More

December 15, 2015

Are locators mandatory for WMS ?
Yes, Locators are mandatory in WMS
What setup you do to enable WMS for an inventory organization ?
Organization should be WMS enabled in Organization Parameter form.
What is LPN ?
LPN is License Plate Number. This is an identification of an object/container(logical or physical) which holds Item/Items.
Click here for More.
What is cost group ?
Cost group is a combination of accounts(material and overhead accounts) which are setup at subinventory/organization level. When any transaction will happen, it will hit those accounts. As part of WMS, cost group can be assigned at material level. You can have multiple cost groups with in a subinventory based on different attributes as per your need.
Click here for more.
What are the different rules you can setup in WMS ?
Pick, Put away, Task Type Assignment, Cost Group Assignment, Label Format, Operational Plan selection
Click here for more
What is pick wave ?
Pick Wave is the process of Picking a Group of orders which can be released to different warehouse operator with the use of Pick Release rule WMS Pick rule and WMS Task assignment rule.
Wave picking is a term for a process used in a warehouse management system to describe a process to support managing the work of a warehouse or distribution center. Wave picking is an application of short interval scheduling, to assign orders into groupings (waves) and release them together so as to allow management to coordinate the several parallel and sequential activities required to complete the work.
The individual orders in the wave are dependent on the criteria used to make the selection.[2] The wave data includes the workload by order or function (case picking, repack picking, pallet movement, pick position replenishment, packing, etc.), providing management the information to calculate staff requirements and assign staff by function, with the expectation that the work in each function, within each wave, can be started and be completed at about the same time. There are two basic planning elements and benefits of wave picking.
To organize the sequence of orders and assignment to waves, consistent with routing, loading and planned departure times of shipping vehicles or production requirements, etc., to reduce the space required for shipping dock handling to assemble orders and load; and
To assign staff to each wave and function within a wave, with the expectation that all the work assigned to each wave will be completed within the wave period, providing management with the ability to monitor and manage performance throughout the day, and respond in a timely way to problems that occur, and more effectively utilize the staffing throughout the shift.
Material handling methods and equipment are independent of waving. Each set of method (e.g., order pick, batch pick, bulk pick) and equipment (e.g., conveyor and sorter, ASRS, order picker, pallet jack, fork lift) will yield a different expected productivity rate for management to use in determining the number of staff-hours to assign to each function by wave.
Additional benefits of wave picking include the improved ability to
  • measure productivity within a function
  • budget labor
  • estimate the throughput capacity based on staffing levels
  • evaluate the impact of changes in methods and equipment by function
  • provide feedback regarding performance
  • Better understand the nature of the workload as it changes seasonally, as a consequence of demand, and as a consequence of sales efforts and marketing campaigns
Where do you use multi-level LPN ?
Multi level LPNs are used when business needs to pack LPN controlled items into a container which itself LPN controlled.
For example: During Shipping, EACH items packed in BOX and BOX are packed in PALLET.
Click here for more
Explain put away rules ?
Put away rules are defined to direct the picked items to business required staging areas in outbound orders and direct the destination locations for inbound purchase order or RMAs.
Put away rules can be defined with many business restrictions as per the need
What are task management activities you can do in MWS ?
Task Management is the activity where warehouse controller will manage different tasks dispatched to warehouse like pick, put away. Controller can assign, unassign tasks to the warehouse resources either to persons or equipment using Warehouse Control Board.
Explain cross-docking feature ?
Cross docking is a process to accommodate the inbound material directly to a staged area for any existing outbound orders.
Supplies are directly tagged to demands and transacted from staging area.
This increases the efficiency of any warehouse operation and order fulfillment process by eliminating the steps of putting supplies into inventory and picking demands from inventory.
Oracle provided cross docking is 2 types

  • Planned Cross Docking
  • Opportunistic cross docking

In case of Planned crossdocking the pre-allocation is done during Pick Release. In opportunistic crossdocking dynamic allocation is done during material putaway.
How to achieve Cross Dock for partial quantity or Cross docking for 1 Sales Order and not for other Sales order?

What is bulk picking ?
Can WMS support over picking ?
What is express picking ?
Explain the cartonization features ?
What is warehouse control board ?
Can we use MSCA without WMS ?
What is MSCA ?
What are warehouse management strategies ?
Difference between physical and Cycle Count?
Why can’t we do physical Count as Cycle count?
How we can assign the tasks to employees automatically?
How to query in Warehouse Control Board?
How to Auto Print WMS label for one item and not for other?
How XML label data sent to printer? I.e. its not printing as shown in XML therefore so how printer print labels?
I want to display all 3 thing say item, LPN and Sub inventory in same line. How to achieve that?
What are basic setups to use MSCA or WMS?
How machines assigned to a particular task? is machine is also a resource or only person is a resource? if machine is not a resource how we assign it to a person or task?
Type of Label in WMS?
Type of label formats in WMS?
Can a LPN created in one organization be used in a different organization?
Ans: Yes it can be used using API WMS_CONTAINER_PUB.REUSE_LPNS provided the current LPN context is Issued Out Of Store and there is no pending transaction on that LPN.

Questions will be Answered soon. Meanwhile you can post more questions in the comment also you can answer to above questions in the comment.
Please help me to rectify if any of the answers are not correct.
Read More

LPN Context

LPN Context is nothing but the state/status of the LPN. Oracle WMS provided many states for an LPN. As per the current state/context, the usage of the LPN will change.
These context can be used to customize specialized picking and put away rules. Also context will help in querying tasks in warehouse control board.

Below are the different LPN context and their state definition

These context have a numeric value in the back end table.


Resides in Inventory:

Indicates that material associated with this LPN has been costed and accounted for in inventory. A LPN with this context may not be used when receiving material against a standard or inspection routed receipt, but may be used during a direct delivery routed receipt. Outbound transactions can be performed on LPNs with this context.

Resides in WIP:

Indicates that material associated with this LPN is currently being transacted in WIP (Work in Process). Therefore, the associated material is not yet in inventory and has not been costed to inventory.

Resides in Receiving:

Indicates that material associated with this LPN have been received using a standard routing or inspection routing receipt and have not been delivered/put away yet. Therefore, the associated material is not yet in inventory and has not been costed to inventory.

Issued out of Stores:

These LPNs are no longer tracked by the system, and hence, no longer associated with a locator within the warehouse. The system does however retain history information pertaining to transactions this LPN was involved in and material it was associated with prior to leaving the warehouse. LPNs shipped out of inventory receive this context and may not be re-received.


When LPNs are pre-generated by Oracle WMS and have not been used yet, they are not associated with any physical material. They can be printed and used to identify material during any stage of the material management process such as inbound, replenishment, outbound, and so on. Essentially, this context refers to LPNs that are ready to be used.

Resides in In-Transit:

A LPN with this context is an indication that it is currently moving from one location to another. Possible uses for this are when a LPN is moved from one organization to the next, for example while the LPN is on a truck. The LPN is in an intermediary state, but resides within the entire system. This context is used only for inter-org transit or internal sales orders where an indirect shipping network is defined between the organizations.

Resides in Vendor Site:

When a vendor sends an Advanced Shipment Notice (ASN) to Oracle WMS, the system internally generates LPNs and associates them with material information on the ASN. These LPNs receive this context. Material associated with LPNs of this context are not on-hand or costed until it is actually received.

Packing Context:

This context is temporary and used internally by the software as an intermediary. It should not be used or referenced anywhere including the setup of picking or put away rules.

Loaded for Shipments:

An LPN loaded for shipment has just been loaded onto a carrier ready to leave the warehouse. Once the entire carrier leaves the dock, the LPN obtains a context of 6 Resides in Intransit or 4 Issued out of Stores.

Prepack of WIP:

LPNs that reside in WIP and are associated with material that is pre-packed by WIP receive this context. This context adds an extra level of granularity to an LPN's usage within WIP. This is used when the system has associated the LPN with material and printed the labels, but the material has not yet been physically packed.


LPNs picked during the picking process receive this context. They are intransit within the warehouse.

Read More

Oracle WMS: LPN

LPN is License Plate Number.
This is nothing but an identification of a certain object which holds Item/Items.
So for understanding, you can say LPN is an identification of a box in which you have kept the item/s whether in your warehouse locations or you have consolidated for shipping or identified for picking or receiving. At any point of time, item/s/group of items can be tracked using one single identification that is called LPN.
  •  This can be a physical container or a logical grouping.
  •  A single LPN can contain one or many qty of the same or different items
  • This is used to store information of items such as LOT, Revision, Serial, Organization, subinventory, locator, etc.
  • Contents of an LPN can be tracked during inventory stocking, shipping, receiving, in-transit
  • Receiving, Shipping, Picking, Packing of material can be done using LPN
  • Onhands can be tracked using LPN
  • Multiple items and qty can be transacted using LPN
  • Contents can be packed, unpacked, split or updated in LPN
  • Labels can be printed based on LPN for the contents inside an LPN
  • LPNs can be reused if that is empty or not assigned to any content

Nesting LPN

Oracle WMS allows to use LPN in nested also.
For example, you have made a Combo deal sale for Christmas.
If customer buys 2 laptop units, they will get one USB hub free.
And for better and faster shipment, you have already packed the units and kept for ready to ship.
So now the nesting hierarchy is like this

Read More

December 2, 2015

Oracle Order Management Setups

Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system to begin processing order information. These orders can be created in Oracle Order Management Suite as well as in some other front-desk application. We can integrate these applications with Oracle Order Management for keeping a controlled track of orders and proper business flow. We can create different types of orders using this application can be for inventory stock items or for services.
You must define your business order policies, such as how you classify your orders, as well as various control features prior to processing orders within the application.
Important Setup Steps for Order Management
Click on the links to go to individual setup steps

Step Optional or Required
1. Define multiple organizations in Oracle Inventoryrequired
2. Setup Multi-Org (Multiple Organization) Access Controloptional
3. Define key and descriptive flexfieldsrequired under certain conditions
4. Define inventory organizations (warehouses), parameters, subinventories, and picking rules in Oracle Inventoryrequired
5. Define Profilesrequired
6. Setting OM System Parametersrequired
7. Define invoicing information, Payment Termsrequired under certain conditions
8. Define your sales representativesoptional
9. Define Tax Featuresrequired
10. Define Quickcodesrequired under certain conditions
11. Define header and line processing flowsrequired
12. Define Document Sequences for Order Numberingrequired
13. Define Order Import Sourcesrequired under certain conditions
14. Define the units of measurerequired
15. Define item informationrequired
16. Define the items that you sellrequired
17. Define the configurations that you sellrequired under certain conditions
18. Define price listsrequired
19. Define customer profile classesrequired under certain conditions
20.Define information on your customersrequired
21. Define item cross referencesrequired under certain conditions
22. Define your sourcing rulesoptional
23. Define Order Management Transaction Typesrequired
24. Set up Cost of Goods Sold Accounting flexfield combinationrequired under certain conditions
25. Define Processing Constraintsoptional
26. Define Defaulting Rulesoptional
27.Define Credit Checking Rulesrequired under certain conditions
28. Define Automatic Holdsrequired under certain conditions
29. Define Attachmentsoptional
30. Define Freight and Special Charge Typesoptional
31. Define shipping parametersrequired
Read More
Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here