AP Invoice Errors

➜ Back to Library
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 ...  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 rejection. This is quite useful in the Payables Invoice interface.   more
Run AP Invoice Errors and other Oracle EBS reports with Blitz Report™ on our demo environment
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 
apir.creation_date>=sysdate-:days
 Number
Download
Related Blitz Reports
INV Intercompany Invoice Reconciliation AP Payables Open Interface Import- Not Supported: Reserved For Future Use GL Account Analysis (Distributions) 11g GL Account Analysis (Distributions) INV Intercompany by AP Invoice Number Diagnostics PA Supplier Costs Interface Audit GL Account Analysis 11g GL Account Analysis JA India - Open Transactions Report for Prior-GST (XML Publisher)
Blitz Report™

Blitz Report™ provides multiple benefits: