Autoinvoce Performance Problem R12 12.1.3+ RPC3

##Notes:

Troubleshooting AutoInvoice: Process Stops Working, No Errors in Log File (Doc ID 1294898.1)
AutoInvoice Error: Program exited with status 1 (Doc ID 1238437.1)
Troubleshooting AutoInvoice Performance Issues (Doc ID 1089196.1)
How To Setup AutoInvoice For Optimal Performance (Doc ID 1083467.1)

Setting Up System Profile Options For AutoInvoice [ID 1069294.1]
Autoinvoice Master Program Spawns Multiple Concurrent Autoinvoice Import Program [ID 1311477.1]

 Troubleshooting AutoInvoice: Master Program Issues including Errors, Warnings and When No Data Imports (Doc ID 1094863.1)

Troubleshooting Autoinvoice Import - Execution Report Errors (Request Status = Completed) [ID 1089172.1]


Check how log was AutoInvoice Running:

SELECT request_id,
TO_CHAR(request_date,'DD-MON-YYYY') "Date",
RPAD(user_concurrent_program_name,60) "Program Name",
RPAD(argument_text,20) "Arg",
RPAD(TO_CHAR(a.ACTUAL_START_DATE, 'hh24:mi:ss'),10) "Start",
RPAD(TO_CHAR(a.ACTUAL_COMPLETION_DATE, 'hh24:mi:ss'),10) "End",
RPAD(TO_CHAR( (TRUNC(SYSDATE) + ( a.ACTUAL_COMPLETION_DATE - a.ACTUAL_START_DATE)), 'hh24:mi:ss'),10) "Actual",
c.user_name,
status_code "S" FROM applsys.fnd_concurrent_requests a,
applsys.fnd_concurrent_programs_tl b,
apps.fnd_user c
WHERE b.user_concurrent_program_name like 'Autoinvoice Import Program'
AND a.concurrent_program_id = b.concurrent_program_id
AND a.request_date >= '01-Sep-2015'
AND a.requested_by = c.user_id ORDER BY request_id desc;