Stage Reservation Summary Log

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 Reservation Summary Staged Records screen by selecting ORS>Data Mart>Stage Reservation Summary Log. This screen displays the property, the reservation ( R ) or Block ( B ) ID, and relevant dates of the staged record. For specific results, select the Property from the Property LOV and/or the Import Date and select Search.

obi_datamart_resv_summary_log_staged

Options

You have several options for working with staged records from the Reservation Summary 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 Reservation Summary Staged Records screen with the updated results.
Delete. Select this button to permanently remove the record.
Edit. Select this button to open the Reservation Summary 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 Reservation Summary Suspended Record screen by highlighting the record from the Reservations Summary Staged Records screen and double-clicking.

Reservation Summary Error Summary

This screen is accessed from the Reservation Summary 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 the to access all records having the error. The Reservation Summary Staged Records screen displays where you can correct the record.
To return to the Reservations Summary Staged Records screen, select Close.

obi_datamart_resv_summary_log_staged_error_summary

Reservation Summary Suspended Record

This screen is accessed from Reservation Summary Staged Records>Edit or from the Error Summary screen when you double-click 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 Reservations Summary Staged Records screen, select the Reprocess button.

obi_datamart_resv_summary_log_staged_error