AR TCA Import Error
Description
Categories: BI Publisher
Application: Receivables
Source: TCA Import Error Report (XML)
Short Name: ARHLERRPT_XML
DB package: AR_ARHLERPT_XMLP_PKG
Source: TCA Import Error Report (XML)
Short Name: ARHLERRPT_XML
DB package: AR_ARHLERPT_XMLP_PKG
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('AR',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 = 'E' AND fnint.party_orig_system = :p_orig_sys AND e.interface_table_name = 'HZ_IMP_FINNUMBERS_INT' AND e.batch_id = :p_batch_id |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Batch Identifier: |
|
LOV Oracle |