Concurrent Manager Request Status Remains Terminating Indefinitely

Concurrent Manager Request Status Remains Terminating Indefinitely

symptom: Concurrent Manager request status remains terminating indefinitely

cause:  Concurrent manager tables needed to be cleared.

fix: To Clear the Concurrent Manager Tables:

This can be done through SQL*PLUS as APPLSYS using the following commands:

SQL>  update fnd_concurrent_queues

      Set running_processes=0, max_processes=0;

IMPORTANT NOTE:  It is very important to NEVER delete/truncate this table

because this holds all the concurrent manager data

      SQL> delete from fnd_concurrent_processes;

              or

      SQL> truncate table fnd_concurrent_processes;

IMPORTANT NOTE:  It is important to note that ALL processes will be deleted. 

This table keeps track of the processes that the concurrent managers currently

are running. If the concurrent managers are down, there should be no concurrent

manager processes running.  This is the only time it is acceptable to delete

from this table.

     SQL> delete from fnd_concurrent_requests where status_code = 'T';

('T' is for terminating requests and when they are left in this status can

prevent the managers from coming up.)

       

     OR

     SQL> Update fnd_concurrent_requests

                   set status_code = 'X', phase_code = 'C'

                    where status_code = 'T';

a). Set Terminating or Running to Completed/Terminated

SQL> UPDATE fnd_concurrent_requests

SET phase_code = 'C', status_code = 'X'

WHERE status_code ='T'

OR phase_code = 'R'

/

b) Place Pending/(Normal/Standby) to On Hold

UPDATE fnd_concurrent_requests

SET hold_flag = 'Y'

WHERE phase_code = 'P'

AND status_code in ('Q','I')

/

This will change the terminating requests to terminated.

     SQL>delete from fnd_concurrent_requests where status_code = 'C';

This will clean up the completed requests as well.  This will delete all

completed requests. 

The PURGE CONCURRENT REQUEST AND/OR MANAGER DATA report can be used to

reduce the amount of information held in this table.  When the number

exceeds 5000, performance of the concurrent managers can be impacted.

     SQL>select * from fnd_dual;

This table should only contain one row.  If you have more than one row in

this table do the following:  

      SQL> delete from fnd_dual

      where rownum < (select max(rownum) from fnd_dual);

 ++++++++++++++++++++++++++++++++++++++

ID 182575.1

[Understanding Cost Manager [ID 304313.1 & 373207.1]]