Oracle Hospitality

Supergood | Oracle Hospitality API

Alex Klarfeld

Alex Klarfeld

— 6 min read
Supergood | Oracle Hospitality API

Programmatically access Oracle Hospitality’s hotel and food & beverage systems—OPERA Cloud PMS, Micros Simphony POS, inventory, folios, rates—and operational data via a stable REST API. Supergood builds and operates production-grade, unofficial Oracle Hospitality integrations so your team can automate reservations, check-in/out, charge posting, and revenue exports without heavy custom engineering.

Oracle Hospitality is software that powers hotel property management and restaurant operations across brands and independent properties. With an unofficial API, you can create and update reservations, retrieve room availability and rates, post charges to folios, ingest POS checks and payments, and export daily revenue for reconciliation—directly inside your apps, data pipelines, or automation.

If you’re a tech company integrating Oracle Hospitality, you can pull normalized reservation and guest data, push check-in/out and folio charges, ingest Simphony checks in real time, and stream occupancy, ADR, and itemized sales to your warehouse. You can also sync guest preferences, trigger upsells, reconcile payments, and generate audit trails—reducing manual portal work while adding modern automation to legacy workflows.

What is Oracle Hospitality?

Oracle Hospitality provides enterprise platforms for hotels, resorts, casinos, and restaurants. Core products include OPERA Cloud Property Management System (PMS) for reservations and guest services, and Micros Simphony POS for food & beverage operations. The suite spans distribution, rate management, inventory, reporting, and analytics.

Core product families include:

  • Property Management (OPERA Cloud PMS: reservations, room management, check-in/out, folios)
  • Food & Beverage (Micros Simphony POS: menus, orders, checks, discounts, payments)
  • Distribution and Rates (rate plans, channels, availability)
  • Inventory and Costing (recipes, items, suppliers)
  • Reporting and Analytics (revenue, occupancy, ADR/RevPAR, sales)

Common data entities:

  • Properties and outlets (hotel, restaurant, bar)
  • Rooms and room types
  • Rate plans and availability
  • Reservations and stays
  • Guests and profiles
  • Folios, line items, payments, taxes
  • POS checks, menu items, modifiers, tenders
  • Employees, shifts, roles

The Oracle Hospitality Integration Challenge

Organizations rely on Oracle Hospitality daily, but turning portal-centric workflows into automated pipelines is difficult:

  • Licensing and entitlements: Modern APIs (OHIP/OHIP Catalog, OPERA Web Services) often require partner programs, paid licenses, and product-specific entitlements.
  • Mixed deployments: Cloud (OPERA Cloud, Simphony Cloud) coexist with on-prem and legacy interfaces, each with different authentication and network constraints.
  • Portal-first operations: Many capabilities sit behind web UIs; public APIs may be limited, versioned by product, or require certification.
  • Data normalization: Folio line items, taxes, service charges, multiple currencies, rate codes, and property-level configuration vary widely.
  • Timeliness and exports: Real-time change events and bulk exports can be restricted or costly; teams resort to manual reports or brittle scrapers.

How Supergood Creates Oracle Hospitality APIs

Supergood reverse-engineers authenticated browser flows and network interactions to deliver a resilient API endpoint layer for your Oracle Hospitality workflows.

  • Handles username/password, SSO/OAuth, and MFA (SMS, email, TOTP) securely
  • Maintains session continuity with automated refresh and change detection
  • Normalizes responses so you can integrate once and rely on consistent objects across PMS and POS
  • Aligns with customer entitlements and licensing constraints to ensure compliant access

Use Cases

Reservation Sync and Mobile Check-In

  • Create and update reservations with normalized rate and room data
  • Trigger check-in/out flows from your app or kiosk
  • Attach preferences and notes to guest profiles

POS Order Ingestion and Reconciliation

  • Ingest Micros Simphony checks with item-level detail and tenders
  • Map restaurant charges to rooms or corporate accounts
  • Reconcile daily F&B revenue with PMS folios

Folio Automation and Charge Posting

  • Post parking, spa, minibar, or upsell charges programmatically
  • Apply taxes and service fees consistently across properties
  • Export folios and payments for financial systems and audit trails

Data Warehouse Exports and Analytics

  • Stream reservations, occupancy, ADR/RevPAR into your warehouse
  • Normalize multi-property data for chain-level analytics
  • Power dashboards, forecasting, and revenue management

Available Endpoints

Authentication

POST /auth/sessions: Establish a session using credentials. Supergood manages MFA (SMS, email, TOTP) and SSO/OAuth when enabled. Returns a short-lived auth token maintained by the platform.

curl --request POST \
  --url https://api.supergood.ai/integrations/<integration_id>/auth/sessions \
  --header 'Authorization: Basic <Base64 encoded token>' \
  --header 'Content-Type: application/json' \
  --data '{
    "username": "[email protected]",
    "password": "<password>",
    "mfa": { "type": "totp", "code": "123456" },
    "ssoProvider": "oracle_idcs"
  }'

Example response

{
  "authToken": "eyJhbGciOi...",
  "expiresIn": 3600,
  "user": {
    "id": "u_8172af",
    "name": "Front Desk",
    "entitlements": ["pms", "pos", "reports"]
  }
}

POST /auth/sessions/refresh: Refresh an existing token to keep sessions uninterrupted.

Reservations

POST /reservations: Create or upsert a reservation in OPERA Cloud PMS.

curl --request POST \
  --url https://api.supergood.ai/integrations/<integration_id>/reservations \
  --header 'Authorization: Bearer <authToken>' \
  --header 'Content-Type: application/json' \
  --data '{
    "propertyId": "prop_rome_001",
    "arrivalDate": "2026-02-10",
    "departureDate": "2026-02-13",
    "roomTypeCode": "DLX",
    "ratePlanCode": "BAR",
    "adults": 2,
    "children": 0,
    "guaranteeType": "credit_card",
    "payment": {
      "cardType": "visa",
      "last4": "4242",
      "token": "tok_9a1bc2"
    },
    "guestProfile": {
      "firstName": "Jordan",
      "lastName": "Lee",
      "email": "[email protected]",
      "phone": "+1-415-555-0101",
      "loyaltyNumber": "GOLD-99821"
    },
    "preferences": ["high_floor", "foam_pillows"],
    "externalReferenceId": "web-resa-55231"
  }'

Example response

{
  "reservationId": "res_78d2f1",
  "propertyId": "prop_rome_001",
  "status": "booked",
  "createdAt": "2026-01-24T11:21:09Z",
  "confirmationNumber": "RC-2338194"
}

Folios

GET /folios/{reservationId}: Retrieve normalized folio items, taxes, and payments for a reservation.

curl --request GET \
  --url https://api.supergood.ai/integrations/<integration_id>/folios/res_78d2f1 \
  --header 'Authorization: Bearer <authToken>'

Example response

{
  "reservationId": "res_78d2f1",
  "folioId": "fol_9c32ab",
  "currency": "EUR",
  "items": [
    {
      "itemId": "fi_001",
      "date": "2026-02-11",
      "description": "Room Charge DLX BAR",
      "amount": 180.00,
      "tax": 18.00,
      "service": 0.00,
      "code": "ROOM"
    },
    {
      "itemId": "fi_002",
      "date": "2026-02-11",
      "description": "Restaurant - Dinner",
      "amount": 62.50,
      "tax": 6.25,
      "service": 0.00,
      "code": "FNB"
    }
  ],
  "payments": [
    {
      "paymentId": "pay_771",
      "date": "2026-02-11",
      "method": "credit_card",
      "amount": 200.00,
      "cardType": "visa",
      "last4": "4242"
    }
  ],
  "totals": {
    "subtotal": 242.50,
    "tax": 24.25,
    "service": 0.00,
    "balance": 66.75
  }
}

POS Checks (Micros Simphony)

GET /pos/checks: List POS checks (orders) from Micros Simphony with item-level detail, tenders, and outlet metadata.

curl --request GET \
  --url 'https://api.supergood.ai/integrations/<integration_id>/pos/checks?propertyId=prop_rome_001&outletId=resto_01&date=2026-02-11' \
  --header 'Authorization: Bearer <authToken>'

Example response

{
  "propertyId": "prop_rome_001",
  "outletId": "resto_01",
  "date": "2026-02-11",
  "checks": [
    {
      "checkId": "chk_50012",
      "openedAt": "2026-02-11T18:02:19Z",
      "closedAt": "2026-02-11T19:14:03Z",
      "table": "12",
      "server": { "id": "emp_299", "name": "S. Rossi" },
      "items": [
        { "sku": "PASTA-CARB", "name": "Spaghetti Carbonara", "qty": 2, "unitPrice": 14.00, "modifiers": [] },
        { "sku": "HOUSE-RED", "name": "House Red Wine", "qty": 1, "unitPrice": 8.50, "modifiers": ["glass"] }
      ],
      "discounts": [ { "code": "HAPPYHOUR", "amount": 2.00 } ],
      "tax": 3.85,
      "service": 0.00,
      "total": 37.35,
      "tenders": [ { "type": "card", "amount": 37.35, "cardType": "visa", "last4": "4242" } ],
      "roomPosting": { "reservationId": null, "folioId": null }
    }
  ],
  "pagination": { "nextCursor": null }
}

Get full API Specs →

Technical Specifications

  • Authentication: Username/password with MFA (SMS, email, TOTP) and SSO/OAuth where enabled; supports service accounts or customer-managed credentials
  • Response format: JSON with consistent resource schemas and pagination across PMS and POS
  • Rate limits: Tuned for enterprise throughput while honoring licensing and usage controls
  • Session management: Automatic reauth and cookie/session rotation with health checks
  • Data freshness: Near real-time retrieval of reservations, folios, and POS checks
  • Security: Encrypted transport, scoped tokens, and audit logging; respects Oracle Hospitality entitlements
  • Webhooks: Optional asynchronous delivery for reservation updates, folio changes, and POS check closures

Performance Characteristics

  • Latency: Sub-second responses for list/detail queries under normal load
  • Throughput: Designed for high-volume reservation sync and nightly POS exports
  • Reliability: Retry logic, backoff, and idempotency keys minimize duplicate actions
  • Adaptation: Continuous monitoring for UI/API changes with rapid adapter updates

Getting Started

  1. Schedule Integration Assessment

Book a 30-minute session to confirm your product mix, licensing, and authentication model.

  1. Supergood Builds and Validates Your API

We deliver a hardened Oracle Hospitality adapter tailored to your workflows and entitlements.

  1. Deploy with Monitoring

Go live with continuous monitoring and automatic adjustments as Oracle Hospitality evolves.

Schedule Integration Call →

Frequently Asked Questions

Q: Which Oracle Hospitality products can this integration cover?

Supergood supports workflows across OPERA Cloud PMS and Micros Simphony POS, subject to your licensing and entitlements. We scope coverage during integration assessment and can extend to inventory and reporting where feasible.

Q: How are API licensing and costs handled?

We operate within your Oracle Hospitality entitlements (e.g., OHIP/OWS access) and do not resell Oracle licenses. If API access is limited, we can automate portal-driven flows while complying with your agreements and usage controls.

Q: Can you support on-prem OPERA or Simphony deployments?

Yes. We adapt to on-prem and hybrid environments with secure headless browser automation or local connectors, accounting for network whitelists, SSO, and property-level segregation.

Q: How are MFA and SSO handled for automation?

We support username/password + MFA (SMS, email, TOTP) and can operate behind SSO/OAuth when enabled. Sessions are refreshed automatically with secure challenge handling.

Q: Can I post charges to guest folios and reconcile POS sales?

Yes. You can retrieve folios and, where permitted, post itemized charges with taxes and service fees. POS checks are normalized for item-level analytics and revenue reconciliation.

Q: How often can data be exported?

Near real-time for operational updates and scheduled batch exports for finance. We tune polling, webhooks, and rate limits to meet your SLAs and licensing constraints.

Toast POS API - Programmatically access Toast POS with Supergood

Ready to automate your Oracle Hospitality workflows?

Supergood can have your Oracle Hospitality integration live in days with no ongoing engineering maintenance.

Get Started →

Read more