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 …
Read More »Oracle Optimizer: A Practical Guide For a Good Execution Plan
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 …
Read More »Oracle ACE PRO Award To Syed Saad Ali 2025
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 …
Read More »Export & Import Process in Oracle 19c
Export & Import Process in Oracle 19c Container Database (CDB/PDB) In this guide, we’ll walk through how to use the Data Pump (expdp/impdp) utility for export and import when …
Read More »Create Accounting Concurrent Program, Application Erros with ORA-01555: Snapshot Too Old
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 …
Read More »Purge Concurrent Request and Manager Data – Part2
Scheduling Purge Concurrent Request and Manager Data in Oracle E-Business Suite (EBS) : A Step-by-Step Guide To schedule the purging of Concurrent Request and/or Manager Data in Oracle E-Business …
Read More »Purge Concurrent Request and Manager Data – Part1
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 …
Read More »Enable Archive Log Mode in Oracle 19c RAC
How to Enable Archive Log Mode in Oracle 19c RAC Database: Step-by-Step Guide In this article, we will learn how to enable Archive Log Mode in an Oracle 19c …
Read More »Proudly in the Top 100 Oracle Blogs on the Web
Oraclesolutions Ranked Among the Top 100 Oracle Blogs Worldwide Since 2017 I am incredibly proud and excited to share a milestone that means a lot to me and the growing …
Read More »Oracle Database Archive Log Generation Details
Oracle Database Archive Log Generation Details The Blog presents a script designed to query and report on redo log switch history and the size of archived logs in an …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner