APPS DBA

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

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 …

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 …

ERROR The Concurrent Manager fails to start with the Error: The ICM is already running. Contact you system administrator for further assistance.

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.

Enabling About This Page Link in Oracle Apps R12 If You need to Enable About This Page Link in Oracle Apps, you need to set the following Profile Options from …

How to View Concurrent Request Output on Browser Step 1. Go To System Administrator Responsibility select Profile>System     Step 2. Search the Profile option ‘Viewer:%’    Step 3. Set the profile Viewer: …

ERROR ORA-12899: value too large for column “APPLSYS”.”FND_PROFILE_OPTION_VALUES”.”PROFILE_OPTION_VALUE”

Useful Commands For Unix Operating System   1.Deleting files older than N number of days ? find . -name ‘*.trc’ -mtime +[N in days]  -exec rm {} \;   Command will …

Enable/Disable Maintenance Mode without using ADADMIN We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure: Enable Maintenance Mode: $sqlplus apps/appspassword SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE Disable Maintenance Mode: …