Questions about purging records from the AP Interface Tables
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.
- 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?
- Will the Purge Interface Tables job purge REJECTED records, as well as PROCESSED records? If not, how do we purge REJECTED records?
- 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?
Tagged:
0