| Oracle Warehouse Management - LPN Context Codes | |
| LPN Context Value | Description |
| 1 | Resides in Inventory |
| 2 | Resides in WIP |
| 3 | Resides in Receiving |
| 4 | Resides in Stores |
| 5 | Pre-generated |
| 6 | Resides in Intransit |
| 7 | Resides in Vendor Site |
| 8 | Packing context, used as a temporary context value |
| 9 | Loaded for shipment |
| 10 | Prepack of WIP |
| 11 | Picked |
Friday, 13 April 2012
To know the Meaning of WMS LPN Context Value
To Know the ONT Released Status Meaning
| Released Status | MEANING | DESCRIPTION |
| B | Backordered | Line failed to be allocated in Inventory |
| C | Shipped | Line has been shipped |
| D | Cancelled | Line is Cancelled |
| R | Ready to Release | Line is ready to be released |
| S | Released to Warehouse | Line has been released to Inventory for processing |
| X | Not Applicable | Line is not applicable for Pick Release |
| Y | Staged/Pick Confirmed | Line has been picked and staged by Inventory |
How to kill the session
/* Formatted on 10-Apr-12 12:42:46 PM (QP5 v5.115.810.9015) */
SELECT c.object_name,
b.sid,
b.serial#,
b.machine
FROM v$locked_object a, v$session b, dba_objects c
WHERE b.sid = a.session_id AND a.object_id = c.object_id
and object_name like 'XXHMI%'--_INV_MAS_PKG_T_EXC%'-- ='MTL_SYSTEM_ITEMS_INTERFACE';
OBJECT_NAME, SID,SERIAL#,MACHINE
MTL_SYSTEM_ITEMS_INTERFACE,2948,7,our12-test.bilt.com
--Solution:-
alter system kill session '2255,371' Immediate;
SELECT c.object_name,
b.sid,
b.serial#,
b.machine
FROM v$locked_object a, v$session b, dba_objects c
WHERE b.sid = a.session_id AND a.object_id = c.object_id
and object_name like 'XXHMI%'--_INV_MAS_PKG_T_EXC%'-- ='MTL_SYSTEM_ITEMS_INTERFACE';
OBJECT_NAME, SID,SERIAL#,MACHINE
MTL_SYSTEM_ITEMS_INTERFACE,2948,7,our12-test.bilt.com
--Solution:-
alter system kill session '2255,371' Immediate;
Subscribe to:
Comments (Atom)