The Septemer updates for Oracle's Financial Consolidation and Close Cloud Service (FCCS) are here! This blog post outlines new features, including a toolkit for Hyperion Financial Management (HFM) migration to FCCS, drilling down from summary members, considerations, and more.
The monthly update for FCCS will occur on Friday, September 21 during your normal daily maintenance window.
Users can now run the consolidation process, in addition to Power Users and Service Administrators. To consolidate data, you must also have Write access for the entity that you want to consolidate.
When you load data to YTD_Input and use the Replace mode, the system loads the data and then reverses the YTD values for the Flow accounts that are not specified in the data load file.
As an end user, you can now set your preferences for many aspects of the application in a comprehensive, integrated framework in the application. For example, from the Home page, select Tools, and then User Preferences to set your profile picture, select members for user variables, set preferences for ad hoc options and printed reports, and so on. The preferences you set override your administrator’s settings, and persist across sessions. However, you can always change your preferences or revert to the administrator’s settings if you want to.
In a further effort to simplify how you manage administrator settings, administrators can now define all application settings and system defaults in one place in the application. For example, from the Home page, select Application, and then Settings to set email options, assign an owner to an application, or to enable currency options.
Previously, these settings were accessed from the Navigator menu on the System Settings and Defaults page. Starting with this update, the System Settings and Defaults link has been removed from the Navigator menu.
The time format used throughout Oracle Financial Consolidation and Close Cloud is now based on the time zone setting that you specify in User Preferences under Tools.
In Supplemental Data, you can set governors on the maximum number of Data Set Calculated and Dimension attributes to improve application performance. The system provides default settings, which you can decrease or increase up to the maximum value. It enforces the maximum limits when attributes are created.
In Close Manager, users with the Viewer role can now have restricted access to Close Manager functionality. For example, auditors can be assigned the Viewer role to check that the close process has been followed correctly without having the ability to modify tasks. Administrators can assign users with the Viewer role to tasks, templates, schedules, and so on, and can also create teams of Viewer users.
Note: The Viewer role is optional. If you have existing Close Manager users with the User role, it is not necessary to reassign them.
EPM Cloud Migration Accelerator is an Oracle utility and whitepaper providing best practices for migrating HFM customers to EPM Cloud. The current version allows migration of Hyperion Financial Management 11.1.2.3 and 11.1.2.4 applications to EPM Cloud. The EPM Cloud Migration Accelerator combines software as well as best practices/recommendations for moving your HFM applications to the Cloud. This holistic guide identifies the recommended approach for every step of the process and helps facilitate a clean and smooth transition.
A new version of the EPM Automate Utility is available with this update. This version includes the following commands:
Data Management now includes an incremental file adapter to optimize the data load process. The new Incremental adapter compares the source data file with a prior version of the source data file and identifies new or changed records and loads only this data set. The user has the option to sort the input source data file before making the comparison or they can provide a pre-sorted file for better performance.
You can now drill down from Summary level grid members and view the detail source data that make up the number.
In order to use this feature you should select the Enable Summary Drill option in Data Management. After enabling this option and loading the data with Create Drill Region option set to Yes the Drill icon will be enabled at the summary level. Drill is limited to 1000 descendant members for a dimension.
The following changes that affect provisioning are included in this update.
Using Groups created in Access Control, EPM Cloud supports application-level access control for planning, consolidation and close, tax reporting, and Oracle Enterprise Data Management Cloud applications. In addition to the custom groups created in Access Control, access control screens list predefined identity domain roles (Service Administrator, Power User, User and Viewer) as groups.
With a view to simplifying security across EPM Cloud and to ensure that application-level access control can be seamlessly migrated across environments Oracle plans to remove the ability to display predefined roles as groups in access control screens. After this change, you will no longer see predefined roles listed when you search for groups in access control screens.
NOTE: The proposed change will not affect how you create and manage groups or use them for application-level access control.
Before making this change, Oracle wants to evaluate the impact, if any, that the proposed change will have on your environments. If you are concerned that the proposed change will affect your environment, please create a service request explaining your use case.
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.
To allow customers more time to adapt and move from composite forms to dashboards, Oracle has decided to defer the removal of the ability to create new composite forms (forms that comprise multiple simple forms) to a future update in 2019. After this update all existing composite forms can still be edited and used. This change impacts only the creation of new composite forms in the service. Oracle will notify you at least two months prior to the removal of the feature.
All customers are advised to use dashboards in place of composite forms. No more enhancements will be made to the composite forms functionality.
Some of the Simplified Dimension Editor errors (cells outlined in red) are false-positive errors (i.e. incorrectly reported as errors).
Data Storage errors for the following members should be ignored:
In addition:
When you create a Translation Override rule, redirection does not work properly when you use a shared Parent account for the Source. Workaround: Specify the primary Parent account.
Seeded dimension members must have the Consolidation Operator set as Ignore. None of the POV members should be set to Dimension member. Rather, always use Top Member to view aggregated values.
When you change Ownership Data that uses a Consolidation rule and then consolidate, the Calculation Status is not correct for the partner and entity.
Reconsolidating Data After Upgrading
After you upgrade to 18.01, the first time you want to re-consolidate and re-translate any entity for a specific Scenario, Year and Period combination, you must run the Compute Rates task rule. Refresh the database and make sure that that Data Status is SC, showing that the cells are impacted. Then launch Consolidation and Translation. Subsequent re-consolidation / re-translation of the same Scenario, Year and Period combination does not require this step.
The Data Storage property has changed from Dynamic Calc to Never Share for these rate accounts in the Rates Cube:
Additionally, due to a change in calculation for Opening Balance for Retained Earnings Prior, you may require reconsolidation of existing data if Opening Balance Adjustment entries have been made, but not otherwise.
Also, enabling the Ownership Management feature requires a reconsolidation of existing data in order to populate the Proportion member of amount in the Consolidation dimension.
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.
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.
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.
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.
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.
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 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.
In Internet Explorer, you may experience issues using the Open Summary dialog in Smart View. To work around this issue: