APPS DBA - Oracle Solutions

Fixing OPP Concurrent Manager in System

Fixing OPP Concurrent Manager in System Hold Status Oracle E-Business Suite R12.1.3 (Out-of-Support Environment) While supporting an old customer still running Oracle E-Business Suite R12.1.3, an out-of-support release, I recently …

ADJRIINITPASSWD ORA-01031 Error in Oracle E-Business Suite

Syed Saad December 15, 2025 APPS DBA 0 21

ADJRIINITPASSWD.sql ORA-01031 Error in Oracle E-Business Suite When running ADJRIINITPASSWD.sql, you may encounter an ORA-01031: insufficient privileges error. This typically occurs when Oracle EBS is unable to retrieve password information …

Troubleshooting Workflow Mailer Errors in Oracle E-Business Suite

Syed Saad December 11, 2025 APPS DBA 0 43

Troubleshooting Workflow Mailer Errors in Oracle E-Business Suite The Workflow Mailer in Oracle E-Business Suite is a critical component for sending notifications and driving business processes. When it fails …

Oracle Optimizer: A Practical Guide For a Good Execution Plan

Syed Saad December 6, 2025 APPS DBA 0 42

Oracle Optimizer: A Practical Guide For a Good Execution Plan Have you ever seen a critical SQL query run lightning fast one day and unbelievably slow the next—without a …

java.lang.OutOfMemoryError: GC overhead limit exceeded error while applying Weblogic Patch

Syed Raheel June 26, 2025 APPS DBA 0 43

ISSUE:[oracle@dev bsu]$ sh bsu.sh -prod_dir=/oradb01/apps/fs1/FMW_Home/wlserver_10.3/ -patch_download_dir=/oradb01/apps/fs1/FMW_Home/utils/bsu/cache_dir/ -patchlist=DI8E -verbose -install >> Apply_WLS_DI8E_1.log Exception in thread “main” java.lang.OutOfMemoryError: GC overhead limit exceeded at com.bea.cie.common.dao.xbean.XBeanDataHandler.getValueFromObject(XBeanDataHandler.java:598)[oracle@dev bsu]$ CAUSE:bsu.sh MEM_ARGS needs to be increased or …

EBS 12.2 Application Tier Cloning on DMZ/Secondary App Node error out with Insufficient space in /tmp mount point

Syed Raheel June 24, 2025 APPS DBA 0 44

ERROR:[root@isupplier tmp]# cat /u01/8052/ebiz8052/fs2/inst/apps/ERPPROD_isupplier/admin/log/clone/fmwT2PApply/CLONE2017-01-18_02-03-38AM.errorSEVERE : Jan 18, 2017 2:06:23 AM – ERROR – CLONE-20275 Insufficient space to create /tmp/CLONINGCLIENT-6554959005609214176.SEVERE : Jan 18, 2017 2:06:23 AM – CAUSE – CLONE-20275 Minimum …

Check existing Weblogic patches in EBS 12.2 that are already applied to your existing EBS App Server

Syed Raheel June 23, 2025 APPS DBA 0 27

Follow below Steps: export ORACLE_HOME=$FMW_HOME cd $FMW_HOME/utils/bsu./bsu.sh -prod_dir=$ORACLE_HOME/wlserver_10.3 -status=applied -view [appl8000@demo12 bsu]$ ./bsu.sh -prod_dir=$ORACLE_HOME/wlserver_10.3 -status=applied -viewProductName: WebLogic ServerProductVersion: 10.3 MP6Components: WebLogic Server/Core Application Server,WebLogic Server/Administration Console,WebLogic Server/Configuration Wizard andUpgrade Framework,WebLogic …

Oracle ACE PRO Award To Syed Saad Ali 2025

Syed Saad June 21, 2025 APPS DBA 0 276

ORACLE ACE PRO AWARD 2025 On 5th June 2025, I received an e-mail once more from the Oracle Corporation with the approval of my application to become an Oracle ACE …

Create Accounting Concurrent Program, Application Erros with ORA-01555: Snapshot Too Old

Syed Saad May 1, 2025 APPS DBA 0 229

An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. ORA-01555: snapshot too old: rollback segment number 32 with name “$TEMPUNDOSEG” too small ERROR ———————–XLAACCUP: Accounting Program+—————————————————————————+ Current system time …

Purge Concurrent Request and Manager Data – Part1

Syed Saad April 19, 2025 APPS DBA 0 340

Purge Concurrent Request and Manager Data Program Concept and Effecting Tables Overview To maintain database performance and avoid excessive disk space usage, Oracle EBS provides the FNDCPPUR concurrent program (Purge …