Sweep Accounting Hub Transactions to Next Open Period
Sweep unresolved Accounting Hub transactions from a previous accounting period to the next open period.
By sweeping unresolved transactions, you can address outstanding issues in the subsequent period without delaying the period close. Without this feature, you'd need to close the ledger period without accounting for the errored transaction, requiring a manual adjustment post-facto, or risking a loss of transaction traceability. With this capability, you can retain the original transaction for traceability and process it in the next open period after resolving the error.
This feature also enhances the purge invalid transactions and purge unaccounted transactions options by adding a filter to purge by accounting period.
Here are the steps to submit the Accounting Hub Maintenance process in sweep mode:
- Make sure to enable the Purge period filter as described in the Steps to Enable.
- Submit the Accounting Hub Maintenance process with following parameters-
- Select the Mode as Sweep Invalid closed period transactions.
- Select the Subledger Application and Ledger for the invalid transactions that need to be swept to the next open period.
- Choose the Accounting Period as the prior closed period for which Sweep process needs to be executed.
- The Accounting Hub Maintenance process identifies eligible invalid transactions and updates the GL date source to the first day of the next open period. The transactions picked up and updated are listed in the report output for record and audit.
- Submit the Create Accounting process for the next open period.
- The Accounting Period parameter list only displays periods associated with the selected ledger that have the status of Closed or Permanently Closed.
- The Sweep process runs only for the selected ledger. If associated secondary ledgers exist, you must explicitly submit the process for them.
Here are the steps to purge invalid transactions from a prior period:
- Make sure to enable the Purge period filter as described in the Steps to Enable.
- Submit the Accounting Hub Maintenance process with following parameters-
- Select the Mode as Purge invalid transactions.
- Select the Subledger Application and Ledger for the invalid transactions that need to be deleted.
- Select the Accounting Period to delete the invalid transactions.
- The process deletes invalid transactions where transaction dates correspond to the accounting period chosen for the specified ledger and subledger application.
Here are the steps to purge unaccounted transactions from a prior period:
- Make sure to enable the Purge period filter as described in the Steps to Enable.
- Submit the Accounting Hub Maintenance process with following parameters-
- Select the Mode as Purge unaccounted transactions.
- Select the Subledger Application and Ledger for the invalid transactions that need to be deleted.
- Choose the inbound datafile to purge all unaccounted transactions for the selected ledger. Use this parameter if the datafile needs reprocessing.
- Specify the Accounting Period to purge unaccounted transactions for a particular period. Use this parameter when the unaccounted transactions from a prior period are no longer required to be processed for accounting.
- The process deletes unaccounted transactions where transaction dates correspond to the accounting period chosen for the specified ledger and subledger application.
- Maintains the original transaction for traceability and granularity.
- Promotes data hygiene and maintenance of accounting data.
- Allows business proper error root cause resolution without affecting period close.
Steps to Enable
Here are the steps to enable sweep invalid closed period transactions:
- Navigate to Manage Standard Lookups Task.
- Search for Lookup type ORA_ERP_CONTROLLED_CONFIG.
- Create lookup code XLA_36373252.
- Enter Meaning as Sweep Invalid closed period transactions.
Once enabled, the parameter From Accounting Period will be enabled.
Here are the steps to enable purge invalid and unaccounted transactions by period:
- Navigate to Manage Standard Lookups Task.
- Search for Lookup type ORA_ERP_CONTROLLED_CONFIG.
- Create lookup code XLA_36730127.
- Enter Meaning as Purge Invalid and Unaccounted Transactions By Period.
Once enabled, the additional parameter Accounting Period will be enabled.
Tips And Considerations
Here are some considerations:
- This is not supported for multi-period accounting entries.
- This does not modify the GL date source for the reversal of any accrual accounting entry.