1. Configuration Guide
  2. Clearing Totals

30 Clearing Totals

If you have the appropriate privileges, you can purge unwanted transaction totals accumulated during testing and training periods prior to going live. Clearing totals immediately purges the totals for all of the designated property’s revenue centers from the Enterprise. You cannot clear totals for individual revenue centers.

The Clear Totals operation performs the following tasks:

  • Immediately purges the property’s transaction totals and check related data on and prior to the selected business date from the Enterprise

  • Initiates a request to run a purge job for the reporting database (Oracle Hospitality Reporting and Analytics Advanced) totals

  • Purges the MRequest Queues data

  • Purges the Journal log file data

  • (Optional) Purges Cash Management data

After the Clear Totals operation begins, two data purging events are scheduled to run for the following purge jobs:

  • Check and Posting Service (CAPS) Database: This event runs first based on the Database Update Frequency setting, plus an additional 30 minutes. When the scheduled time is reached, the application purges the designated property’s CAPS database.

  • Workstation DataStore Data: This event runs second based on the Database Update Frequency setting, plus an additional 45 minutes. When the scheduled time is reached, the application purges the DataStore data from the designated property’s workstations.