How To Troubleshoot OID DIP Sync Mapping Problems
Consider the following scenarios: Scenario 1: DIP Import Sync from Active Directory (AD) to OID works for most entries, but fails when a new organizationalunit (ou) entry is added in…
Read More12.2 E-Business Suite Applications Technology Stack Oacore and OAFM Servers Do Not Restart And Are Stuck at State-Admin After Aborting ADOP Session And Restarting The Database / Applications Tiers
During an in progress ADOP patch session applying AD/TXK patch, users reported issues with login attempts to the E-Business Suite instance. To resolve the login issues, the ADOP patch session was…
Read MoreAdmin Server Startup Issue in EBS (R12.2) Must Run On Primary Node
Issue: Error starting Admin Server When we are starting Admin Server, getting below error sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start logs: $EBS_DOMAIN_HOME/servers/AdminServer/logs/AdminServer.log adadminsrvctl.sh should be run only from the primary node Doyensys Cause: Wrong Entry…
Read MoreIntegrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA – Supply Planning Work Area
What is Oracle ADF? Oracle Application Development Framework (Oracle ADF) is an end-to-end application framework that builds on Java EE standards and open-source technologies to simplify and accelerate implementing enterprise…
Read MoreQuery to get source code in database from back end
set verify off set feedback off set lines 300 set pages 0 set heading off set space 0 column text format a79 column line noprint select DECODE(line,1,’create or replace ‘,”)||text,…
Read MoreQuery to get SQL changed Performance
SPO sql_performance_changed.txt; DEF days_of_history_accessed = ’31’; DEF captured_at_least_x_times = ‘1’; DEF captured_at_least_x_days_apart = ‘1’; DEF med_elap_microsecs_threshold = ‘1e4’; DEF min_slope_threshold = ‘0.1’; DEF max_num_rows = ’20’; SET lin 500 ver…
Read MoreQuery to get concurrent Manager status from back end.
SELECT DECODE ( CONCURRENT_QUEUE_NAME, ‘FNDICM’, ‘Internal Manager’, ‘FNDCRM’, ‘Conflict Resolution Manager’, ‘AMSDMIN’, ‘Marketing Data Mining Manager’, ‘C_AQCT_SVC’, ‘C AQCART Service’, ‘FFTM’, ‘FastFormula Transaction Manager’, ‘FNDCPOPP’, ‘Output Post Processor’, ‘FNDSCH’, ‘Scheduler/Prereleaser…
Read MoreRestore the database from AVAMAR backup
As root user in Target Node: Step 1 : /usr/local/avamar/bin/avtar –backups –flagfile=/var/avamar/scripts/my-avtar-flags.txt Make a note of recent Seq in our case it is 124980 . Step 2 : /usr/local/avamar/bin/avtar –list –sequencenumber=124980 –flagfile=/var/avamar/scripts/my-avtar-flags.txt Get the control file name using above command. In our case “11g/PROD/CONTROLFILE.PROD.c-193295451-20170128-00” As Oracle user in Target Node: Step 3 : Step 4 : Create a pfile with db_name=PROD. Step 5 : Start the database in nomount. SQL> startup nomount pfile=’initPROD.ora’; Step 6 : Connect Rman and execute below command RMAN > set DBID=193295451; run{ allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘%d_%U’; send ‘”–prefix=11g/PROD/” “–flagfile=/var/avamar/scripts/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–sysdir=/usr/local/avamar/etc”‘; restore controlfile from ‘CONTROLFILE.PROD.c-193295451-20170128-00’; } #### Control file taken from step 2. Step 7 : SQL> alter database mount; Step 8: RMAN> list backup; Take recent LOW SCN number. 181267677438…
Read MoreHow to activate Periodic Alert Scheduler in Oracle EBS Application
How to activate Periodic Alert Scheduler in Oracle EBS Application Step 1:Login to ORACLE EBS Application HOME PAGE with Alert Manager Responsibility We need to Login the Oracle EBS Application…
Read MoreFORM is not opening after the clone
ERROR: FORM session is not opening after the clone SOLUTION: Go to FORMS node if it is multi node. cd $ORACLE_HOME/lib32 ls -lrt ldflags unlink ldflags ln -s /devweb/oracle/TEST/apps/tech_st/10.1.2/lib32/ldflags ldflags…
Read More