Reporting and Analytics 20.5
Data Access and Integrations
Real-Time Check Extensibility APIs
The Guest Check Extensibility and Guest Check Line Item Extensibility APIs now support incremental retrieval of real-time data using the changedSinceUTC request parameter and curUTC response field. The getGuestCheckExtensibilityDetails API also adds business date and closed business date parameters, aligning its date-selection with getGuestChecks.
City in Location and Revenue Center Dimensions
The getLocationDimensions and getRevenueCenterDimensions BI API endpoints can now return an optional city attribute, providing more complete address information for integrations.
Simphony Check GUID in BI API and Exports
The BI API and Self-Service Exports now expose a consistent identifier for tracing the same check across STSGen2, BI API data, and exported data. It is available as posChkGUID in getGuestChecks and posCheckGUID in the Guest Check Headers export subject area, and corresponds to the checkRef attribute in STSGen2.
Additional SPI Payment Details for Reconciliation
The getSPIPaymentDetails API now includes additional fields to support payment reconciliation, including the modification PSP reference, PSP store identifier, posting date and time in UTC, and table number. These fields help customers performing their own reconciliation connect payment records with the corresponding transaction data.
The API also returns the Boolean orclPmntsTransFlag field for each transaction, identifying transactions processed through Oracle Payments so integrations can distinguish them during reconciliation.
PGP Encryption for Self-Service Exports
PGP-encrypted Self-Service Export files no longer include the OpenPGP “for your eyes only” flag. This allows export files to be decrypted and processed without manual confirmation, supporting unattended integration workflows.
Reports
Brazil Fiscal Reports Updated for NF-e
The “Comprovantes Fiscais do Brasil”, “Comprovantes Fiscais do Brasil Detalhados”, and “Comprovantes Fiscais do Brasil com chave fiscal e arquivo de gravação” reports have been updated to support the NF-e (Nota Fiscal Eletrônica) fiscal model. The reports now provide visibility into NF-e fiscal invoice status and totals from electronic invoice XML files issued and submitted to Brazilian fiscal authorities. This addresses the NF-e requirements for B2B transactions under Brazil’s Reforma Tributária do Consumo (RTC) and Ajustes SINIEF nos. 12/2026 and 13/2026. Oracle Harmony Fiscal Connector for Brazil 25.1.3 or later is required for NF-e fiscal model support.
New Printing Options
New Compact Print options make it easier to print reports using less paper while preserving essential report content. Compact Print reduces spacing, padding, and whitespace, while Compact Print (No Charts) also removes visualizations from the printed output. Both options repeat selected filter details on each page, with the complete filter selections included on the final page.
People Management
New Search Filters
People Management now provides additional search options to help administrators quickly locate employee records. Administrators can filter by De-identified status and search by POS Sign-in Number or Magnetic Card Number, making it easier to find records for support investigations, duplicate review, and integration with external HR systems. Note: Searching by POS Sign-in Number requires Configuration and Content API 23.9.
People Audit Details Enhancements
The People Audit Details export now provides more complete information for reviewing, auditing, and reconciling people data. It applies the selected People Management filters, includes additional employee and audit details, and reorganizes role, visibility, and location information to clarify organizational relationships. Note: Some new columns require Configuration and Content API 23.9.
Platform
RTA Download Available Through My Oracle Support
The RTA download for legacy RES 3700 customers is now provided through My Oracle Support (MOS). The RTA download portlet links to the applicable support article, where users can access the RTA patch.
Mobile Order and Pay Access from Simphony Home
Authorized users can now access Mobile Order and Pay configuration directly from a new navigation item in the Simphony Home side menu. The option is available when the enterprise is enabled for Mobile Order and Pay and the signed-in user has the required POS employee role.