Queries For Oracle Interface Errors Records.
Below are the queries to get the error records information while processing interface data. AP Invoices: SELECT airl.last_update_date process_date, HU.NAME, nvl(ail.invoice_line_id,aii.invoice_id) process_id, 'AP' module, 'Import AP Invoice' interface_name, aii.source source, NVL(SUBSTR( ail.dist_code_concatenated,1,instr(ail.dist_code_concatenated,'.',1,1)-1),'ALL') company, 'ERROR' status, ail.line_type_lookup_code , airl.parent_table , ail.description , NVL(ail.distribution_set_name,dist_code_concatenated) , pvsa.vendor_site_code , listagg(NVL(airl.reject_lookup_code,'AP_INV_ERROR') ,';') within group (order by NVL(airl.reject_lookup_code,'AP_INV_ERROR')) error_code, listagg(flv.meaning,';') within group (order by NVL(flv.meaning,'AP_INV_ERROR'))error_summary, NULL error_details, pv.vendor_name , pv.segment1 , aii.invoice_amount, aii.i