My Oracle Support Banner

R12: AP: How to Delete Records from the Interface Tables When Running Payables Open Interface Import with Purge Parameter Set to Yes? (Doc ID 2449304.1)

Last updated on DECEMBER 04, 2020

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


According to Oracle Payables User's Guide, when running Payables Open Interface Import with Purge parameter set to Yes, Payables deletes from the Payables Open Interface tables all successfully imported invoice records that match the Source and Group ID of this import.

In this case, which records are deleted from the Interface tables?

 - All successfully imported records including the records existing before running the concurrent request
 - Only the records imported successfully by that concurrent request


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

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

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