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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s