Kill session for lock

1. find target session.

SELECT aob.object_name
,aob.object_id
,b.process
,b.session_id,c.SID, c.SERIAL#,c.LOGON_time,c.seconds_in_wait, c.state
FROM all_objects aob, v$locked_object b, v$session c
WHERE aob.object_id = b.object_id
and b.session_id = c.sid


2. delete session.

alter system kill session '<sid>,<serial>'

How to open multiple OAF to work

As an Oracle ERP engineer, we often need to access multi window in OAF to execute job, then below method will help you to get it!

1) make a IE shortcut and edit attribute.
2) put -nomerge in the target bottom.

How to resume PR lines in AutoCreate Documents

It's often to get buyer to request to resume PR lines in AutoCreate Document pool. It could be some reasons like they don't want to group lines or somehow to cancel PO etc..

2 actions to resume:

1:  Clean line_location_id value in po_requisition_lines_all.

2:  Put 'Y' in reqs_in_pool_flag in po_requisition_lines_all. 

Then you will see  they show up in the pool.