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 AUGUST 14, 2019

Applies to:

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

Goal

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
OR
 - Only the records imported successfully by that concurrent request

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!


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