Sample Process Messages

Below are some of the process messages based on the parameters defined.

Sample XML File Format

Below is the sample information of the XML file. 

<DataSetReservations>
  <MESSAGE__TYPE>
    <MSSG_CONTENT></MSSG_CONTENT>
    <MSSG_XFRSHIP></MSSG_XFRSHIP>
    <RESERVATION>
      <RESERVATION_RCDID></RESERVATION_RCDID>
      <RESERVATION_XFRSHIP></RESERVATION_XFRSHIP>
      <RESERVATION_XFRSTATUS></RESERVATION_XFRSTATUS>
      <RESERVATION_RCDMODDATE></RESERVATION_RCDMODDATE>
      <RESERVATION_RES_ID></RESERVATION_RES_ID>
      <RESERVATION_PAX_GUID></RESERVATION_PAX_GUID>
      <RESERVATION_TYPE></RESERVATION_TYPE>
      <RESERVATION_CABIN></RESERVATION_CABIN>
      <RESERVATION_CABIN_SHARING></RESERVATION_CABIN_SHARING>
      <RESERVATION_STATUS></RESERVATION_STATUS>
      <RESERVATION_EMBARK></RESERVATION_EMBARK>
      <RESERVATION_DEBARK></RESERVATION_DEBARK>
      <RESERVATION_BOOKINGNO1></RESERVATION_BOOKINGNO1>
      <RESERVATION_BOOKINGCODE></RESERVATION_BOOKINGCODE>
      <RESERVATION_BOOKINGDATE></RESERVATION_BOOKINGDATE>
      <RESERVATION_V_GUESTID></RESERVATION_V_GUESTID>
      <RESERVATION_VIP></RESERVATION_VIP>
      <RESERVATION_GROUP_ID></RESERVATION_GROUP_ID>
      <RESERVATION_ACATEGORY></RESERVATION_ACATEGORY>
      <RESERVATION_PCATEGORY></RESERVATION_PCATEGORY>
      <RESERVATION_PRODUCT></RESERVATION_PRODUCT>
      <RESERVATION_PREPRODUCT></RESERVATION_PREPRODUCT>
      <RESERVATION_CRUISE_FARE></RESERVATION_CRUISE_FARE>
      <RESERVATION_TRAVEL_TYPE></RESERVATION_TRAVEL_TYPE>
      <RESERVATION_PPD_TAG></RESERVATION_PPD_TAG>
      <RESERVATION_OPERATOR></RESERVATION_OPERATOR>
      <RESERVATION_AGENTID></RESERVATION_AGENTID>
      <RESERVATION_CREDITLIMIT></RESERVATION_CREDITLIMIT>
   <RESERVATION_EMBARKPORTCODE></RESERVATION_EMBARKPORTCODE>
   <RESERVATION_DEBARKPORTCODE></RESERVATION_DEBARKPORTCODE>

Refresh Interval

Figure 5–1 below shows the system constantly checks for new records to process every 60 seconds or per a defined interval time.

Figure 16-8 Sample Refresh Interval Messages


This figure shows the sample refresh interval messages logged by DGS.

Delete reservation data older than 60 Days

In the Messages tab, data older than 60 days from the date of modification is removed.

Figure 16-9 Sample Deleted Reservation Message


This figure shows the sample messages of deleted reservation.

Stop update on embarkation day

A message “Update Disable for current embarkation date after x:xx:xx” is added to the ResOnline Data Import log file, when the Stop Update on Embarkation parameter is enabled or when a value is inserted into the field.

Figure 16-10 Sample Stop update on embarkation day message

This figure shows the sample messages of records imported when the Stop Update On Embarkation Day is enabled.

Log SQL statement

The system logs an SQL statement into a log file in C:\Users\Public\Documents\Oracle Hospitality Cruise\ResOnlineDataImportYYYYMMDD.txt if you have the Log SQL Statement checked in Parameter1. You can view the statement from the Debug tab.

Do not update package after guest check-in (B2B)

This parameter updates the booking records based on the selection of the checkbox.as described in the following:

  • If the checkbox is selected and the guest with back to back booking has checked in:

    • It does not process or update the package plan be it new or of the same plan.

  • If the checkbox is deselected and the guest with back to back booking has checked in:

    • It processes and creates a new package plan when new plan is send in and prompts ‘No Changes’ if the plan is the same as previous and without changes.

  • If the checkbox is selected/deselected for back to back booking due to arrive:

    • It creates a new package plan when a new plan is sent in and prompts ‘No Changes’ if the plan is the same as previous and without changes.

Stop process when QCI Offline Sync is enabled

This parameter backs up and restores the latest database to the QCI Shore Database when the parameter is enabled and the QCI Sync Interface is started.

At the point when Quick Check In Synchronizer Ship database mode is in an Enabled status in Offline Mode, the DGS ResOnline Interface status switches to a Pause and resumes when the Offline Mode is Disabled.

Figure 16-11 QCI Synchronization Status


This figure shows the QCI Synchronizer Status when when QCI Offline Sync is Enabled.

Figure 16-12 DGS Pause Mode


This figure shows the DGS Pause Mode when QCI Sync is running

Do not import cruise (SCR), only import cruise details (SCD)

When this parameter is enabled, the system only imports the cruise details excluding the cruise date.

Figure 16-13 Sample Do Not Import Cruise Details Messages


This figure shows the sample import text for Do not import cruise SCR and only import cruise details of SCD.

Only process UCIData with account check in status = 0

Below is the sample message of UCIData when the parameter value of ‘Only Process UCIData With Account Check In Status’ is set to 0 and the option is checked in the application.

Figure 16-14 Sample Message of Only Process UCIData With Account Check In Status


This figure shows the sample message of UCIData when the parameter value of ‘Only Process UCIData With Account Check In Status’ is set to 0 and option is checked in the application.

Number of hours to retry process credit card info

If this parameter is enabled and the Pretty Good Privacy (PGP) Credit number fails to decrypt during the import process, the application will retry to process with the credit card information stored in the credit card buffer based on the hours defined in the parameter.

Figure 16-15 Sample Retry Processing Credit Card Info Messages


This figure shows the sample message of the number of hours to retry decrypting the credit card information.

Stop Reservation Update x Days Before Embarkation

This parameter stops the import of reservation updates based on the number of days defined in the parameter and logs a fail message, ‘Expected Embark date must be x day(s) after the system date.’

For example, the number of days defined before embarkation is three and record with embark date less than or equal to three days after the system date are not imported

Figure 16-16 Sample mMessage on Stop Reservation Update x Days Before Embarkation


This figure shows the sample message of Stop Reservation Update x Days Before Embarkation.

Enable Shore Excursion Language Import

This parameter allows import of excursion booking by Language to prevent the overbooking of tour buses/guide. It applies to the same bookable tour with a different language (ESE_LANGUAGE) and with same external ID (ESE_EXTERNAL_ID)

When this parameter is enabled, the application performs:

  1. A search based on ESE_EXTERNAL_ID + ESE_DATE.

  2. If the search returns no record, then the application searches the next record using the ESE_DATE + ESE_NO.

  3. If no result is yielded, the application reject the import and inserts an error, “tour code is not found” in the record.

  4. If the search returns a record, then the tour code is inserted into the excursion booking table (EPO), regardless of the language set in ESE_LANGUAGES field.

  5. If the search returns more than one record, then the application checks and matches the language in <EXCURSIONS_LANGUAGE> set during import.

  6. If no match is found, the application then searches the Account_Languages.

  7. If it still does not return a matching result, the program then inserts the booking into the first bookable excursion.

Enable Over Weight Bookings Price Increase

This parameter triggers a price increase based on the value set up in Shore Excursion, Overweight Price Increase (either in Value or Percentage). When the import is processing, the system updates the price Gross Price in Shore Excursion. The price increase is based on the EXCURSION_EXTRA_SEAT value set to “W” in the XML file.

Allow Update Flights for Check-In Guest

This parameter disables users from adding, deleting or editing the flight information in the Management and Crew, Flight Information function, and sets it to view only. When the parameter is checked, importing of flight information including checked-in guest is allowed.

Figure 16-17 Sample Allow Update Flights for Check-In Guest


This figure shows the sample message of Allow Update Flights for Check-In Guest.

Do not allow Import Zero Price Shorex/Ticket Prepaid/Prebook Transactions

When this parameter is checked, the system checks for prepaid records that have an empty price in the XML file, and rejects the import and then sets status=Fail.

Figure 16-18 Sample messages Do Not Allow Import Zero Price From Shorex/Ticket Prepaid/Prebook Transactions


This figure shows the sample Do Not Allow Import of Zero Price Shore Excursion, Prepaid Ticket/Prebook Transactions that has empty price value.

Only Update Cruise ID, Department, Net Price and Sales Price For Excursion/Ticket

The system only updates the cruise ID, department, net price, and sales price for excursion when the parameter is selected, and no other changes shall take place. The example below shows the price value has been updated.

Figure 16-19 Sample message of Update Cruise ID, Department ID, Net Price


This figure shows the sample message of Update Cruise ID, Department ID, Net Price when the option is enabled.

Allow Change Excursion/Ticket Date for the same tour

When this parameter is turned on and a date change is made to the same excursion, the system does not create a new booking but update the excursion date with new date sent by the interface.

When the data is sent with the same EPO_VID, ESE_ID=EPO_ESE_ID with different booking date, the EPO_ESE_ID and EPO_SDAT the updated the same record.

Figure 16-20 Sample message of Allow Change Excursion/Ticket Date


This figure shows the sample message of Allow Change Excursion/Ticket Date

Validate ENOAD Data

This parameter validates ENOAD data during import and inserts an import warning if the ENOAD data is found to be missing. You can view the data validation warning from ResOnline Viewer.exe under Import Warning

Allow Update Value to Null

This parameter updates the existing data to null, excluding fields that do not allow null.

Figure 16-21 Sample message of Allow Update Value To Null


This figure shows the sample message of Allow Update Value To Null

Prevent Process Duplicate UCIData

When this parameter is enabled, the system processes the latest UCIData records and ignore the earlier records if multiple records were sent for the same guest. If the parameter is disabled, the system processes all records for the same guest.

Figure 16-22 Sample message of Disabled Prevent Process Duplicate UCIData


This figure shows the sample message of Prevent Process Duplicate UCIData status that set to ‘Disabled’

Allow Field Update for B2B Guest > Embarkation Date

This parameter updates the disembarkation date according to the XML file for guest with back to back bookings that are checked-in. When the expected disembarkation date of the checked-in guest in the XML file is greater than current cruise end date, the system creates the second record. You can view the details of the imported messages with the ResOnline Viewer

Interval to Send Alert e-Mail

This parameter triggers an alert e-mail to the the user based on the Alert e-Mail list defined in Setting Up Alert Email List. If the system finds a record that matches the settings during an import process, a report is generated and sent to the respective user. A message also appears in the Message tab with “xxxxxx Generating Report-ShorexAlertEmail”, followed by “xxxxxx Sending eMail to Shorex Booking (xxxx)”

Enable Update of Shorex/Ticket Bookable and Template

This parameter checks and updates the bookable records x days before the next cruise. For example a price change from 300 to 150 is set in Shore Excursion. During import, the application checks the date to Stop Bookable Update, and updates the price accordingly to the future cruises, where applicable.

This change is reflected in the Shore Excursion, Pricing & Sales tab.

This change also affects the shore excursion bookable and template, and is only applicable to a future cruise. You cannot change the current cruise shore excursion bookable and template.

Figure 16-23 Sample Price Update on Shore Excursion, Ticket Bookable and Template


This figure shows the sample messages for price change update in Shore Excursion, Ticket Bookable and Template, when enabled.