mahonglin123456 发表于 2015-9-23 12:36:37

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 ;
  deletefrom fnd_concurrent_requests;
  select * from fnd_concurrent_processes ;
  select *from applsys.fnd_concurrent_queues t where t.concurrent_queue_idin(1,39); --for update;
页: [1]
查看完整版本: Oracle EBS-SQL (MRP-5):重起MRP Manager.sql