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:
Posts (Atom)