Now you can Subscribe using RSS

Submit your Email

Thursday 15 September 2016

Query to find Locked Object in Oracle Apps R12

How can find Locked Object in Oracle Apps R12 ?or How can find Locked object name and Oracle User name in Oracle Apps R12?

Query 1 -

SELECT b.owner
     , b.object_name
     , a.oracle_username
     , a.os_user_name
FROM   v$locked_object a
     , all_objects b
WHERE  a.object_id = b.object_id

Query 2 -

SELECT c.owner
     , c.object_name
     , c.object_type
     , b.SID
     , b.serial#
     , b.status
     , b.osuser
     , 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;

Query 3 -

SELECT a.session_id
     , a.oracle_username
     , a.os_user_name
     , b.owner "OBJECT OWNER"
     , b.object_name
     , b.object_type
     , a.locked_mode
FROM   ( SELECT object_id
              , session_id
              , oracle_username
              , os_user_name
              , locked_mode
        FROM   v$locked_object ) a
     , ( SELECT object_id
              , owner
              , object_name
              , object_type
        FROM   dba_objects ) b
WHERE  a.object_id = b.object_id;

“A GUIDE FOR ORACLE E-BUSINESS SUITE” – A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on Or Subscribe your email-id on OracleAppsGuide.


  1. Hello Guys…i ahve been searching for clarity on the difference between Dynamic and Standard Supplier List, I hope you can really help.

  2. I believe this is actually the most useful blog I've been through this entire day.Small Business ERP Software

  3. Is Technology Killing Creativity? No that is an impossibility. In fact creativity is more in demand than ever before. There has never been a better time in the history of the world for the average person to express and benefit from creativity. schlüsselnotdienst

  4. I value the blog article. Really looking forward to read more. Great.
    locksmith southfield

  5. Nature of a website relies upon the substance on the grounds that the substance is the part.

    ReplyDelete ©Coprights 2013,