Oracle EBS-SQL (MRP-5):重起MRP Manager.sql

UPDATE fnd_concurrent_processes SET process_status_code = 'K' WHERE process_status_code not in ('K', 'S');

UPDATE fnd_concurrent_queues SET running_processes = 0, max_processes = 0;

 

create table fnd_concurrent_requests_bak as ;

delete  from fnd_concurrent_requests;

select * from fnd_concurrent_processes ; 

select *  from applsys.fnd_concurrent_queues t where t.concurrent_queue_id  in(1,39); --for update;