Rejected Expense Report in AP Invoice Interface During “Expense Report Export”

— Following Query gives Rejected Expense Report in AP Invoice Interface During “Expense Report Export” Concurrent Program processing
— This will help to debug issue related to Expense Report Export
— CURSOR c_rejected_invoices(l_request_id IN NUMBER) IS
— Expense Export successful but failed in AP invoice interface upload
SELECT to_number(aii.reference_key1) report_header_id,
reject_lookup_code,
aii.invoice_id
FROM ap_interface_rejections air, ap_invoices_interface aii
WHERE air.parent_table = ‘AP_INVOICES_INTERFACE’
AND air.parent_id = aii.invoice_id
AND to_number(aii.reference_key1) = 693624
— AND aii.request_id = l_request_id
UNION ALL
SELECT to_number(aii.reference_key1) report_header_id,
reject_lookup_code,
aii.invoice_id
FROM ap_interface_rejections air,
ap_invoices_interface aii,
ap_invoice_lines_interface aili
WHERE air.parent_table = ‘AP_INVOICE_LINES_INTERFACE’
AND air.parent_id = aili.invoice_line_id
AND aii.invoice_id = aili.invoice_id
— AND aii.request_id = l_request_id;
AND to_number(aii.reference_key1) = 693624

Thanks Yogesh