adop issues troubleshooting scripts | ADZDPATCH

[STATEMENT] Checking status of adzdpatch concurrent program [STATEMENT] Status of adzdpatch: [STATEMENT] The concurrent manager to process this request is currently deactivated. Contact your system administrator to reactivate the concurrent manager to allow processing of this request. ==>> Can you share the current adop.log for reviewing the error message to see if there is any change. ==>> See which managers are actually running: SQL> select CONCURRENT_QUEUE_NAME, MAX_PROCESSES, RUNNING_PROCESSES from FND_CONCURRENT_QUEUES where MAX_PROCESSES > 0 order by 1; ==>> Share output of SQL> select count(*) from fnd_concurrent_programs where concurrent_program_name='ADZDPATCH'; SQL> select request_id, status_code, phase_code, concurrent_program_name from fnd_concurrent_requests f, fnd_concurrent_programs fc where status_code='D' and phase_code='C' and f.concurrent_program_id=fc.concurrent_program_id and concurrent_program_name like'%ADZDPATCH%'; SQL> select owner, count(*) from dba_objects where status = 'INVALID' and owner in ('APPS','APPLSYS') group by owner; SQL> select object_name,object_type, owner, status from dba_objects where status = 'INVALID' and object_name like 'FND%'; SQL> select REQUEST_ID , REQUEST_DATE,PHASE_CODE,STATUS_CODE from Fnd_Concurrent_Requests where REQUEST_ID=; ==>>( replace Request ID for the program ADZDPATCH) SQL>select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(55497979) from dual; ==>> This is taken from previous adop.log, you can replace it if there is change in new adop.log