My Oracle Support Banner

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

Last updated on SEPTEMBER 19, 2021

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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