You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!