20.1.15

This patch contains bug fixes.

Log in to the Support Portal and then click the following links for more information:

• Document 8285 contains a list of bugs fixed in the patch.

• Document 8286 describes documentation updates to support the patch.

Reporting and Analytics

20.1.15 introduces the following changes:

• New People Management feature introduces a single user interface in the cloud to complete the various tasks around hiring and managing people by managers or corporate employees. The following features were combined:

  • Reporting and Analytics User Management

  • Simphony Enterprise Maintenance Console (EMC) Employee Maintenance

  • Labor Management Human Resources

  From the updated landing page, the logged in person can view and filter all users and employees they manage and have access to. Existing people can be edited and new people can be added to the system. The roles and permissions they can be granted depend on the roles and permissions that are assigned to the hiring manager. As a general rule, you can’t grant more access than you have yourself.

  If your enterprise uses the Oracle MICROS Labor Management product, the Human Resources employee user interface is now fully integrated into the new workflow. The Simphony EMC Employee Maintenance workflow is also integrated so all aspects and permissions of a person can now be set using a single user interface. You can now complete the hiring process of adding a new person in one place, rather than using multiple applications.

  Privileged users can download people audit information, which is a complete list of people in the system with their assigned roles and permissions to be used for internal or external security audits.

  Privacy-related activities, such as de-identifying people, or viewing a person’s personal data report are integrated into the new user interface as well and can be performed with the appropriate permissions.

  See People Management in the Oracle MICROS Reporting and Analytics User Guide for more details.

• To support the new Simphony point of sale feature of Order Channels, new reporting and data access options were added to Reporting and Analytics. Using the new reports, you can analyze business operations and where orders originate from, such as delivery providers, phone, website, and front-of-house.

  New reports were added and several updates were made to some existing reports, the Business Intelligence (BI) API, Self-Service Exports, and Direct Database Access view.

  • Newly added reports. Refer to the Oracle MICROS Reporting and Analytics Reports Reference Guide for more details:

    • Order Channel Sales Mix (Add-On Tax) and (Inclusive Tax).

    • Order Channel Employee Sales (Table Service Restaurant, Add-On Tax), (Table Service Restaurant, Inclusive Tax), (Quick Service Restaurant, Add-On Tax), and (Quick Service Restaurant, Inclusive Tax).

    • Order Channel Sales and Operations (Table Service Restaurant, Add-On Tax), (Table Service Restaurant, Inclusive Tax), (Quick Service Restaurant, Add-On Tax), and (Quick Service Restaurant, Inclusive Tax).

  • Additional breakdowns of sales and operational metrics by order channel were added to existing reports. Refer to the Oracle MICROS Reporting and Analytics Reports Reference Guide for more details:

    • Daily Operations reports

    • System Financial reports

    • Employee Financial Detail reports

  • New and updated API endpoints in the BI API:

    • Added the new getOrderChannelDimensions endpoint.

    • Added the new getOrderChannelDailyTotals endpoint.

    • Order Channel Number (ocNum) was added to getComboItemDailyTotals, getMenuItemDailyTotals, getOrderTypeDailyTotals, and getGuestChecks.

    • New and updated subject areas in Self-Service Exports:

      • Added the Order Channel subject area.

      • Added the Daily Order Channel Summary subject area.

      • Added the orderChannelID, orderChannelNum, orderChannelName, orderChannelMasterNum, and orderChannelMasterName dimensions to various existing menu item, guest check, guest check details, order type, employee, and fixed period subject areas.

    • New and updated components in the Standard Export specification. For more details refer to the Oracle MICROS Enterprise Back Office Standard Export User’s Guide:

      • Added the Daily Order Channel Summary (OCD) component.

      • Added the orderChannelNum, orderChannelName, orderChannelMasterNum, and orderChannelMasterName dimensions to various existing menu item, guest check, guest check details, order type, employee, and fixed period exports and components.

    • New views and dimensions were added to the Database Access Cloud Service Reference Guide:

      • Added the VRO_ORDER_CHANNEL_DAILY_TTL_V1 and VRO_ORDER_CHANNEL_V1 tables.

      • Added the orderChannelID dimension to various existing menu item, guest check, guest check details, order type, employee, and fixed period views.

    • Added a new report with drill-down reports related to Acknowledging Time Card Adjustments. Refer to the Simphony User Guide for more information on the new features. Refer to the Oracle MICROS Reporting and Analytics Reports Reference Guide for more details on the reports:

      • Adjusted Time Cards

      • Unacknowledged Adjustments

      • Time Card Adjustment Details

20.1.15 also introduces the following other changes:

• Further enhanced the BI API:

  • Empty strings are now allowed for searchCriteria and Include request parameter. The API will behave as if the parameters are not specified.

  • The new balanceAmt field was added to the getCashManagementDetails endpoint.

  • The new modPrfx and modFlag were added to the menuItem array in getGuestChecks endpoint. These new fields allow an integrator to identify (default) condiments, and added, removed, or substituted condiments. Refer to the new use case documentation for more details.

• Report filters saved using the Save as action now only appear in the Library as separate reports for the person that saved the parameters. Other users will not see those reports anymore. If a user had been using a report with saved filters they didn’t save themselves, they will need to run the original report, set the filters as desired, and then click Save as for themselves.

• Product version information was removed from the footer and can now be found by clicking your profile name and then clicking About.

• The return limit was increased to 25,000 rows on all reports. That includes all core reports as well as reports built through Report Builder, iQuery, Audit and Analysis, and reports scheduled through Report Mail.

• The character limit was increased for several point of sale definition types so that names with up to 128 characters are displayed on reports. The increased limit applies to the following definitions:

  • Discount, Service Charge, Tax, Tender Media

  • Family Group, Major Group, Menu Item

  • Cash Management Item, Account, Count Sheet, Receptacle, Vendor

  • Employee, Employee Class

  • Order Type

  • Revenue Center

  • Event Area, Definition, Subtype, Type

  • Cashier, Currency, Job Code, Reason Code, Report Group, User Workstation

• Some date and datetime fields in components in the Self-Service Export Standard Export core templates were using a wrong date format. This has been corrected in the latest Version 1.23 of the templates.

• SSH cipher suites support has changed. If you use your own sFTP servers for exports, you must ensure that the receiving servers are up-to-date and do not require the removed ciphers to connect. This applies to custom exports, legacy standard exports, Self-Service Exports, and Gift and Loyalty segmentation exports. If you use an Oracle provided sFTP account, you do not need to make any changes.

  • Removed support for the following SSH cipher suites:

    • Key Exchange

      • diffie-hellman-group14-sha1, diffie-hellman-group-exchange-sha1, diffie-hellman-group1-sha1

    • Symmetric Cipher

      • aes128-cbc, aes192-cbc, aes256-cbc, blowfish-cbc, 3des-cbc, 3des-ctr, arcfour, arcfour128, arcfour256

    • Message Authentication Code (MAC)

      • [e-mail], hmac-sha1, hmac-md5, hmac-md5-96, hmac-sha1-96

    • Server Host Key

      • ssh-rsa, ssh-dss

  • Going forward, we will support the following cipher suites:

    • Key Exchange

      • curve25519-sha256 ([e-mail]), curve448-sha512, diffie-hellman-group-exchange-sha256, diffie-hellman-group14-sha256, diffie-hellman-group15-sha512, diffie-hellman-group16-sha512, diffie-hellman-group17-sha512, diffie-hellman-group18-sha512, ecdh-sha2-nistp256, ecdh-sha2-nistp384, ecdh-sha2-nistp521

    • Symmetric Cipher

      • aes128ctr, aes192ctr, aes256ctr, [e-mail], [e-mail], [e-mail]

    • Message Authentication Code (MAC)

      • [e-mail], [e-mail], hmac-sha2-256, hmac-sha2-512

    • Server Host Key

      • ssh-ed25519 ([e-mail]), nistp384 (ecdsa-sha2-nistp384), rsa-sha2-256, rsa-sha2-512, nistp256 (ecdsa-sha2-nistp256), nistp521 (ecdsa-sha2-nistp521), [e-mail], [e-mail], [e-mail]