Deleting Data from the Recognition Staging Tables

If you have administrator permissions, you can delete data from the recognition staging tables. You can do this manually or by a scheduled job. Only old versions of staging data are deleted. The latest version is not deleted.

Notes:

Each time you generate data, previous versions of the staging data can be deleted automatically. This is controlled by the Disable Delete field in the Revenue Management Staging Settings custom setting. By default this field is deselected meaning that old data is deleted automatically when you generate new data.

When using the Recognize All process, staging data is deleted automatically as soon as the process completes, not the next time you run the process.

On rare occasions, a version of staging data might not be deleted even though it is an old version. This can happen when a process using that version of data does not complete (for example, the process is aborted) so the staging version remains locked and cannot be deleted. If this happens, delete the records under the process control record related to the version. This will unlock the version so that it can be deleted.

Deleting Data Manually

When deleting data manually, you can delete all data or data that was generated by particular users.

1. Open the Revenue Management Task Launcher tab.
2. Click Delete Staging Data from the list of actions.
3. From the list of users, choose the users whose data you want to delete. Alternatively you can select all users to delete all data regardless of which user generated it.
4. Click Delete to delete the data.

Setting Up a Schedule

You can schedule the following class to delete data in the recognition staging tables. Data is deleted for all users.

Setup | Custom Code | Apex Classes | Schedule Apex

Class name: StagingServiceDeleteScheduledJob

We recommend that you schedule this process at a time when user activity is low, usually overnight.