Oracle R12
Warehouse Management System (WMS) – LPN Contexts:
License Plate Number (LPN):
In Oracle Warehouse Management, LPN (License Plate
Number) is an object that holds items in the WMS enabled organization. Although
LPNs are associated with containers, they do not need to represent a physical
entity, such as a box / container. Thus, a collection of items can be defined
in a LPN. A single LPN can contain many quantities of the same item and or
different items.
Oracle Warehouse Management system (WMS) defines a
context for each LPN to denote the current state of the LPN. Some of these
contexts can be used in the WMS Rules Engine to define specialized picking and
put away rules.
The below table summarizes the LPN Contexts:
LPN Context Code
|
Description
|
Definition
|
1
|
Resides
in Inventory
|
An LPN with a context of 1 indicates that material associated with
this LPN has been costed and accounted for in inventory. Outbound
transactions can be performed on LPNs with a context of 1.
|
2
|
Resides
in WIP
|
An LPN with a context of 2 indicates that material associated with
this LPN is currently being transacted in WIP. Therefore, the associated
material is not yet in inventory and has not been costed to inventory.
|
3
|
Resides
in Receiving
|
An LPN with a context of 3 indicates that material associated with
this LPN have been received using a standard routing or inspection routing
receipt and have not been put away yet. Therefore, the associated material is
not yet in inventory and has not been costed to inventory.
|
4
|
Resides
in Stores
|
LPNs with a context of 4 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.
|
5
|
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.
|
6
|
Resides
in Intransit
|
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.
|
7
|
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 a context of 7. Material
associated with LPNs of this context are not on-hand or costed until it is
actually received.
|
8
|
Packing
context, used as a temporary context value
|
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
|
9
|
Loaded
for shipment
|
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.
|
10
|
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.
|
11
|
Picked
|
LPNs picked during the picking process receive this context. They are
intransit within the warehouse.
|
Query to find the context of
a LPN:
select LPN_CONTEXT from
apps.wms_license_plate_numbers WHERE LICENSE_PLATE_NUMBER =:P_LPN_NO
Thanks for giving important information
ReplyDeleteBridge SMSRS