1 System Parameter
This section describes the parameters required to run the DGS ResOnline module.The parameters are set up in Administration, System Setup, Database Parameter.
Table 1-1 PAR Group General
PAR NAME | PAR VALUE | Description |
---|---|---|
Allow overwrite posted pre posting |
0 – Disable 1 – Enable |
0 - Do not allow update PPS when PPS_POS_ID > 0 1 - Allow Update PPS when PPS_POS_ID > 0 and POS_CLOSED=0 |
Number of day(s) before embarkation alert |
Number of day(s) |
The system sends an alert e-mail for change less than x days before embarkation |
Interface Parameters
Apart from enabling the above system parameters, the program also requires interface parameter settings to further define and manage the information to be transferred to Oracle Hospitality Cruise Shipboard Property Management System (SPMS). The interface parameters are categorized into three sub-tabs in the DGS ResOnline, Settings tab.
-
Parameters: All settings for data transfer from Oracle Cruise Hospitality Fleet Management System (FMS). See Table 1-2 for detailed description of the parameters.
-
Parameters 1: All settings for data transfer from FMS (continuous).
-
Alert E-Mail List: An alert email list to inform user of the transferred reservation status.
The information transferred from FMS to SPMS depends on the settings.
Figure 1-1 DGS ResOnline Parameters
![This figure shows the DGS Resonline Parameters and Parameters 1 tabs. This figure shows the DGS Resonline Parameters and Parameters 1 tabs.](img/dgs_resonline_parameters_tab.png)
Table 1-2 DGS ResOnline Parameters
Parameter | Description |
---|---|
Refresh interval by seconds |
The intervals time to obtain new data to transfer if any. Default minimum interval is 15 seconds. |
Delete reservation Data Older than x days |
Minimum setting is seven days based on the following process:
|
Stop Bookable Update x days(s) before next cruise start |
This stops any shore excursion and bookable ticket update x days before the start of next cruise. This change only affects shore excursion bookable and templates for future cruise. |
Interval to send alert email (in minutes, 0=disable) |
Define the interval to send an alert email, based on email list defined in ‘Alert e-mail List’ tab. 0 = disable send alert email. |
Stop Update on Embarkation Day (Ctrl+Del to clear and disable) |
Define the time to stop an update on embarkation day. Press Ctrl+Del to clear the time value. |
Do not update package after guest check-in (B2B) |
This stops the update of package for checked-in guest, and is only applicable to back to back guest. |
Enable Update of Shorex/Ticket Bookable and Template |
This allows update of shore excursion/bookable ticket tour and template. This rule depends on the “Stop Bookable update x day(s) before next Cruise start.” |
Multiply Pre-posting Quantity to Unit Price |
This multiplies the pre-posting quantity by unit price for input to PPS_TOTAL field. Requires additional configuration in Administration module, Database parameter. |
Stop Process When QCI Offline Sync is enable |
This function pauses the ResOnline updates when the QCI Offline Sync process is enabled and resume when QCI Offline Sync stop is running. |
Do not import cruise (SCR), only import cruise details (SCD) |
This flag is to only import System Cruise Days Information, excluding Cruise Itineraries. |
Only process UCIData with account_checkin_status = 0 |
This flag only processes UCIData with status Registration that is not complete. ACCOUNT_CHECKIN_STATUS=RES_RGN_COMPLETE |
Number of hours to retry process credit card info |
Define number of hours to retry processing of credit info in DGS. |
Stop Reservation update x days before embarkation |
Stops reservation update x days before of embarkation date. |
Log Changes into chglog |
Log changes made into change log table. |
Enable Shore Excursion Language import |
This enables the import of language from Shore Excursion. |
Enable Over Weight Bookings Price Increase |
This enables price increase by percent set in Overweight Booking.parameter |
Allow Update Flights for Check-In Guest |
This enables the flight info update for Check-In Guest. |
Do not allow import zero price shorex/ticket prepaid/prebook transactions |
This disables the import of prepaid/pre-book transactions Shore Excursion with zero pricing. |
Only update cruise id, department, net price and sales price for excursion/ticket |
This only allow updates of cruise ID, department, net price and sales price for excursion only. |
Allow Change Excursion/Ticket Date for the same tour |
This enables changes made to tour/ticket of the same record even though the booking date is different. |
Validate ENOAD Data |
When enabled, the system validates the Electronic Notice of Arrival/Departure (ENOAD) data during import, and inserts as Import Warning if any of the ENOAD data is missing. The ENOAD data validation warning is viewable from ResOnlineViewer application, Import warnings. |
Allow Update Value to NULL |
This allows the change of Excursion or Ticket Date for the same tour. |
Prevent process duplicate UCIData |
This enables the update of value to null when the flag is checked. |
Allow Field Update for B2B Guest : Disembarkation Date |
This enables the additional fields to be updated for back to back guest, even after guest has checked in. |
(MSSG_NOTES)
using ResOnline and
they are:
-
UCIData - Reservation record
-
ReservationsData - Reservation record
-
DataDefinition - All field settings in Shore Excursion and Ticket description.
-
ItinData - Cruise Itinerary
-
CAMVisitor - Visitor Info
-
SPMSConfig - SPMS Configuration setup
-
Transferstatuslog - Summary of Transaction status
-
OHCEVENT - Field setting used in Event module
The reservation messages in(RESERVATION_MSGS)Table
is updated with one of the following statuses after a successful
import.
-
MSSG_STATUS = 2 (New record that ResOnline processes)
-
MSSG_STATUS = 3 (Successfully processed)
-
MSSG_STATUS = 5
(RESERVATION_RES_ID in XML <> RESERVATION_RES_ID in RESERVATION_MSGS table)
-
MSSG_STATUS = 6 (Current reservation is older than previous, request for resend)
-
MSSG_STATUS = 7 (No Future cruise created in system)
-
MSSG_STATUS = 8 (Failure)