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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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