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

Error:

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

Solution:

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