Oracle Enterprise Performance Management Cloud
What's New
  1. December 2019 Update
  1. Revision History
  2. Enterprise Performance Management, December Update
        1. Monthly Update Schedule
        2. Please Join Oracle Cloud Customer Connect
        3. Give Us Documentation Feedback
        4. Follow Us on Social Media
        5. Defects Fixed
    1. EPM Cloud Common
        1. New Videos
        2. New Access Control Feature to Assign a User to Many Groups
        3. New Select All Option in the Financial Reporting Web Studio and Book Editor Select Members Dialog Box
        4. Financial Reports Renamed to Reports
        5. EPM Integration Agent Installable as a Windows Service or Linux Background Process
        6. New Version of Oracle Smart View for Office
      1. Upcoming Changes
        1. EPM Cloud's New Look and Feel
        2. Planner Role to be Renamed as User
        3. Removal of Instance Name from Predefined Role Names
        4. Predefined Role Names as EPM Cloud Key Words
        5. Query Governor on BSO and ASO Cubes
      2. Considerations
        1. Clarifications on addUsers EPM Automate Command Behavior
        2. Clarifications to addUsers REST API Behavior
    2. Account Reconciliation
        1. Ability to Filter and Search Jobs List Added to Transaction Matching
        2. Ability to Work with Lower Level Detail in Group Reconciliations
      1. Upcoming Changes
        1. Removal of .XLS Format as Report Export Option
    3. Enterprise Data Management
        1. E-Business Suite General Ledger Application Type
        2. Incremental Import Using Requests - Merge Mode
        3. Custom Validations for Node Types and Hierarchy Sets
        4. New String and Comparison Methods in Expressions
        5. Access to Children and Ancestors in Expressions
        6. Copy and Paste Expression Terms
        7. Node Type Overrides for Property Parameters
        8. Mass Delete of Draft Requests
        9. Node Transaction History
      1. Considerations
        1. Property Pane Doesn't Update in Firefox
        2. Validate Viewpoint Results Show No Failures
        3. Default Values for Node, Date, and Timestamp Display with Red Border
        4. Email Notifications in English
        5. Reverting Property Parameters
        6. User with No Email Address
        7. All Business Processes to Support an Identical Set of Predefined Roles
    4. Financial Consolidation and Close
        1. New Video
        2. Task Manager Audit Enhancements
        3. Ability to Disable Ratio Calculations
        4. Dynamic Children Support is not Available for Business Rules Created Using Calculation Manager
        5. Accumulate Export Mode Available for Financial Consolidation and Close Users in Data Management and Data Integration
      1. Considerations
        1. Calculation Status
        2. Copying Data
        3. Editing Data in a Data Collection Period
        4. Adding Shared Members in Smart View
        5. Self-Service Upgrade
        6. Horizontal Scroll on a Non-Tabular Form
        7. Unable to Refresh the Cube
        8. Viewing Members on Seeded Forms
        9. Viewing the FCCS_VIEW_SYSTEM_MEMBERS
        10. Translation Override Rule Redirection
        11. Simplified Dimension Editor and Metadata Validation
        12. Entity Member Names/Aliases with ICP Property
        13. Working with Metadata
        14. Ownership Management Enablement
        15. Smart View Summary Dialog Display
        16. Extended Dimensionality Performance Consideration
        17. Equity Pickup - Different Currencies for a Holding Company and Its Immediate Parent
    5. Narrative Reporting
        1. Support for Multiple Data Sources in a Book
        2. Ability to Display Ancestors Before Children in a Grid
        3. Additional Member Selections for Book POV
        4. Prior Version Limit Added to Report Package
        5. New Updates to Disclosure Management
        6. Ability to Set Language Attribute on the Footnote
        7. Disclosure Management support ESMA, EBA, EIOPA, and CIPC Validations
        8. New Version of Oracle Smart View for Office
        9. Narrative Reporting 19.12 Extension for Smart View
      1. Upcoming Changes
        1. All Business Processes to Support an Identical Set of Predefined Roles
      2. Considerations
        1. Access Control
        2. Books
        3. Disclosure Management
        4. Management Reporting
        5. Report Packages
        6. Smart View
    6. Planning
        1. New Video
        2. Determine Why Cells Are Read-Only
        3. Assign Security to Reporting Currency Dimension In Simplified Multicurrency Applications
        4. New Import Exchange Rates Job Type
      1. Upcoming Changes
        1. Update to the Exception Response in REST APIs for Planning and Planning Modules
    7. Profitability and Cost Management
      1. Upcoming Changes
        1. Change to Calculation Rules Screen in Application Cluster
    8. Tax Reporting
        1. Year of Origination Column Added to Reports
        2. New Weighted Average Rate Override Form
        3. Task Manager Audit Enhancements
        4. Accumulate Export Mode Available for Tax Reporting Users in Data Management and Data Integration
        5. Updating the TAR Form Validations Member Formula
      1. Upcoming Changes
        1. Removal of .XLS Format as Report Export Option
        2. Future New Connection Type and Advanced Options for External Connections for Tax Reporting

December 2019 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:

Date Feature Notes
28 NOV 2019

Narrative Reporting: Disclosure Management 

Updated document.  Revised Tips and Considerations section.

27 NOV 2019   Created initial document.

Enterprise Performance Management, December Update

This document outlines the upcoming Enterprise Performance Management Cloud update.

Monthly Update Schedule

Oracle will apply the latest monthly updates to your Test environments during the first daily maintenance that occurs at or after 23:00 UTC (15:00 PST) on Friday, December 6, 2019. Oracle will apply the latest monthly updates to your Production environments during the first daily maintenance that occurs at or after 23:00 UTC (15:00 PST) on Friday, December 20,  2019.

The Oracle Help Center provides access to updated documentation. The updates will be available in the Help Center on Friday, December 6, 2019. Some of the links to new feature documentation included in this readiness document will not work until after the Oracle Help Center update is complete.

NOTE: Backing up the daily maintenance snapshot and restoring the environment as needed are self-service operations. Oracle recommends that you download the maintenance snapshot every day to a local server.

Please Join Oracle Cloud Customer Connect

Please take a moment to join the Cloud Customer Connect forums for EPM Cloud services. Oracle Cloud Customer Connect is a community gathering place for members to interact and collaborate on common goals and objectives. This is where you will find the latest release information, upcoming events, or answers to use-case questions. Joining takes just a few minutes. Join now!

https://cloud.oracle.com/community

NOTE: The Settings and Actions menu now contains a link to Cloud Customer Connect. To access this link, from the Home page, click the down arrow next to the user name (in the upper right-hand corner of the screen), and select Cloud Customer Connect.

Give Us Documentation Feedback

We welcome your comments and suggestions to improve the content of the What's New document and the product documentation. Please send us your feedback at EPMdoc_ww@oracle.com. In the body or title of the email, state that you are inquiring or providing feedback, and indicate for which EPM Cloud service and the monthly update cycle.

Follow Us on Social Media

For the latest updates and information about EPM Cloud, follow us on YouTube, Twitter, Facebook, and LinkedIn at Hyperion EPM Info.

Defects Fixed

Software issues addressed each month will be posted to My Oracle Support.

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 Videos

Watch videos and learn about service capabilities, benefits and how to use key features.

Overview: Learn more about all of the value in the comprehensive EPM Cloud: EPM Standard Cloud and EPM Enterprise Cloud.

Getting help for Oracle EPM Cloud is easy. Access videos, tutorials, new feature updates, forums, documentation, translated Information, and more on our help center.

New Access Control Feature to Assign a User to Many Groups

EPM Cloud now allows Service Administrators to assign a user to many groups. This new feature simplifies group-based assignment of application roles and access control.

Key Resources

New Select All Option in the Financial Reporting Web Studio and Book Editor Select Members Dialog Box

A new Select All checkbox in the Select Members dialog box in Financial Reporting Web Studio lets you select all members currently assigned to a report or a book instead of selecting one member at a time. This saves time if you have a report or a book with several members and wish to remove all the members to update the report or book instead of removing one member at a time.

NOTE: This feature does not apply to Account Reconciliation, Enterprise Data Management, and Narrative Reporting.

Key Resources

  • Selecting Members in Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud

Financial Reports Renamed to Reports

Financial Reports has been renamed to Reports in User Preferences, on the title of the Reports page, and in the object library in the Navigation Flow designer.

EPM Integration Agent Installable as a Windows Service or Linux Background Process

The EPM Integration Agent can now be installed as a Windows service, enabling you to run the agent in its own Windows session. This service can be started automatically when the computer boots, can be paused and restarted, and does not show any user interface. On Linux computers, the EPM Integration Agent will be started as a background process.

NOTE: This feature does not apply to Profitability and Cost Management and Enterprise Data Management.

New Version of Oracle Smart View for Office

Oracle Smart View for Office 11.1.2.5.910 will be available in December 2019. This version includes new features and fixed defects.

NOTE: Account Reconciliation and Enterprise Data Management do not use Oracle Smart View for Office.

Upcoming Changes

EPM Cloud's New Look and Feel

In a future update, there will be a revised interface with enhanced navigation and a new theme called Sky Blue.

New Interface of Planning

The following EPM Cloud business processes will adopt this new theme as their default interface:

  • Planning
  • Financial Consolidation and Close
  • Tax Reporting
  • Profitability and Cost Management
  • Account Reconciliation
  • Strategic Workforce Planning
  • Sales Planning

The revised interface retains existing functionality and enhances your experience with a more modern look and feel and responsive design. The Welcome Panel and the Global Header readjust after resizing, which means less scrolling. An updated Welcome Panel features Announcements and Notifications. Arrows are available on the Home Page to help you navigate easily between the Springboard and infolet dashboard pages. A bigger Navigator Menu has improved usability, more themes for customization are included, and a bigger work area has more space to maneuver and provide better visibility. The interface is also more consistent with other Oracle products, such as Fusion Applications.

After the interface is released, all new customers will use the new lighter-colored Sky Blue theme, and existing customers will keep their current theme. You can switch themes using Tools, and then Appearance.

Planner Role to be Renamed as User

In an upcoming release, Oracle will rename the Planner EPM Cloud predefined role as User. This change will have no functional effect.

Subscriptions that were provisioned prior to the May 2016 update used the Planner role, which has been maintained in subsequent updates to provide continuity. In subscriptions that were activated after May 2016, the Planner role was already replaced by the User role.

NOTE: This change will affect Planning, Financial Consolidation and Close, and Tax Reporting only.

Removal of Instance Name from Predefined Role Names

Currently, the predefined role names displayed in the Access Control screens of EPM Cloud environments prefix the instance name to the role name in INSTANCE_NAME ROLE_NAME format. They are also stored in this format in the snapshots, making it difficult to migrate snapshots from one instance to another.

To facilitate the migration of security across EPM Cloud environments, Oracle plans to rename predefined role names displayed within EPM Cloud applications by removing the instance name prefix. For example, if the instance name is Planning1, predefined role names are Planning1 Service Administrator, Planning1 Power User, Planning1 User, and Planning1 Viewer, the new role names will be Service Administrator, Power User, User, and Viewer.

NOTE: This change does not affect how the role names are displayed in the MyServices customer portal.

This change won't impact customers who currently use predefined roles for managing application-level provisioning and access to artifacts. Oracle will ensure that all application role assignments and artifact security assignments are automatically updated after the roles are renamed. This change makes it easy to migrate EPM Cloud artifacts across environments.

This change is being implemented to address customer feedback. If you have any concerns about this change, please contact Oracle Support.

Predefined Role Names as EPM Cloud Key Words

Starting with an update in the near future, Oracle plans to treat the following predefined role names as EPM Cloud key words, which should not be used in the name of any custom artifacts that you create; for example, as a group name in Access Control.

  • Service Administrator
  • Power User
  • User
  • Viewer
  • Planner
  • System Administrator
  • Application Administrator
  • Library Administrator
  • Reports Administrator

If you have any groups or artifacts named using these keywords, Oracle requests that you rename or delete them; else Oracle will rename them to ensure that there is no impact because of this change. For example, a group named Power User will be renamed as Power User1 without affecting the current role assignments. If you do not want Oracle to automatically rename such groups, you must rename them.

This change is being implemented to address customer feedback. If you have any concerns about this change, please contact Oracle Support.

Key Resources

  • Modifying Groups in Administering Access Control for Oracle Enterprise Performance Management Cloud

Query Governor on BSO and ASO Cubes

In a future update, Oracle will add a query governor on Essbase block storage and aggregate storage cubes to guard against excessive server load created unintentionally by running ad hoc queries that take a very long time to complete. The new governor will limit all queries to a maximum of 30 minutes execution time. This governor affects only retrieval of data, for example, Smart View ad hoc queries, web and Smart View forms, and reports. It does not affect business rules.

NOTE: This feature change affects Planning, Financial Consolidation and Close, Tax Reporting, and Profitability and Cost Management only.

Considerations

Clarifications on addUsers EPM Automate Command Behavior

Enhanced EPM Automate documentation on the addUsers command is now available. The updated document details command usage and behavior in SSO and non-SSO configurations. 

Clarifications to addUsers REST API Behavior

Enhanced REST API documentation on the addUsers API is now available. The updated REST API documentation details API usage and behavior in SSO and non-SSO configurations.

Key Resources

Role Information

  • System Administrator

Account Reconciliation

Ability to Filter and Search Jobs List Added to Transaction Matching

In Transaction Matching, you can now search for matching jobs using the Job ID and filter on the list of jobs using the following attributes:

  • Name
  • Status
  • Created By
  • Start Date
  • End Date

Key Resources

Ability to Work with Lower Level Detail in Group Reconciliations

An enhancement to group reconciliations in Reconciliation Compliance gives preparers an improved capacity to reconcile at one level but understand the detail at a lower level.  Examples include:

  • For Account Analysis, preparers can perform a single group reconciliation for many General Ledger (GL) balances but also access which Balance Explained transactions do not add up to which child balances.
  • For Balance Comparison, preparers can perform a single group reconciliation for many General Ledger (GL) balances and Subledger balances, and easily see which child balances do not match.
  • Gives preparers, reviewers, or auditors of reconciliations a view into which child balances are part of a group reconciliation.
  • Gives administrators the ability to check that all balances intended to be loaded have loaded and are valid in the system. 

Key Resources

Upcoming Changes

Removal of .XLS Format as Report Export Option

Currently, the following report export options are available: csv, xls, xlsx, pdf and html.

In version 20.02, the option for xls will be removed. Customers who have built custom reports must ensure that their reports will export as desired to one of the remaining formats: csv, xlsx, pdf, or html.

Enterprise Data Management

E-Business Suite General Ledger Application Type

A new E-Business Suite General Ledger application type is available to manage segment values and hierarchies for GL charts of accounts in Enterprise Data Management Cloud.

The application type includes:

  • Registration of settings and Segments for an application
  • General Ledger properties and validations
  • Import segment values and hierarchies from files
  • Export segment values and hierarchies to files

Key Resources

Incremental Import Using Requests - Merge Mode

The Merge import mode can be used to incrementally import data into an application using a request.

Source data being imported is compared to existing data in bound viewpoints and differences are captured as request items in an Import type request. Import requests are validated and automatically submitted if the request items are valid. After being submitted, an import request bypasses approvals and is immediately committed.

Changes from an import request can be synchronized to other viewpoints using subscriptions and are recorded in transaction history for audit purposes.

Key Resources

Custom Validations for Node Types and Hierarchy Sets

Custom validations can be defined for node types and hierarchy sets to enforce business rules which are not covered by standard system and application validations. Custom validations use an expression to define custom logic and return a Boolean value to indicate success or failure of the validation. Owners can create and manage custom validations for their applications and dimensions. Custom validations are run for requests and when you validate viewpoints.

Key Resources

New String and Comparison Methods in Expressions

In Expressions, additional methods have been added.

To evaluate and manipulate string values, these methods have been added for String data types:

  • Matches
  • StartsWith
  • EndsWith
  • ToLowercase
  • ToUppercase.

Also, comparison methods are available for Integer, Float, Date, and Timestamp data types to evaluate values of those types:

  • Equals
  • LessThan
  • LessThanOrEqual
  • GreaterThan
  • GreaterThanOrEqual
  • Before
  • After

Key Resources

Access to Children and Ancestors in Expressions

You can access child and ancestor nodes in an expression to evaluate their data for derived properties, property transformations, and custom validations.

The Children and Ancestors expression fields are available for the Node object. The following methods can be used to iterate through the list of children/ancestors and return a value:

  • Any
  • Count
  • Find

Key Resources

Copy and Paste Expression Terms

You can copy and paste expression terms within the same expression in the Expression Builder. This enables terms to be moved and reorganized as expressions are defined and altered.

Key Resources

Copying and Pasting Expression Terms in Building Expressions in Administering and Working with Oracle Enterprise Data Management Cloud

Node Type Overrides for Property Parameters

Default, common, data type, and allowed value parameters for properties can be configured at the node type level in the Property inspector. Application owners can use custom settings for individual node types instead of using base or application level parameters for a specific property.

The following property parameters can be edited at the node type level:

  • Default Type
  • Default Value
  • Editable
  • Inheritance
  • Case
  • Invalid Characters
  • Max and Min Length
  • Boolean Display Type
  • Decimal Places
  • Allowed Values

Key Resources

Mass Delete of Draft Requests

To clean up obsolete requests that were never submitted, a Service Administrator can delete multiple draft requests at one time. Multiple requests can be selected in Request Activity and deleted together in a single operation.

Key Resources

Node Transaction History

History can be viewed for a selected node in a viewpoint to quickly identify changes that happened to the node. Node history includes past transactions recorded from previous requests as well as visualized actions performed in the current request. You can search for a particular change to the node and download all history for it.

Key Resources

Considerations

Property Pane Doesn't Update in Firefox

In Firefox, the property pane may not be populated with values after a request is submitted.

Workaround:  Select a different node and then select the node that had the issue and the properties are populated.

Validate Viewpoint Results Show No Failures

If an enabled validation has a trigger action and Date trigger property and evaluates the Date property, validation errors occur in the context of a request. However if you validate the viewpoint no validation errors are displayed.

Default Values for Node, Date, and Timestamp Display with Red Border

Valid default values for node, date, and timestamp properties may display a red border in the property pane indicating that the values are invalid. When this occurs you can still submit the request successfully.

Email Notifications in English

Subscription and workflow email notifications are displayed in English only.

Reverting Property Parameters

After reverting overridden property parameters back to base parameter, the icon next to the parameter indicates that the property is still overridden or overridden values are reverted to blank instead of base values. When this happens, there is no way to change the values back to base values.

User with No Email Address

If an approval policy is set up for a user who does not have an email address specified, when that user is invited to approve a request, the email is not sent to that user or to the user who submitted the request. Use Access Control to assign email addresses to users.

All Business Processes to Support an Identical Set of Predefined Roles

In an upcoming release, Oracle plans to implement the following predefined roles for Enterprise Data Management. Other EPM Cloud business processes already use this common set of predefined roles, which will become the standard set of predefined roles as a result of this change. This update will allow Oracle to address customer issues related to migrating services from current environments to EPM Standard Cloud Service and EPM Enterprise Cloud Service environments.

  • Service Administrator
  • Power User
  • User
  • Viewer

This change is automatic; you do not need to update current role assignments. If you have any concerns about this proposed change, please contact Oracle Support by submitting a service request that explains your concerns.

Enterprise Data Management Cloud will support two additional predefined roles, Power User and Viewer.

CAUTION: Do not assign the Power User and Viewer roles to Enterprise Data Management users because these roles do not assign any privileges to users.

Financial Consolidation and Close

New Video

Watch videos and learn about service capabilities, benefits and how to use key features.

Source System Integration with the EPM Integration Agent

We're happy to announce the EPM Integration Agent, a flexible, extensible source data integration solution! With custom and seeded SQL queries and scripting you can extract and transform data from on-premise and third party cloud source systems for use in Financial Consolidation and Close.

Task Manager Audit Enhancements

In Task Manager Audit, audit records are now available for the creation, modification, and deletion of Holiday Rules defined in Task Manager.

Key Resources

Ability to Disable Ratio Calculations

To improve consolidation performance, you can disable the Ratio calculations of “FCCS_Days Sales in Receivables” and “FCCS_Days Sales in Inventory” for selected scenarios if you do not use these calculations. This option is only available when the Asset Management feature is enabled.

Key Resources

Dynamic Children Support is not Available for Business Rules Created Using Calculation Manager

When using Calculation Manager to create a business rule, the Create Dynamic Members and Delete Dynamic Members options are not available for Financial Consolidation and Close applications.

Key Resources

Accumulate Export Mode Available for Financial Consolidation and Close Users in Data Management and Data Integration

When loading data using Data Management or Data Integration, the accumulate export mode is now available for Financial Consolidation and Close users. This mode enables users to accumulate the date in the application with the data in the load file. For each unique point of view in the data file, the value from the load file is added to the value in the application. Note that data for system account is not accumulated.

Key Resources

Considerations

Calculation Status

When you change Ownership Data that uses a Consolidation rule and then consolidate, the Calculation Status is not correct for the partner and entity.

Copying Data

When copying an entity with a Calculation Status of No Data, the target should also have a Calculation Status of No Data. The Copy Data process is incorrectly setting the Calculation Status to Impacted.

Editing Data in a Data Collection Period

In a Data Collection Period in Supplemental Data, editing Start, End, and Close Dates may result in an error that the date is outside the valid range.

Adding Shared Members in Smart View

When using Smart View, after adding a Shared Member, Refresh and Submit may not work correctly.

Self-Service Upgrade

It is strongly recommended that you do not use the Upgrade Application Content settings in this update.

Although a new Upgrade screen is available in Daily Maintenance, this feature is not fully functional.

Horizontal Scroll on a Non-Tabular Form

In Supplemental Data forms, the horizontal scroll does not work on a non-tabular form, which is intended only for use on a single record. Do not use non-tabular layout if the form is meant for more than one record.

Unable to Refresh the Cube

A Cube refresh will not complete if a level 0 currency dimension member has the "Label only" data storage property, but this is not currently detected in the Dimension Editor or Metadata Validator.

Viewing Members on Seeded Forms

If you are using an Extended Dimensionality environment, on seeded forms, use the View members, such as Periodic, QTD and YTD, instead of using functions to ensure the _RULE members are not accidentally added to the forms.

Viewing the FCCS_VIEW_SYSTEM_MEMBERS

If you are using an Extended Dimensionality environment, users other than the Administrator can view the FCCS_VIEW_SYSTEM_MEMBERS and its hierarchy in the data form and Intercompany reports.

Translation Override Rule Redirection

When you create a Translation Override rule, redirection does not work properly when you use a shared Parent account for the Source. The workaround is to specify the primary Parent account.

Simplified Dimension Editor and Metadata Validation

Some of the Simplified Dimension Editor errors (cells outlined in red) are false-positive errors (that is, incorrectly reported as errors). Data Storage errors for the following members should be ignored:

  • Data Source --> All children of "FCCS_Source Entities" Entity --> "FCCS_Global Assumptions"

If you are using an Extended Dimensionality upgraded environment, the Simplified Dimension Editor does not show Dynamic Calc as an allowed value for Custom dimension parent member Data Storage. This issue does not occur in a newly-installed Extended Dimensionality environment. You can use the Classic Dimension Editor, Import Metadata, or Smart View to change the Data Storage value.

In addition, the Metadata Validator incorrectly shows validation errors for the following:

  • Shared level 0 Scenario dimension members
  • Parent members of the Scenario dimension

Entity Member Names/Aliases with ICP Property

When you create an Entity with the ICP property enabled, the maximum length of the member name is 76 characters instead of 80, to allow for the ICP prefix.

Working with Metadata

Be aware of the following considerations.

You should not make metadata changes that result in the following:

  • Changing a base member to which a journal has been posted into a parent member. If there are journals or Supplemental Data posted to those members, these changes can cause problems when accessing Journals or importing existing journals.
  • When you use ad hoc grids in Smart View with Financial Consolidation and Close Cloud, do not add a root Period member on the grid. Make sure the root Period member is removed by either clicking Remove Only or selecting periods that are in the application and selecting Keep Only.
  • If a Period member is left on the grid, then any changes to data that you make will fail to properly set the impact status of the Entities.

Ownership Management Enablement

Enabling the Ownership Management feature entails adding seeded accounts, which causes a restructuring of your application. Depending on the size of your application, the restructuring could take a considerable length of time. This can be expected to take as long as manually refreshing the database after adding accounts. If there are conflicts with aliases of existing members, an error is displayed that the system cannot enable the feature. Resolve the member alias conflict, refresh the database and then enable the feature.

When the Ownership Management feature is enabled, you will need to reconsolidate all existing data in your application in order to re-populate the Proportion member in the Consolidation dimension. If you enable the Ownership Management feature, you may not be able to open some existing Financial Reporting reports due to metadata changes for Ownership Management.

Key Resources

Smart View Summary Dialog Display

In Internet Explorer, you may experience issues using the Open Summary dialog in Smart View.

Workaround:

  • Use the keyboard arrow keys to make your selection, then close and reopen the dialog, or
  • Minimize and then reopen the dialog, or
  • Use a different browser

Extended Dimensionality Performance Consideration

For an Extended Dimensionality application with Ratios enabled, consolidation performance may be slower.  When you create an Extended Dimensionality application, you should not enable the “Include Ratio Calculations” feature.

Equity Pickup - Different Currencies for a Holding Company and Its Immediate Parent

In Ownership Management it is generally assumed that the Holding Company and the immediate parent (which represents the consolidated results of the Holding Company) have the same local currency. You may encounter an issue with the EPU calculations if the Holding Company does not have the same currency as its immediate parent.

Narrative Reporting

Support for Multiple Data Sources in a Book

Multiple data sources are now supported in a Book.

NOTE: 

If the Book contains multiple data sources, in the Book Designer you will need to manually add the additional data sources using the Actions menu, and select Manage Data Source, otherwise you will get a validation error for any reports or Books with additional data sources stating “Datasource <data source name> is not in the allowed datasources”.

When inserting a Section into a Book, if the Section contains reports with multiple data sources, you need to add the data source in the Section’s Actions menu, and select Manage Data Source. The available dimensions in Dimension Layout are based on the first data source appearing in the Manage Data Source dialog.

Key Resources

Ability to Display Ancestors Before Children in a Grid

The Ancestor Before Children option in Management Reporting enables you to display the ancestor members before child members instead of after the child members when using specific member selection functions such as Children or Descendants.

Key Resources

Additional Member Selections for Book POV

The Book POV selections in the Book Designer now supports all Functions, Substitution Variables, and Lists.

Prior Version Limit Added to Report Package

Report Package owners can set the number of prior doclet versions maintained within their Report Packages. The system will automatically maintain the most current versions of the doclet up to the limit set within the Report Package. If a doclet version limit is met, the system will remove the oldest prior version as new versions are added.

Key Resources

New Updates to Disclosure Management

Disclosure Management supports the Inline XBRL 1.1 specification. 

Disclosure Management supports the following date formats:

  • "(D)D*(M)M"
  • "(M)M*(D)D"
  • "(D)D*(Mon)th"
  • "(Mon)th*(D)D"
  • "(Mon)th*(Y)YYY"
  • "(Y)Y(YY)*(Mon)th"

Key Resources

Ability to Set Language Attribute on the Footnote

In Disclosure Management, you can now set the language attribute on the footnote.

Key Resources

  • About Footnotes in Working with Disclosure Management for Narrative Reporting

Disclosure Management support ESMA, EBA, EIOPA, and CIPC Validations

In the current release, Disclosure Management client supports ESMA, EBA, EIOPA, and CIPC validations. The presentation, calculation, and formula related validation errors are supported.

New Version of Oracle Smart View for Office

Oracle Smart View for Office 11.1.2.5.910 will be available in December 2019. This version includes new features and fixed defects.

Narrative Reporting 19.12 Extension for Smart View

The Narrative Reporting 19.12 Extension for Oracle Smart View for Office is now available. This update contains general improvements and bug fixes.

Key Resources

Upcoming Changes

All Business Processes to Support an Identical Set of Predefined Roles

In an upcoming release, Oracle plans to implement the following predefined roles for Narrative Reporting. Other EPM Cloud business processes already use these common predefined roles, which will become the standard set of predefined roles as a result of this change. This update will allow Oracle to address customer issues related to migrating services from current environments to EPM Standard Cloud Service and EPM Enterprise Cloud Service environments.

  • Service Administrator
  • Power User
  • User
  • Viewer

This change is automatic; you do not need to update current role assignments. If you have any concerns about this proposed change, please contact Oracle Support by submitting a service request, which explains your concerns.

Current non-conforming Narrative Reporting predefined roles will be deleted; users assigned to those roles will be remapped automatically as follows to the common set of predefined roles.

Remapping for Narrative Reporting Roles

 Current Non-Conforming Roles  Common Remapped Roles
System Administrator Service Administrator
Application Administrator Power User
Library Administrator Power User
Reports Administrator Power User

NOTE: User role assignments are not affected by this change. The Viewer role will not be assigned to users.

Considerations

Access Control

  • In Access Control, the Service Administrator can manage group using “*” (asterisk) as the wildcard character to retrieve all available groups. For example, "John*" should be added to search user in the search field. However, in Oracle Narrative Reporting (NR) search automatically displays that are matching in the "contains” field. See Creating Groups in Administering Access Control for Oracle Enterprise Performance Management Cloud.

  • In Access Control, the Service Administrator can create and manage group, where as in Narrative Reporting, an Application Administrator can create and maintain all artifacts, such as applications, models, dimensions, and data grants. You may not be able to view each individual Application-Level provisioning roles in Narrative Reporting. See Understanding Pre-Defined Roles in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

  • In Oracle Narrative Reporting, if a user has Reports Administrator rights, then the user can view the folder and can perform import or export option on that folder, else the user will not have rights to view all the folders in the library. See Understanding Pre-Defined Roles in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Books

Be aware of the following considerations when working with Books.

  • If a Book was created in the 19.10 release and it contains a reference to another Book, it cannot be exported and imported into a 19.09 environment.
  • When creating a Book and inserting another Book into it, if the Book is saved using the same name as the inserted Book, you may receive a service error when reopening the Book. The best practice is to save a Book with a different name than any Books that are inserted into it.
  • Using either the Intersect or Except member selection functions in a Book will resolutely in a service error.

  • When previewing a Book with multiple data sources, and selecting a member in the Book POV for a common dimension where only one of the data source contains the member, you may receive a service error.

Disclosure Management

Be aware of the following considerations when working with Disclosure Management.

  • Bidirectional language functionality is not supported in Disclosure Management for this release. 

  • When publishing a taxonomy in Taxonomy Designer, you must enter the full path for the ZIP file when specifying the location to publish to. An error is displayed if you specify the ZIP file name only without the path.  

  • When auto preview is enabled and you select Exhibit Linking after publish, Exhibit Linking does not work.

Workaround: Close Preview and select Exhibit Linking

  • When publishing a taxonomy in Taxonomy Designer, you must enter the full path for the ZIP file when specifying the location to publish to. An error is displayed if you specify the ZIP file name only without the path.

  • Ribbons are grayed out.

    Workaround: Reopen the same report. No need to restart the entire Microsoft Word instance. Only the report needs to be closed and reopened from the Private Connection. After the report is reopened, the ribbon is in an enabled state. At this time you can undo the checkout so the issue doesn’t occur again. The issue occurs due to the report being checked out earlier and never checked back in, or the Undo Checkout was selected while the application was in an unstable state

  • Arelle from the client cannot connect to the internet.

Workaround: Run Arelle on a PC that has access to the internet or open an SR and DEV (or support) will deliver the http cache and should be unzipped at:

<USER_HOME>\AppData\Local\Arelle\cache

  • Do not convert PDF formatted Disclosure Management reports to Word document.

Best Practice: Use original Word documents where available or re-create the content in a Word instance. Converting a PDF report to Word format is prohibited and will prevent the user from checking in the repository item when working in Disclosure Management.

  • The Auto-Tag process can detect only one dimension now. The dimension name should be located on the horizontal or vertical column header.

  • You must ensure that the document is checked-in before clicking Auto-Tag. If not, the current mappings in the Review Pane may disappear.

  • If you are restoring a database back up from 18.08 or 18.09, then the taxonomy registrations will not be restored. All the taxonomies need to be registered again. For open taxonomies that was edited using Taxonomy Designer template, you need to publish the taxonomy and register it again. For close taxonomies, you need to download the taxonomy from the issuing jurisdiction and register it again.

  • Auto-Tag process will only detect Level 4 tags in tables. It will not be able to detect tags in narratives.

  • Document Entity Information tags, Level 3 tags should be made first before attempting Auto-Tagging.

  • In Disclosure Management, you should remove spaces inside of the negative number before Auto-Tagging. As a workaround, you must update individual doclet table cell from removing space. For example, you need to change table cell as follows:

    • From: "(74 )" – An extra space is displayed in the table cell.
    • To: "(74)" – Remove an extra space in the table cell.
  • If you are trying to install a Disclosure Management client with Microsoft Office 2010. It may fail due to some Microsoft DLL files are missing. Refer to the logs files, where you can view error message displays that the Microsoft.Office.Interop.Word, Version=15.0.0.0 is not found. 

    To fix this issue, perform the following steps:
    • You need to Download Microsoft.Office.Interop.Word Version 15 from the link:  https://www.nuget.org/packages/Microsoft.Office.Interop.Word/
    • Unzip the package and look for the Microsoft.Office.Interop.Word.dll file. 
    • Using File Explorer, type %APPDATA% and click Enter, and then navigate to the following path: Oracle\SmartView\Extensions\Bin\E632A1C1-B3D4-4941-80F3-8C9E83747BE7\Release.
    • Copy the Microsoft.Office.Interop.Word.dll file, and then paste the file within the Release folder.
    • You need to Download Microsoft.Office.Interop.Excel Version 15 from the link: https://www.nuget.org/packages/Microsoft.Office.Interop.Excel/
    • Unzip the package and look for the Microsoft.Office.Interop.Excel.dll file.
    • Using File Explorer, type %APPDATA% and click Enter, and then navigate to the following path: Oracle\SmartView\Extensions\Bin\E632A1C1-B3D4-4941-80F3-8C9E83747BE7\Release.
    • Copy the Microsoft.Office.Interop.Excel.dll, and then paste the file within the Release folder.
    • Try opening the Microsoft Word or Excel. It works.
  • While editing a taxonomy and the namespace has not changed, before registering, you must consider these two options:
    • You need to delete the old taxonomy with the same namespace before registering for the new one.
    • After registering the new taxonomy, you can update the existing taxonomy.

Management Reporting

Be aware of the following consideration when working with Management Reporting.

  • When uploaded for use with Management Reporting, Microsoft Internet Explorer requires you to install custom fonts. If custom fonts are not installed, then Internet Explorer will substitute a different font. Google Chrome and Mozilla Firefox do not require installable fonts.

Report Packages

Be aware of the following considerations when working with Report Packages.

  • In Report Package, if you are adding a table of contents with a report package that uses multi-byte fonts, a service error may occur when executing a link within the table of contents if the associated fonts have not been uploaded to the service. As a workaround, upload the required fonts to the service.

  • With the latest Oracle Application Development Framework (ADF) software update, Time zone preference is set to UTC - 08:00 by default. If a user tries to set the date selection in any of the Report Package's time line fields, the time zone code (GMT+/-00:00) is shown at the end of the input field. For example, if the user sets the due date for the start of the author phase to be January 1, 2019 at 9 AM in the Pacific US time zone, the date field is displayed as Jan 1, 2019 9:00:00 AM GMT-08:00.

  • In PDF-based Report Packages, Reviewers are unable to add comments to the report content sourced from Microsoft Excel doclets. Review commenting on the Excel doclet contents will be supported in a future release.

  • Publishing a report package to PDF that contains embedded charts that were created in Microsoft Word results in errors.

Workaround: Either convert the Word charts to images, or replace the Word charts with embedded content from a reference file or doclet.

  • Previewing a report that has a PowerPoint style sample with a custom slide that has numbering starting at zero will display an error.

Workaround: Download the PowerPoint style sample document and change the numbering on the Slide Master to start with one, instead of zero. Then, edit your report package properties and select the updated style sample document.

  • When you add embedded content that contains internal hyperlinks to a report package, if you select Download Preview to view the document, the hyperlinks within the embedded content do not open when clicked.  

  • When creating embedded content, if you use the horizontal text alignment format Center Across Selection in Excel, the selection does not carry forward into the embedded content when the doclet is embedded in Word. The text remains within the original cell.

Workaround: To achieve the same visual layout, use Merge cells and Center align to align the text in the merge cell.

  • When you insert a reference variable value that references a document that was created using Word 2007, a line break is inserted in the text, creating an extra line.

Workaround: If you encounter this issue, delete the extra line.

  • If an Excel worksheet uses a double-line bottom border on the last row of a named range, an extra row appears in the embedded content within a consuming doclet.

Workaround: To work around this issue, try one of the following options:

  1. Do not use a double line bottom border in the last row of a named range, but select an alternative bottom border.

  2. Navigate to a cell that is below the named range, and add dummy text or a blank space. You can then upload and check in the reference doclet. When the embedded content is generated, the empty row is no longer included.

  3. Resize the row below the row that contains the double-line bottom border. You can keep the double line border in the last row intact, but resize the next row to be very small (but not hidden). Click any cell in the relevant row and choose Home, then Format, and then Row Height and enter a small value such as 2 or 3. The extra space is included in the embedded content, but it has a minimal impact.
  • If a PowerPoint slide is created from a layout that contains placeholders for tables, charts, smart art, or media files, those objects seem to disappear when uploaded to the service. The content is not lost however. After downloading the files, a reset on the slide will cause the content to reappear.

Workaround: To work around this issue, create the slide by adding the content directly to the slide rather than use a layout with place holders.

  • If the user enters a simple URL format (for example, www.oracle.com) within the Rich Text Editor, a service error will be displayed when the link is executed.

Workaround: If a user enters a fully qualified URL format (for example, http://www.oracle.com) within the Rich Text Editor, the URL link will open within a new browser tab.

  • When using an iPad with the Safari browser to preview a report package, Safari stops responding when you magnify the screen and tap preview.    

  • When downloading files using Safari 9, any spaces in the filename will appear as special characters.    

  • When performing a review of a PowerPoint report package using Safari, a service error is displayed if the user places the comment anchor in the blue area outside the slide.    

  • When you open a review instance within Smart View, add a comment, switch to another review instance, and then switch back to the first review instance using the Content Selector, the comment is not updated correctly.

Workaround: Click “Refresh Comments” or click the Content Selector refresh button to display the comment correctly.

  • When performing a "Refresh All" on a report package, there is a database transaction timeout limit of 10 minutes in the system. As a result, if Management Reporting doclet refreshes take more than 10 minutes to complete, the entire refresh operation is rolled back to its previous state.

Workaround: For a larger report package, it is recommended to perform manual refresh, and split the report package into multiple ones and refresh them separately. Later manually combine resulting PDF outputs into a single output.

  • For any Report Packages created prior to the 19.12 update, the doclet prior version limit default value is set to 500. After modifying the Doclet Versions Options, the new selection will be enforced on all the doclets. If any pre-19.12 report packages are copied or imported, the new Report Package’s doclet prior version limit will default to 20.

Smart View

Be aware of the following considerations when working with Smart View.

  • In the Mozilla Firefox browser, if you are trying to download the Smart View extensions, this may result in a new tab opening with a large amount of code being displayed. This is due to a security policy within the Mozilla Firefox browser related to certain file extensions.

Workaround: Download the Smart View extensions using an alternate supported browser (Microsoft Internet Explorer or Google Chrome) or you can install the extension from Smart View directly.

Then, follow the install instructions in “Installing the Narrative Reporting Cloud Extension” of the Oracle Smart View for Office User's Guide.

  • In Word 2016, 32- or 64-bit, when you close a document, Word stops responding (displays the spinning wheel) until you either click in the ribbon area of the interface, or press the Alt key.  

  • On Microsoft Windows 10 with Office 32- or 64-bit, in the Add Report Content dialog, range names display incorrectly.

Workaround: Go to the Control Panel, then Display, then click the link for “Set a custom scaling level” and ensure that the setting in the “Custom sizing options” dialog is 100%. If it is not, set it to 100%, and then log out of Windows and log back in.

  • A connection created in one language cannot be used if Smart View is changed to a different language.

Workaround: Create multiple private connections using the Add Connection Wizard. Before creating each connection, change the Smart View language display (in the Options dialog box, Advanced tab, Language drop-down list). Then, follow the instructions “Using the Private Connection Wizard” in the Oracle Smart View for Office User's Guide.

  • When downloading a new Smart View extension from Microsoft Internet Explorer, the filename extension defaults to .ZIP instead of .SVEXT. This prevents you from being able to double-click to install the extension.

Workaround: When Internet Explorer prompts you to save the file, choose “Save As”, change the Type to “All Files”, and then change the extension from .ZIP to .SVEXT. Then, double-click the downloaded file to install the extension.

  • When any of the allowable special characters are used in a report package name (such as commas, semicolons, or ampersands), there may be a discrepancy between how the name displays in the library tree and how it displays in the Report Center panel.  

  • If you have open or close bracket characters in an Excel reference or supplemental doclet, Excel changes the brackets to parentheses when you save the file.  

  • When you upload an Excel reference doclet with many named ranges, not all of the named ranges are listed as available content.

Workaround: Upload the doclet and then go to the web and add the embedded contents within the doclet inspect dialog.

  • User names or artifact names containing special characters, such as ampersands (&), may cause errors in the Smart View Narrative Reporting extension when displaying the Home panel or inspecting an artifact’s history.

Workaround: Remove special characters from user names and artifact names.

  • After opening a review instance, then switching back to the Report Center and selecting a doclet, in some cases, the Show / Hide Comments link is no longer visible, but the Comments panel is always displayed.

Be aware of the following consideration when working with Smart View for ad hoc analysis.

  • When users sign in to the service for the first time, they will be prompted to change the password. Oracle recommends that users sign in first to the web to change their password before connecting through Smart View.

Planning

New Video

Watch videos and learn about service capabilities, benefits and how to use key features.

Source System Integration with the EPM Integration Agent

We're happy to announce the EPM Integration Agent, a flexible, extensible source data integration solution! With custom and seeded SQL queries and scripting you can extract and transform data from on-premise and third party cloud source systems for use in Planning.

Determine Why Cells Are Read-Only

There are many reasons why a data cell is read-only. For example, you might not have write access to the cell, or maybe the cell’s value is calculated dynamically. Now you can determine the reason why a cell is read-only.

The Action menu in a form now provides an option, Show Reasons for Read-Only Cells. Selecting this option loads the reasons why cells are read-only. Then you can right-click on a cell and select View Reasons for Read-Only Cell to see the reasons why the cell is read-only.

Key Resources

Assign Security to Reporting Currency Dimension In Simplified Multicurrency Applications

In simplified multiple currency applications, you can now assign security to the Currency dimension to make Currency dimension members read-only based on user access. To enable security for the Currency dimension, click the Edit Dimension Properties tab, and then select Apply Security.

Key Resources

New Import Exchange Rates Job Type

There is now an Import Exchange Rates job type for simplified multicurrency. To create this job type, you must point to an import CSV file that is located (available) in the inbox.

Upcoming Changes

Update to the Exception Response in REST APIs for Planning and Planning Modules

Oracle will remove the internal package and class names from the following fields in the exception response in REST APIs for Planning and Planning modules in an upcoming release in early 2020:

  • message
  • localizedMessage

Key Resources

  • Planning section in REST API for Oracle Enterprise Performance Management Cloud

Role Information

  • System Administrator

Profitability and Cost Management

Upcoming Changes

Change to Calculation Rules Screen in Application Cluster

In an upcoming update, the Calculation Rules screen in the Applications cluster will be replaced with the Designer screen from the Models cluster. The Designer screen is an enhanced version of the Calculation Rules screen, with capability to create and edit complete rule definitions.

Tax Reporting

Year of Origination Column Added to Reports

A Year of Origination column has been added to some reports to display the actual Financial years such as FY17, FY18, rather than only presenting "Current Year", "Current Year Minus1", and so on.

The names of the actual Financial years are updated based on the selected year in the POV for the report.

Key Resources

New Weighted Average Rate Override Form

Previously, the Weighted Average FX Rate calculation applied to both NIBT and Expense. With this release, you now have the following options:

  • Use the new Weighted Average FX Rate Override form for NIBT to override the system calculated rate.
  • Use the new Weighted Average FX Rate Override form for Other Tax and Book Accounts.

A new attribute must be assigned to one or more book accounts to calculate the weighted average rate.

Key Resources

Task Manager Audit Enhancements

In Task Manager Audit, audit records are now available for the creation, modification, and deletion of Holiday Rules defined in Task Manager.

Key Resources

Accumulate Export Mode Available for Tax Reporting Users in Data Management and Data Integration

When loading data using Data Management or Data Integration, the accumulate export mode is now available for Tax Reporting users. This mode enables users to accumulate the data in the application with the data in the load file. For each unique point of view in the data file, the value from the load file is added to the value in the application. Note that data for the system account is not accumulated.

Key Resources

Updating the TAR Form Validations Member Formula

When configuring the TAR automation, you can set the Deferred Tax Closing Balance to update the TAR form Validations Member formula.

Key Resources

Upcoming Changes

Removal of .XLS Format as Report Export Option

Currently, the following report export options are available: csv, xls, xlsx, pdf and html.

In version 20.02, the option for xls will be removed. Customers who have built custom reports must ensure that their reports will export as desired to one of the remaining formats: csv, xlsx, pdf or html.

Future New Connection Type and Advanced Options for External Connections for Tax Reporting

In a future update, Service Administrators for Tax Reporting will be able to use connections created for external Web services, specifying optional query or header parameters. These connections could be referenced or used in a Groovy script to create a communications link between the Groovy script and the external Web resource. Users will be advised when this new feature is to be supported in Tax Reporting.