1 Features and Updates

The content below is a list of the features and updates for the FMS 9.2 release.

FMS Database

  • Added a new column ‘SCD_VISITOR_COUNT’ in FMS_TRANSFER table via FCONSOL.sql script for [module] to receive data sent from Ship database and display of visitor count.

  • Enhanced the column size of ‘EPO_INFO_COMMENTS’ and ‘EPW_INFO_COMMENTS’ to support up to 200 characters of data transferred from FMS to SPMS or vice versa. You must update SPMS to version 20.2.2 or higher.

  • Updated FCONSOL schema using FCONSOL.sql script to change the data type from LONG to CLOB in DTG table, ensuring the DTG data from Ship database is sent to Shore database. This change is only compatible with SPMS version 23.1.0.

  • Added new tables for Entry/Exit System (EES) under FCONSOL schema to enable the data sending from Ship to Shore database. This change is compatible with SPMS version 23.1.0. All the EES fields are available and can be written in Extensible Markup Language (XML) format, enabling customization of transfer type using the structured table.

Tools and Technology Updates

  • Upgraded Crystal Report Runtime to version 13.0.33

Deprecated Modules

Following are lists of deprecated modules in FMS 9.2.0:

  • Oracle Hospitality Cruise Fleet Management Business Intelligence

  • Oracle Hospitality Cruise Fleet Management Universal Check-in

  • Oracle Hospitality Cruise Fleet Management Universal Check-in Web Service

  • Oracle Hospitality Cruise Fleet Management Database Updater