How to rebuild WF_DEFERRED_TABLE_M Queue
Sometimes we need to rebuild the WF_DEFERRED_TABLE_M queue due to corruption. Here are the steps to perform it. (1) First, take a pre snapshot of all the objects related to that queue Login to server and source the EBS environment spool WF_DEFERRED_TABLE_M_objects_pre.lstselect object_name, object_type, status, ownerfrom dba_objectswhere object_name like ‘%WF_DEFERRED_TABLE_M%’;spool off (2) Now we will proceed …
How to rebuild WF_DEFERRED_TABLE_M Queue Read More »
