11 Reservations Online

The Reservation Online module ensures the data gets transferred from the reservation system to the ship side without any manual intervention, and this would require fields to be mapped for accuracy. See Document ID 2575588.1 Oracle Hospitality Cruise Fleet Management OHC ResOnline to SPMS Mapping and Specifications for more information.

The standard and the main responsibilities of this module are:

1. Homogenize the otherwise distinct source data from the external reservation systems and render it compatible with the SPMS data structures.

2. Compose the entire passenger's reservation into a composite business object entity and deliver it to the corresponding vessel within the correct deliverable date range.

3. Repository for audit activities from FMS.

Figure 11-1 Cruise Reservations Online

General Setup

This section explains the setting up of general parameters like the data path , data transition states flags, and others.

Figure 11-2 General Parameters

Reservation Online application logging has two logs files:

1. ExceptionLog.txt
2. Log.txt

The ExceptionLog.txt files are backed up with date-time stamp once it reaches 5MB size, and Log.txt file are overwritten.

Ships Decode

This set up is needed to convert ships code from Polar to the equivalent FM codes. Also, it enables you to assign several sets of ships to different processing machines for load balancing. Some sections of the vessel decoding are for the main Reservation Online application use only.

Figure 11-3 Ships Decode set-up

Data Processing

During Data Processing, the application gathers records from the external source and proceeds to insert or update corresponding records in the target tables as configured in the data mapping. This process proceeds the data in the way the Reservation Online can deliver the data to SPMS.

Figure 11-4 Data Processing

To process credit card data, you need to have both the SPMS and FMS Key pair.

See Encryption Manager section for more information.

Source Data Filtering

When processing the source data such as Passenger's Air flights, different types of addresses, Special Requests, or Gift Orders, the application needs to filter only the specifically required data from the same source.

A logical target column called DATA_FILTERS enables you to create a combination of data filtering rule for each one of the source and target that requires it. For example, the first record combination instructs the application to extract only flights data where the source field PAX_CARRIER5 is not empty when processing data for the target table FLIGHTS and detects that the source fields set contains the field PAX_FROM_AIR5

See topic Reservations Online

Reservations Messaging Process

This process select the records from the internal schema that stores the transformed reservations data processed before, and then converts the data into an XML message that is delivered to the respective ships by FMS Sender and Receiver.

Once the left panel is visible, you can view all the messages and their respective XML text by scrolling the batch list.

Interface - Import Reservations To The Ship Database

To send and receive reservations and statuses, FMS Sender/Receiver and MSMQ are used alongside with the OHC DGS ResOnline interface for data import to SPMS. This interface imports reservation provided by FM Transfer, and then sends back a status for each record to the shoreshide.

Reservation Status

The FMS Reservation Online module controls the dataflow status.

Table 11-1 FM Reservation Online module

Status	Description
Passenger Manifest	Shows all reservations imported and processed, together with their ship import statuses.
FM Dashboard ResOnline Transfer Status	Provides quick data of how many reservations we currently have to send per ship and how many have status Pending (not processed onboard yet).
Transfer Status	Detailed grid shows how many reservations were loaded, processed, transferred, imported and pending.
Loading Status Grid	External files upload status. Provides an overview of daily upload process.
Ship Response Messages	Allow seeing the complete ship import history of each individual reservation.
Reservations Status SPMS Viewer	In SPMS, provides an overall history status on daily basis - what is new, updated, deleted.
Reservations Status SPMS Reports	In SPMS, provides a status report.

Reservation Status Alerts

Reservation Online sends alerts and email transport protocols. There are two groups of alerts, each with different distribution lists and destinations (ship/shore departments):

• Emergency

• Status alerts