Applying Patch on EBS Environment using ADOP and Creating a Restore Point for Database if patch fails in Cutover Phase Introduction: As an Apps DBA, applying patches to an E-Business …
Read More »Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request
ERROR The Concurrent Manager fails to start with the Error: The ICM is already running. Contact you system administrator for further assistance.
Read More »How to clean FND_NODES table in Oracle Applications
How to clean FND_NODES table in Oracle Applications Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity. Step 1: Login to Database with Apps …
Read More »How to Change Weblogic Password in Oracle APPS R12.2
How to Change Weblogic Password in Oracle APPS R12.2 Today we will explore how to change Weblogic Admin Password in Oracle E-Business Suite 12.2.x, we will explore 2 different …
Read More »ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ERROR ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors ORA-06508: PL/SQL: could not find program unit being called: “APPS.AP_ACCTG_DATA_FIX_PKG” ORA-06512: at line 38
Read More »The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException
ERROR <Error> <Store> <BEA-280061><The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException: [Store:280105]The persistent file store “_WLS_AdminServer” cannot open file _WLS_ADMINSERVER000000.DAT.
Read More »How to Get Apps Password From Backend
How to Get Apps Password From Backend STEP 1. First login to Database through Command Prompt sqlplus / as sysdba STEP 2 : Create Function From Below Script …
Read More »Oracle E-Business Suite on Autonomous Database on Dedicated Exadata Infrastructure
Oracle E-Business Suite (EBS) Release 12.2 is now certified for Autonomous Database on Dedicated Exadata Infrastructure. Oracle runs best on Oracle. So, running Oracle applications on the Autonomous Database Dedicated …
Read More »How to FIND Oracle EBS R12 Component Versions
How to FIND Oracle EBS R12 Component Versions
Read More »ERROR: ORA-01408 such column list already indexed
ERROR ERROR: ORA-01408 such column list already indexed while upgrading database to 11.2.0.4 using DBUA SOLUTION Prior starting the upgrade drop the index in the SYSTEM Schema drop index system.REPCAT$_AUDIT_COLUMN_IDX1; Start …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner