Need To Delete Bad Records From The Interface Table Ap_invoices_interface (Doc ID 2710158.1)

Last updated on AUGUST 07, 2024

Applies to:

Goal

On : 11.13.20.07.0 version, Invoice Transactions

Need to delete bad records from the interface table ap_invoices_interface

For one of our vendor sources namely 'XYZ', there are 7 invoices which are tax only invoices and are ending in exception due to which the Import payables invoices job is ending in warning and the corresponding records all remain unprocessed in the staging table with the status NULL.

The Invoice process status is NULL due to which these records donot show up in the invoice correction screen for the business to delete these records.

Customer wants to know how to delete these records 
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.