[ERROR] ETCC not run in the database node
12.2 adop cleanup fails with the following error : ERROR : ———————– Validating system setup. Node registry is valid. [ERROR] ETCC not run in the database node The EBS Technology…
Read MoreEBS R12 login console blank Page – no Error messages
When we get a blank page after we enter the credentials and it doesn’t show any error or message on the page Please check the OAcore’s application.log and if the…
Read MoreProgram to extend the customer sites into the multiple orgs.
Objective: The below code logic is used to extend the customer sites into the different org. (eg. Suppose customer sites exist in 82 org and the requirement is to extend…
Read MoreSQL QUERY TO FIND THE CUSTOM FORMS , FORM PERSONALIZATION AND CUSTOMIZED CONCURRENT PROGRAMS
custom forms: select COUNT(*) from apps.fnd_form_vl where form_name like ‘XX%’ custom form personalization: SELECT ffcr.form_name, ffft.user_function_name “User Form Name”, ffcr.SEQUENCE, ffcr.description, ffcr.rule_type, ffcr.enabled, ffcr.trigger_event, ffcr.trigger_object, ffcr.condition, ffcr.fire_in_enter_query, (SELECT user_name FROM…
Read MoreORDS (Oracle Rest Data Service) Installation for Standalone Database
MAKE DIRECTORY: mkdir /u01/ords cd /u01/ords unzip ords.3.0.9.348.07.16.zip sqlplus / as sysdba select value from v$parameter where name like ‘%service_name%’; cp ords.war ords.war_bkp mv ords.war apex.war BACKUP THE PARAMETER FILE:…
Read MoreFind the list of Patches from a Merged Patch
SQL> SELECT applied_patch_id, patch_name, patch_type,LAST_UPDATE_DATE from applsys.ad_applied_patches where PATCH_NAME=’1809065289′; APPLIED_PATCH_ID PATCH_NAME PATCH_TYPE LAST_UPDATE_DATE ————————— ——————- ——————— ————————— 370789 …
Read MoreAutoconfig Pre-requisites after cloning in R12.2
These steps are used to avoid the autoconfig phas error in R12.2 Steps:login as applsys user conn applsys/*********** Backup the following Tables. create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;…
Read MoreFloating /Fixed scrollbar in Oracle APEX Classic report
Introduction This blog explains to create floating/Fixed scrollbar for Classic report in Oracle APEX Paste the below code in “Execute when Page Loads“ $(function($) { var scrollbar = $(‘<div id=”fixed-scrollbar”><div></div></div>’).appendTo($(document.body));…
Read MoreScript to check the Highest SQL Wait Time using Active Session History (ASH)
Below sql script to check the Highest SQL Wait Time using Active Session History (ASH) col session_id for a10 col session_serial# for a10 col session_state for a20 SELECT h.session_id, h.session_serial#,…
Read MoreScript to see if any Debug or Trace profile options have been set to Y in Oracle ERP application.
Below sql script to check if any Debug or Trace profile options have been set to Y in Oracle ERP application, select distinct a.application_short_name app_short, user_profile_option_name optname, decode(level_id, 10001,’SITE’, 10002,’APP…
Read More