Follow recommended best practices to obtain optimal results from purging transactions.
When transactions are being purged for a Match Type, the Match Type is locked and operations such as importing transactions, matching transactions manually, running Auto Match are not allowed. Therefore, it is recommended that you purge transactions outside of business hours.
Purging Transactions for the First Time
If this is the first time you are purging transactions in your application, you must open a Service Request with Oracle Support. Oracle Support will assess your application and outline the steps you need to take.
Oracle Support will advise you on the right approach based on the following factors:
- Volume of transactions to be purged
- Shape of your data
Oracle recommends that you clone your production instance to your test instance, and then purge transactions on your test instance first. The learnings from this exercise will help you purge transactions on your production instance.
Prerequisites for Purging Transactions on the Test Instance
- Raise a Service Request with Oracle Support.
- Backup your test instance. See Create Backup of the Environment in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.
- Clone your production instance into your test instance. See Cloning EPM Cloud Environments in Administering Migration for Oracle Enterprise Performance Management Cloud.
Steps to Purge Transactions on the Test Instance
- Perform a backup of your application.
Oracle support will advise you on the following:
appropriate age of matched transactions to be selected for the purge operation
This is based on the volume of transactions that needs to be purged.
batch size setting on configuration
The default is 200,000. However, this may vary based on the shape of your data.
window to perform this process
This should not overlap with the Daily Maintenance process (see Setting Daily Maintenance in Getting Started with Oracle Enterprise Management System for Administrators. You can choose to change this setting before purging transactions and then restore the setting after the transactions are purged.
- Assess the count of matched transactions that you would purge. You can do this using the Transactions tab in Transactions Matching or through BI Publisher reports. This count can be verified after purging transactions. See Searching Transactions in Transaction Matching.
- Purge the transactions.
- Make note of the time taken for each step in the process.
Based on these learnings, purge transactions in your production instance.
Purging Transactions at Regular Intervals
After you purge transactions for the first time, Oracle recommends that you purge transactions at regular intervals. You can automate this process through EPM Automate. See purgeTmTransactions in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.
Steps to Purge Transactions at Regular Intervals
- Apply the learnings from the purge process performed on the production instance.
- Test your automated purge schedule on your test instance with the recommended settings.
- Deploy the automated purge schedule on your production instance.