Financial Consolidation and Close
What's New
  1. August 2019 Update
  1. Revision History
  2. Financial Consolidation and Close, August Update
        1. Monthly Update Schedule
        2. Please Join Oracle Cloud Customer Connect
        3. Give Us Documentation Feedback
        4. Follow Us on Social Media
        5. New Videos
    1. Features
        1. New Version of EPM Automate
        2. Ability to Create Rate Accounts for Translation Overrides
        3. New Server Setting in Financial Reporting Web Studio
        4. Scenario Override Option for Opening Balance
        5. Simplified Seeded Balance Sheet and Movements Option
        6. Event Monitoring Integrations for Oracle Fusion General Ledger
        7. Task Manager Limits on Object Instances
        8. New Troubleshooting Information
    2. Upcoming Changes
        1. Removal of Instance Name from Predefined Role Names
        2. Classic Dimension Editor
        3. EPM Cloud's New Look and Feel
        4. Query Governor on BSO and ASO Cubes
    3. Defects Fixed
    4. 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. Setting the Data Collection Period
        14. Working with Metadata
        15. Ownership Management Enablement
        16. Smart View Summary Dialog Display
        17. Extended Dimensionality Performance Consideration
        18. Equity Pickup - Different Currencies for a Holding Company and Its Immediate Parent

August 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
25 JUL 2019   Created initial document.

Financial Consolidation and Close, August Update

This document outlines the upcoming Financial Consolidation and Close 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 22:00 UTC (15:00 PDT) on Friday, August 2,  2019. Oracle will apply the latest monthly updates to your Production environments during the first daily maintenance that occurs at or after 22:00 UTC (15:00 PDT) on Friday, August 16,  2019.

The Oracle Help Center provides access to updated documentation. The updates will be available in the Help Center on Friday, August 2,  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.

New Videos

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

  • Overview: Performance Testing With the EPM Automate Replay Command

    Admins, want to ensure that application design changes, patches, and new processes won’t negatively impact concurrent user activity in production? Use the EPM Automate replay command to simulate activity in a test environment under heavy load so you can address performance issues before migrating to production, keeping your production app seamless, spotless and your users speedy.

  • Oracle EPM Cloud Today: EPM Cloud as a Suite Featuring Hari Sankar

    We are pleased to announce our 3rd video in our Oracle EPM Cloud Today series, where Hari Sankar, Group Vice President of Product Management, will be talking about EPM Cloud as a suite. He’ll talk about what we mean by EPM Cloud as a suite, how it benefits customers, and what we’re doing to make it even easier to use EPM Cloud. http://bit.ly/2XMj2zQ  

Features

New Version of EPM Automate

A new version of EPM Automate is available with this update. This version contains updates to the recreate command, which has been enhanced with the removeAll optional parameter. This parameter, when set to true,  removes all user created snapshots as well as the content of the inbox (uploaded files) and outbox (files generated by using the Export capabilities of Migration).

Key Resources

Ability to Create Rate Accounts for Translation Overrides

In addition to the seeded system rate accounts (Average and Ending), you can create additional rate accounts to be used as part of configurable Translation Override rules.  From “Manage Translation Override Rules”, you can create, edit, or remove user-defined rate accounts.

Key Resources

New Server Setting in Financial Reporting Web Studio

A new server setting in Financial Reporting Web Studio, Related Content URL Launch Mode, defines the type of request made for related content URLs. The default launch method is HTTP post. In scenarios where related content URLs do not support a post request, change the server setting to HTTP get.

Key Resources

  • Managing Server Settings in Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud

Scenario Override Option for Opening Balance

You can now specify a different Scenario from which to source the Closing Balance data in the first period of each year. The default behavior is to carry forward the Closing Balance from the same Scenario as the Opening Balance to which the data is being written.

Key Resources

Simplified Seeded Balance Sheet and Movements Option

When you create an application, you can select a new “Basic” Balance Sheet option. The Basic option provides simplified hierarchies of the minimum required set of Account and Movement dimension members and a minimum set of seeded forms. The existing Traditional and Net Asset Approach hierarchies are still also available.

Key Resources

Event Monitoring Integrations for Oracle Fusion General Ledger

Task Manager now provides out-of-the-box Event Monitoring tasks for Oracle Fusion General Ledger.  These events can be monitored:

  • Accounting Period Closed
  • Accounting Period Opened
  • Accounting Period Re-opened
  • Journal Batch Approved
  • Journal Batch Posting Completed

Key Resources

Task Manager Limits on Object Instances

In Task Manager, maximum limits have been added on the number of templates, schedules, attributes, tasks per template, and tasks per schedule, to improve application performance. The system enforces the maximum limits when these objects are created.

In addition, the system also enforces the maximum number of these objects during the Migration import process.

Key Resources

New Troubleshooting Information

With a view to assisting customers troubleshoot issues related to application performance, a new chapter titled "Troubleshooting Application-Specific Issues" has been added to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators. The initial installment of this document covers information on diagnosing consolidation failures and performance issues in Oracle Financial Consolidation and Close Cloud

The contents of this chapter are expected to grow as more troubleshooting topics, based on tested solutions, are added  to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators in the near future.

Key Resources

Upcoming Changes

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 will affect you if you use the predefined roles for managing application-level provisioning and access to artifacts; you will need to reassign such assignments using the updated role name after the roles are renamed. This change makes it easy to migrate EPM Cloud artifacts across environments.

Additionally, all predefined role names; Domain Administrator, Service Administrator, Power User, User, and Viewer will be treated as EPM Cloud keywords, which should not be used in the name of any custom artifacts that you create; for example, as a group name in Access Control. If you have any group with these keywords, rename them before this change comes into effect.

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

Classic Dimension Editor

With a view to allowing customers more time to familiarize themselves with the Simplified Dimension Editor, Oracle has decided to defer the removal of support for Classic Dimension Editor to a future update in 2019. Oracle will notify you at least two months prior to the removal of the feature.

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 services 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.

Query Governor on BSO and ASO Cubes

Currently, there is no query governor on Essbase block storage and aggregate storage cubes. Absence of a query governor can lead to excessive load created unintentionally by running ad hoc queries that take a very long time to complete.

In the September EPM Cloud update (Release 19.09), Oracle will add a query governor that limits all queries to a maximum 15 minutes execution time. After Release 19.09 is applied to your environments (September 6, 2019 for test and September 20, 2019 for production environments), the query governor will terminate queries that exceed the 15 minutes execution limit.

If you have any questions or concerns about the value of the governor (15 minutes), please open a Service Request.

Defects Fixed

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

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

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.

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.

Setting the Data Collection Period

In Supplemental Data, when setting the Data Collection Period (DCP), the Start, End, and Close dates must be inside the valid range.

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.

See Enabling Ownership Management in Applications section in Administering Oracle Financial Consolidation and Close Cloud

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.