Tag Archives: Oracle WMS

Reusing Shipped LPNs in Oracle WMS

26 Jul

Yes LPNs can be reused in either same inventory organization or a different organization.
This can be achieved using container public API

Provided the current context of the LPN is issued out of store and there is no pending transaction on that LPN and LPN name is a valid LPN name.

Prior to R12.1.1, oracle was not allowing to re use the LPN once shipped out.

But in certain business case this is necessary to reuse.
Like logistic business they have they container returned to dock or warehouse after delivering to customer and which can be resused, so why not the LPN tagged to that.

As of now there is no functionality in oracle forms using which this can be achieved.
In those cases, this can be achieved by using the below API

apps.wms_container_pub.reuse_lpns
It will Validate the LPN on below points

  • It should be issued out of stores. 
  • It should have a valid LPN name. 
  • There should not be any pending transactions for this LPN.

It derives the contents from WMS_LPN_CONTENTS & WMS_LICENSE_PLATE_NUMBERS. This will update the WMS_LPN_HISTORIES table as well

  • It marks the LPN as ‘Defined but not used’ with no Subinventory/Locator. 
  • LPN is ready for reuse in the organization provided. 
–SAMPLE API CODE 
prompt Enter License Plate Number which has to be reused accept lpn;
Declare
l_Return_Status Varchar2(1);
l_Msg_Count Number;
l_Msg_Data Varchar2(100);
l_Lpn_Id Number;
l_Clear_Attributes Varchar2(10) := ‘Y’;
l_Unpack_Inner_Lpns Varchar2(10) := ‘N’;
l_Clear_Containter_Item_Id Varchar2(10) := ‘N’;
l_Organization_Id Number := Null;
— l_License_Plate_Number Varchar2(100) := ‘JR1’;
l_License_Plate_Number VARCHAR2(100):= ‘&lpn’;
Begin
Select Lpn_Id
Into l_Lpn_Id
From Wms_License_Plate_Numbers
Where License_Plate_Number = l_License_Plate_Number;
Wms_Container_Pub.Reuse_Lpns
(
p_Api_Version => 1,
x_Return_Status => l_Return_Status,
x_Msg_Count => l_Msg_Count,
x_Msg_Data => l_Msg_Data,
p_Lpn_Id => l_Lpn_Id,
p_Clear_Attributes => l_Clear_Attributes,
p_New_Org_Id => l_Organization_Id,
p_Unpack_Inner_Lpns => l_Unpack_Inner_Lpns,
p_Clear_Containter_Item_Id => l_Clear_Containter_Item_Id
);
Commit;
Exception
When Others Then
Dbms_Output.Put_Line(‘SQLEERM ‘ || Sqlerrm);
End;

WMS Label Format Setup and Demo

6 Aug

Labels are an integral part of WMS functionalities.
This will help in easy transaction, clear tracking and using this transactions can be automated.
Oracle provides different types of labels to setup as per your business transactions.
Supplier labeling speeds-up the receiving process by enabling bar code scanning of inbound purchase orders, that results in less receipt processing time, immediate recognition of available materials, and higher receiving accuracy.

Labels can be customized as per customer needs to cpmly with specific business or govt compliances with fields and barcodes.
Even you can print customized documents as labels in case of requirement using label printing api.
Below is the step wise setup with an example for clear understanding

Create an Item

Navigation:
Inventory Super User -> Inventory -> Items -> Master Items

Assign Items to the organization

Tools -> Organization Assignments

Define Label Format

You can use oracle provided standard Labels or you can customize as per your business need

Warehouse Manager -> Setup -> Warehouse Configuration -> Printers & Devices -> Define Label Format

Select label type and entity type, find seeded label format and click on Label Fields and variables to check visible fields. You can define your custom format and select required fields.

Assign Label Format to Business Flow

Setup -> Warehouse Configuration -> Printers & Devices -> Assign Label Format to Business Flow

*Drill down business flow and select Miscellaneous / Alias Receipt. Assign label type at user level

Create Label Format Rule

Setup -> Warehouse Configuration -> Rules -> Warehouse Execution -> Rules

*Create a new Label format rule to satisfy the business condition
Then run Generate All Rule concurrent program

Do A transaction to understand how it works

Do a Misc Receipt Transaction using MSCA 

Check the generated Labels

Navigate to

Warehouse manager -> Inquiry -> View Label Requests

Query by giving your user id or any such specific parameter in the form and you will be able to see the label, its status with details and the XML format of the label.

This labels can be printed in all types of label printers provided by many different vendors like Zebra, etc.

Oracle WMS: Curtail Pick

28 Jul

Curtail Pick

To raise a task exception in Oracle Warehouse Management, a transaction reason set up is required and it should be linked to the reason type. While entering an exception during the picking process, we need to select the reason for the exception.

Curtail Pick and Pick None are the two reason contexts, in which Pick None is applied when there is no need to perform the task from that locator or the system assumes that there is no on-hand quantity available in that locator while Curtail Pick ends the picking process after picking a few license plate numbers (LPN) or lots and loads the contents.

Oracle Inv & WMS: Cycle Count

28 Jul

Cycle Count

What is Pickwave

12 Jan

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.

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

Oracle Warehouse Management Rule Engine

5 Jan

Oracle WMS Rule

Oracle WMS provides a complete advanced set of tools which enables a warehouse to work effectively dispatching tasks in time error free to the correct destination and operators.
Non WMS warehouses are mostly managed by manual interventions and decisions taken by the operators which increases the scope for manual error, delay in delivering a task, sometimes serious mistakes which incur huge loss in inventory management.
Also some complex decisions cannot be taken by human operators which can increase the warehouse optimization.

To all these questions, concerns and mistakes, oracle has answered in the WMS in the form of WMS rule engine.

The rules engine enables directed picking and put away, assigns newly received material to a cost group, ensures customer compliant labeling, assigns tasks to a resource with the appropriate training and equipment, and selects the correct operation plan for a task. You can also use the cartonization criteria to assign the four options of the cartonization algorithm at the organization or subinventory level. Rules can be based on nearly any attribute in the database, including user-defined flexfields. Strategies, or a collection of rules, can be organization specific, customer specific, item specific, or specific to one of many additional business objects. Below are the different types of rules which can be defined in WMS rule engine.

Below are the different types of rules which can be defined in WMS rule engine:

Directed Picking and Putaway

The rules engine provides intelligent suggestions for put away locations of new material, based on virtually any business process. Some common processes the rules are capable of modeling include: minimizing item fragmentation, requiring no lot commingling in a locator, directing hazardous materials to a corresponding hazardous storage location, or placing seasonal items in a subinventory dependent on time of year. Other put away possibilities include: basing the location on inspection results, purchase order type, or item category. The rules engine also suggest material put away to intelligent locations suggested by the rules engine, for any items anywhere within the warehouse. 

When the system releases a pick wave to the warehouse floor, the rules engine determines the allocation suggestions. You can create picking rules to model business practices such as: to ensure stock rotation, meet customer requirements such as stock condition or quality, lot expiration date, or country of origin. You can allocate material by a simple FIFO or FEFO (first expired, first out) rule at the organization level, picking rules that pick to deplete a location to free up additional warehouse space, or rules to pick by cost group ownership. You can also model customer requirements so a single lot fills an entire order, or warehouse preferences so an item is picked from a single locator.

Task Type Assignment

Task type assignment captures the skill sets and equipment required for a warehouse task so work is assigned to appropriate users. Operators can sign onto a mobile RF device, optionally specifying the equipment available to them. Tasks are assigned to operators based on the operators skill set, equipment requirements and capacity, or the subinventory in which the task occurs. For example, you can assign hazardous tasks to personnel with the appropriate HAZMAT training, and limit put aways to the top racks to operators who signed on with a high-reach forklift.

Cost Group Assignment

Cost groups capture the material valuation accounts necessary for tracking inventory value. For instance, you can set up different accounts for refurbished, consigned, and company-owned inventory. You can also keep different cost groups for different sales channels. When you receive new material into the warehouse the owning cost group must be determined.

Material handlers should not make Cost group decisions. The rules engine automates this decision making, removes complexity from the floor and still provides material valuation accounts tracking. Cost group assignment can be made by inspection results, with a failed item assigned to a Hold for MRB cost group. Cost groups can also be assigned by supplier site, item category, or by item. The system uses default cost group of the items storage subinventory when it cannot find a rule for the transaction.

Label Format Assignment

Compliant labeling is becoming increasingly important, but also increasingly difficult as different customers or carriers may require a different label format. The rules engine can select the appropriate label format based on customer, carrier, item category, or transportation method. These formats are associated with the required information, barcode symbologies, and appropriate layout for each item or container. Additionally, odd sized items may require different label types, or some order types may require weather-resistant labels. The rules engine can print different labels for different freight carriers or shipment types. The rules engine can also select label formats for use inside the warehouse. When you receive lot controlled items, the rules engine can print the appropriate lot stickers automatically.

Operation Plan Assignment

Operation plans determine the routing, packing, and consolidation operations that a task must go through. Some outbound processes may require LPN-based consolidation, whereby the system suggests which LPN to consolidate a delivery into when dropping an LPN in a staging lane, while other deliveries do not use this LPN consolidation. The operation plan selected during task creation controls these options as well as several additional features. The Rule Engine selects the operation plan based on the source subinventory, destination staging lane, customer class, or item type, or any number of different criteria.

Oracle WMS Setup Navigations

24 Dec

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

Define Profile Options
Define Mobile User ID

Navigation:
System Administration>Security>User>Define

Define Warehouse

Navigation:
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
Navigation:
Setup>Warehouse Configuration>Warehouses>Warehouse Parameter

Receiving Options

Navigation:
Setup>Warehouse Configuration>Warehouses>Receiving Parameters

Define Subinventory Attributes

Navigation:
Setup>Warehouse Configuration>Warehouses>Receiving Parameters

Define Stock Locators Attributes

Units, volume, weight, Dimansions, coordinates
Navigation:
Setup>Warehouse Configuration>Warehouses>Stock Locators

Define Dock Door to Staging Lane Relationships

Navigation:
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
Navigation:
Setup>Warehouse Configuration>Warehouses>Shipping Networks

Define Item Attributes for WMS

Lot, Lot Expiration,Serial controlled, Physical attributes and Material Status
Navigation:
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
Navigation:
Setup>Transaction Setup>Inventory Transactions>Material Status

Define Lot and Serial Attributes

Navigation:
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
Navigation:
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
Navigation:
Setup>Material Setup>Items>Master Items
Setup>Warehouse Configuration>Resources>Equipment

Define Equipment Serial Numbers

Navigation:
Setup>Inventory Management>Material Maintenance>Generate Serial Numbers

Define Departments

Navigation:
Setup>Warehouse Configuration>Departments & Resources>Departments

Define Transaction Reasons

Navigation:
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
Navigation:
Setup>Warehouse Configuration>Printing>Define Label Formats

Define Associate Label Formats to Business Flows

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

Assign Labels to Printers

Navigation:
Setup> Warehouse Configuration>Printing>Assign Printers to Documents

Define Cost Groups

Navigation:
Setup>Material Setup>Costs>Cost Groups

Define Account Alias

Navigation:
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
Navigation:
Setup>Warehouse Configuration>Rules>Pick Wave>Pick Slip Grouping

Define Release Sequence Rules

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

Define Release Rules

Navigation:
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
Navigation:
Setup>Material Setup>Items>Container Types

Define Container Items

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

Define Cartonization Groups

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

Define Cartonization Category Sets

Navigation:
Setup>Material Setup>Items>Categories>Category Sets

Define Container Item Relationship

Navigation:
Setup>Material Setup>Items>Define Container Item Relationship

Define Shipping Parameters

Navigation:
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.
Navigation:
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.
Navigation:
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.

Navigation:
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.
Navigation:
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
Navigation:
Setup>MWA Personalization Framework

Oracle SCM Functional Interview Questions: WMS

15 Dec
Are locators mandatory for WMS ?
Ans. 
Yes, Locators are mandatory in WMS
What setup you do to enable WMS for an inventory organization ?
Ans. 
Organization should be WMS enabled in Organization Parameter form.
What is LPN ?
Ans. 
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 ?
Ans: 
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 ?
Ans: 
Pick, Put away, Task Type Assignment, Cost Group Assignment, Label Format, Operational Plan selection
Click here for more
What is pick wave ?
Ans:
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 ?
Ans:
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 ?
Ans:
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 ?
Ans:
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 ?
Ans: 
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.

Oracle WMS: LPN Context

15 Dec

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.

Definition

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.

Pre-generated:

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.

Picked:

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

Oracle Warehouse Management System: License Plate Number (LPN)

15 Dec

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