Posts by jayan sellappan

Gather Schema Statistics – Program error with Locks and Duplicate columns

Oracle E-Business Suite Release 12 uses cost–based optimization in order to choose the most efficient execution plan for SQL statements.Gather Schema Statistics is the favourite one among Apps DBA’s and…

Read More

How to open Concurrent Out file in excel format

An *.out file is a compiled executable file created by various source code compilers in Unix-like operating systems, such as Linux and AIX. *.out files are most commonly seen as…

Read More

No Write Permission on ACFS Mount Point

I managed to create the ACFS Mount Point after resolving the issue “ACFS-9459: ASVM/ACFS is not supported on this os version”. But, after creating the ACFS Mount Point, I’m unable…

Read More

GETTING APPLICATION USER PASSWORD IN R12 

Step 1 :   CREATE OR REPLACE PACKAGE get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2; END get_pwd; / Step 2 :…

Read More

RC-00110: FATAL: ERROR OCCURRED WHILE RELINKING OF APPLYDBTECHSTACK

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack Problem: I faced the following error while cloning one of our recently upgraded EBS version from 11.5.10 to 12.1.3 RC-00110: Fatal: Error…

Read More

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 More

12.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 More

Admin 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 More

Integrate 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 More