Essbase 21c is the latest version of Oracle essbase. It is the first release after 11.1.2.4 where Oracle is giving the option of installing on the on-prem machine. New Feature in Essbase 21c New Improved User Interface Essbase 21c has improved the user interface from the Essbase 19c Version. Shadow Application New Improved Outline Editor […]
What is Essbase 21c Read More »
We can find the various patch levels using the table ad_trackable_entities in Oracle Apps R12.2. In this post, we will see How to find ad and txk patch levels, how to check the delta level in r12, how to check fwk in r12.2 Here is the definition of the Table ad_trackable_entities How to find ad
How to find ad and txk patch level Read More »
We may get a failure while running the managed backup on the ExaCS system. Let’s see How to troubleshoot backup Failures in ExaCS (1)Identification of the error We need to first find out what is the error for the backup. We can check those in the backup log files. You can find the backup log
How to troubleshoot backup Failures in ExaCS Read More »
Statistics played in key role in Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the Oracle table involved in the SQL queries. You may want to lock statistics in an Oracle table in some cases, for example There could be many more cases where we want to lock statistics
How to find the table where statistics are locked in Oracle Read More »
We often get in situations where we are Unable to Start Output Post Processor and workflow-related Concurrent Manager. If we check the error in the concurrent manager logs we see the following errors Error in log file : $ cat FNDOPP10587566924.txtUnable to initialize state monitor.oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01403: no data foundORA-06512: at “APPS.FND_CP_GSM_IPC”, line 539ORA-06512: at line 1at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233)at
Unable to Start Output Post Processor and workflow related Concurrent Manager Read More »
In this article, we will check about the various ways Oracle database can be shut down, what things happen during shutdown, How to shutdown the RAC Database Oracle Shutdown steps decoded We can shut down the Oracle database in four ways(i) Shutdown normal(ii) Shutdown immediate(iii)Shutdown abort(iv) Shutdown Transactional sqlplus / as sysdbashutdown Normalsqlplus / as
Oracle Shutdown steps decoded Read More »
