Purge Import Tables Job Does Not Work Correctly When Using "Maintenance" Option
We are testing the "Purge Interface Tables" job, as we want to clean up the "Import Payables Invoices" records from the interface tables. I created a BI report over the interface table (AP_INVOICES_INTERFACE) and we have over 500k records, dating back to 2020. We would like to schedule the job to run regularly to maintain the size of the tables.
However, when I run the job selecting "Maintenance" for the "Purge Process Intent" parameter, and entering "365" in the "Number Of Days" parameter, the job does not delete any records from the interface tables, even though we have data back to 2020. It does delete records, when I enter "FBDI" for the "Purge Process Intent" parameter, and a range of Request Id's to purge, but that method will not work if we want to schedule the job and maintain a certain number of days of rolling history.