Posts by Ragunathan Kannan

To find the user process_id from EBS Front End R12

Navigate to System Administrator–> Security –> User –> Monitor Note the User Name and Oracle Process ID Now run this sql as &PID=Oracle Process ID &USER_NAME=User Name SELECT SUBSTR(d.user_name,1,30) “User…

Read More

UPGRADE ORACLE APEX FROM 5.0.X TO 18.1

Current Setup : Apex Version : Oracle Apex 5.0 Webserver : ORDS Running on Apache Tomcat 9 DB Version : Oracle 12.2 • Step 1: Download Apex 18.1 from Oracle…

Read More

After Upgrade to 12C utlrp got hang

We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…

Read More