AP Invoice Errors

Description
Categories: Toolkit - Setup & Support
Columns: Parent Table, Reject Lookup Code, Creation Date ...
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
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