AP Invoice Errors
Description
This sql query help you to get Payables invoice interface rejection records. You can get complete details for the rejected records using this sql query. It helps you to understand the invoice rejection reason in the AP invoice interface and can work on this. We cannot get those details in oracle apps but using this sql query we can get the rejected records with the detailed reason for the rejectio ...
more
select parent_table, reject_lookup_code, apir.creation_date from apps.ap_interface_rejections apir where parent_table = 'AP_INVOICES_INTERFACE' and parent_id in (select invoice_id from apps.ap_invoices_interface where 1 = 1) union select parent_table, reject_lookup_code, apir.creation_date from apps.ap_interface_rejections apir where parent_table = 'AP_INVOICE_LINES_INTERFACE' and parent_id in (select apili.invoice_line_id from apps.ap_invoices_interface apii, apps.ap_invoice_lines_interface apili where 1=1 and apili.invoice_id = apii.invoice_id) order by creation_date desc |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Created within days |
|
Number |