Cleanup Procedure After Unclear Shutdown of ERP Application Server

Cleanup Procedure After Unclear Shutdown of ERP Application Server

1. Login user apps and run the following SQL :
    connect apps

    select running_processes,max_processes from fnd_concurrent_queues where running_processes>0 or max_processes>0;

    select status_code,phase_code from fnd_concurrent_requests where status_code = 'T';

    If  any result return, please run the following SQL :

    update fnd_concurrent_queues set running_processes=0, max_processes=0;

    commit;

    delete from fnd_concurrent_requests where status_code = 'T';

    commit;

3. Check table fnd_dual :

    select * from fnd_dual;

     DUMMY
    ----------
                 1
                 1

    If retreive more than one row, please run the following SQL :
   
    delete from fnd_dual where rownum < (select max(rownum) from fnd_dual);
 
    commit;