Stage Financial Statistics

The Data Mart Staged Records functionality allows you to view records that were rejected, and therefore staged, by the system during data upload and conversion from PMS to OXI to ORS/OCIS data marts. These rejected records were staged because they were incomplete or inaccurate. By using the ORS>Data Mart screens you can view these records and their errors, make corrections, and then process them to be uploaded to the appropriate data mart.

Access the Financial Statistics Staged Records screen by selecting ORS>Data Mart>Stage Financial Statistics. This screen displays the property, relevant dates, PMS Confirmation Number and Transaction Code, Market, Status, and Import Date. For specific results, select the Property from the Property LOV and/or the Import Date and select Search.

obi_datamart_financial_statistics_staged

Options

You have several options for working with staged records from the Reservations Daily Statistics Staged Records screen.

Summary. Select this button to open the Error Summary screen (described below) which lists a description of all the errors that occurred while processing the reservations.
Reprocess. After you select Edit (see below) and make corrections to resolve the errors, select Reprocess to refresh the Financial Statistics Staged Records screen with the updated results.
Delete. Select this button to permanently remove the record.
Edit. Select this button to open the Financial Statistics Suspended Record screen (see below) where you can make corrections and reprocess the currently highlighted record (make the change and select the Process button). You can also access the Financial Statistics Suspended Record screen by highlighting the record from the Financial Statistics Staged Records screen and double-clicking.

Financial Statistics Error Summary

This screen is accessed from the Financial Statistics Staged Records screen, when Summary is selected. The Error Summary screen lists a description of all the errors that occurred while processing the reservations.

On the Error Summary screen, highlight the desired error and double-click to access all records having this error. The Financial Statistics Staged Record screen displays where you can correct the record.
To return to the Financial Statistics Staged Records screen, select Close.

obi_datamart_financial_statistics_staged_error_summary

Financial Statistics Staged Record

This screen is accessed from Financial Statistics Staged Records>Edit or from the Error Summary screen when you double-clicked on an error. Here you can change the field highlighted in red, explained in the bottom Error Grid.

Make the change and select the Process button to implement your changes.
When you return to the Financial Statistics Staged Records screen, select the Reprocess button.

obi_datamart_financial_statistics_staged_error