Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.
All 92 tools →
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/oracle-hospitality-packagecategory-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no email required.
A second provider on the same verified email joins the account you already have.
openapi: 3.2.0
info:
title: OPERA Cloud Reservation Package Category API
description: APIs to cater for Reservation functionality in OPERA Cloud. <br /><br />OPERA Cloud Reservations provides a complete set of capabilities for creating and updating reservations. Reservations are a central feature of OPERA Cloud. As a key source of information, the reservation specifies a guest's arrival date, departure date, room type, rate, packages, and many other details. It is also a gateway to dozens of other functions that contribute to the guest's experience. All reservations in OPERA Cloud require a guest profile. <br /><br /> You can create profiles while booking a reservation. If a profile already exists, you can look it up (using getProfiles in CRM module) and attach it to the reservation during the reservation booking process using the Profile ID.<br /><br /> Compatible with OPERA Cloud release 26.2.0.0.<br /><br /><p> This document and all content within is available under the Universal Permissive License v 1.0 (https://oss.oracle.com/licenses/upl). Copyright (c) 2020, 2026 Oracle and/or its affiliates.</p>
version: 26.2.0.0
termsOfService: https://www.oracle.com/legal/terms.html
contact:
email: hospitality_apis_ww_grp@oracle.com
license:
name: UPL
url: https://opensource.org/licenses/upl
servers:
- url: /rsv/v1
tags:
- name: PackageCategory
paths:
/hotels/{hotelId}/reservations/packageCategoryReservations:
get:
summary: Get Reservations by pacakge and consumption date
description: Use this API to get reservations with package consumption for a specific date. <p><strong>OperationId:</strong>getReservationsByPackage</p>
operationId: getReservationsByPackage
parameters:
- name: hotelId
in: path
required: true
description: Unique ID of the hotel where reservation is searched based on reservation ID.
schema:
type: string
maxLength: 2000
minLength: 1
- name: packageCategory
in: query
required: false
description: Package Category of the package attached to the reservation. Reserved for future development.
style: form
explode: true
schema:
type: array
items:
type: string
maxItems: 20
- name: packageCode
in: query
required: false
description: Package code of the package attached to the reservation
style: form
explode: true
schema:
type: array
items:
type: string
maxItems: 20
- name: date
in: query
required: true
description: Forecasted package consumption date
schema:
type: string
format: date
- name: limit
in: query
required: false
description: Indicated maximum number of reservations to be sent in the response
schema:
type: integer
default: 30
- name: offset
in: query
required: false
description: Index or initial index of the set(page) being requested. If the index goes out of the bounds of the total set count then no data will be returned.
schema:
type: integer
default: 0
responses:
'200':
headers:
Content-Language:
description: Audience language
x-example: en-GB
schema:
type: string
pattern: '[a-zA-Z]{1,8}(-[a-zA-Z0-9]{1,8})*'
description: Response object to the Fetch Reservations by package request operation. Based on the criteria, reservation information is returned.
content:
application/json;charset=UTF-8:
schema:
$ref: '#/components/schemas/packageCategoryReservations'
'204':
description: HotelReservations not found.
'400':
$ref: '#/components/responses/400'
'401':
$ref: '#/components/responses/401'
'403':
$ref: '#/components/responses/403'
'404':
$ref: '#/components/responses/404'
'405':
$ref: '#/components/responses/405'
'406':
$ref: '#/components/responses/406'
'413':
$ref: '#/components/responses/413'
'414':
$ref: '#/components/responses/414'
'415':
$ref: '#/components/responses/415'
'500':
$ref: '#/components/responses/500'
'502':
$ref: '#/components/responses/502'
'503':
$ref: '#/components/responses/503'
tags:
- PackageCategory
components:
schemas:
guestHousekeepingServiceRequestType:
type: string
description: Possible values for the Guest Service Status.
enum:
- DoNotDisturb
- MakeUpRoom
- NoStatusSelected
- ServiceDeclined
cardReIssueType:
type: string
description: Request to re issue a new card.
enum:
- Pending
- NotApplicable
- Requested
stayInfoType:
type: object
description: Details on the Room Stay including Guest Counts, Time Span of this Room Stay, pointers to Res Guests, guest Memberships, Comments and Special Requests pertaining to this particular Room Stay and finally financial information related to the Room Stay, including Guarantee, Deposit and Payment and Cancellation Penalties.
properties:
arrivalDate:
type: string
format: date
departureDate:
type: string
format: date
originalTimeSpan:
description: The Original Time Span covers the Room Stay dates of the original reservation.
$ref: '#/components/schemas/timeSpanType'
bookingTimeSpan:
description: The booking time span of the reservation, only applicable when time increments are being used.
$ref: '#/components/schemas/bookingTimeSpanType'
expectedTimes:
description: The expected arrival, return and departure times of the guest.
$ref: '#/components/schemas/resExpectedTimesType'
adultCount:
description: A collection of Guest Counts associated with Room Stay.
type: integer
childCount:
description: A collection of Child Counts associated with Room Stay.
type: integer
childAges:
description: Defines Children's Ages. Number of children ages mentioned may mot match with children counts.
$ref: '#/components/schemas/childAgesType'
childBuckets:
description: Defines children counts with Age Qualifying Group(Child Bucket#1) classification.
$ref: '#/components/schemas/childBucketsType'
roomClass:
description: Room class code
type: string
minLength: 0
maxLength: 20
roomType:
description: Room type code
type: string
minLength: 0
maxLength: 20
numberOfRooms:
description: Room Id
type: integer
roomId:
description: Room Id
type: string
minLength: 0
maxLength: 20
roomOwnershipType:
description: Provides the information of the assigned reservation room is an Owner, Referral or regular room.This value is returned when Room Rotation OPERA Control is active and room number is assigned to a reservation.
$ref: '#/components/schemas/reservationRoomOwnershipType'
scheduledRoomMoveRoomPending:
type: boolean
description: Pending Scheduled Move Room.
ratePlanCode:
description: Rate plan code
type: string
minLength: 0
maxLength: 20
postingInterval:
description: Specifies the frequency at which charges are posted for the rate plan on the reservation.
$ref: '#/components/schemas/postingIntervalType'
rateAmount:
description: Rate amount
$ref: '#/components/schemas/currencyAmountType'
offshoreRateInformation:
$ref: '#/components/schemas/offshoreRateType'
points:
description: The Points contains the number of points used to book a particular room type.
$ref: '#/components/schemas/pointsType'
rateSuppressed:
description: Whether this rate should be suppressed from view
type: boolean
reservationBlock:
description: Key information about the block for this reservation.
$ref: '#/components/schemas/reservationBlockType'
bookingChannelCode:
description: Classifies the medium(Channel field on reservation screen) through which the reservation is made.
type: string
minLength: 0
maxLength: 40
linkCode:
description: Party code
type: string
maxLength: 2000
fixedRate:
description: True if the rate is a fixed rate, otherwise false
type: boolean
totalAmount:
description: The total amount charged for the Room Stay including additional occupant amounts and fees. If TaxInclusive is set to True, then taxes are included in the total amount.
$ref: '#/components/schemas/currencyAmountType'
guarantee:
description: The guarantee information associated to the Room Stay. A maximum of 5 occurances are available for use depending on the context.
$ref: '#/components/schemas/resGuaranteeType'
promotion:
description: Promotion Codes
$ref: '#/components/schemas/promotionType'
marketCode:
description: Market code
type: string
minLength: 0
maxLength: 20
sourceCode:
description: Source of business
type: string
minLength: 0
maxLength: 20
sourceCodeDescription:
description: Description of the source of business.
type: string
minLength: 0
maxLength: 4000
balance:
description: Balance amount
$ref: '#/components/schemas/currencyAmountType'
compBalance:
description: Comp Balance amount
$ref: '#/components/schemas/currencyAmountType'
roomTypeCharged:
description: Room type code that was charged
type: string
minLength: 0
maxLength: 20
depositPayments:
description: A collection of deposit and/or payments for the Room Stay.
$ref: '#/components/schemas/currencyAmountType'
guestServiceStatus:
description: Service Status of In House guest like DND or MUP
$ref: '#/components/schemas/guestHousekeepingServiceRequestType'
scheduledCheckoutTime:
description: Indicates that this reservation is scheduled for automated check out.
type: string
format: date
roomNumberLocked:
description: When true, indicates a room number cannot be changed. When false, indicates a room number may be changed.
type: boolean
pseudoRoom:
description: True indicates as pseudo room type. This is usually used for a posting master reservation.
type: boolean
assignedByAI:
description: Represents the room was assigned by AI Room Assignment.
type: boolean
upgradedByAI:
description: Represents the room was assigned by AI Room Assignment.
type: boolean
roomAvailableNights:
description: Number of nights this room is avaiable if room is assigned to reservation
type: integer
backToBack:
description: This attribute indicates if the linked reservation is marked as Back to Back or not.
type: boolean
backToBackSequence:
description: This attribute represents Back To Back Sequence of Linked Reservations(e.g. '1 of 2' i.e, 1 indicates Sequence Position of total count 2). This is applicable when OPERA control Back to Back Handling for Linked Reservations is active.
$ref: '#/components/schemas/backToBackResSequenceType'
scheduledRoomMoveResponseType:
description: Scheduled Room Move Response Information.
$ref: '#/components/schemas/scheduledRoomMoveResponseType'
backToBackGroupId:
description: This attribute represents a common identifier for a subgroup of linked reservations marked as Back to Back in a group of linked reservations.
type: string
minLength: 0
maxLength: 80
resAccompanyGuestInfoType:
type: object
properties:
firstName:
description: Given name, first name or names
type: string
lastName:
description: Family name, last name.
type: string
fullName:
description: String representation of the full name
type: string
alternateFirstName:
description: Alternate first name
type: string
alternateLastName:
description: Alternate last name.
type: string
alternateFullName:
description: Alternate full name
type: string
registrationCardNo:
description: Unique identifier of the police registration card number.
type: string
minLength: 0
maxLength: 40
profileIdList:
description: Unique identifiers for the Profile for both internal and external systems. In case of Travel Agent the IATA code and in case of Company can be any form of identifier as id.
$ref: '#/components/schemas/profileIdList'
externalReferences:
description: External References information for this Profile. Will be returned in getReservations and getHotelReservations when the 'profileExternalReferencesToFetch' query parameter is sent.
$ref: '#/components/schemas/externalReferencesType'
resSharedGuestInfoType:
type: object
description: Contains information regarding the share reservation.
properties:
profileId:
$ref: '#/components/schemas/profileId'
reservationId:
$ref: '#/components/schemas/reservationId'
firstName:
description: Given name, first name or names
type: string
lastName:
description: Family name, last name.
type: string
fullName:
description: String representation of the full name
type: string
cardTypeType:
type: string
description: This is required for Credit Card Payment Methods. This indicates the type of Credit Card associated with this payment method.
enum:
- Ab
- Am
- Ax
- Cb
- Dc
- Ds
- Dt
- Ec
- Er
- Jc
- Jl
- Mc
- Nb
- So
- St
- Sw
- Va
- Xy
- Zz
- Cp
- Cu
backToBackResSequenceType:
type: object
description: Type object represents Back To Back Sequence Position and Total Count of Linked Back To Back Reservations ordered by consecutive Stay Dates.
properties:
position:
description: Indicates the Sequence position of Back to Back Reservation.
type: integer
totalCount:
description: Indicates the total count of Back To Back Reservations in the group of Linked Reservations.
type: integer
namePrefixType:
type: string
description: Salutation of honorific. (e.g., Mr. Mrs., Ms., Miss, Dr.)
minLength: 0
maxLength: 40
pointsType:
type: object
description: The Redeem Points contains the number of points required to book a room type.
properties:
awardsType:
description: Awards type for the award type rate code.
type: string
points:
description: No of points required to book this Room Stay.
type: integer
packageCodeHeaderType:
type: object
properties:
primaryDetails:
description: Package code header primary details.
$ref: '#/components/schemas/configPackagePrimaryDetailsType'
transactionDetails:
description: Package code header transaction information.
$ref: '#/components/schemas/configPackageTransactionType'
postingAttributes:
description: Package code posting attributes.
$ref: '#/components/schemas/configPostingAttributesType'
membershipEarningPreferenceType:
type: string
description: The earning preference of a membership, it depends on the type of property. eg. when the property is a airline it should be Miles, other than Points.
enum:
- Points
- Miles
reservationIdList:
type: array
description: Unique Id that references an object uniquely in the system.
maxItems: 4000
items:
$ref: '#/components/schemas/uniqueID_Type'
reservationPackageScheduleType:
type: object
description: A HotelPackageSchedule type.
properties:
consumptionDate:
description: The date the package was used or can be used.
type: string
format: date
unitPrice:
description: The price per unit of the package.
type: number
totalQuantity:
description: The total quantity of the package for this date, calculated based on the calculation rule as defined in the PackageHeaderType
type: integer
computedResvPrice:
description: Computed Reservation Price of the package. Calculation Will Be Performed Based On Other Parameters.
type: number
computedResvAllowance:
description: Computed Reservation Allowance of the package. Calculation is based off of the allowance amount, posting rhythm, and quantity for the package.
type: number
unitAllowance:
description: The allowance per unit of the package.
type: number
reservationDate:
description: The date of the Reservation when this package is applicable. This can be different from the date the package will be consumed. Example are next day packages. Reservation date is when the package is applied to the guest and Consumption date is when the guest can consume the package.
type: string
format: date
originalUnitPrice:
description: The original price per unit of the package if it has been changed.
type: number
originalUnitAllowance:
description: The original allowance per unit of the package if it has been changed.
type: number
ageBucket2OriginalUnitPrice:
description: The original price per unit for Child Bucket 2 / Guest Age Category 2 of the package. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child
type: number
ageBucket2OriginalUnitAllowance:
description: The original allowance per unit for Child Bucket 2 / Guest Age Category 2 of the package. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child
type: number
ageBucket2UnitPrice:
description: Unit Price for Child Bucket 2 /Guest Age Category 2. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child.
type: number
ageBucket2UnitAllowance:
description: Unit Allowance for Child Bucket 2 /Guest Age Category 2. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child.
type: number
ageBucket3OriginalUnitPrice:
description: The original price per unit for Child Bucket 3 / Guest Age Category 3 of the package. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child
type: number
ageBucket3OriginalUnitAllowance:
description: The original allowance per unit for Child Bucket 3 / Guest Age Category 3 of the package. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child
type: number
ageBucket3UnitPrice:
description: Unit Price for Child Bucket 3 /Guest Age Category 3. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child
type: number
ageBucket3UnitAllowance:
description: Unit Price for Child Bucket 3 /Guest Age Category 3. Applicable when Child Bucket or Guest Age Categories functionality is active and package's price calculation rule is Per Child
type: number
calculatedQuantity:
description: The calculated quantity available to be consumed for the package based on the package's quantity and posting rhythm.
type: integer
consumedQuantity:
description: The quantity consumed for the package.
type: integer
forecastConsumptionDate:
description: The forecasted consumption date of the package.
type: string
format: date
consumedAllowance:
description: The allowance amount consumed for the package based on transactions posted.
type: number
resPaymentCardType:
type: object
description: Information on a credit card for the customer.
properties:
cardId:
description: credit card id
$ref: '#/components/schemas/uniqueID_Type'
currentAuthorizedAmount:
$ref: '#/components/schemas/currencyAmountType'
approvalAmountNeeded:
$ref: '#/components/schemas/currencyAmountType'
approvalCode:
description: Approval code sent by the credit card company on a successful authorization.
type: string
minLength: 0
maxLength: 20
cardType:
description: Indicates the type of credit card from a defined list
$ref: '#/components/schemas/cardTypeType'
userDefinedCardType:
description: Indicates the user defined credit card type if credit card type from a defined list is not provided
type: string
minLength: 0
maxLength: 2
cardNumber:
type: string
minLength: 0
maxLength: 80
cardNumberMasked:
type: string
minLength: 0
maxLength: 80
cardNumberLast4Digits:
type: string
minLength: 0
maxLength: 80
expirationDate:
description: Expiration date of the credit card
type: string
format: date
expirationDateMasked:
description: Masked Expiration date of the credit card
type: string
minLength: 0
maxLength: 20
expirationDateExpired:
type: boolean
cardHolderName:
type: string
minLength: 0
maxLength: 200
storeToCreditCardWallet:
description: Indicate whether the credit card will be stored to the credit card wallet or not.
type: boolean
processing:
description: This contains information on whether EFT is enabled. A value of 'C' indicates EFT is enabled and 'M' indicates manual authorization is available for this payment card type.
$ref: '#/components/schemas/cardProcessingType'
swiped:
type: boolean
cardPresent:
description: Flag to determine if the credit card was swiped/manually entered , This element is only used when PAYMENT SERVICE DIRECTIVE(PSD) Opera Control is active.
type: boolean
cardOrToken:
description: This contains information on whether credit card is tokenized (token enabled). A value of 'Token' indicates credit card is token enabled and 'CardNumber' indicates non token environment for this payment card type.
$ref: '#/components/schemas/cardNumberTypeType'
citId:
description: Customer Initiated Transaction(CIT) Id for Credit Cards. This is only used when PAYMENT SERVICES DIRECTIVE (PSD2) Opera Control is active.
type: string
minLength: 0
maxLength: 30
pkgInventoryItemType:
type: object
properties:
articleNumber:
description: Article Number of the inventory item.
type: string
minLength: 0
maxLength: 20
description:
description: Description of the inventory item.
type: string
minLength: 0
maxLength: 200
quantity:
description: Quantity of the inventory item allocated to the package.
type: integer
itemId:
description: Identifier for the inventory item.
type: integer
reservationPaymentMethodType:
type: object
properties:
paymentCard:
$ref: '#/components/schemas/resPaymentCardType'
balance:
$ref: '#/components/schemas/currencyAmountType'
authorizationRule:
$ref: '#/components/schemas/authorizationRuleType'
emailFolioInfo:
description: Information on an email for the customer.
type: object
properties:
email:
description: eMail deatils for the profile.
$ref: '#/components/schemas/emailType'
emailFolio:
type: boolean
id:
description: A unique identifying value assigned by the creating system. The ID attribute may be used to reference a primary-key value within a database or in a particular implementation.
type: string
minLength: 0
maxLength: 80
type:
description: A reference to the type of object defined by the UniqueID element.
type: string
minLength: 0
maxLength: 40
paymentMethod:
type: string
minLength: 0
maxLength: 20
description:
type: string
minLength: 0
maxLength: 2000
folioView:
type: integer
confidential:
type: boolean
description: Flag indicating a billing window (2-8) as confidential. Applied only when Confidential Billing Window Opera Control is active.
timeSpanType:
type: object
description: Allows for a choice in description of the amount of time spanned by this type. EndDate specifies a specific date, while Duration provides a measure of time to add to the StartDate to yield end date.
properties:
startDate:
type: string
format: date
endDate:
type: string
format: date
duration:
type: string
childBucketsType:
type: object
description: Defines children counts with Age Qualifying Group(Child Bucket) classification.
properties:
bucket1Count:
description: Number of children classified under the first Age Qualifying Group(Child Bucket#1).
type: integer
bucket2Count:
description: Number of children classified under the second Age Qualifying Group(Child Bucket#2).
type: integer
bucket3Count:
description: Number of children classified under the third Age Qualifying Group(Child Bucket#3).
type: integer
bucket4Count:
description: Number of children classified under the fourth Age Qualifying Group(Child Bucket#4).
type: integer
bucket5Count:
description: Number of children classified under the fifth Age Qualifying Group(Child Bucket#5).
type: integer
warningsType:
type: array
description: Used in conjunction with the Success element to define a business error.
maxItems: 4000
items:
$ref: '#/components/schemas/warningType'
cardNumberTypeType:
type: string
description: Simple type for indicating if credit card number is tokenized.
enum:
- CardNumber
- Token
packageCategoryReservationType:
type: object
description: Information regarding each reservation being returned in the response
properties:
reservationIdList:
description: Unique identifiers for the reservation for both internal and external systems
$ref: '#/components/schemas/reservationIdList'
roomStay:
description: Collection of room stays.
$ref: '#/components/schemas/stayInfoType'
reservationGuest:
description: Collection of guests associated with the reservation.
$ref: '#/components/schemas/resGuestInfoType'
reservationMemberships:
description: List of reservation memberships which are attached from profile.
type: array
maxItems: 10
items:
$ref: '#/components/schemas/reservationMembershipType'
sharedGuests:
description: Collection of guests who share this reservation.
$ref: '#/components/schemas/resSharedGuestListType'
reservationPaymentMethod:
description: Payment method used for this reservation
$ref: '#/components/schemas/reservationPaymentMethodType'
advanceCheckIn:
description: Information relating to Reservation's Advance Checked In state and Expected Time of Return
$ref: '#/components/schemas/advanceCheckInType'
reservationStatus:
description: Indicates the status of the reservation.
$ref: '#/components/schemas/pMS_ResStatusType'
reservationPackages:
description: A Service object represents a non-room product provided to guests. Service products may have associated inventory and charges.
type: array
maxItems: 4000
items:
$ref: '#/components/schemas/reservationPackageType'
paymentMethod:
description: Payment Method.
type: string
minLength: 0
maxLength: 20
openFolio:
description: Returns true when reservation has an open folio.
type: boolean
preRegistered:
description: Defines if the reservation is pre-registered or not.
type: boolean
shareReservation:
description: Defines if the reservation is shared with another reservation or not
type: boolean
noPost:
description: Defines if the no post flag is set on the reservation or not
type: boolean
uniqueID_Type:
type: object
description: An identifier used to uniquely reference an object in a system (e.g. an airline reservation reference, customer profile reference, booking confirmation number, or a reference to a previous availability quote).
properties:
id:
description: A unique identifying value assigned by the creating system. The ID attribute may be used to reference a primary-key value within a database or in a particular implementation.
type: string
minLength: 0
maxLength: 80
type:
description: A reference to the type of object defined by the UniqueID element.
type: string
minLength: 0
maxLength: 40
idExtension:
description: 'Additional identifying value assigned by the creating system. Eg: ConfirmationLegNumber, ExternalLegNumber'
type: integer
currencyAmountType:
type: object
description: A monetary value expressed with a currency code.
properties:
amount:
description: A monetary amount.
type: number
currencyCode:
description: Provides a currency code to reflect the currency in which an amount may be expressed.
type: string
minLength: 3
maxLength: 3
housekeepingRoomStatusType:
type: string
description: Simple type for room status instructions to be used in requests for fetching housekeeping rooms. Valid status values are Clean, Dirty, Pickup, Inspected, OutOfOrder, OutOfService.
enum:
- Clean
- Dirty
- Pickup
- Inspected
- OutOfOrder
- OutOfService
tierAdministrationType:
type: string
# --- truncated at 32 KB (89 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-hospitality/refs/heads/main/openapi/oracle-hospitality-packagecategory-api-openapi.yml