ECC Admin - Data Load Tracking

Description
Categories: Application, DBA, Enginatics
Repository: Github Columns: Run Id, Load Type, Run Status, Application, Data Set Key Parameter, Language Parameter, Start Time, End Time, Time, Seconds ...
Enterprise Command Center data load run history, including status, the load SQL and possible error messages in case of failures.
For description of the load process, see ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/
select
ear.audit_request_id run_id,
xxen_util.meaning(ear.param_run_load_type,'ECC_LOAD_TYPE_LKUP',0) load_type,
ear.status run_status,
(select eat.application_name from ecc.ecc_application_tl eat where ear.param_application_id=eat.application_id and eat.language='en') application,
nvl((select edb.dataset_key from ecc.ecc_dataset_b edb where ear.param_dataset_id=edb.dataset_id),'All') data_set_key_parameter,
ear.param_languages language_parameter,
ear.start_time,
ear.end_time,
xxen_util.time((nvl(ear.end_time,sysdate)-ear.start_time)*86400) time,
(nvl(ear.end_time,sysdate)-ear.start_time)*86400 seconds,
ear.status_message run_status_message,
xxen_util.meaning(decode(ear.sql_trace_flag,'Y','Y'),'YES_NO',0) sql_trace,
ead.audit_dataset_id audit_data_set_id,
edb.dataset_key data_set_key,
edt.display_name data_set,
ead.status ds_status,
xxen_util.time(ead.seconds) ds_time,
ead.seconds ds_seconds,
case when ead.status_message like