Saturday, October 10, 2015

Oracle R12 Warehouse Management System (WMS) – LPN Contexts:

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



1 comment: