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 www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.
Hello Guys…i ahve been searching for clarity on the difference between Dynamic and Standard Supplier List, I hope you can really help.
ReplyDeleteI believe this is actually the most useful blog I've been through this entire day.Small Business ERP Software
ReplyDeleteThanks a lot for sharing a valuable blog on OA Framework. I was browsing through the internet looking for OAF and Oracle ADF and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can find more information about OAF by attending OA Framework Online Training. You can learn about interview questions by visiting OAF Interview Questions
ReplyDeleteIs 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
ReplyDeleteI value the blog article. Really looking forward to read more. Great.
ReplyDeletelocksmith southfield
Nature of a website relies upon the substance on the grounds that the substance is the part.
ReplyDeleteonohosting.com/