FND Concurrent Programs and Executables

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Concurrent programs, executables and program parameters
Run FND Concurrent Programs and Executables and other Oracle EBS reports with Blitz Report™ on our demo environment
select
fcpv.user_concurrent_program_name program,
fcpv.description,
fav.application_name,
fav.application_short_name,
fcpv.concurrent_program_name short_name,
xxen_util.meaning(fcpv.enabled_flag,'YES_NO',0) enabled_flag,
fev.executable_name executable_short_name,
xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method,
fev.execution_file_name,
fcpv.execution_options options,
xxen_util.meaning(fcpv.output_file_type,'CP_OUTPUT_FILE_TYPE',0) output_format,
fcrc.request_class_name type,
fcpv.increment_proc incrementor,
xxen_util.meaning(fcpv.multi_org_category,'CONC_PROGRAM_CATEGORY',0) operating_unit_mode,
case when fcpoi.business_event_map like '%Y%' then fcpoi.business_event_map end business_events,
fcpoi.node_name1 target_node1,
fcpoi.node_name2 target_node2,
fcpoi.connstr1 two_task1,
fcpoi.connstr2 two_task2,
&column_parameters
case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end executable_description,
xxen_util.user_name(fcpv.created_by) created_by,
xxen_util.client_time(fcpv.creation_date) creation_date,
xxen_util.user_name(fcpv.last_updated_by) last_updated_by,
xxen_util.client_time(fcpv.last_update_date) last_update_date,
fcpv.concurrent_program_id
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv,
fnd_executables_vl fev,
(select fdfcuv.* from fnd_descr_flex_col_usage_vl fdfcuv where '&show_parameters'='Y') fdfcuv,
fnd_flex_value_sets ffvs,
fnd_concurrent_request_class fcrc,
fnd_conc_prog_onsite_info fcpoi
where
1=1 and
fav.application_id=fcpv.application_id and
fcpv.executable_application_id=fev.application_id and
fcpv.executable_id=fev.executable_id and
fcpv.application_id=fdfcuv.application_id(+) and
'$SRS$.'||fcpv.concurrent_program_name=fdfcuv.descriptive_flexfield_name(+) and
fdfcuv.descriptive_flex_context_code(+)='Global Data Elements' and
fdfcuv.flex_value_set_id=ffvs.flex_value_set_id(+) and
fcpv.class_application_id=fcrc.application_id(+) and
fcpv.concurrent_class_id=fcrc.request_class_id(+) and
fcpv.concurrent_program_id=fcpoi.concurrent_program_id(+) and
fcpv.application_id=fcpoi.program_application_id(+)
order by
fav.application_name,
fcpv.user_concurrent_program_name,
fdfcuv.column_seq_num
Parameter Name SQL text Validation
Concurrent Program Name like 
upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name)
 LOV
Concurrent Progr. (all languages) 
fcpv.user_concurrent_program_name in (
select
fcpt.user_concurrent_program_name
from
fnd_concurrent_programs_tl fcpt0,
fnd_concurrent_programs_tl fcpt
where
fcpt0.user_concurrent_program_name=:user_conc_name_all_languages and
fcpt0.application_id=fcpt.application_id and
fcpt0.concurrent_program_id=fcpt.concurrent_program_id and
fcpt.language=userenv('lang')
)
 LOV
Concurrent Program Short Name 
upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name)
 LOV
Enabled 
fcpv.enabled_flag=:enabled_flag
 LOV Oracle
Creation Date From 
fcpv.creation_date>=:creation_date_from
 Date
Application Name 
fav.application_name=:application_name
 LOV
Application Short Name 
fav.application_short_name=:short_name
 LOV
Executable Name 
fev.user_executable_name=:executable_name
 LOV
Executable Short Name 
fev.executable_name=:executable_short_name
 LOV
Executable Description 
case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end=:executable_description
 LOV
Execution Method 
fev.execution_method_code=xxen_util.lookup_code(:execution_method,'CP_EXECUTION_METHOD_CODE',0)
 LOV
Execution File Name like 
lower(fev.execution_file_name) like lower(:execution_file_name)
 Char
Output Format 
fcpv.output_file_type=xxen_util.lookup_code(:output_format,'CP_OUTPUT_FILE_TYPE',0)
 LOV
Show Parameters 
Y
 LOV
Parameter Default Type 
fdfcuv.default_type=xxen_util.lookup_code(:parameter_default_type,'FLEX_DEFAULT_TYPE',0)
 LOV
Show Reports only 
(
fcpv.concurrent_program_name in ('RGFSGXML','RGRARG','XXEN_REPORT','') or
lower(fcpv.user_concurrent_program_name) like '% report' or
fev.execution_method_code='P' or
fev.executable_name='XDODTEXE'
) and
fcpv.user_concurrent_program_name not like 'Transfer %' and
fcpv.user_concurrent_program_name not like 'Create %'
 LOV
Download
 
Related Blitz Reports
FND Concurrent Programs and Executables 11i FND Concurrent Requests FND Concurrent Requests 11i FND Flex Value Sets, Usages and Values FND Access Control 11i FND Responsibility Access XDO Publisher Data Definitions FND Responsibility Access 11i PER Organizations
Blitz Report™

Blitz Report™ provides multiple benefits: