Oracle Concurrent Program

Oracle Reports are executed as concurrent programs.

To find the executable used in the concurrent program:

select pt.user_concurrent_program_name
, p.concurrent_program_name
, p.execution_method_code
, e.executable_name, E.EXECUTION_FILE_NAME
from applsys.FND_CONCURRENT_PROGRAMS P
inner join applsys.FND_CONCURRENT_PROGRAMS_TL PT
ON PT.APPLICATION_ID =P.APPLICATION_ID
AND PT.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
and PT.LANGUAGE='US'
inner join applsys.FND_EXECUTABLES E
on p.Executable_ID = E.Executable_ID
and P.APPLICATION_ID = E.APPLICATION_ID
where 1=1
-- and p.CONCURRENT_PROGRAM_NAME like 'FA%' 
and  p.application_id = 140
-- and rownum <10
--and pt.user_concurrent_program_name like '%Asset%'
order by 1

;

The meaning of the execution method:

Select  LOOKUP_CODE, MEANING from fnd_lookup_values where LOOKUP_TYPE='CP_EXECUTION_METHOD_CODE';