Issue Concurrent Manager Scheduler/Prereleases Manager status is System Hold, Fix Manager in Oracle Apps R12


Issue Concurrent Manager "Scheduler/Prereleases Manager" Show  System Hold, Fix Manager


select control_code 
  from fnd_concurrent_queues 
  where concurrent_queue_name = 'FNDSCH';

It will show 'H' as output

1. Take the backup of table fnd_concurrent_queues table

create table fnd_concurrent_queues_DDMMYYY as select * from fnd_concurrent_queues;

2. Please run the following SQL statement :

SQL> update fnd_concurrent_queues
set control_code = null
where concurrent_queue_name = 'FNDSCH';

SQL> commit;

3. Wait for few minutes before checking, the manager should be working fine.

If you like please follow and comment