top of page

AnalyzeOra
An Insight into the Oracle Tech
1 min read
Query to identify concurrent requests that can't be cancelled.
Have you ever got the below error while cancelling a concurrent request from the front end: Of course, you got it, otherwise you wouldn't...
310
2 min read
After cloning in Oracle EBS R12.2, the SESSION_COOKIE_NAME resulted in Forms being unable to open.
Forms were failing with the below error after cloning Error: Cannot complete application logon. You may have entered an invalid...
520
1 min read
Find a patch that modified a file in EBS R12.2
Retrieve the file details from the apps.ad_files table SELECT file_id, filename, subdir FROM apps.ad_files WHERE filename LIKE...
580
1 min read
Autoconfig failed PLS-00201: identifier 'EBS_SYSTEM.AD_DIR_OBJ_UTIL' must be declared in Database
Autoconfig failed with the below error in one of our Oracle EBS Database instances while cloning. Connected. from ...
3410
1 min read
Autoconfig failed with ORA-04088: error during execution of trigger 'APPS.ALR_FND_PROFILE_OPTIO_0_84
Autoconfig has failed with the below error in Oracle EBS R12.2 during the ADOP patching. ERROR at line 1: ORA-04091: table...
460
1 min read
ADOP was unable to detect an external node in EBS R12.2
Today, a strange issue occurred while cloning our QA env from PROD. We have one admin node, one internal node and two external nodes for...
340
1 min read
How adstrall.sh script works internally in Oracle E-Business Suite12.2
It sets the environment by calling the APPS_contextname.env file it creates log directory and adstral.log file under...
210
8 min read
Oracle EBS Database upgrade 12c to 19c -- Part 1
IMPORTANT Points When upgrading your Oracle E-Business Suite to Oracle Database 19c, your database will be converted to the multitenant...
1130
6 min read
Oracle EBS Database Upgrade 12c to 19c - Part 2
PREPARE for UPGRADE 1. Make sure all are VALID SQL> set pagesize 500 set linesize 300 col COMP_NAME format a40; select...
460
bottom of page