Calling the Oracle Hospitality Data APIs
The details of which data points can be fetched for each Subject Area can be found in the GraphQL schemas available in Github. All these APIs are available under a single endpoint – the OHIP Gateway endpoint (see details below) followed by “/rna/v1/graphql/.”
Table 9-3 List of Available Subject Areas
| ID | Subject Area | Description | Primary View |
|---|---|---|---|
| 1 | Accounts Receivable | Detailed Accounts Receivable data, including Adjustments, Payments, Invoices, and Postings for AR Accounts with linked reservation data. | Account Details |
| 2 | AR-Aging | Detailed information on accounts receivable transactions including aging bucket of invoices, open transaction amounts, folio information, and the account details. | AR Aging Report Details |
| 3 | AR-Ledger | Ledger details showing activity in accounts receivables including reservation and transaction details. | AR Ledger Details |
| 4 | Activities | Provides information of Sales activities related to Accounts, Contacts, and Blocks for the selected Property. | Work Orders Details |
| 5 | Booking-Reservation-Extended | Detailed information on reservations booked in the past and future, including market code, rate code, reservation status, guest information, and associated room and revenue details. | Reservation Unified Details |
| 6 | Bookings Block | Block header and grid details, including actual and potential room and revenue statistics, catering events, and the associated profile and reservations data. | Block Details |
| 7 | Bookings-Block Production Changes | Detailed information on blocks and any changes to the number of rooms or revenue by stay date, property, and Block Owner. | Block Changes Net Details |
| 8 | Bookings-Block Status Changes | Detailed information on the status changes throughout the production period of a block, including the new and old status codes, rooms, and associated revenues by property and Block Owner. | Book Status Change Details |
| 9 | Bookings-Reservation | Detailed information on reservations booked in the past and future, including market code, rate code, reservation status, guest information, and associated room and revenue details. | Reservation Details |
| 10 | Catering-Event Forecast | Event revenue forecast details for defined periods broken down by Event Type, Revenue Group, and Revenue Type. | Event Type Forecast Details |
| 11 | Catering-Event Postings | Event posting details including revenues by property, Block, Event, and Revenue groups. | Event Posting Details |
| 12 | Catering-Events Status Changes | Detailed information on the status changes throughout the production period of an event, including the new and old status codes, change date, revenue, and attendees. | Event Status Change Details |
| 13 | Catering-Event Types | Event type definitions | Event Type Details |
| 14 | Catering-Events And Resources | Event and Block details including group profile information, menu, packages, and revenues broken down by event type. | Event Details |
| 15 | Changes Log | Provides detailed information on actions and the users who completed the action, including date, time, activity type, and description. Also providing the capability to combine with reservation, block, and profile data. | Action Details |
| 16 | Configuration - Chain | The Configuration Chain contains configuration/setting attributes for Chain from components such as Enterprise Administration, Financial Administration, Booking Administration, and Client Relations Administration in OPERA. | Chain Details |
| 17 | Configuration - Resort | The Configuration Chain contains configuration/setting attributes for Resort from components such as Enterprise Administration, Financial Administration, Booking Administration, and Client Relations Administration in OPERA. | Property Details |
| 18 | Efolio | This subject area contains data for billing folio settlements to be used for exporting to an external system for efolios. | Folio Tax Details |
| 19 | Export Mapping | Provides detailed information of all configured external codes/values (that is, general ledger codes) mapped to codes used in OPERA (that is, transaction codes, market codes). It contains a comprehensive set of data including, but not limited to, Mapping Type Code/Descriptions, Mapped To Code/Descriptions with other Mapping details such as Export Values by Property / Chain. | Export Mapping Details |
| 20 | Financial-Commissions | Detailed information on the commissions module, including Reservation and Travel Agent profile information with commission codes, amounts, payment activity, and processing status. Commission information can be reported across all properties by Travel Agent and Source profiles, bank account, guest information, and dates. | Commission Agent Details |
| 21 | Financial-Deposit Ledger | Deposit ledger details including individual transactions, folio information, calendar and financial period and the reservation details. | Deposit Ledger Details |
| 22 | Financial-Guest Ledger | Guest ledger details including individual reservations and posted transaction details with debit and credit amounts. | Financial Guest Ledger Details |
| 23 | Financial-Transaction Codes | Transaction code header details including flags, group, and sub-group details. | Transaction Code Details |
| 24.. | Financial-Transaction Details | Detailed information on all posted transactions including net and gross amounts, currency, calendar and financial period, market code, and rate code. | Financial Transaction Details |
| 25 | Financial-Transaction-Details-Extended | Detailed information on all posted transactions including net and gross amounts, currency, calendar and financial period, market code, and rate code. | Financial Unified Details |
| 26 | Financial-Transactions Summary | Summarized information on posted transactions including transaction group, sub group and codes, broken down by property and business date. | Trial Balance Details |
| 27 | Integration Configurations | Exchange Configurations data including External Systems, External Databases, Business Events, Interface Setup, Interface Controls, and Interface Mappings. | External System Properties |
| 28 | Inventory-Function Spaces | All Function Space Details and Configured Options Including Room Type, Occupancy, Function Type, Room Setup, Notes, and Physical Dimensions. | Function Space Details |
| 29 | Inventory-Housekeeping Management - Room | Providing Information on Rooms, Room Attributes and Statuses for the current date. | House Keeping Daily Task Room Details |
| 30 | Inventory-Housekeeping Management-Task Sheet | Details on Tasks, Task Sheets Attributes, and Statuses for the current date. | House Keeping Task Sheets Details |
| 31 | Inventory-Rooms | Comprehensive Information on Guest Room Details and Configuration. | Room Details |
| 32 | Inventory-Rooms Management | Provides detailed information on room maintenance and out of order/service assignments broken down by property, time and room dimensions. Also provides reservations and profile details for service requests. | Room Details |
| 33 | Profiles-Accounts | The Profiles-Accounts subject area contains Account Room Night and Revenue statistics broken down between Group and Individual stays and can be summarized by Property, Stay Date, Business Segment, Owner, and Profile Type. | Profile Accounts Details |
| 34 | Profiles-Addresses | All associated addresses including primary and secondary addresses, and address types which can be associated with the proper profile and profile type. | Profile Address Details |
| 35 | Profiles-Communications | All associated communication details including communication types and roles, which can be associated with the proper profile and profile type. | Profile Communication Details |
| 36 | Profiles-Contacts | The Contacts subject area contains Room Night and Revenue statistics broken down between booked and stays reservations and can be summarized by Property, Stay Date, Business Segment, and Owner. | Contact Details |
| 37 | Profiles-Individuals | Guest profile data including contact information, VIP codes, memberships, and stay statistics with room and revenue details. | Profile All Information Details |
| 38 | Profiles-Loyalty | Detailed information on the Loyalty Program providing details on the Membership, Profiles, Stay Information, and the ability to track Awards and Claims. | Loyalty Profile Membership Details |
| 39 | Profiles-Loyalty - Claims | Detailed information on the Loyalty Program providing details on the Membership, Profiles, Stay Information, and the ability to track Awards and Claims. | Membership Claim Details |
| 40 | Profiles-Loyalty - Transactions | Detailed information on the Loyalty Program providing details on the Membership, Profiles, Stay Information, and the Transaction details. | Membership Transactions Details |
| 41 | Profiles-Membership Transactions | Detailed information on the Loyalty Program providing details on the Membership, Profiles, Stay Information, and the Membership Transaction details. | Membership Transactions Details |
| 42 | Profiles-Notes | Profile note types and note details, including internal and confidential flags, and the profile details they are associated with. | Profile Note Details |
| 43 | Profiles-Relationship Type | Relationship type definition | Relationship Details |
| 44 | Profiles-Relationships | The Profile - Relationships subject area contains relationship details including the relationship type, description and role and the profiles that are linked through the relationship. | Profile Relationship Details |
| 45 | Profiles-Stay Records | Provides information on Stay Records statistics of guest stay and its respective Membership Transactions details for a profile. | Stay Records |
| 46 | Promotion Coupon Codes | Promotion Coupon Codes details | Promotion Coupon Codes Detail |
| 47 | Property | Property definition with marketing, financial, and housekeeping details. | Property Details |
| 48 | Rates-Buckets | Rate bucket definition. | Rate Bucket Details |
| 49 | Rates-Categories | Rate category definition including begin and end date and rate class association. | Rate Categories Details |
| 50 | Rates-Classes | Rate class definition with begin and end date. | Rate Classes Details |
| 51 | Rates-Code Details | Rate Header information including room types, package elements, market code, source code, and associated flags. | Rate Code Details |
| 52 | Rates Codes | Rate detail information including all rate header details, room type, rate tiers and rate amounts per occupant. | Rate Code Details |
| 53 | Rates-Deposit and Cancellation Rules | Deposit and cancellation rules schedules and details by date, rate code, and days prior to arrival or after booking. | Rate Deposit Cancellation Details |
| 54 | Rates-Hurdles | Rate yielding and hurdle information including date, amount, length of stay, and room type. | Rate Hurdles Details |
| 55 | Rates-Rate Seasons | Rate season code definition | Rate Season Details |
| 56 | Rates-Restrictions | Rate restriction definition including restriction type, date applied, room and rate code with day of the week and length of the stay details. | Rate Restrictions Details |
| 57 | Rates-Tiers | Rate tier definition by length of stays. | Rate Tier Details |
| 58 | Resort Budget Forecast | This Subject Area Contains the Budget Forecast Details of the Property(s). | Property Budget Forecast Details |
| 59 | Revenue-Fixed Charges | Details on fixed charges including amount, frequency, and transaction code and the linked reservations. | Fixed Charges Details |
| 60 | Revenue-Groups and Types | Revenue group and type details. | Revenue Group Types Details |
| 61 | Revenue-Packages | Package header details including package group setup and associated flags for selling and consumption options. | Revenue Packages Details |
| 62 | Sales Manager Goals | The Sales Manager Goals subject Area enables end users to retrieve information / create reports to compare the goals set for the Sales Managers against completed activities and against statistical revenue data associated to profiles. | Sales Manager Details |
| 63 | Simple Reports Activities | The Simple Reports Subject Area simplifies creating and building adhoc reports for Activities. | Sr Activities Details |
| 64 | Simple Reports Booking Blocks | The Simple Reports Subject Area simplifies creating and building adhoc reports for Booking Blocks. | Sales Event Business Block Information Details |
| 65 | Simple Reports Bookings Reservation | The Simple Reports Subject Area simplifies creating and building adhoc reports for Bookings Reservation. | Reservation General Details |
| 66 | Simple Reports Events | The Simple Reports Subject Area simplifies creating and building adhoc reports for Events. | Sales Event Information Details |
| 67 | Simple Reports Financial Transactions | The Simple Reports Subject Area simplifies creating and building adhoc reports for Financial Transactions. | Sr Financial Transactions Details |
| 68 | Simple Reports Profile Individuals | The Simple Reports Subject Area simplifies creating and building adhoc reports for Profile Individuals. | Profile Details |
| 69 | Statistics-Forecast Summary | Future on the books information including rooms, revenue, and persons with breakdown by room types, market code, source code, and periods of time. | Forecast Summary Details |
| 70 | Statistics-History and Forecast | Detailed information on past and future reservations including occupancy and revenue figures with all profile data, broken down by Market code, Rate code, Room type, and periods of time. | History Forecast Details |
| 71 | Statistics-Managers Report | Past statistics including rooms and revenue figures, arrivals, departures, and occupancy broken out by multiple time periods. | Managers Report Details |
| 72 | Statistics-Reservation Pace | The Reservation Pace subject area contains daily rooms and revenue information on reservations on the books as of specific dates in the past (snapshot dates) summarized by Property, Market, Room Type, Channel, and Rate Code. | Reservation Pace Fact Details |
| 73 | Statistics-Reservations Daily | Detailed information on past reservations including occupancy and revenue figures with all profile data, broken down by Market code, Rate code, room type, and periods of time. | Reservation Daily Statistics Details |
| 74 | Statistics-Reservations Daily Summary | Summarized information on past reservations including number of persons, rooms, and revenue figures, broken down by room type, market code, rate code, and periods of time. | Reservation Daily Summary Details |
| 75 | Statistics-Reservations Summary | Summarized booking data for both on the books and past stays including rooms, revenue, and occupancy details broken out by Market code, Rate code, and periods of time. | Reservation Summary Details |