Table of Contents

Query to find Responsibility for which Menu / Form Function is assigned To get responsibility based on Menu SELECT DISTINCT a.respon...

Query to find historical blocking sessions We can use either  GV$ACTIVE_SESSION_HISTORY or DBA_HIST_ACTIVE_SESS_HISTORY Query: SELECT DISTIN...

Query to find Form Function attached to which Responsibility Script: SELECT DISTINCT faa.application_name application, rtl.respon...

Query to find the size of Databases on an ASM disk group Assupmtion: All datafiles/redolog/temp files are on ASM. Query: column DATABASE for...

Query to find Concurrent Request Details from Concurrent Program Name Script SELECT    distinct user_concurrent_program...

Query to get list of EBS users with responsibility and last login date (responsibility wise) Script: SELECT     usr.user_name,     rsp.respo...

 frmcmp Module=<pll name> Userid=<userid/password> [Parameters].  Optional parameters with default values given: Mo...

The below query can be used for getting all the details for a scheduled concurrent program. select a.requested_by,a.status_code,a.phase...

In the previous post, we have seen an overview about ADOP . Now we will try to understand Various phases of ADOP in detail. Prepare Phase...

How To Audit  and Monitor An Oracle Applications User in R12 Sign-On:Audit Level allows you to select a level at which to audit users who si...