1 Feature Summary

Column Definitions

SMALL SCALE: These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.
LARGER SCALE: These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.
CUSTOMER ACTION REQUIRED: You must take action before these features can be used. These features are delivered disabled, and you choose if and when to enable them.


REPORTING - NEW FEATURES AND ENHANCEMENTS


Added new profile privacy configuration

New folders have been added to the Profile - Individual and Configuration subject areas to support the Profile Correspondence customization feature, which is available in OPERA Cloud when the PROFILE PRIVACY CUSTOMIZATION OPERA Control is enabled. See https://docs.oracle.com/search/?q=Profile+Correspondence+customization&lang=en&category=industries&product=en%2Findustries%2Fhospitality https://docs.oracle.com/search/?q=Profile%20privacy%20customization&pg=1&size=10&product=en%2Findustries%2Fhospitality&category=en%2Findustries&showfirstpage=true&lang=en for details.


Subject Areas


Subject Areas

Added new column for Code in Menu and Menu Item Class

A new field for Menu Item Class Code is added to the Resource Management>Menu Items> Menu Item Class folder.

A new field for Menu Class Code is added to the Resource Management>Menu> Menu Class folder.

New fields for Completed YN and Activity Owner Name are added in the Activities folder in the Sales Manager Goals subject area.

Added Room Plan BI Publisher Report

A new Room Plan BI Publisher (BIP) report has been introduced, providing a detailed view of room assignments and availability at the individual room level for a property. The report displays up to 14 days per page, allowing you to easily monitor occupancy and reservation status over time.

You can filter the report using the following criteria:

  • Property

  • From Date

  • To Date

  • Room Class

  • Room Type

  • Room

  • Floor

  • Room Features

  • Smoking Preference

The Room Class, Room Type, and Room filters follow a hierarchical structure to support more refined filtering. For example, selecting a Room Class limits the available Room Types to those associated with the selected class. Similarly, selecting a Room Type further restricts the available Rooms to those within the selected type.

The report layout includes the following enhancements:

  • Displays the guest count for reservations with more than one guest

  • Provides visual indicators (icons) for Shared Reservations (Shared reservations), Do Not Move Room (Do Not Move room), and Day Use Reservations (Day User Reservations)


Room Plan

Added Service Requests Detail Report

A new Service Requests Detail BI Publisher (BIP) report is available, providing a detailed list of service requests for a selected date range based on the specified search criteria. The report is designed to align with the format and layout of the existing OPERA Cloud Service Requests report.

You can filter the report using the following criteria:

  • Property

  • Open From Date

  • Open To Date

  • Closed From Date

  • Closed To Date

  • Status

  • Department

  • Priority

  • Service Request Code

  • Profile Name/Profile ID (free text)

  • Confirmation Number (free text)

Added 28 days Forecast and Detailed Availability R & A Reports

The 28 Days Forecast Report (28daysavail), already available in OPERA Cloud, is introduced in Reports and Analytics with filtering by Chain (required), Property (default: All), and Start Date.

The report is also available in OPERA Cloud as rna_28daysavail.


28 Days Forecast Report

The Detailed Availability Report (detail_avail), already available in OPERA Cloud, is introduced in Reports and Analytics and provides a detailed breakdown of room availability for a selected date range.

You can filter by the following criteria: Property (required), From Date (required), To Date (required), Room Class (for properties with the Room Class OPERA Controlinactive, the list of values will be empty), Room Type, Display (Availability, Occupancy), and Include Non-Deduct Inventory, Overbooking, Out of Order Rooms, Master Allocations. When Display is set to Occupancy, the Include Overbooking and Include Out of Order Rooms options are not available, as these selections are not valid for the Occupancy Display.

The report is also available in OPERA Cloud as rna_detail_avail.

You can filter the report using the following criteria:

  • Property (required)

  • From Date (required)

  • To Date (required)

  • Room Class (for properties where the Room Class OPERA Control is inactive, no values are available)

  • Room Type

  • Display (Availability or Occupancy)

  • Include Non-Deduct Inventory

  • Include Overbooking

  • Include Out of Order Rooms

  • Include Master Allocations

When Display is set to Occupancy, the Include Overbooking and Include Out of Order Rooms options are unavailable because they are not applicable to the Occupancy display.

The report is also available in OPERA Cloud as rna_detail_avail.


Detailed Availability Report

Added Length of Stay Forecast Report

The LOS Forecast Matrix report is now available in Reports and Analytics and can be run directly from the OPERA Cloud user interface.

The Reports and Analytics version provides the same reporting experience as the existing OPERA Cloud report and supports the same filtering options, including:

  • Arrival Date Range

  • Room Class

  • Room Type

  • Market Options

  • Individuals and Blocks

  • Deduct and Non-Deduct

  • Currency and Rate Basis

  • Group by Room Type

The report also provides the same matrix output by date and room type, including:
  • Total Rooms

  • Available to Sell

  • Average Daily Rate (ADR)

  • Totals

The report results reconcile with OPERA Cloud, ensuring that the data is accurate and consistent with the information displayed in the application.


LOS Forecast

LOS Forecast

IMPACT OR OTHER CONSIDERATIONS

Ensures continuity of existing reporting capabilities by recreating Length of Stay(LOS) Forecast report in R&A with equivalent filters, output, avoiding disruption to customer operations.

Added Yearly Forecast Report

The Stat Forecast Yearly (stat_forecastyearly) report, which is already available in OPERA Cloud, is now available in Reports and Analytics. The report provides a yearly summary of all reserved rooms, categorized as either deduct or non-deduct based on the reservation type. The report includes both reservations and rooms held against blocks.

You can filter the report using the following criteria:

  • Property (required)

  • From Date

  • To Date (required)

  • Room Class (for properties where the Room Class OPERA Control is inactive, no values are available)

  • Calendar/Fiscal

  • Rooms/Guests

The report is also available in OPERA Cloud as rna_stat_forecastyearly.


Yearly Forecast


Yearly Forecast

Added Block Forecast BI Publisher Report

A new Block Forecast BI Publisher (BIP) report has been added to the Blocks and Groups template folder. The report provides a daily overview of room allocations based on the selected Forecast (Grid Type). It can be generated to display Current, Picked Up, Contracted, or Available room forecasts and can optionally include net rates and revenue.

You can filter the report using the following criteria:

  • Property

  • From Date

  • To Date

  • Room Class

  • Room Category

  • Forecast (Grid Type)

  • Status

  • Room Owner

  • Include Catering-Only Blocks

  • Display Net Rate/Revenue

  • Order By


Block Forecast Report

Added Service Requests Summary Report

A new Service Requests Summary BI Publisher (BIP) report is available, providing a summary of service requests for a selected date range. The report includes the total number of service requests, the average time to complete, and the average follow-up time, and is presented in a format consistent with the existing OPERA Cloud Service Requests report.

You can filter the report using the following criteria:

  • Property

  • From Date

  • To Date

  • Request State (Open or Closed)

  • Status (Open, Pending Follow-up, or Closed)

  • Department

  • Priority

  • Service Request Codes

Added Leisure Experiences Subject Area

A new Leisure Experiences subject area has been added to Reports and Analytics. The following folders have been introduced within the subject area:

  • Scheduled Experiences

  • Scheduled Experiences Resources

The Scheduled Experiences subject area delivers reporting capabilities for scheduled guest experiences and activities.

It supports operational and analytical reporting across reservation management, package tracking, revenue analysis, and experience scheduling.

Organizations can use this subject area to:

  • Monitor scheduled activities and experiences

  • Track reservation statuses and cancellations

  • Analyze pricing and package performance

  • Review scheduling utilization and timing trends

  • Improve operational planning and customer engagement


Scheduled Experience

The Scheduled Experience Resources subject area provides reporting capabilities for resources assigned to scheduled experiences, including equipment, facilities, personnel, or service components.

Organizations can use this subject area to:

  • Track resource assignments and availability

  • Monitor utilization and scheduling conflicts

  • Analyze resource demand trends

  • Manage cancellations and inactive resources

  • Improve operational efficiency and planning


Scheduled Experience Resource

IMPACT OR OTHER CONSIDERATIONS

The addition of the Scheduled Experiences and Scheduled Experience Resources subject areas to Reports & Analytics (R&A) delivers significant operational value by providing organizations with centralized visibility into experience scheduling, reservations, resource allocation, and operational performance.

Create History Forecast Block Template Reports

The History Forecast report HISTORY_FORECAST_BLK, available in OPERA Cloud, has been recreated in Reports and Analytics as the History Forecast Summary and Detail templates. These templates provide the same filters and output as the existing OPERA Cloud report.

The report templates are available in the Reservation template folder.


History Forecast Block Detail

History Forecast Block Summary

IMPACT OR OTHER CONSIDERATIONS

Ensures continuity of existing reporting capabilities by recreating the History Forecast Block report in R&A with equivalent filters, output, avoiding disruption to customer operations.

Data Studio - Reporting

This release introduces a new reporting capability in Reports and Analytics (R&A) that provides comprehensive visibility into all Subject Areas and their associated data points, replacing the information previously available in the Subject Area Definitions documentation in the R&A library. These reports provide a clear and efficient way to explore available data and quickly identify the attributes required for both report creation and Data API development.

With these reports, you can easily explore the complete structure of each Subject Area, including detailed attribute-level information such as data types, PII indicators, and corresponding Data API elements. This enables you to quickly identify the data available for reporting and API development, reducing the time required to locate relevant fields and build reports or GraphQL queries.

The reports are presented in a centralized, read-only format and include built-in search capabilities, allowing you to quickly locate specific Subject Areas and attributes. The reports are also version-aware, ensuring that the information displayed is aligned with the version of the platform currently deployed in your environment.

Key capabilities include:

  • Centralized, read-only reports listing all Subject Areas and their attributes

  • Detailed metadata for each attribute (for example: type, PII, API fields, filters, descriptions)

  • Search functionality across Subject Areas and attribute names for quick discovery of data points

  • Version-aware content that displays information aligned with the version of the platform deployed in each customer environment.

These reports improve usability and efficiency by making it easier to review, understand, and leverage the data available for reporting and Data API development.

Note:

Data Studio reports are available only for customer instances running on Oracle Analytics Server (OAS) after the analytics upgrade has been completed. Customer instances running on Oracle Business Intelligence Enterprise Edition (OBIEE) are not currently supported.

This image shows Subject Area Reporting

This image shows Subject Area Reporting Profile Individuals report

This image shows Data API report

GraphQL Convert the Mandatory Parameters to Optional

This enhancement updates the GraphQL API to improve flexibility in request handling by making previously mandatory parameters optional. Additionally, it introduces a new conditional requirement for the Chain Code parameter.

  • Initially, only limited APIs supported optional/mandatory parameter behavior.

  • This enhancement extends the optional/mandatory framework across all APIs.

Identity Management Based User Access by Default

Currently, Identity Management-based user access is an optional feature for existing Reporting & Analytics (R&A) instances, which continue to use the R&A Reporting Hierarchy and User Assignment model for managing data access.

With this release, all newly onboarded Reporting & Analytics (R&A) tenants will use OPERA Cloud Identity Management (OCIM) group-based access by default. The previous R&A-based access management model is no longer available for new tenants. As a result, all user data access permissions must be managed and assigned through OCIM groups.


Identity Management Based User Access

Reports Added to the Template Folder Leisure Experiences

  • Most Popular Experiences

    The Most Popular Experiences report helps organizations identify the experiences and activities most frequently booked by guests. It provides visibility into guest preferences and participation trends, enabling operations and management teams to understand which offerings generate the highest engagement and demand. These insights can be used to support marketing strategies, package planning, and operational resource allocation.

  • Production Report

    The Production Report provides operational visibility by tracking completed, canceled, and lost production. It helps operations teams evaluate production efficiency, identify operational gaps, monitor production losses, and improve overall service delivery performance. The report supports proactive operational management and informed decision-making across leisure and experience operations.

  • Resource Allocation and Utilization Report

    The Resource Allocation and Utilization Report provides detailed visibility into how resources are assigned to and utilized across scheduled experiences. It helps organizations optimize resource usage, identify overbooked or under-resourced experiences, reduce idle capacity and operational waste, and ensure that the appropriate resources are allocated to the right experiences at the right time. These insights improve operational efficiency, capacity planning, and service reliability.

  • Resource Utilization Report

    The Resource Utilization Report helps organizations understand how effectively operational resources, such as equipment, facilities, and personnel, are being used. By analyzing utilization patterns, organizations can identify underutilized and overutilized resources, improve operational planning, optimize staffing and equipment allocation, and enhance overall operational efficiency.

  • Top Revenue Experiences

  • The Top Revenue Experiences report identifies the highest-performing experiences based on generated revenue. It enables organizations to determine which experiences contribute the greatest financial value, supporting pricing strategies, investment planning, package optimization, and revenue growth initiatives. The report also provides valuable insight into guest spending behavior and the profitability of individual experiences.

IMPACT OR OTHER CONSIDERATIONS

Together, these reports provide comprehensive insights into guest demand, operational performance, production efficiency, resource allocation, resource utilization, and revenue generation, enabling organizations to optimize operations and make faster, data-driven decisions.

Converted ACRS (Amadeus Central Reservation System) Reconciliation Reports into R&A Templates

The following reports have been created under the Templates folder in Reporting & Analytics:

  • Blocks and Groups:
    • Blocks on the Books
  • Forecast:
    • Availability
    • Availability OO
  • Reservation:
    • Reservation on the Books
    • Reservation on the Books with ACRS
    • Zero Adult Reservations

This image shows reports created under Blocks and Groups folder

This image shows reports created under Reservation folder

This image shows reports created under Reservation folder

This image shows reports created under Forecast folder