Use the Payables Open Interface Purge Program after you submit the Payables Open Interface Import program. This program purges records from the Payables Open Interface tables (AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE). Purge only invoices that you successfully imported, or enter Yes for Purge All to purge all records in the table that match the Source and Group program parameters you enter.
You submit this program from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Source. Choose the source of the invoices you want to purge from the list of values. Use e-Commerce Gateway, Credit Cards, Quick Invoices, Oracle Property Manager, or a Source type lookup you defined in the Oracle Payables Lookups window. The source must exactly match the Source in the Payables Open Interface tables. This parameter is required.
Group. (Optional) To limit the purge to invoices with a particular group, enter the GROUP_ID. If you entered the invoices in the Quick Invoices window, enter the Quick Invoices Batch name. The Group must exactly match the value in the GROUP_ID column in the Payables Open Interface tables. You can purge data in concurrent processes for the same source by specifying a unique Group for each request. This reduces purge process time. The Payables Open Interface Purge Program purges data with the Source and Group combination you specify.
Purge All. Enter Yes to purge all records in the Payables Open Interface tables that match the Source and Group you enter above. These records include successfully imported records, records rejected during import, and records that you have not tried to import yet. Enter No to purge only records that have been successfully imported.