Skip to content

FousOracle MICROS Simphony Reporting & Analytics

Pull your Simphony reports into your own systems

Read the Daily Operations report, guest checks and the checks with voids or discounts from Reporting and Analytics with one API call each. A workflow can collect the previous business day for every location each morning and email you the totals.

Works with your own Oracle MICROS Simphony Reporting & Analytics account. Fous is an independent product.

What you can build on Reporting and Analytics

  • Get the Daily Operations report

    Build this

    Runs the Daily Operations report for one location and business date and reads its sales and labor figures and its Adjustments section.

    Takes
    Location, business date
    Returns
    Net sales, check count, total discounts, voids, manager voids, returns, error corrects, cancels, labor cost, labor cost percent
  • Search guest checks

    Build this

    Uses Reports > Guest Checks to find the checks at one location that match a business date range and other criteria, and opens each Check Detail.

    Takes
    Location, business dates (up to 7 days), check number, check employee, check total (optional)
    Returns
    Check number, business date, check employee, revenue center, order type, tender type, discounts, check total
  • Get checks with voids or discounts

    Build this

    Opens All Checks with Voids, All Checks with Manager Voids or All Checks with a Discount for one location and business date.

    Takes
    Location, business date, kind (voids, manager voids or discount)
    Returns
    Check number, check employee, item or discount name, amount, check total
  • Run a report from My Reports or Library

    Build this

    Opens a report from My Reports or Library, such as Labor Summary or Time Card Summary, runs it for the locations and dates given and reads its table.

    Takes
    Report name, locations, start date, end date
    Returns
    Report name, location, date range, the report's rows with its column names

Automate Reporting and Analytics with a workflow

A workflow runs your methods as one process, with nobody at the screen. A schedule or a call from your own system starts it, the steps run in order, and the result arrives in your inbox or in the systems you already use.

  • Previous business day's Daily Operations, every location

    Build this
    Starts
    Every day at 7:00 in your time zone
    Step 1
    For each location you name, get the Daily Operations report for the previous business date.
    Step 2
    Keep net sales, check count, total discounts, voids and labor cost percent.
    Step 3
    Email you one table with a row per location.
  • Manager voids and discounts, sent to loss prevention

    Build this
    Starts
    Every day at 8:00
    Step 1
    For each location, get the checks with manager voids and the checks with a discount for the previous business date.
    Step 2
    Keep the checks above the amount you set.
    Step 3
    Post each check, with location, check employee and amount, to your loss prevention webhook.
  • Weekly Labor Summary, sent to your payroll system

    Build this
    Starts
    Every Monday at 6:00
    Step 1
    Run the Labor Summary report for the previous Monday to Sunday for each location.
    Step 2
    Group the rows by location in an AI step.
    Step 3
    Post the result to your payroll system's webhook.

You can run a workflow by hand on every plan, Free included. Schedules and webhook triggers come with the paid plans, from $29 a month.

Once built, one call from your code

Once you have built a method, it is one POST to /v1/runs from your backend, or a tool an AI agent calls over MCP. This is what “Get the Daily Operations report” would look like.

Example request
curl https://api.fous.com/v1/runs \
  -H "Authorization: Bearer $FOUS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "method": "oraclemicros.com/get_daily_operations",
    "input": {
      "location": "Northwind Grill Downtown",
      "business_date": "2026-11-11"
    }
  }'
Example response
{
  "status": "completed",
  "data": {
    "location": "Northwind Grill Downtown",
    "business_date": "2026-11-11",
    "net_sales": 18420.55,
    "check_count": 612,
    "total_discounts": 486.2,
    "voids": {
      "count": 9,
      "amount": 131.4
    },
    "manager_voids": {
      "count": 3,
      "amount": 58.75
    },
    "returns": {
      "count": 1,
      "amount": 12.5
    },
    "error_corrects": {
      "count": 14,
      "amount": 96.3
    },
    "cancels": {
      "count": 2,
      "amount": 21
    },
    "labor_cost": 4973.55,
    "labor_cost_percent": 27
  }
}

An example with invented data, not a ready-made endpoint. The method exists in your organization once you build it, and its name, inputs and fields follow your request.

Reporting and Analytics’s own options

Oracle documents a Business Intelligence REST API that reads the Reporting and Analytics database: daily and quarter-hour totals, guest checks, labor, kitchen, cash management and fiscal data. It needs an API account added in Reporting and Analytics. Self-service exports deliver files by SFTP or HTTPS, and Report Mail emails scheduled reports.

OptionWhat it coversWhat it takes
Business Intelligence APIDaily and quarter-hour totals, guest checks, time cards, kitchen performance, cash management and fiscal transactions, by location.An API account added by a user with the Manage API Accounts privilege, scoped to an organizational level or chosen locations.
Self-service exportsA query you configure, run on a schedule or on demand, delivered as a file to an endpoint through SFTP or an HTTPS post.An export configuration, a location group, a delivery profile and an export schedule set up on the Exports tab.
Report MailRuns a report at a set date and time and emails it to a person or role. Chart visualizations are not included.A report mail schedule set up in Reporting and Analytics.
Reporting and Analytics by handReports from My Reports or Library, exported to Excel (.xlsx), CSV or PDF, and the Guest Checks search.A user account with the data permissions each report needs, such as Sales and Operations or Labor.

Read on November 12, 2026: Adding a Business Intelligence API Account, Export Data from Reporting and Analytics, Business Intelligence API Guide: All REST Endpoints.

Signing in to Reporting and Analytics

Reporting and Analytics asks for your user name and enterprise name, then your password, or sends you to your company's own sign-in page when it uses single sign-on. Each company has its own address with its short name in it. With Fous you sign in through that page with your own account: the login is sealed with AES-256, code and AI agents never see it, and with password sign-in an expired session is signed back in.

Worth knowing

Guest Checks searches cover 7 days at most
The business date range in Reports > Guest Checks is limited to 7 days, and the discount name filter appears only after you pick a location.
Daily Operations has several versions
Daily Operations has separate versions for quick service and table service restaurants, and for add-on and inclusive tax. Build the method on the version your locations use.
Permissions decide what a report shows
Daily Operations needs the Sales and Operations and Labor permissions, and Guest Checks needs Sales and Operations. A method sees only what your user's permissions allow.
API accounts cannot sign in to the site
A Business Intelligence API account gets an Invalid credentials error on the Reporting and Analytics sign-in page. It is scoped to a level or to locations, and a location list is not updated when locations are added.

More in Food service, restaurants and alcohol

Other industries: Banno Business, NextGear Capital Account Portal, 登記情報提供サービス, FBR IRIS, Alloggiati Web, Portal Empresarial INFONAVIT.

Frequently asked questions

Yes. Oracle documents the Business Intelligence REST API for totals, guest checks, labor, kitchen, cash management and fiscal data. You need an API account added in Reporting and Analytics by a user with the Manage API Accounts privilege. Self-service exports and Report Mail also send data out on a schedule.

Open the report from My Reports or Library and export it to Excel (.xlsx), CSV or PDF, or print it. For a file on a schedule, set up a self-service export or Report Mail.

Reporting and Analytics shows them per report: Daily Operations has the counts and amounts, and All Checks with Voids or All Checks with a Discount list the checks. With Fous, a workflow you build can loop over your locations each morning, run those methods and email you or post the result to a webhook.

Yes, through Reports > Guest Checks. Search by business date, check number, check total, employee name or the last 4 digits of a card where your payment setup supports it, then open the Check Detail report to download or print it.

No. Fous is an independent product. You use it with your own Reporting and Analytics account, and a method reads and does only what that account can.

Put Oracle MICROS Simphony Reporting & Analytics behind an API call

Describe one job in Studio and see the method it builds, with 100 credits a month and no credit card, or book a demo and bring the sites your team signs in to.

Read nextToast WebInsights C3MSGWS ProofBanno BusinessHow methods workHow workflows run

Fous is an independent product: it is not affiliated with, endorsed by or sponsored by the operator of Oracle MICROS Simphony Reporting & Analytics (Oracle). The name is used only to say which system this page is about. Something here wrong or out of date? Write to legal@fous.com.