Concurrent Request Queries   HISTORY OF CONCURRENT REQUEST  (PROGRAM WISE)   SELECT DISTINCT t.user_concurrent_program_name, r.request_id, To_char(r.actual_start_date, ‘dd-mm-yy hh24:mi:ss’) “Started at”, To_char(r.actual_completion_date, ‘dd-mm-yy hh24:mi:ss’) “Completed at”, Decode(r.phase_code, ‘C’, ‘Completed’, ‘I’, ‘Inactive’, ‘P ‘, ‘Pending’, ‘R’, ‘Running’, ‘NA’) phasecode, Decode(r.status_code, ‘A’, ‘Waiting’, ‘B’, ‘Resuming’, ‘C’, ‘Normal’, ‘D’, ‘Cancelled’, ‘E’, ‘Error’, ‘F’, ‘Scheduled’, ‘G’, ‘Warning’, ‘H’, ‘On Hold’, ‘I’, ‘Normal’, ‘M’, ‘No Manager’, …

Oracle Forms Session Queries

RAC Useful Views And Tables GCS and Cache Fusion Diagnostics v$cache contains information about every cached block in the buffer cache v$cache_transfer contains information from the block headers in SGA …

RAC Files and Directories   $ORA_CRS_HOME/cdata/<cluster_name> OCR backups (default location) $ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log OCR command log file $ORA_CRS_HOME/crs/log contains trace files for the CRS resources $ORA_CRS_HOME/crs/init contains trace files for the CRS …

ERROR APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your system administrator.

Real Application Cluster Acronyms GCS Global Cache Services in memory database containing current locks and awaiting locks, also known as PCM GES Global Enqueue Services coordinates the requests of all …

August 2017 Update to E-Business Suite Technology Codelevel Checker (ETCC) By: Steven Chan| Senior Director The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches …

Can Oracle Label Security be Used with EBS 12.2? By: Steven Chan | Senior Director Yes, Oracle Label Security (OLS) can be used with EBS 12.2.  It can also be used for earlier EBS releases …

What’s the E-Business Suite Roadmap for Java? By: Steven Chan | Senior Director Oracle E-Business Suite uses Java.  When discussing EBS’s use of Java, it is important to distinguish between server-side vs. client-side …