Oracle EPM Cloud Update – June’21 (21.06)

Posted by: PARC’s Oracle EPM Team

Each month PARC analyzes Oracle’s EPM Cloud updates with an eye toward our customers’ ability to take full advantage of them. The monthly updates include things like bug fixes, modest changes, and even powerful new functionality. This update is part of PARC’s service to its valued customers and is centered around changes to the products and technologies most impacted in their implementations.

 

The below changes are scheduled to take place during the first nightly maintenance period after 2AM ET on Saturday June 5, 2021 (test environments) and on or after 2AM ET on Saturday, June 19, 2021 (production environments).

Customers with questions about any of the changes summarized below should contact us. Oracle’s web page for the full contents of the update can be found here: 

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/epm/wn/epm/releases/Jun21/21jun-epm-wn.htm

EPM Cloud Common

Removal of Some Migration Options

Oracle has removed some unused or rarely used options from the Import Options screen in Migration.

Deleted Import Options and their Default Replacement Values:

 

Migration Option

Import Default Value

 Data Management – Skip Validation False
 Essbase Application – Overwrite Artifacts N/A
 Essbase Application – Restructure Cube N/A
 Groups and Membership – Max Error Threshold 100

 

Embedding Content Using Direct Links

Oracle has increased their customization of EPM Cloud objects to ERP Cloud Source systems with Direct Links. Now, you can easily embed EPM Forms, Reports, Dashboards and Grids within the ERP Source Systems to create a more unified interface across platforms.

How-To Video link here:

https://apexapps.oracle.com/pls/apex/f?p=44785:265:0:::265:P265_CONTENT_ID:29877

 

New EPM Integration Agent Diagnostic Mode

The EPM Integration Agent now enables you to run a set of validations against the parameters in the agent startup file.

In diagnostic mode, the agent is not registered to the EPM Cloud but runs these validations:

  • SSL certificates
  • Agent connectivity to the Internet. Includes making a test call to the oracle.com from the agent.
  • Agent connectivity to the EPM Cloud URL within the agent.
  • Proxy type (basic, digest, or NTML) when proxy is enabled in the customers environment.
  • Double quotes are used in Linux/Mac OS startup parameter file entries. Double quotes enable the shell to interpret dollar sign ($), backtick(`), backslash(\) and exclamation mark(!)
  • Password is encrypted in the agent parameter file.
  • Checks any whitespaces before or after parameters. If whitespaces are encountered, the system trims them and updates the startup parameter file.

 

 

Importing Data From Files in the EPM Integration Inbox

Customers can now import data from a file in a local EPM Integration Agent inbox folder and then have the agent upload and process the file.

This feature requires that a customer create an inbox in the EPM Integration Agent Data folder and then stage the file. Additionally, the customer must specify the location of the inbox in the startup parameters file and then update the integration definition in Data Integration.

Business Benefit: Prior to this update, a customer had to use an EPM Automate command to import data from a file to the EPM Integration Agent.

 

New Integration Agent File Adapter

In this update, Data Integration supports the direct load of a file-based data source using the EPM Integration Agent.

With this feature, customers can now create a new data source adapter for an on-premises file. The agent file adapter does not include any connection or query parameters. The only required parameter is the name of the file. A delimited file with a header record is required for the load.

 

Other Important Notices

Upcoming Change to Smart View Ad hoc Behavior

Starting with the August (21.08) update, all new and recreated applications will default to “Standard” mode instead of “Native” mode for the Smart View Ad Hoc Behavior.

For existing applications and migrated applications, “Native” will remain as the default Smart View Ad Hoc Behavior, with “Standard” being an option.

Please note that “Native” mode in Smart View Ad Hoc Behavior will eventually be phased out. We recommend that all customers switch their applications to “Standard” mode ad hoc behavior soon.

 

Smart View Add-on Installation for Task Manager and Supplemental Data Manager

In an upcoming release, the installation of Smart View add-ons for Task Manager and Supplemental Data Manager will change. At that time, users of the Smart View add-ons will need to uninstall and re-install their add-ons to take advantage of the latest features and fixes.

Author: PARC Oracle EPM Team
PARC's expert Oracle EPM team includes: Steven Cranford, Tom Stehura, Luis Castillo

Leave a Reply

  • Oracle EPM Cloud Update – Dec’21 (21.12)

    These Oracle EPM updates are scheduled to take place during the first nightly maintenance period on or after 2AM ET on Saturday Dec 3, 2021 (test environments) and on or after 2AM ET on Saturday, Dec 17, 2021 (production environments).

    December 2, 2021
  • Oracle EPM Cloud Update – Nov’21 (21.11)

    These Oracle EPM updates are scheduled to take place during the first nightly maintenance period on or after 2AM ET on Saturday Nov 5, 2021 (test environments) and on or after 2AM ET on Saturday, Nov 19, 2021 (production environments).

    November 3, 2021
  • Block Creation in Essbase – Part 2

    The previous post ended with a discussion on using DATACOPY to create blocks. I stated that it was my preferred method of making sure the right blocks were created for use. However, we may run into a situation requiring an “IF” test to determine when we create the blocks. In this situation, we cannot use DATACOPY as it is not syntactically valid inside an IF test.

    October 22, 2021
  • Block Creation in Essbase – Part 1

    A data block is the fundamental unit of storage for a cube in Essbase or Planning (including Planning Cloud). When developing a new calculation or updating an existing calculation, inevitably, block creation will become an issue for us. When writing calculations, you need to be sure that the data blocks either already exist or that they get created as part of your calculation; otherwise, you’ll end up without the data you need.

    October 14, 2021
+ posts

PARC's expert Oracle EPM team includes:
Steven Cranford,
Tom Stehura,
Luis Castillo

+ posts

PARC's expert Oracle EPM team includes:
Steven Cranford,
Tom Stehura,
Luis Castillo