接收管理器可用进程不足问题

查可用进程的SQL

 select /*+ ORDERED USE_NL (fa fcp fr fcpp fcq)
            INDEX (fcq,FND_CONCURRENT_QUEUES_N1)
            INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */
       fcpr.*
     from fnd_application fa,
          fnd_concurrent_programs fcp,
          fnd_conc_processor_programs fcpp,
          fnd_responsibility fr,
          fnd_concurrent_queues fcq,
          fnd_concurrent_processes fcpr
        where fcq.processor_application_id = fcpp.processor_application_id
          and fcq.concurrent_processor_id =  fcpp.concurrent_processor_id
          and fcpp.concurrent_program_id = fcp.concurrent_program_id
          and fcpp.program_application_id = fcp.application_id
          and fcp.application_id = fa.application_id
          and fa.application_short_name = 'PO'
          and fcp.concurrent_program_name = 'RCVTPO'
          and fr.responsibility_id = 50703
          and fr.application_id = 401
          and fr.data_group_id = fcq.data_group_id
          and fcq.manager_type = '3'
          and fcpr.concurrent_queue_id = fcq.concurrent_queue_id
          and fcpr.queue_application_id = fcq.application_id
          and fcpr.process_status_code = 'A'
          and fcpr.instance_number = userenv('instance')
         order by DBMS_RANDOM.RANDOM;

select application_id ,T.* from fnd_concurrent_queues T where manager_type = ‘3’;
select queue_application_id,T.* from fnd_concurrent_processes T where process_status_code = ‘A’
AND queue_application_id=201 AND T.CONCURRENT_QUEUE_ID=222;–2018-10-10 16:36:47

        select CONCURRENT_QUEUE_ID, USER_CONCURRENT_QUEUE_NAME, DESCRIPTION, CONCURRENT_QUEUE_NAME, ENABLED_FLAG, RUNNING_PROCESSES, TARGET_PROCESSES
from FND_CONCURRENT_QUEUES_VL
where CONCURRENT_QUEUE_NAME in ('INVMGR','PODAMGR','RCVOLTM');
          

进程自动重启导致可用数量不足需要打补丁

Upgrade 12.1.3: PO Document Approval Manager (POXCON), Receiving Transaction Manager (RCVOLTM) and INV Remote Procedure Manager (INCTM) Do Not Start / Die After Restart (文档 ID 1413393.1)