<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: AR TCA Import Error -->
 <REPORTS_ROW>
  <GUID>82288223EE963869E053B46B63588994</GUID>
  <SQL_TEXT>SELECT
fnint.party_orig_system_reference    fnposr,
fnint.type_of_financial_report       fn_rep_type,
fnint.document_reference             fn_doc_ref,
fnint.date_report_issued             fn_dt_rep_issued,
fnint.issued_period                  fn_issued_period,
fnint.report_start_date              fn_rep_st_dt,
fnint.report_end_date                fn_rep_end_dt,
fnint.financial_number_name          fn_fin_no_name,
HZ_UTILITY_V2PUB.get_message(&apos;AR&apos;,e.message_name, 
e.TOKEN1_NAME, e.TOKEN1_VALUE, e.TOKEN2_NAME, e.TOKEN2_VALUE, 
e.TOKEN3_NAME, e.TOKEN3_VALUE, e.TOKEN4_NAME, e.TOKEN4_VALUE, 
e.TOKEN5_NAME, e.TOKEN5_VALUE) fnint_error_message
FROM   HZ_IMP_ERRORS e, HZ_IMP_FINNUMBERS_INT fnint
WHERE  fnint.ERROR_ID = e.ERROR_ID
AND  e.batch_id     = fnint.batch_id 
AND  fnint.INTERFACE_STATUS  = &apos;E&apos;    
AND  fnint.party_orig_system = :p_orig_sys
AND  e.interface_table_name  = &apos;HZ_IMP_FINNUMBERS_INT&apos;    
AND  e.batch_id     = :p_batch_id
</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <XDO_APPLICATION_SHORT_NAME>AR</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>ARHLERRPT_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>AR تقرير أخطاء استيراد TCA (بتنسيق XML)</REPORT_NAME>
    <DESCRIPTION>Application: المقبوضات
Source: تقرير أخطاء استيراد TCA (بتنسيق XML)
Short Name: ARHLERRPT_XML
DB package: AR_ARHLERPT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>AR TCA-Importfehler</REPORT_NAME>
    <DESCRIPTION>Application: Debitoren
Source: TCA-Importfehler (XML)
Short Name: ARHLERRPT_XML
DB package: AR_ARHLERPT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>AR Importation TCA - Etat des erreurs</REPORT_NAME>
    <DESCRIPTION>Application: Receivables
Source: Importation TCA - Etat des erreurs (XML)
Short Name: ARHLERRPT_XML
DB package: AR_ARHLERPT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>AR TCA Import Error</REPORT_NAME>
    <DESCRIPTION>Application: Receivables
Source: TCA Import Error Report (XML)
Short Name: ARHLERRPT_XML
DB package: AR_ARHLERPT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>AR TCA 导入错误报表</REPORT_NAME>
    <DESCRIPTION>Application: 应收帐款
Source: TCA 导入错误报表 (XML)
Short Name: ARHLERRPT_XML
DB package: AR_ARHLERPT_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>:p_batch_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_batch_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_cre_dt</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_cre_dt1</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_load_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_orig_sys</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_tot_b_rec</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_tot_rec_imp</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_batch_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>HZ_IMP_ERRPT_BATCH_ID</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
batch_id id,
batch_id value,
null description
from
hz_imp_batch_summary bs,hz_orig_systems_b os
where bs.original_system=os.orig_system
and bs.batch_status&lt;&gt;&apos;PURGED&apos;
and bs.import_status in (&apos;COMPL_ERRORS&apos;,
&apos;COMPL_ERROR_LIMIT&apos;,
&apos;ERROR&apos;,&apos;COMPLETED&apos;)
and bs.main_conc_status&lt;&gt;&apos;PROCESSING&apos;
order by bs.last_update_date desc</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>معرف المجموعة:</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Stapelkennung:</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Identifiant du lot :</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Batch Identifier:</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>批标识：</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
