Run the Accounting Hub Maintenance Process to Delete Transactions

Here are the steps to run the Accounting Hub Maintenance process and delete the invalid, unaccounted, or final transactions:

  1. On the Scheduled Processes Overview page, click Schedule New Process.

  2. In the Schedule New Process dialog box, search for Accounting Hub Maintenance, and then click OK.

  3. In the Process Details dialog box, select the mode as Purge invalid transactions, Purge unaccounted transactions, or Purge final accounted transactions.

    Note: You must contact the help desk before you use the Restructure indexes to optimize performance mode.
  4. Next, select the subledger application and ledger.

  5. Click Submit.

Caution: When you submit the Accounting Hub Maintenance process in the Purge unaccounted transactions mode, it deletes all eligible transactions for the ledger and subledger in the program parameter. To avoid unintended deletion of unprocessed transaction, run this process only after all the import accounting transaction and create accounting processes are completed for the ledger and subledger.

What is Deleted

Here's the information that's deleted for eligible transactions in the different modes of the Accounting Hub Maintenance process:

Information

Purge final accounted transactions

Purge unaccounted transactions

Purge invalid transactions

Transaction records in transaction objects

Deleted

Deleted

Deleted

Transaction entity records

Not deleted

Deleted

Deleted

Accounting events including reversal events

Not deleted

Deleted

Deleted

Incomplete accrual reversal journal entries

Not deleted

N/A

Deleted only if the associated accrual entries are also deleted

Invalid journal entries in the primary ledger as well as any reporting currencies and secondary ledgers

N/A

N/A

Deleted

Correcting the Transactions

When you run the Accounting Hub Maintenance process in the Purge invalid transactions or Purge unaccounted transactions mode, the application generates these files:

  • An output file listing the deleted transactions.

  • Two CSV files with transaction header and line details for the deleted transactions.

The layout of the CSV files follows the updated transaction templates. You can review the CSV files, change the source value as needed, and import the accounting transactions again.