R12:AP: Is There a Script to Delete Payables Open Interface Data For Invoices Not in the Current Period?
(Doc ID 2973263.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
Is there a SQL script that deletes all the Payables Open Invoice Interface headers and lines data except for current period data and new or unprocessed records?
The 'Payables Open Interface Purge' program deletes the data, but not by period.
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 |