Oracle Data Guard Startup & Shutdown Steps 1:05:00 AM Data Guard Shutdown Sequence Stop log apply service or MRP and shutdown the standby SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABAS...Read More
Oracle EBS Workflow ( Requisition , PO and Others) status wait for background process 3:52:00 PMOracle EBS Workflow ( Requisition , PO and Others) Status Wait for background process * If the workflow status stuck in Waiting Backgr...Read More
Step by Step SOA 12c Installation guide 9:07:00 AMStep by Step SOA 12c Installation guide Useful link : https://apps2fusion.com/training_demo/SOA-12c/SOA-12c-Installation-Guide.pdf Than...Read More
Oracle APPS Query to get Instance cloned Date 2:30:00 PM Query to get Instance cloned Date select to_char(CREATION_DATE,'DD/MM/RRRR HH24:MI') from fnd_nodes a ; OR select to_char(resetlo...Read More
ORA-01000 maximum open cursors exceeded 11:37:00 AMWhen youo get this error: " ora-01000 maximum open cursors exceeded " error during the database operation. Then check open_cursor...Read More
Transactions Stuck In MTL_TRANSACTIONS_INTERFACE with lock flag Yes 3:19:00 PM Oracle EBS Oracle Inventory Management - Version 12.2.5 and later: Transactions Stuck In MTL_TRANSACTIONS_INTERFACE with To Locking Iss...Read More