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
End-of-Day Reporting Enhancement
You can now use End of Day Reporting to schedule analysis reports for delivery when the property end of day (EOD) from OPERA is identified.
Note: For an analysis report to qualify for use during EOD, the report must be configured with Property as Is Prompted under Filters to identify the correct property’s end of day reporting data.
These reports are limited to email delivery only.
Flex Dynamic Field Tables Added
The following tables are added to Reporting and Analytics as part of the Flexible Dynamic Fields functionality:
-
FLEX_DYNAMIC_FIELD_CONFIG_E
-
FLEX_DYNAMIC_FIELD_DATA_E
GDS_RATE_CODE_NEG_SECURITY and RATE$CODE_ROUT_INSTR Tables Added
The following tables are added to Reporting and Analytics database:
-
GDS_RATE_CODE_NEG_SECURITY
-
RATE$CODE_ROUT_INSTR
Housekeeping Task Sheet Reports Updates
Housekeeping Tasksheet BI Publisher Report
-
Back To Back indicator shows a 'Y' when the Back to Back Handling for Linked Reservations OPERA Control is active and the reservation is Back To Back.
-
Membership Level Code field is replaced with Membership Level Description field in the Room Details section of the report. Membership Level Code field is available in the data model.
Housekeeping Tasksheet OBIEE Report
-
Membership Level Code field is replaced with Membership Level Description field in the existing HK Task Sheet report. Membership Level Code field is available in the Reservation Detail folder of the subject area.
-
Back To Back Reservation field is available in the Housekeeping Task Sheets folder of the subject area to create a new report with this field.
Integration Configurations Subject Area Added
A new Integration Configurations Subject Area is added to build reports on the Interface Subject Area for Internal (Support Org) and External (Tenant) users.
The subject area includes External System Properties, External Databases, Business Event Configuration, Interface Setup, Interface Mappings, and Interface Parameters.
Interface Configuration Tables Added
The following interface tables in the OPERA Schema are added to Reporting and Analytics.
-
EXT_SYSTEMS (PK: CODE)
-
EXT_SYS_ACTIVE_RESORT (UK: CODE + RESORT)
-
DATABASES (PK: DATABASE_ID)
-
DATABASE_RESORTS (UK: DATABASE_ID + RESORT)
-
ACTION_TYPE_SUBSCRIPTION (UK: EXT_SYSTEM_CODE + DATABASE_ID+ MODULE + ACTION_TYPE)
-
ACTION_TYPE_SUBSCRIPTION_DTLS ( UK: EXT_SYSTEM_CODE + DATABASE_ID + MODULE + ACTION_TYPE + DATA_ELEMENT)
-
INT_INTERFACE_SETUP (PK: INTERFACE_ID + PMS_RESORT)
-
INT_PARAMETERS ( UK: INTERFACE_ID + CHAIN_CODE + RESORT + PARAMETER_NAME)
-
INT_CC_DETAILS (PK: CCD_SEQ_NO, FK: INTERFACE_ID + RESORT)
Promotion Coupon Codes Subject Area Added
The Promotion Coupon Codes Subject Area is added to create reports based on promotion coupon code details.
The following subfolders are added under the Promotion Coupon Codes Detail subfolder:
-
Batch Code
-
Coupon Code
-
Coupon ID
-
Creation Date
-
Promotion Code
-
Property
-
Status
-
Chain Code
-
Export Date
-
Inactive Date
-
Insert User
-
Update Date
-
Update User
-
Used In Reservation Name ID
-
Used In Reservation Property
REPORTING - NEW REPORTS
Country Specific - Spain - ES_SII Export Added
The ES_SII Export is available in Reporting and Analytics using ES_SII.xml located in /Shared Folders/Templates/Fiscal/Spain folder.
NOTE: Full details showing how to configure and run the ES_SII.xml to provide the required data is available in the Spain - Oracle Hospitality OPERA Cloud Fiscal Reference Guide (DOC8843).
Country Specific - Türkiye – RESMIMUSTERI, RESMI MUSTERI LISTESI and KBS Reports Updated
The Resmimusteri (Data Model) and Resmi Musteri Listesi and KBS Reports are updated, and located in /Shared Folders/Templates/Fiscal/TUR folder. The previous reports are no longer available.
NOTE:Full details showing how to configure and run the RESMI MUSTERI LISTESI and KBS to provide the required data is available in the Turkey - Oracle Hospitality OPERA Cloud Fiscal Reference Guide.
Current template reports are hidden:
-
KBS-Polis-Janderma and Hotspot Report (Report)
-
RESMI_MUSTERI_LISTESI_RAPORU (Report)
Updated template reports:
-
RESMI MUSTERI LISTESI (Report)
-
KBS (Report)
New BI Publisher (BIP) Job Reports Added
New BIP reports are added to the Monitor/OASReports folder in Reporting and Analytics.
| Report Name | Country Specific | Release Version | Subfolder | Description |
|---|---|---|---|---|
|
BIP_Jobs_Report |
All Countries |
25.1 |
OASReports |
The BIP Jobs Report provides information on Job ID, User Job Name, Report URL, Status, Start Date, End Date, Schedule Description, Owner, Shared Option, Bursting. |
|
BIP_Job_Summary_Report |
All Countries |
25.1 |
OASReports |
The BIP Job Summary Report provides fields for Summary of Jobs Created, Run Count, Completed, Running, Failed, Cancelled, Cancelling, With Output Error, With Delivery Error, Submitted Waiting, No data, Invalid Parameters, Report not found. |
|
BIP_Report_Performance_Summary |
All Countries |
25.1 |
OASReports |
The BIP Report Performance Summary Report provides a summary of all reports run within a specific date range, such as maximum and minimum run time, number failed, produced no data, not found, or invalid parameters. |
|
Waiting BIP_Job_Details_Report |
All Countries |
25.1 |
OASReports |
The Waiting BIP Job Details Report provides details on all BIP jobs that are in waiting status within a specific date range, including User Job Names, Owner, Job Status, Status Details, etc. |
New Block Status Change BI Publisher (BIP) Report Added
The Block Status Change Report displays a count by status, block details, and revenue information for blocks that changed status within the selected date range.
The Block Status Change Report is located in the /Shared Folders/Templates/Blocks and Groups subfolder.
New Block Status Change Report Added
The Block Status Change Report identifies blocks which have changed status within a specific time period.
The Block Status Change Report is a template report located in the Sales and Events subfolder.
New Journal By Cashier and Transaction Codes Report (finjrnlbytrans)
The Journal By Transaction Code report displays each posted transaction code and its corresponding amount for a particular date. The ability to filter on a Transaction Code is available. Each transaction code displays the cashier that posted the transaction, any taxes that apply, and if any package credits exist for that particular code.
REPORTING - SUBJECT AREAS UPDATED
Bookings-Block Subject Area Updated
The Bookings-Block Subject Area is updated with the new Available Occupancy 1-4 and On The Books (OTB) Rooms and On The Books (OTB) Occupancy 1-4 attributes within the Room & Rate subfolder within the Room & Rate Grid folder.
Bookings-Reservation Subject Area Updated
The Bookings-Reservation subject area is updated with the following new attributes in the Daily Details folder:
-
Scheduled Move Status
-
Scheduled Move Time
-
Scheduled Move Out Room
-
Scheduled Move Comments
-
Scheduled Move In Room
-
Scheduled Move In Room Type
-
Scheduled Move Out Room Type
Brand Code Attribute Added to all Property Details Folders
The Brand Code attribute is added to all subject areas that contain the Property Details folder.
Catering-Events and Resources Subject Area Updated
The Catering-Events and Resources subject area is updated with the following attributes in the Business Date Calendar folder within the new Dates folder.
These attributes allow you to select Month, Year, Quarter or other date options rather than manually building these fields each time.
-
Business Date
-
Month
-
Month Description
-
Quarter
-
Quarter Description
-
Quarter Start Date
-
Quarter End Date
-
Year
Financial Transaction Details Subject Area Updated
The Financial Transaction Details subject area is updated with the new CC Approval Code attribute in the Details folder.
Inventory-Housekeeping Management Subject Area Updated
The Inventory-Housekeeping Management subject area is updated with the following new attributes in the Reservation Details folder and the Housekeeping Task Sheets folder:
Reservation Details folder:
-
Reservation membership Level Desc
Housekeeping Task Sheets folder:
-
Reservation membership Level Desc
-
Back To Back Reservation
-
Back To Back Parameter
-
Confirmation Number
-
Reservation name Id
Profiles-Accounts Subject Area Enhancement
Previously in the Profiles-Accounts subject area the profiles were displayed at the chain level and showed all negotiated rates regardless of those associated to the property. The Profiles-Accounts subject area now only displays property assigned negotiated rates.
Rate-Codes Subject Area Updated
The following attributes are included in the Rate Components folder of the Rate-Codes Subject Area:
-
Base Rounding
-
BBAR Base Amount
-
BBAR Base Flat Percentage
-
BBAR Base Rounding
-
BBAR Based Y/N
-
BBAR Compare Y/N
-
BBAR Y/N
-
Dynamic Base Amount
-
Dynamic Base Compare Y/N
-
Dynamic Base Flat Percentage
-
Dynamic Base Rate Code
-
Dynamic Base Rounding
-
Pending Approval Y/N
-
Print Rate Y/N
-
Privileged Restriction Y/N
-
Privileged Y/N
-
Show Rate Amount Y/N
-
Yield Market Code
-
Advanced Base Compare Y/N
-
Advance Base Rate Code
-
Advance Base Rounding
-
Base Amount
-
Base Flat Percentage
