Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Synopsis of EPM Cloud Updates - May 2020 | Main | Best Practice: Oracle Primavera P6 EPPM Cloud Migration »

Synopsis of EPM Cloud Updates - June 2020

Oracle Enterprise Performance Management Cloud June 2020 New Feature Summary


ENTERPRISE PERFORMANCE MANAGEMENT CLOUD


EPM CLOUD COMMON

This section contains announcements related to the common EPM Cloud components such as EPM Automate, Migration, Access Control, Data Integration, and Smart View for Office.

NEW TOPICS IN EPM CLOUD OPERATIONS GUIDE:

The EPM Cloud Operations Guide has been enhanced with additional topics.

Making EPM Cloud-Related Requests:

Ø      Requesting Design Comparison for On-Premises Planning Application Migrated to EPM Cloud

Ø      Submitting an Enhancement Request

Ø      Requesting an Increase in Financial Consolidation and Close Dimension Governor Limits

Ø      Requesting Root Cause Analysis (RCA) for a Resolved Issue

Ø      Requesting an Old Backup Snapshot of an Environment

Ø      Requesting an Increase in Capacity

Ø      Requesting a Health Check for an Environment

Ø     Requesting EPM Cloud Roadmap Information

Ø     Making Other Requests

Asking How-to Questions.

EPM AUTOMATE UPDATES:

A new version of EPM Automate, which contains the runRuleset command is available. This command, which launches a ruleset, works only with Planning, Financial Consolidation and Close, and Tax Reporting environments. Additionally, the sortMember command has been updated to work with Planning Modules applications.

CHANGE IN EMAIL ADDRESS FOR OUTGOING EMAILS:

Emails originating from EPM Cloud applications will now use no.reply@oraclecloud.com  instead of oraclecloudadmin_ww@oracle.com  as the from address.

Emails from other Oracle Cloud sources, for example, New Account email sent from the Identity Domain, will continue to use the current From email addressses, for example, oraclecloudadmin_ww@oracle.com.

SIMPLIFIED SEARCH IN ACCESS CONTROL:

Access Control now uses a simplified, intelligent search function across screens that supports search for artifacts such as users and groups. This search function, unlike the previous version, does not use wildcard characters with partial search strings. Instead, it searches using a partial string from one of the user (user name, first name, last name, and email ID) or group (group name) attributes to retrieve all artifacts that contains the search string. For example, using the string st to search for groups displays groups such as Test, Cast, Analysts, and so on. Similarly, using the search string Fr displays user names of Frank, Freddy, Alfred, and so on.

FLASH DISABLED BY DEFAULT IN CALCULATION MANAGER:

Flash is now disabled by default in Calculation Manager. You can still enable Flash temporarily, if desired.

MANAGE DIMENSIONS WITH ADMIN EXTENSION IN SMART VIEW (MAC AND BROWSER):

Service Administrators can now deploy and use the Admin Extension in Oracle Smart View for Office (Mac and Browser) to import and edit dimension and member metadata in a Smart View grid.

SET USER PREFERENCES IN SMART VIEW (MAC AND BROWSER):

You can now set user preferences in Oracle Smart View for Office (Mac and Browser) to control many aspects of function and display. The changes you make in Smart View (Mac and Browser) are saved to the EPM Cloud business process and are remembered the next time you log in to either the web interface or Smart View. User Preferences apply to Planning, Financial Consolidation and Close, and Tax Reporting.

REST API TO REVIEW REJECTED DATA AFTER IMPORT:

While using a REST API to import data, you can now get the errored out records. To do this, you specify an error file that captures the data records that are not imported for each dimension. If an error file is specified, a separate error file is created for each dimension. The error files are then zipped together and the zip file is stored in the Outbox where you can download the file using Inbox/Outbox Explorer or tools like EPM Automate or REST APIs. This applies to Planning, Financial Consolidation and Close, and Tax Reporting.

NEW APPLICATIONS OPTION IN DATA INTEGRATION:

A new Applications option is now available in Data Integration (the simplified user interface). Use the new option to register new applications, or select an existing application and update application options, delete it, or refresh application definitions.

REGISTERING APPLICATIONS FOR CUBES IN DATA INTEGRATION:

In Data Integration, customers can now register more than six cubes as applications.

NEW ORACLE NETSUITE PBCS SYNC SUITEAPP SAVED SEARCHES:

In this update, two new Oracle NetSuite PBCS Sync SuiteApp Saved Searches are supported in Data Integration and Data Management.

REPLACE MODE FOR ALL DATA TYPE WITH SECURITY LOAD METHOD NOW SUPPORTED:

In Data Management and Data Integration, Replace mode for the All Data Type with Security load method is now supported.

LCM MIGRATION OF DATA LOAD MAPPINGS IN DATA MANAGEMENT:

In order to improve the performance of export and importing large data load mappings, Data Management now exports the mapping by individual locations. When importing the mappings to the target environment, the existing mappings are completely replaced with mappings from the source environment. Prior to this update, data load mappings from the source were merged into the target environment.

CONNECTING DIRECTLY FROM ORACLE ANALYTICS CLOUD TO EPM CLOUD PLATFORM:

 With this release, you can connect directly from Oracle Analytics Cloud Enterprise Edition or Professional Edition 5.6 to EPM Cloud Platform, provided you have both services. When you've configured the connection, you can visualize data from EPM Cloud business processes (Planning, Financial Consolidation and Close, and Tax Reporting) in Oracle Analytics Cloud. You no longer have to model EPM data in a metadata repository (RPD) file to create visualizations and dashboards in Oracle Analytics Cloud.

ABILITY TO WRITE TO UPPER-LEVEL MEMBERS USING GROOVY:

Using Groovy's new setForcedEditable()method, you can now write to upper level members that are dynamic Calc in both ASO and BSO cubes within an application. You can then use custom allocation logic in Groovy to push data to lower level members. To implement this, follow the steps to create a Groovy business rule in "Creating a Groovy Business Rule" in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud.

SUPPRESS MISSING ROWS WHEN BUILDING GRIDS USING GROOVY:

You can now use Groovy to apply row suppression at the Essbase level when building grids using DataGridDefinitionBuilder. This benefits you by reducing the amount of data on the Planning side and eliminating the impact on query thresholds. To implement this, follow the steps to create a Groovy business rule in Creating a Groovy Business Rule in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud.

USE HSGETVALUE AND HSSETVALUE TO RETRIEVE DATA IN SMART VIEW (MAC AND BROWSER):

The Smart View functions, HsGetValue and HsSetValue, can now be used in Smart View (Mac and Browser). This feature applies to Planning, Financial Consolidation and Close, and Tax Reporting.

 

ACCOUNT RECONCILIATION

 

ABILITY TO SPLIT AN UNMATCHED TRANSACTION AMOUNT IN TRANSACTION MATCHING:

Splitting transactions allows you to manage timing differences for 1 to Many, Many to 1, or Many to Many matches by allowing you to match part of a transaction, leaving aside only the split remaining amount unmatched. This helps keep the number of unmatched transactions as low as possible at the end of each day and allows a reviewer to look at a reconciliation with fewer unmatched transactions.

DATABASE TABLES AND VIEWS GUIDE AVAILABLE FOR HELP WITH CUSTOM REPORTS:

A new Account Reconciliation Tables and Views guide is available to help with developing custom reports. This guide outlines all the database tables and views for Reconciliation Compliance, Transaction Matching, and common tables so that you can more easily develop queries for custom reports.

DELETE ALL TRANSACTIONS FUNCTIONALITY ADDED TO RECONCILIATION COMPLIANCE:

You can now choose to delete all the transactions associated with a reconciliation from the Actions dialog without needing to select them individually.

SETTING DASHBOARD MAXIMUM ROWS FOR RECONCILIATION ACTIONS DIALOG:

The system setting for Maximum Rows now applies to the number of rows of transactions to display in the Reconciliation Actions dialog. Previously, this system setting applied to the Reconciliation, Transactions, Profile, and Matching Lists.

 

FINANCIAL CONSOLIDATION AND CLOSE

 

PERFORMANCE SUBSTITUTION VARIABLES:

The following Substitution Variables can be enabled to improve performance: 

Ø      EnableSimpleAggregation

Ø      OptimizeDBRefresh

Ø      OptimizeYTDCalculation

Ø      OptimizeConcurrency

NOTE: The degree of performance improvement varies widely across different applications as it is purely driven by the application design and data distribution.

ABILITY TO AUTOMATICALLY OPEN AND CLOSE JOURNAL PERIODS USING TASK MANAGER:

 A new Task Manager Integration Type is available that enables you to use Task Manager to open or close Financial Consolidation and Close journal periods automatically during the close period.

ITEM COUNT ADDED TO SUPPLEMENTAL DATA LISTS:

An item count has been added to the lists for Supplemental Data Tasks, and Supplemental Data Analysis. This enables you to see at a glance how many items are contained in that list.

ABILITY TO SELECT LEVEL 0 DESCENDANTS FOR JOURNAL REPORTS:

 When you run a Journal report, you can now directly select the Level 0 descendants of a parent member. For example, from the Member Selector, you can select Level 0 Descendants of the Total Geography Entity parent member, without needing to first select all the entities for that parent.

INTERCOMPANY ENTITY AGGREGATION OPTIONS:

Two additional Intercompany dimension aggregation methods "Subtraction" and "Ignore", in addition to the existing default "Addition" have been added to the Create Application options. If Subtraction or Ignore are selected, then the selected consolidation operator will be applied to the "Intercompany Entities" member when aggregating to the "Intercompany Top" member. The default selection is Addition. The system entries generated by the Standard Eliminations process will also be amended to post the required additional entries should Subtraction or Ignore be selected. Note that the seeded consolidation rules are designed to work with the Addition option so will need to be amended should the Subtraction or Ignore options be selected. Also note that these options are only available during application creation and cannot be enabled after an application has been created.

YEAR-TO-DATE AND JOURNAL-TO-DATE JOURNAL ENTRIES:

 In addition to existing Periodic journal entries, you can now post Year-to-Date and Journal-to-Date journal entries. When you create a journal, you can now select YTD_Input for the View dimension, and then select either of the YTD or JTD options. You can also select Periodic or YTD journals when you run a journal report.

REST API FOR IMPORTING SUPPLEMENTAL COLLECTION DATA:

You can now use a REST API to import supplemental collection data from a file to a collection.

APPLICATION SETTING TO DISABLE VIEW CALCULATIONS:

 Starting with this update, a new option to disable the View calculations is available in Application Settings. This option disables computation and storing of YTD, HYTD and QTD data for data inputs (through forms, data import, Data Management, etc.) in the YTD, HYTD and QTD members.

IMPORTANT! This setting is powerful, and it is recommended that you assess the potential impact before enabling the setting.

 

NARRATIVE REPORTING


UPDATED NARRATIVE REPORTING EXTENSION FOR DISCLOSURE MANAGEMENT:

An updated Narrative Reporting Extension for Oracle Disclosure Management is now available. This update includes general improvements and bug fixes. Download and install the latest Narrative Reporting extension for Disclosure Management to get these changes.

UPDATED NARRATIVE REPORTING EXTENSION FOR SMART VIEW:

An updated Narrative Reporting Extension for Oracle Smart View for Office is now available. This update includes a new message that notifies you if a more recent version of a doclet is available at checkout time, along with other accessibility-related and general improvements and bug fixes.

 

PLANNING

 

WORKFORCE RULES AND FORMS SUPPORT DIFFERENT PLANNING YEARS FOR PLAN AND FORECAST SCENARIOS:

In the Workforce module, rules, templates, and forms have been updated to allow different planning years for the Plan and Forecast Scenarios.

NEW SYNCHRONIZE MENU COMMAND WHEN CREATING DATA MAPS THAT INCLUDE STRATEGIC MODELING MODELS:

In Strategic Modeling or Planning, when you're creating a data map that includes a Strategic Modeling model, if a newly created Strategic Modeling model doesn't appear in the Model list, a new menu command-- Synchronize--is available.

NEW AUDIT TYPE TRACKS CHANGES TO VARIABLES:

There is now an audit type, called Variables, that tracks changes, additions, and deletions to user and substitution variable definitions and values.

REST API TO SORT MEMBERS FOR MODULE APPLICATIONS:

You can now use a REST API to sort members for Module applications. Previously, this feature was only available for Planning and Free Form applications. For example, you can alphabetize a list of child members by sorting in descending order to help users quickly locate members in hierarchies in the dimension editor. This feature is only supported for Planning, Module, and Free Form applications. In Module applications, you cannot sort these dimensions: dense dimensions and the Plan Element dimension from Financials and Project Element dimension from Projects (even if they are renamed).

MANAGE APPLICATIONS WITH ADMIN EXTENSION IN SMART VIEW (MAC AND BROWSER):

Service Administrators can now deploy and use the Admin Extension in Oracle Smart View for Office (Mac and Browser) to create and manage applications in Planning and Planning Modules.

DISPLAY OF LONG ALIAS NAMES WITHIN MEMBER SELECTOR:

You can now see full alias names within member selector in the Web interface without these values being truncated.

NEW PLANNING FORMULA EXPRESSION IN CALCULATION MANAGER:

Calculation Manager now supports a new Planning Formula Expression to leverage the Module Scenario Fiscal Year setting: isPlanStartYearSameAsCurrentFiscalYear.

 

TAX REPORTING

 

ITEM COUNT ADDED TO SUPPLEMENTAL DATA LISTS:

An item count has been added to the lists for Supplemental Data Tasks, and Supplemental Data Analysis. This enables you to see at a glance how many items are contained in that list.

REST API FOR IMPORTING SUPPLEMENTAL COLLECTION DATA:

You can now use a REST API to import supplemental collection data from a file to a collection.

NEW CONSOLIDATED ETR IFRS TAX RATES BY ENTITY FORM:

With this release, you can now override Consolidated ETR IFRS global tax rates (National and Regional/Local) to calculate Consolidated ETR IFRS rates by Entity using a specific entity-level tax rate. You select the specific Entity on the new Consolidated ETR IFRS Rates form, and enter the override National and Local tax rates for the calculation.

TAX AUTOMATION BY INTERCOMPANY PARTNER AND RELATED TAX CALCULATIONS:

With this release, customers can select data from an Intercompany Partner source (for instance, ICPTop, Intercompany [Member], and so on) to perform intercompany eliminations for tax reporting, such as Intercompany dividends, revenue and expense. When performing intercompany eliminations by setting an attribute on the profit account, you can now tax effect the elimination, for instance, intercompany dividends.  

TAX AUTOMATION BY SCENARIO:

With this release, customers can select data from a Source Scenario, and automate the data to a different selected Scenario. As a result, customers will be able to automatically copy data from one Scenario to another. For instance, copy data from a GAAP Scenario to a Statutory Scenario.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Archives