ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A412F6421530508AE053B46B6358EEE4 ECC Application Y select eat.application_name value, eab.application_short_name description from ecc.ecc_application_b eab, ecc.ecc_application_tl eat where eab.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) order by eat.application_name US A412F6DAE15B5127E053B46B635821CD ECC Data Set Y select edt.display_name value, edb.dataset_key||' ('||( select distinct listagg(eat.application_name,', ') within group (order by eat.application_name) over (partition by eadr.dataset_id) application from ecc.ecc_app_ds_relationships eadr, ecc.ecc_application_tl eat where edb.dataset_id=eadr.dataset_id and eadr.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) )||')' description from ecc.ecc_dataset_b edb, ecc.ecc_dataset_tl edt where (:$flex$.ecc_application is null or edb.dataset_id in ( select eadr.dataset_id from ecc.ecc_application_tl eat, ecc.ecc_app_ds_relationships eadr where eat.application_name=:$flex$.ecc_application and eat.language=xxen_util.bcp47_language(userenv('lang')) and eat.application_id=eadr.application_id ) ) and edb.dataset_id=edt.dataset_id and edt.language=xxen_util.bcp47_language(userenv('lang')) order by edt.display_name US A4237D6C8AE57781E053B46B63586B0A ECC Load Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='ECC_LOAD_TYPE_LKUP' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning US A41ECC679A09021CE053B46B6358087A 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.yes(ear.sql_trace_flag) 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 '% Check the log at %' then substr(ead.status_message,1,instr(ead.status_message,' Check the log at ')) else ead.status_message end ds_status_message, case when ead.status_message like '% Check the log at %' then 'HYPERLINK("'||substr(ead.status_message,instr(ead.status_message,' Check the log at ')+18)||'","'||substr(ead.status_message,instr(ead.status_message,' Check the log at ')+18)||'")' end log_file_url, ealr.audit_load_rule_id data_load_rule_id, ealr.status rule_status, xxen_util.time(ealr.seconds) rule_time, ealr.seconds rule_seconds, ealr.procedure_sql_time, ealr.status_message rule_status_message, eald.audit_load_detail_id audit_rule_details_id, eald.sql_query, eald.operation, eald.status detail_status, eald.status_message detail_status_message, xxen_util.time(eald.seconds) detail_time, eald.seconds detail_seconds, eald.total_sql_time, eald.rows_processed, eald.rows_failed, eald.rows_succeed from ecc.ecc_audit_request ear, (select ead.*, (nvl(ead.end_time,sysdate)-ead.start_time)*86400 seconds from ecc.ecc_audit_dataset ead) ead, ecc.ecc_dataset_b edb, ecc.ecc_dataset_tl edt, (select ealr.*, (nvl(ealr.end_time,sysdate)-ealr.start_time)*86400 seconds from ecc.ecc_audit_load_rule ealr where '&show_ealr'='Y') ealr, (select eald.*, (nvl(eald.end_time,sysdate)-eald.start_time)*86400 seconds from ecc.ecc_audit_load_details eald where '&show_eald'='Y') eald where 1=1 and ear.audit_request_id=ead.audit_request_id(+) and ead.dataset_id=edb.dataset_id(+) and edb.dataset_id=edt.dataset_id(+) and edt.language(+)=xxen_util.bcp47_language(userenv('lang')) and ead.audit_dataset_id=ealr.audit_dataset_id(+) and ealr.audit_load_rule_id=eald.audit_load_rule_id(+) order by ear.audit_request_id desc, ead.audit_dataset_id desc, ealr.audit_load_rule_id desc, eald.audit_load_detail_id desc, eald.audit_load_detail_id desc Y AR ECC Admin - Data Load Tracking سجل تشغيل تحميل بيانات Enterprise Command Center ، بما في ذلك الحالة ، وتحميل SQL ورسائل الخطأ المحتملة في حالة الفشل. للحصول على وصف لعملية التحميل ، راجع برامج ECC المتزامنة https://www.enginatics.com/reports/ecc-concurrent-programs/ D ECC Admin - Data Load Tracking Historie des Datenladevorgangs im Enterprise Command Center, einschließlich Status, des Lade-SQL und möglicher Fehlermeldungen bei Fehlern. Zur Beschreibung des Ladevorgangs siehe ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/ E ECC Admin - Data Load Tracking Historial de ejecución de la carga de datos del Centro de Comandos Empresarial, incluyendo el estado, el SQL de la carga y los posibles mensajes de error en caso de fallos. Para la descripción del proceso de carga, véase ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/ F ECC Admin - Data Load Tracking L'historique de l'exécution du chargement des données de l'Enterprise Command Center, y compris le statut, le SQL de chargement et les éventuels messages d'erreur en cas de défaillance. Pour une description du processus de chargement, voir ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/ I ECC Admin - Data Load Tracking Storia dell'esecuzione del carico di dati di Enterprise Command Center, compreso lo stato, il carico SQL e i possibili messaggi di errore in caso di fallimento. Per la descrizione del processo di caricamento, vedere ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/ JA ECC Admin - Data Load Tracking Enterprise Command Center データロードの実行履歴（ステータス、ロード SQL、障害が発生した場合に考えられるエラーメッセージを含む）。 ロードプロセスの説明については、ECC コンカレントプログラム https://www.enginatics.com/reports/ecc-concurrent-programs/ を参照してください。 KO ECC Admin - Data Load Tracking 상태,로드 SQL 및 실패시 가능한 오류 메시지를 포함한 Enterprise Command Center 데이터로드 실행 기록. 로드 프로세스에 대한 설명은 ECC 동시 사용 프로그램 https://www.enginatics.com/reports/ecc-concurrent-programs/를 참조하십시오. PTB ECC Admin - Data Load Tracking Histórico de carga de dados do Enterprise Command Center, incluindo status, a carga SQL e possíveis mensagens de erro em caso de falhas. Para descrição do processo de carga, consulte Programas Concorrentes do ECC https://www.enginatics.com/reports/ecc-concurrent-programs/ RU ECC Admin - Data Load Tracking История выполнения загрузки данных Enterprise Command Center, включая статус, загрузку SQL и возможные сообщения об ошибках в случае сбоев. Описание процесса загрузки см. в разделе ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/. S ECC Admin - Data Load Tracking Enterprise Command Center-datahastningskörningshistorik, inklusive status, last-SQL och eventuella felmeddelanden vid fel. För beskrivning av belastningsprocessen, se ECC-samtidiga program https://www.enginatics.com/reports/ecc-concurrent-programs/ TR ECC Admin - Data Load Tracking Durum, yükleme SQL'i ve arıza durumunda olası hata mesajlarını içeren Enterprise Command Center veri yükleme çalıştırma geçmişi. Yükleme sürecinin açıklaması için bkz. ECC Eşzamanlı Programları https://www.enginatics.com/reports/ecc-concurrent-programs/ US ECC Admin - Data Load Tracking 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/ ZHS ECC Admin - Data Load Tracking 企业指挥中心数据加载运行历史，包括状态、加载SQL和失败时可能出现的错误信息。 关于加载过程的描述，请参见ECC并发程序https://www.enginatics.com/reports/ecc-concurrent-programs/。 Enginatics R12 only &show_eald &show_ealr 1=1 1 10 1=1 ear.audit_request_id=:audit_request_id LOV custom Y select ear.audit_request_id value, ear.start_time||' '||ear.status||': '||(select eat.application_name from ecc.ecc_application_tl eat where ear.param_application_id=eat.application_id and eat.language='en')||' ('||xxen_util.meaning(ear.param_run_load_type,'ECC_LOAD_TYPE_LKUP',0)||')' description from ecc.ecc_audit_request ear where (:$flex$.failed_only is null or ear.status='FAILURE') and (:$flex$.application is null or ear.param_application_id in (select eat.application_id from ecc.ecc_application_tl eat where eat.application_name=:$flex$.application and eat.language='en')) and (:$flex$.running_within_past_x_days is null or ear.start_time>=sysdate-:$flex$.running_within_past_x_days) and (:$flex$.start_date_from is null or ear.start_time>=:$flex$.start_date_from) order by ear.audit_request_id desc F Id. d'exécution US Run Id 2 20 1=1 edb.dataset_id in ( select eadr.dataset_id from ecc.ecc_application_tl eat, ecc.ecc_app_ds_relationships eadr where eat.application_name=:application_name and eat.language='en' and eat.application_id=eadr.application_id ) LOV ECC Application A412F6421530508AE053B46B6358EEE4 Y select eat.application_name value, eab.application_short_name description from ecc.ecc_application_b eab, ecc.ecc_application_tl eat where eab.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) order by eat.application_name US Application 3 30 1=1 edt.display_name=:data_set LOV ECC Data Set A412F6DAE15B5127E053B46B635821CD Y select edt.display_name value, edb.dataset_key||' ('||( select distinct listagg(eat.application_name,', ') within group (order by eat.application_name) over (partition by eadr.dataset_id) application from ecc.ecc_app_ds_relationships eadr, ecc.ecc_application_tl eat where edb.dataset_id=eadr.dataset_id and eadr.application_id=eat.application_id and eat.language=xxen_util.bcp47_language(userenv('lang')) )||')' description from ecc.ecc_dataset_b edb, ecc.ecc_dataset_tl edt where (:$flex$.ecc_application is null or edb.dataset_id in ( select eadr.dataset_id from ecc.ecc_application_tl eat, ecc.ecc_app_ds_relationships eadr where eat.application_name=:$flex$.ecc_application and eat.language=xxen_util.bcp47_language(userenv('lang')) and eat.application_id=eadr.application_id ) ) and edb.dataset_id=edt.dataset_id and edt.language=xxen_util.bcp47_language(userenv('lang')) order by edt.display_name F Ensemble de données US Data Set 4 40 1=1 ear.param_run_load_type=xxen_util.lookup_code(:load_type,'ECC_LOAD_TYPE_LKUP',0) LOV ECC Load Type A4237D6C8AE57781E053B46B63586B0A Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='ECC_LOAD_TYPE_LKUP' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning F Type de charge US Load Type 5 50 1=1 (ear.status='FAILURE' or ead.status='FAILURE' or ealr.status='FAILURE' or eald.status='FAILURE') LOV custom Y select 'FAILURE' value, null description from dual union all select 'SUCCESS' value, null description from dual FAILURE F Statut US Status 6 1=1 ear.status='SUCCESS' SUCCESS F Statut US Status 7 60 1=1 ear.start_time>=sysdate-:days Number select 7 from dual where :$flex$.start_date_from is null and :$flex$.start_date_to is null F Course à pied au cours des x derniers jours US Running within past x Days 8 70 1=1 ear.start_time>=:start_date_from Date F Date de début de US Start Date From 9 80 1=1 ear.start_time<:start_date_to+1 Date F Date de début au US Start Date To 10 90 &show_ealr Y LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y F Afficher les règles de chargement US Show Load Rules 11 100 &show_eald Y LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y F Afficher les SQLs US Show SQLs 12 &show_ealr Y Y F Afficher les SQLs US Show SQLs :$flex$.application Application Run Id :$flex$.ecc_application Application Data Set :$flex$.running_within_past_x_days Running within past x Days Run Id :$flex$.start_date_from Start Date From Y Run Id :$flex$.start_date_from Start Date From Y Running within past x Days :$flex$.start_date_to Start Date To Y Running within past x Days