ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFF63869E053B46B63588994Y select htb.start_time, to_char(htb.stop_time,'DD-MON-YY') stop_time, htb.resource_id, htb.resource_type, htb.scope, htd.exception_description, htd.transaction_id, ht.transaction_code, ht.transaction_process_id, htd.time_building_block_id, htd.time_building_block_ovn, hrp.retrieval_process_id, ht.transaction_process_id, hrp.name, HXC_HXCRTERR_XMLP_PKG.cf_resourceformula(htb.resource_type, htb.resource_id) CF_resource, HXC_HXCRTERR_XMLP_PKG.CP_employee_number_p CP_employee_number, HXC_HXCRTERR_XMLP_PKG.CP_last_name_p CP_last_name, 'X' dummy from hxc_transactions ht, hxc_retrieval_processes hrp, hxc_transaction_details htd, hxc_time_building_blocks htb where ht.type = 'RETRIEVAL' and htd.status = 'ERRORS' and htd.transaction_id = ht.transaction_id and htd.time_building_block_id = htb.time_building_block_id and htd.time_building_block_ovn = htb.object_version_number and htb.scope = 'TIMECARD' and ht.transaction_code = nvl(:p_transaction_code,ht.transaction_code) and hrp.retrieval_process_id = nvl(:p_retrieval_process,hrp.retrieval_process_id) and ( hrp.retrieval_process_id = ht.transaction_process_id OR ( DECODE( :p_retrieval_process, :p_BEE_RP_ID, -1, -999) =ht.transaction_process_id ) ) and ht.transaction_date between :p_start_date and (:p_end_date + 1 - 1/(24*3600) ) order by htd.time_building_block_id HXC HXCRTERR_XML AR HXC تقرير معالجة خطأ الاسترجاع Application: محرك الوقت والعمالة Source: تقرير معالجة خطأ الاسترجاع (XML) Short Name: HXCRTERR_XML DB package: HXC_HXCRTERR_XMLP_PKG D HXC Abruffehlerbehandlung Application: Time & Labor-Engine Source: Abruffehlerbehandlung (XML) Short Name: HXCRTERR_XML DB package: HXC_HXCRTERR_XMLP_PKG F HXC Etat de traitement des erreurs d'extraction Application: Moteur Time and Labor Source: Etat de traitement des erreurs d'extraction (XML) Short Name: HXCRTERR_XML DB package: HXC_HXCRTERR_XMLP_PKG US HXC Retrieval Error Handling Application: Time and Labor Engine Source: Retrieval Error Handling Report (XML) Short Name: HXCRTERR_XML DB package: HXC_HXCRTERR_XMLP_PKG ZHS HXC 检索错误处理报表 Application: 时间和人工引擎 Source: 检索错误处理报表 (XML) Short Name: HXCRTERR_XML DB package: HXC_HXCRTERR_XMLP_PKG BI Publisher :cp_employee_number :cp_last_name :p_bee_rp_id :p_conc_request_id :p_end_date :p_end_date_dsp :p_retrieval_process :p_retrieval_process_label :p_start_date :p_start_date_dsp :p_transaction_code 1 10 :p_retrieval_process LOV Oracle HXC_RETRIEVAL_PROCESS Y select hrt.retrieval_process_id id, hrt.name value, null description from hxc_retrieval_processes hrt order by value,description Y AR عملية الاسترجاع D Abrufprozess F Processus d'extraction US Retrieval Process ZHS 检索流程 2 20 :p_start_date Date Y US Start_Date 3 30 :p_end_date Date Y US End_Date 4 40 :p_transaction_code LOV Oracle HXC_TRANSACTION_CODE Y select ht.transaction_code id, ht.transaction_code value, null description from hxc_transactions ht where ht.type='RETRIEVAL' and ht.transaction_id in (select max(transaction_id) from hxc_transactions tx1, hxc_retrieval_processes hrp where ((tx1.transaction_process_id= (:$flex$.hxc_retrieval_process) and hrp.retrieval_process_id=tx1.transaction_process_id) or (tx1.transaction_process_id= decode(:$flex$.hxc_retrieval_process ,hrp.retrieval_process_id,-1,-999) and hrp.name='BEE Retrieval Process')) and tx1.status in('SUCCESS','ERRORS') and tx1.transaction_date between to_date(:$flex$.start_date,'YYYY/MM/DD HH24:MI:SS') and (to_date(:$flex$.end_date,'YYYY/MM/DD HH24:MI:SS')+1-1/(24*3600) ) and exists (select 'x' from hxc_transaction_details txd where txd.transaction_id=tx1.transaction_id and txd.status='ERRORS' ) group by transaction_code ) order by 1,2 AR رمز الحركة D Transaktionsschlüssel F Code mouvement US Transaction Code ZHS 事务处理代码