July 2020 Update

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Overview

This guide outlines the information you need to know about new or improved functionality in this update.

DISCLAIMER

The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.

This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.

Sales Planning Cloud

New Topics in EPM Cloud Operations Guide

The EPM Cloud Operations Guide has been enhanced with the following topics:

• Diagnosing REST API Issues
• Handling Issues Related to Large Data Exports

Operations Guide Links in the Provide Feedback Utility

The Provide Feedback Utility in EPM Cloud now contains links that connect you to different types of troubleshooting information published in the Oracle Enterprise Performance Management Cloud Operations Guide. These links provide you information to self-diagnose issues and the mandatory information that you must submit to Oracle when you seek help for an issue that you cannot solve yourself.

New Version of Oracle Smart View for Office

Oracle Smart View for Office 20.100 is now available. This version includes a new connection URL mapping tool; a new VBA function, HypUpdateConnection; support for basic authentication in the HypSetCustomHeader function; and performance improvements focused on refresh functionality. Install the 20.100 version of Smart View to ensure access to the new features.

EPM Automate Updates

A new version of EPM Automate, which contains the createGroups and deleteGroups commands, is available. Additionally, the login command has been updated to exclude the use of  IDENTITY_DOMAIN as a required parameter.

Add and Remove Groups Using REST APIs

You can now use REST APIs to add and remove a batch of groups listed in an ANSI or UTF-8 encoded CSV file that was uploaded to the environment. Use the Upload REST API to upload the file. This gives you the freedom to manage groups outside of the user interface.

REST API to Run Integrations/Data Load Rules by Period Name and Override Source Filters

In Data Management and Data Integration, a new REST API is available to run integrations/data load rules by period name and override source filters.

Support for Groovy Templates in ASO Cubes for Sales Planning Cloud Applications

Groovy templates are now supported in ASO cubes for Sales Planning Cloud applications.

Consistent Column Labels and Search in Access Control

Access Control now uses a consistent, intelligent search function across screens that supports search for artifacts such as users and groups. You now can enter a search string to search all searchable attributes. Previously, you had to select an attribute; for example First Name, from a drop down list before running a search. Additionally, Access Control now uses consistent artifact names and labels across screens.

EPM Integration Agent Write-Back

In Data Integration, EPM Integration Agent write-back is now available.

New Clear Region Option in Data Integration

When loading data to a Planning module or Oracle Fusion General Ledger application in Replace mode, you can now specify a custom clear region to filter data at a granular level.

New System Setting for Migration of Data Load Mappings in Data Management

In Data Management, a new Map LCM Format profile option has been added that enables you to specify how data load mappings are exported to the target environment.

Oracle Financial Cloud Source System Type Name Changed to Oracle ERP Cloud

The "Oracle Financial Cloud" source system type name has been changed to "Oracle ERP Cloud."

New Time Balance Properties Let You Customize or Disable Data Spreading Behavior on Forms

You can now customize or disable data spreading on forms using two new time balance properties: Custom and Disable.

Audit Will Now Retain Records for Up to 365 Days

Audit information is now retained for up to 365 days from the current system date.

New Data Map Option - Prioritize Smart List Entry Names When Moving Data

A new data map option, called Prioritize Smart List Entry Names When Moving Data, requires the data map and Smart Push operations to use Smart List entry names instead of aliases in cases where the target cube has duplicate aliases.

APIs Deprecated from the EPM Cloud Groovy Rules Java API Reference

When using EPM Cloud Groovy Rules, be aware that the following APIs are deprecated from the EPM Cloud Groovy Rules Java API Reference: TimeZone.setDefault(TimeZone zone), Locale.setDefault(Locale.Category category, Locale newLocale), and Locale.setDefault(Locale newLocale).

Update to the Exception Response in REST APIs

When working with REST APIs, be aware that Oracle has removed the internal package and class names from the following fields in the exception response in REST APIs: message and localizedMessage.