ECC Admin - Concurrent Programs

Description
Categories: Application, DBA, Enginatics
Repository: Github Columns: Concurrent Program, Short Name, Method, Execution File Name, Incremental Load Request Id, Incremental Responsibility, Full Load Request Id, Full Load Responsibility ...
List of all concurrent programs required to synchronize Oracle EBS data to the Enterprise Command Centers (ECC) Weblogic server, based on Oracle note 2495053.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2495053.1 ...  List of all concurrent programs required to synchronize Oracle EBS data to the Enterprise Command Centers (ECC) Weblogic server, based on Oracle note 2495053.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2495053.1

The report includes all currently scheduled request_ids and responsibilities for incremental and full loads, to check which ones are already scheduled.
The short code can be used as multiple parameter value entry in other reports, e.g. https://www.enginatics.com/reports/fnd-access-control/ to see which responsibilities or users have access to schedule them, or https://www.enginatics.com/reports/fnd-concurrent-requests/ to look at past execution and schedule times.

ECC data is defined by dataset codes, which have a related DB package procedure containing the SQL for each dataset, see:
https://www.enginatics.com/reports/ecc-data-sets/

The individual load progams are all calling child program 'ECC Run Data Load' either for specific datasets or by application, and the program's java executable ECCRUNDL then executes the dataset SQL and transfers the data to the Weblogic server where it is stored in a file structure using Apache Lucene technology https://en.wikipedia.org/wiki/Apache_Lucene
   more
select
y.concurrent_program,
fcpv.concurrent_program_name short_name,
xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method,
fev.execution_file_name,
(
select distinct
listagg(fcr.request_id,'; ') within group (order by fcr.request_id) over (partition by fcr.program_application_id,fcr.concurrent_program_id) request_id
from
fnd_concurrent_requests fcr
where
fcr.argument_text like '%INCREMENTAL_LOAD%' and
(fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R')