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

Questions about purging records from the AP Interface Tables

edited Feb 20, 2025 9:54PM in Payables, Payments & Cash Management 2 comments

We want to purge the AP_INVOICE_INTERFACE Table, using the "Purge Interface Tables" job, as we have data back to 2020. We have the following questions.

  1. We see records in the table with a SOURCE of "CC_EXPENSE_REPORT". Can these be purged or are they necessary for Expense auditing/processing?
  2. Will the Purge Interface Tables job purge REJECTED records, as well as PROCESSED records? If not, how do we purge REJECTED records?
  3. We see records in the AP_INVOICES_INTERFACE table with a blank REQUEST_ID value and -1 in the LOAD_REQUEST_ID. As the PURGE INTERFACE TABLES job requires one of those two values, how can we purge these records?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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