Friday, 13 April 2012

To know the Meaning of WMS LPN Context Value

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

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;