Document History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date Update Version Notes
05 APR 2018 April 2018 Update Revised April 2018 update.
07 MAR 2018 March 2018 Update Revised March 2018 update.
05 FEB 2018 February 2018 Update Revised February 2018 update.
22 DEC 2017 January 2018 Update Delivered new features in January 2018 update.

April 2018 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
05 APR 2018 Support for Infolets Updated document. Revised feature description.
05 APR 2018 Changing the Exchange Rate Type

Updated document. Added new consideration delivered in April 2018 update.

05 APR 2018

Copying and Clearing Data

Updated document. Revised description.

28 MAR 2018   Created initial document.

Oracle Financial Consolidation and Close Cloud, April Update

This document outlines announcements, defects fixed and considerations in the upcoming Oracle Financial Consolidation and Close Cloud update.

Monthly Update Schedule

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, April 6, 2018 and to your production environment on Friday, April 20, 2018, also starting at 22:00 UTC. The updates will be applied to your environments during the first subsequent daily maintenance.

The Oracle Help Center, which provides access to updated documentation, has a new look and feel. The updates will be available on April 6, 2018. Some of the links to new feature documentation included in this document will not work until after the Oracle Help Center update is complete.

Tips And Considerations

Reminder: 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.

NOTE: You can import backup snapshots into environments with the same, the preceding or the next update versions. For example, you can import backup snapshots from release 17.08 into releases 17.07 and 17.09. For more information about migration, see Administering Migration for Oracle Enterprise Performance Management Cloud.

See Backing Up and Restoring an Environment Using the Maintenance Snapshot in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for detailed procedures.

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.

Announcements

Additional Charts in Activity Report

The Activity Report has been enhanced to include the following charts that help you understand the processing load in your environment:

Number of User Interface Requests by Hour

Duration of User Interface Requests by Hour

Number of Essbase Operations By Hour

Duration of Essbase Operations By Hour

CPU Usage

Memory Usage

Key Resources

See Using Activity Reports and Access Logs to Monitor Usage in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Migration and Audit Cards Moved to Tools Cluster

Starting with the 18.04 update, the Migration card and Audit card will be moved to the Tools cluster in the Home page.

The Migration card enables Service Administrators to access and manage lifecycle management-related activities such as exporting and importing artifacts and data, working with snapshots, and viewing the Modified Since and Migration Status Report has been moved to the Tools cluster.

The Audit card allows Service Administrators to activate audit trails to track changes to artifacts and data.

Previously, this card was included in the Application Cluster.

Key Resources

Support for Infolets

Infolets, a new dashboard capability to enable data visualization, are now available in Financial Consolidation and Close. Infolets enable Service Administrators to provide enhanced graphical data presentation using charts and texts. Service Administrators can create infolets for any cube.

Infolets are interactive and use progressive disclosure to display high-level, aggregated, essential information for quick consumption at a glance. Users can act upon the information in the infolets as needed. They can be flipped and resized to display up to three charts or sets of values.

Service Administrators can create an infolets page that contains one or more infolets. An Infolets page houses a container that manages the space occupied by the infolets and rearranges them depending on the size of the browser and the size of the infolets.

Service Administrators can customize the application interface to enable end users to access infolets from the Home page using the Navigation Flow Designer.

NOTE: Although you can design infolets on the 18.04 Test environment, they will not work in Production before 18.04 is applied. If you try to apply the infolets in Production 18.03, the infolet dots will be displayed, but you may not see any content upon accessing the infolet pages. When 18.04 is applied to the Production environment, you will be able to access infolets in the Navigation Flows.

Key Resources

Support for Subtitles in Infolets

Service Administrators can now add subtitles to infolets after the infolet header. The infolet header remains the same for all views of an infolet, but you can now add an optional subtitle which can be customized to display different text for each view of an infolet. To add subtitles to an infolet, open an infolet in the Infolets Designer and hover over the upper right corner of the infolet to view the Infolet Menu. Under Layout, select Subtitle.

Key Resources

For more information, see Using the Infolets Designer in Administering Oracle Financial Consolidation and Close Cloud.

New Financial Reporting Explore Repository

For new subscriptions, Financial Reporting has implemented a new Explore repository, which is very similar to the existing Explore repository.

Existing subscriptions will be migrated to the new Explore repository in a near term release. The Explore repository documentation has been updated.

Key Resources

See Working with Financial Reporting for Oracle Enterprise Performance Management Cloud.

New Row and Column Suppression Behavior

Service administrators can use the Smart View Suppression Behavior option to change suppression behavior when both the Smart View No Data/Missing and Zero suppression options for rows, or columns, or both are selected.

If the Smart View Suppression Behavior option in the web application is set to:

Legacy—Only suppresses rows or columns containing either all No Data/Missing or all Zeros. Does not suppress rows or columns containing a combination of No Data/Missing and Zeros. For example, in Smart View, if both the No Data/Missing and Zero suppression options are selected for rows, and a row contains both zeroes and Missing labels, then the row is displayed; it is not suppressed.

Standard—Suppresses rows or columns containing all No Data/Missing or all Zeros, or a combination of both. For example, in Smart View, if both the No Data/Missing and Zero suppression options are selected for columns, and a column contains both zeroes and Missing labels, then the column is suppressed; it is not displayed.

Tips And Considerations

This feature was introduced with the 18.03 update.

Key Resources

Configurable Consolidations

You now have the ability to develop consolidation and elimination adjustment rules specific to your application. You can create rules for consolidation requirements that are not already provided by the system seeded rules. You can create one or more rule-sets, each defining a Source POV and Global conditions and representing a “consolidation adjustment journal.” Within each rule-set, you can then define individual rules, each representing the individual detail lines of the journal. Source POV members can also be re-directed within the rules to post to alternative target members based on one or more conditions. You can deploy the consolidation rules when needed.

Key Resources

For more information, see About Configurable Consolidation Rules in Administering Oracle Financial Consolidation and Close Cloud.

Exporting Ownership Management Information

You can now import and export Ownership Management information. 

Key Resources

For more information, see Importing and Exporting Ownership Data in Administering Oracle Financial Consolidation and Close Cloud.

New Seeded Member in Other Comprehensive Income Hierarchy

The seeded Other Comprehensive Income hierarchy in the Account dimension now includes a base member named FCCS_OR_OBFXCICTA, Other Comprehensive Income – Opening Balance – FX – CICTA.  It is used to carry forward Opening Balance for all revenue and expense accounts within Other Reserves (the parent member of Total Other Comprehensive Income).

Key Resources

For more information, see FX Calculations in Other Comprehensive Income Hierarchy in the Seeded Dimension Members section in Administering Oracle Financial Consolidation and Close Cloud.

Support for Custom Automated and Event Monitoring Integrations

Close Manager now includes the ability to create Process Automated and Event Monitoring tasks for external applications. A new EPM Adapter allows you to create connections and integration flows in Integration Cloud Service using Oracle EPM Cloud and other cloud and on-premises applications.

Key Resources

For more information, see Creating Custom Close Manager Integrations in Administering Oracle Financial Consolidation and Close Cloud.

Support for XLSX Format in Close Manager and Supplemental Data Manager Reports

When you generate reports for Close Manager and Supplemental Data Manager, the output format options now include XLSX format, in addition to PDF, HTML, and XLS formats. 

Key Resources

For more information, see Generating Custom Reports for Close Manager and Supplemental Data Manager in Administering Oracle Financial Consolidation and Close Cloud.

Removal of Support

Classic Dimension Editor

Effective with the June 2018 (18.06) update, the Dimensions link in the Navigator will link to the Simplified Dimension Editor, which was released with the 17.05 update (May 2017). Consequently, the Classic Dimension Editor will not be supported starting with the June 2018 update to the service (June 1, 2018 for test and June 15, 2018 for production instances).

Key Resources

For detailed information on using the Simplified Dimension Editor, See Editing Dimensions in the Simplified Dimension Editor in Administering Oracle Financial Consolidation and Close Cloud.

File-Based Integration of Data Management with Oracle Fusion Financials Cloud

Oracle Fusion Financial Cloud Budgetary Control and Encumbrance Accounting is now fully integrated with Data Management.

This enhancement brings the integration of Oracle Fusion Financials Cloud with Oracle Enterprise Performance Management Cloud on par with the current, out of the box, file-based integration. As a result, the file-based integration is being phased out starting the September update to the service.

If you are using file-based integration between Oracle Fusion Financials Cloud and Oracle Enterprise Performance Management Cloud, Oracle recommends that you adopt this new integration as soon as possible.

Financial Reporting Studio Desktop Client

Oracle is committed to providing a simple and intuitive user experience. To achieve this, Financial Reporting Web Studio, available since March 2016, will become the only environment for designing and building reports.

Oracle is providing additional time for users to transition from Financial Reporting Desktop Studio to Financial Reporting Web Studio. Tentative plans call for functional parity between Financial Reporting Web Studio and Financial Reporting Desktop Studio in 2018, at which time, support for the Desktop Studio will transition to the Web Studio and distribution of the Desktop Studio will cease. This transition is currently planned for the 18.06 update (June 01, 2018 for test and June 15, 2018 for production environments).

Oracle recommends that you transition to using Financial Reporting Web Studio at the earliest opportunity. Please send questions and concerns to Oracle using the Provide Feedback option in the service.

Defects Fixed

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

Considerations

Changing the Exchange Rate Type

When you change the Exchange Rate Type for an account to a Historical Override Exchange Rate Type  (for example, from “No Rate” to “Historical Amount Override”), the shared member is not created under FCCS_Historical Accounts. When you change the Exchange Rate Type from “Historical Amount Override” or “Historical Rate Override” to another Exchange Rate Type, the system does not delete the shared members from FCCS_Historical Accounts.

Workaround:  When you change an Exchange Rate Type, you must manually add or delete the members from the Historical Override shared hierarchies.

Restructuring Cubes

After you upgrade to 18.04, you must run the Restructure Cubes job, due to a change in the position of the Entity dimension that will result in significant performance gains.  First run the Restructure Cubes job for the Consol cube and then re-run it for the Rates cube. 

NOTE: If you import an LCM zip file that is created from a prior release, after the LCM import process, the Entity dimension reverts to its original position.  To correct the dimension order, after the import process, navigate to the Enable Features screen and click Enable, without making any other changes. Then proceed with the Restructure Cube steps.

Also, if you import an LCM zip file created in this release to a previous release, you must perform the same steps.

Key Resources

For details, see Restructuring Cubes in Administering Oracle Financial Consolidation and Close Cloud.

Configurable Consolidation Rules

If you were using 18.03 with Ownership Management enabled and the three Configurable Consolidation seeded rules deployed, after you upgrade to 18.04, the seeded rules will be displayed as Undeployed.

Setting the Factor in Configurable Consolidation RuleSets

If the None entry is selected in the first of the Rule-Set factor drop down boxes, ensure that the second drop down box has no selection (i.e. no entry / null and not None). If the second drop down box has a selection, then the factor cannot be saved in the individual rules.

Exchange Rate Type for Plug Accounts

The Exchange Rate Type must be the same for an Intercompany account and the plug account associated with it. For example, if the source accounts have an Exchange Rate Type of “No Rate”, then the Plug account Exchange Rate Type must be “No Rate”. If the source accounts have any of the three Historical Exchange Rate Types, then the plug account must also have the Historical Exchange Rate Type. The plug account does not have to be the exact same Historical type, but it must be one of the Historical Exchange Rate Types.

Intercompany Matching Reports

When a Power User has no access to an Entity or Partner in the report, the report displays “#noaccess”, and it also does not display the Variance.

If a Power User has access to all members in the report except an Entity or one of the Intercompany Account members, the system displays “An error occurred while processing”. The error occurs because the Power User requires security access to both the Entity and Partner, and the Intercompany Account members.

Member Formulas in the Simplified Dimension Editor

In the Simplified Dimension Editor, when you add a member formula for a member that has all the Data Storage (Default/Consol/Rates) properties the same, such as Dynamic Calc, the system incorrectly changes the Consol Data Storage value to Store, and displays it as a non-compliant value.

Translation Rules

When you create a translation rule and specify redirection to different members, the Source POV can be any members, including parent members, and seeded and system calculated members. You cannot select parent members only as part of the Source selection. The Redirection POV must be a base member and not a system calculated member. If you create a translation rule with no redirection, using only parent members in the Source selection is not allowed.

Auto Reversal Journals

If an auto reversal journal has an Approved status, you cannot unpost the corresponding auto-reversing journal. If the auto reversal journal is Rejected, then you can unpost the auto-reversing journal.

Importing Journal Artifacts

When you import Journal artifacts into Oracle Financial Consolidation and Close Cloud through Migration, errors may occur and the journals are not imported.

To work around this issue, after the import process fails, log out and log back in as an Administrator. From the Navigator, select Migration, and then the Snapshot tab. Expand the application. Expand Relational Data, select Journals, and click Import.

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.

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. To work around this issue, log off, and then log back in. Resolve the member alias conflict and refresh the database.

NOTE:  If you try to refresh the database without re-logging into the session, a server crash may occur.

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

For more information, see Member and Alias Considerations in the Enabling Ownership Management in Applications section in Administering Oracle Financial Consolidation and Close Cloud.

Adding Base Members From Dimension Editor

If you add a base member using the classic Dimension Editor and change the initially displayed Data Storage property on the Member Properties tab, please also check the Consol cube Data Storage option on the Member Formula tab. Ensure that the Data Storage option matches between the two settings. If it does not match, the member might not be usable. The Data Storage options can also be easily viewed and changed in the Simplified UI Dimension Editor.

Copying and Clearing Data

Be aware of the following issues relating to copying and clearing data:

Change in Calculation of CTA for Net Income / Retained Earnings Current Accounts

In the August, 2017 update (17.08), the seeded Net Income hierarchy included a new member named “Retained Earnings Current – Opening Balance – FX-CTA” as a sibling of Net Income. Opening Balance calculation was done for the new member, which was automatically added during the upgrade process. Due to this change, if you have not yet done so, you must reconsolidate your historical data by running the Consolidation process.

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.

Editing Dates in a 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.

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:

If there are journals or Supplemental Data posted to those members, these changes can cause problems when accessing Journals or importing existing journals.

Smart View Summary Dialog Display

In Internet Explorer, you may experience issues using the Open Summary dialog in Smart View. To work around this issue:

March 2018 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
07 MAR 2018 FX Calculations in Other Comprehensive Income Hierarchy Updated document. Added new feature delivered in March 2018 update.
07 Mar 2018

ClearEmptyBlock Rule

Updated document. Added new feature delivered in March 2018 update.
02 MAR 2018 Updated EPM Cloud Application Creation Page Updated document. Revised landing page for this feature.
23 FEB 2018   Created initial document.

Oracle Financial Consolidation and Close Cloud, March Update

This document outlines announcements, considerations and defects fixed in the upcoming Oracle Financial Consolidation and Close Cloud update.

Monthly Update Schedule

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (14:00 PST) on Friday, March 2, 2018 and to your production environment on Friday, March 16, 2018, also starting at 22:00 UTC. The updates will be applied to your environments during the first subsequent daily maintenance.

The Oracle Help Center, which provides access to updated documentation, will also be available on March 2, 2018. Some of the links in this document may be available only after the Oracle Help Center update is complete.

Reminder: 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. See Backing Up and Restoring an Environment Using the Maintenance Snapshot in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for detailed procedures.

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 as well as the monthly patch cycle.

Announcements

Updated EPM Cloud Application Creation Page

The first time you log in, you'll see an updated screen displaying these Oracle Enterprise Performance Management Cloud solutions from which to choose:

To create a Financial Consolidation and Close application, select Start under Finance, then select Financial Close, and then select the type of application you want to create.

The New Application Creation Page

Key Resources

For detailed application creation information, see Creating an Application in Administering Financial Consolidation and Close Cloud.

Supplemental Data Manager Multi-Cube Support

When you work with Supplemental Data Manager forms, you now have the option to select the cube from which to use dimension members. For example, when you are validating supplemental data, you select the cube from which the data needs to be validated.

During the Refresh Database process, metadata is copied to Supplemental Data Manager. In addition to leaf-level members, non-leaf level members are now copied, and the corresponding parent node name is displayed in Supplemental Data Manager.

Key Resources

See “Validating Supplemental Data” in Administering Oracle Financial Consolidation and Close Cloud.

Reporting Translation Process

Translating to reporting currencies is now required for all periods. Correct presentation of translated opening balances for historical accounts requires the cumulative translation of prior periods.

If prior periods in the current year have not yet been translated, they will be translated before the selected period. If there are prior years that have not been fully translated, the user will need to translate in sequence each year that has not yet been translated and then translate the current year. This requirement is the same as for the consolidation process.

Key Resources

See “Translation Process” in Administering Oracle Financial Consolidation and Close Cloud.

Provisioned Users Audit Report

A script is now available to automate the process of creating an audit report for provisioned users. This report shows the users and associated roles or groups that changed since the last time the report was generated.

Key Resources

See Scenario 13: Creating Provisioned Users Audit Reports in Working with EPM Automate for Oracle Enterprise Performance Management Cloud for detailed information.

New Server Setting in Financial Reporting Web Studio

A new property has been added to the Server Settings in Financial Reporting Web Studio. The "Maximum Number of Page Members For Excel Report" property allows you to specify the maximum number of page dimension members that can be exported to Microsoft Excel. The default value for this property is 100.

Key Resources

Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud

Smart View Support for Integrated Business Process Navigation Flows

Smart View now supports integrated business process navigation flows.

Using integrated business process navigation flows, Service Administrators can configure shared connections that enable Smart View users to navigate across any combination of the supported EPM Cloud subscriptions.

Key Resources

Service Administrators: See “Connecting Subscriptions in EPM Cloud” in Administering Oracle Financial Consolidation and Close Cloud for information on setting up integrated business process navigation flows.

Smart View users: See these topics in the Oracle Smart View for Office User's Guide for information on connecting:

ClearEmptyBlock Rule

A new rule, ClearEmptyBlock, is now provided by default to enable you to remove empty blocks from the database. You can launch the rule at any time from the Rules card, or from the EPM Automate process. It is recommended that you automate the rule to run periodically, for example, just before the consolidation process of every month.

FX Calculations in Other Comprehensive Income Hierarchy

The seeded Other Comprehensive Income hierarchy in the Account dimension includes a base member named FCCS_OR_OBFXCICTA, Other Comprehensive Income - Opening Balance - FX - CICTA. It is a sibling of Total Other Comprehensive Income and a child of Other Reserves.

This member is populated with the sum of the Opening Balance of the Other Comprehensive Income accounts, and a single FX and single FX-to-CICTA entry is made to this account based on a calculation of the values for the Total Other Comprehensive Income statement.

Removal of Support

Classic Dimension Editor

Effective with the June 2018 (18.06) update, the Dimensions link in the Navigator will link to the Simplified Dimension Editor, which was released with the 17.05 update (May 2017). Consequently, the Classic Dimension Editor will not be supported starting with the June 2018 update to the service (June 1, 2018 for test and June 15, 2018 for production instances).

Key Resources

For detailed information on using the Simplified Dimension Editor, See “Editing Dimensions in the Simplified Dimension Editor” in Administering Oracle Financial Consolidation and Close Cloud.

File-Based Integration of Data Management with Oracle Fusion Financials Cloud

Oracle Fusion Financial Cloud Budgetary Control and Encumbrance Accounting is now fully integrated with Data Management.

This enhancement brings the integration of Oracle Fusion Financials Cloud with Oracle Enterprise Performance Management Cloud on par with the current, out of the box, file-based integration. As a result, the file-based integration is being phased out starting the September update to the service.

If you are using file-based integration between Oracle Fusion Financials Cloud and Oracle Enterprise Performance Management Cloud, Oracle recommends that you adopt this new integration as soon as possible.

Financial Reporting Studio Desktop Client

Oracle is committed to providing a simple and intuitive user experience. To achieve this, Financial Reporting Web Studio, available since March 2016, will become the only environment for designing and building reports.

Oracle is providing additional time for users to transition from Financial Reporting Desktop Studio to Financial Reporting Web Studio. Tentative plans call for functional parity between Financial Reporting Web Studio and Financial Reporting Desktop Studio in 2018, at which time, support for the Desktop Studio will transition to the Web Studio and distribution of the Desktop Studio will cease. This transition is currently planned for the 18.06 update (June 01, 2018 for test and June 15, 2018 for production environments).

Oracle recommends that you transition to using Financial Reporting Web Studio at the earliest opportunity. Please send questions and concerns to Oracle using the Provide Feedback option in the service.

Defects Fixed

Beginning in this update, software issues addressed each month will be posted to My Oracle Support.

Considerations

Auto Reversal Journals

If an auto reversal journal has an Approved status, you cannot unpost the corresponding auto-reversing journal. If the auto reversal journal is Rejected, then you can unpost the auto-reversing journal.

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.

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. To work around this issue, log off, and then log back in. Resolve the member alias conflict and refresh the database.

Note:  If you try to refresh the database without re-logging into the session, a server crash may occur.

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

For more information, see “Member and Alias Considerations” in this topic:  https://docs.oracle.com/cloud/latest/financial-consol-cloud/AGFCC/migrating_ownership_mgt.htm#AGFCC-GUID-F200B598-0A2D-4458-BA92-C2B43D3588B7

Importing Journal Artifacts

When you import Journal artifacts into Oracle Financial Consolidation and Close Cloud through Migration, errors may occur and the journals are not imported.

To work around this issue, after the import process fails, log out and log back in as an Administrator. From the Navigator, select Migration, and then the Snapshot tab. Expand the application. Expand Relational Data, select Journals, and click Import.

Adding Base Members from Dimension Editor

If you add a base member using the classic Dimension Editor and change the initially displayed Data Storage property on the Member Properties tab, please also check the Consol cube Data Storage option on the Member Formula tab. Ensure that the Data Storage option matches between the two settings. If it does not match, the member might not be usable. The Data Storage options can also be easily viewed and changed in the Simplified UI Dimension Editor.

Smart View Summary Dialog Display

In Internet Explorer, you may experience issues using the Open Summary dialog in Smart View. To work around this issue:

Copying and Clearing Data

After copying data from actual to forecast, if you select the Rate option along with the Data option when clearing the forecast data, the system will clear the data as per the POV specified, but it also clears the Rate data for all Scenarios and not just the rate data as per the POV specified.

Change in Calculation of CTA for Net Income / Retained Earnings Current Accounts

In the August, 2017 update (17.08), the seeded Net Income hierarchy included a new member named “Retained Earnings Current – Opening Balance – FX-CTA” as a sibling of Net Income. Opening Balance calculation was done for the new member, which was automatically added during the upgrade process. Due to this change, if you have not yet done so, you must reconsolidate your historical data by running the Consolidation process.

Comprehensive Income CTA Accounts

If you configure a Comprehensive Income CTA account (CICTA) to capture CTA adjustments, the CICTA values are not correctly translated to reporting currencies other than the Entity and Parent Currency.

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.

Editing Dates in a 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.

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:

If there are journals or Supplemental Data posted to those members, these changes can cause problems when accessing Journals or importing existing journals.

February 2018 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
05 FEB 2018 Defects Fixed Updated document. Added defect information.
26 JAN 2018   Created initial document.

Oracle Financial Consolidation and Close Cloud, February Update

This guide outlines the announcements, fixed issues and considerations in the upcoming Oracle Financial Consolidation and Close Cloud update.

Monthly Update Schedule

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (14:00 PST) on Friday, February 2, 2018 and to your production environment on Friday, February 16, 2018, also starting at 22:00 UTC. The updates will be applied to your environments during the first subsequent daily maintenance.

The Oracle Help Center, which provides access to updated documentation, will also be available on February 2, 2018. Some of the links in this document may be available only after the Oracle Help Center update is complete.

NOTE: You can import backup snapshots into environments with the same, the preceding or the next update versions. For example, you can import backup snapshots from release 17.08 into releases 17.07 and 17.09.

Key Resources

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 as well as the monthly patch cycle.

Announcements

Support for Auto-Reversing Journals

You can now create auto-reversing journals. A new option is available on the Create Journal screen where you can select Auto-reverse as the journal type. When an auto-reversing journal is posted, an auto reversal journal is automatically created in the next period reversing all the adjustments corresponding to the journal.

You can also create auto-reversing journal templates, and run reports on auto-reversing journals.

Key Resources

See “Creating Autoreversing Journals” in Working with Oracle Financial Consolidation and Close Cloud.

Journal Attachments

When you perform a journal action such as Submit, Approve, Post, or Reject, you can attach additional information supporting the action performed. You can attach a document such as a text, Word or Excel file, pdf, audio, video or image file to the journal. You can view or download attached documents on the Journal History page.

Key Resources

For information, see “Working with Journals” in Working with Oracle Financial Consolidation and Close Cloud.

Enabling the Balance Calculation

When you create a new application, the system includes an entry for the Balance Calculation on the Consolidation Process page. The Balance Calculation ensures that the Balance Sheet is balanced (Total Assets = Total Liabilities and Equity). By default, the calculation is disabled for all Scenarios.

To enable the Balance Calculation:

  1. On the Home page, click Application, and then click Consolidation.
  2. Select the Consolidation Process tab.
  3. From the Local Currency tab, select the Balance the Balance Sheet calculation.
  4. From the right panel, under Disable by Scenario, use one of these methods:
  1. Click Save to save the rule.

For existing applications, the Balance Calculation is enabled by default. If you want to disable the calculation, you can add an entry to disable it for one or more specific Scenarios.

Key Resources

For information, see “System Calculations” in Administering Oracle Financial Consolidation and Close Cloud.

Exporting Tasks From Close Manager Task Lists to Excel

Close Manager Users are now able to export tasks from a Task List to Microsoft Excel. From the Task List, you can export selected rows, or export all the rows in the table. The export file is formatted for Excel.

Key Resources

See “Exporting Tasks” in Administering Oracle Financial Consolidation and Close Cloud.

Selectable Parameters for EPM Integrations

When you are using EPM Cloud Integrations through Close Manager, many parameters for automated integrations are now selectable from drop-down lists, which eliminates the need to manually enter values. For example, for the Run Business Rule pre-built integration, you can select from a list of business rules, such as ForceConsolidate or ForceTranslate.

Key Resources

See “Pre-Built EPM Cloud Integrations” in Administering Oracle Financial Consolidation and Close Cloud.

Integration Tasks for Uploading and Downloading Files Within EPM

In Close Manager, you can use pre-built integration tasks to upload and download files to automate data extract from one service to import into another service. For example, you can export data from Oracle Financial Consolidation and Close Cloud and import it into Oracle Tax Reporting Cloud.

Key Resources

See “Uploading and Downloading Files Within EPM Services” in Administering Oracle Financial Consolidation and Close Cloud.

New EPM Automate Utility Version

A new version of the EPM Automate Utility is available with this update. This version includes the upgrade command, which automatically downloads and silently installs the newest version of the EPM Automate Utility. After you run the login command to initiate a session, the utility identifies the current installed version. If the installed version is not the newest available, you can run this command to download and install the latest version.

Key Resources

See "EPM Automate Utility Commands" in Working with EPM Automate for Oracle Enterprise Performance Management Cloud for detailed information.

Application-Level Provisioning for Data Management

Application-level provisioning is now available for Data Management. This enhancement allows Service Administrators to grant the following roles to users who have the User or Viewer identity domain role. Granting these roles allow Users and Viewers to participate in the data integration process using Data Management.

Key Resources

See "Managing Application-Level Provisioning" in Administering Access Control for Oracle Enterprise Performance Management Cloud for detailed information.

Removal of Support

Classic Dimension Editor

With the March 2018 (18.03) update, the Dimensions link in the Navigator will link to the Simplified Dimension Editor, which was released several months ago. Consequently, the Classic Dimension Editor will not be supported starting with the March 2018 update to the service (March 2, 2018 for test and March 16, 2018 for production instances).

Key Resources

For detailed information on using the Simplified Dimension Editor, See “Editing Dimensions in the Simplified Dimension Editor” in Administering Oracle Financial Consolidation and Close Cloud.

File-Based Integration of Data Management with Oracle Fusion Financials Cloud

Oracle Fusion Financial Cloud Budgetary Control and Encumbrance Accounting is now fully integrated with Data Management.

This enhancement brings the integration of Oracle Fusion Financials Cloud with Oracle Enterprise Performance Management Cloud on par with the current, out of the box, file-based integration. As a result, the file-based integration is being phased out starting the September update to the service.

If you are using file-based integration between Oracle Fusion Financials Cloud and Oracle Enterprise Performance Management Cloud, Oracle recommends that you adopt this new integration as soon as possible.

Defects Fixed

Check this list again for the latest information when the update is applied to your test environment.

Defect Number

Description

27350021

The Override rate is now used for primary and shared entities and aggregated to parent entities of both.

27129399

Power Users can generate Intercompany Reports if they have access to all the entities and partners used in the report.

27353517

In Close Manager, graphs on the Compliance dashboard are now exported correctly to Excel.

27261080

Loading data in each month will not affect consolidation performance.

27255075

Users can generate Close Manager Report Binders without selecting any tasks.

27338211

In Close Manager, switching between tasks using the Next and Previous buttons displays the information correctly.

27235098

Users are now allowed to export tasks from the Task List to Excel.

27231950

In Data Management, empty journal entries are now exported correctly to FCCS.

27340363

In Data Management, when using an FCCS application, a data load rule no longer has different target options depending on the language of the web browser.

26405218

In Data Management, the French version of the File Selection window now shows Télécharger (Download button) and Charger (Upload button).

27267369

In Data Management, the application snapshot no longer fails with the "EPMFDM-140223:EXPORT FAILED FOR SYSTEM SETTING" error.

27314175

In Data Management, the Source Value field in Data Load Mappings now has a maximum length of 80 characters instead of 75.

26955559

A provider error no longer occurs when launching business rules from Smart View.

25678319

When working with user variables in Smart View, the order of the children members available for selection is now consistent with the order specified in the Planning web application.

27227923

In an ad hoc grid, all members selected for a POV are retained after changing the POV member for a dimension, and then changing the alias table to “None.”

27159164, 27239819

In cases where duplicate aliases exist in a hierarchy but their parent member does not have an alias, Smart View now displays the member name as the qualified name and the friendly name as the alias.

25217541

In Smart View, hierarchy member indentation and expansion are now correctly displayed when the “Suppress hierarchy” and “Start Expanded” options are enabled in Planning.

27334131

Refreshing a previously-saved Smart View ad hoc grid no longer causes an "invalid display POV" error.

27227593

Users no longer get an "error executing query" when running a book if the book has a level 0  list and descendants for the book Point of View.

26598697

Users no longer get an "error executing query" when running a book if the book has a level 0 list, descendants for the book Point of View, and level 0 members.

26921808

Financial Reporting Web Studio no longer times out.

27266649, 27271949

In Financial Reporting Web Studio, you can now successfully close the Select Members page.

27281312

Batch scheduler reports that are set up with a bursting file now successfully send emails after they are run.

Considerations

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.

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. To work around this issue, log off, and then log back in. Resolve the member alias conflict and refresh the database.

NOTE:  If you try to refresh the database without re-logging into the session, a server crash may occur.

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

For more information, see “Member and Alias Considerations” in this topic:

Importing Journal Artifacts

When you import Journal artifacts into Oracle Financial Consolidation and Close Cloud through Migration, errors may occur and the journals are not imported.

To work around this issue, after the import process fails, log out and log back in as an Administrator. From the Navigator, select Migration, and then the Snapshot tab. Expand the application. Expand Relational Data, select Journals, and click Import.

Adding Base Members from Dimension Editor

If you add a base member using the classic Dimension Editor and change the initially displayed Data Storage property on the Member Properties tab, please also check the Consol cube Data Storage option on the Member Formula tab. Ensure that the Data Storage option matches between the two settings. If it does not match, the member might not be usable. The Data Storage options can also be easily viewed and changed in the Simplified UI Dimension Editor.

Smart View Summary Dialog Display

In Internet Explorer, you may experience issues using the Open Summary dialog in Smart View. To work around this issue:

Copying and Clearing Data

After copying data from actual to forecast, if you select the Rate option along with the Data option when clearing the forecast data, the system will clear the data as per the POV specified, but it also clears the Rate data for all Scenarios and not just the rate data as per the POV specified.

Change in Calculation of CTA for Net Income/Retained Earnings Current Accounts

In the August, 2017 update (17.08), the seeded Net Income hierarchy included a new member named “Retained Earnings Current – Opening Balance – FX-CTA” as a sibling of Net Income. Opening Balance calculation was done for the new member, which was automatically added during the upgrade process. Due to this change, if you have not yet done so, you must reconsolidate your historical data by running the Consolidation process.

Comprehensive Income CTA Accounts

If you configure a Comprehensive Income CTA account (CICTA) to capture CTA adjustments, the CICTA values are not correctly translated to reporting currencies other than the Entity and Parent Currency.

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.

Editing Dates 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.

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:

If there are journals or Supplemental Data posted to those members, these changes can cause problems when accessing Journals or importing existing journals.

January 2018 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 What's Changed Notes
22 DEC 2017   Created initial document.

Oracle Financial Consolidation and Close Cloud, January Update

This guide outlines the announcements, fixed issues and considerations in the upcoming Oracle Financial Consolidation and Close Cloud update.

Announcements

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.

Monthly Update Schedule

Oracle will apply the latest updates to your test environments starting at 22:00 UTC-8 (2:00pm Pacific Time) on Friday, January 5, 2018 and to your production environment on Friday, January 19, 2018, also starting at 22:00 UTC-8. The updates will be applied to your environments during the first subsequent daily maintenance.

The Oracle Help Center, which provides access to updated documentation, will also be available on January 5, 2018.

NOTE: You can import backup snapshots into environments with the same, the preceding or the next update versions. For example, you can import backup snapshots from release 17.08 into releases 17.07 and 17.09.

Key Resources

Validating Metadata Option

This update includes an option to validate metadata. You can run a metadata validation report at any time to ensure that your metadata is valid. If metadata errors occur, the report displays the dimension name, the member name in [Parent].[Child] format, and the error description. You can use the Dimension Editor to fix the errors.

For example, if an error occurs that an Entity dimension member has a Consolidation Operator of other than “Ignore”, in the Dimension Editor, select the member and change the Consolidation Operator property to “Ignore”.

Steps to Enable

To validate metadata:

  1. On the Home page, click Application.
  2. Click Overview, then from Actions, select Validate Metadata.
  3. Click Run to validate the metadata.
  4. Expand a dimension to see the invalid results for the dimension. The results are displayed in [Parent].[Child] format with the error description.
  5. Navigate to the Dimension Editor to fix the metadata errors.

Restructure Cube Job

You can now run a Restructure Cube job in the Jobs console. When you select this option, the system performs a restructure of a Block Storage cube (BSO) to eliminate or reduce fragmentation, rebuild indices and remove empty blocks.

Steps to Enable

To run the Restructure Cube job:

  1. From the Home page, click Application, and select Jobs.
  2. Click Schedule Jobs.
  3. From the General tab, click Restructure Cube.
  4. From Cube, select the cube to restructure.

Relocate EPM Cloud Environments from One Identity Domain to Another

Oracle Cloud Account Administrators can now move an environment from its current identity domain to another. Unifying multiple EPM Cloud environments under one identity domain helps simplify user management and single sign on configuration. It also supports seamless cross-environment navigation.

Oracle Cloud Account Administrators may relocate an environment from its current identity domain to another if the target identity domain is provisioned to the same customer account and is in the same data center.

In addition to requesting the relocation of instances from My Services, additional service environment-specific tasks must be completed.

NOTE: You can relocate an environment only if it was provisioned after May 1, 2016. Environments that were provisioned prior to this date cannot be unified to use one identity domain.

Key Resources

New EPM Getting Started Guides

Starting with the December update (17.12), Service Administrator and end-user “getting started” information for all EPM Cloud Services is available from the following new guides:

Getting Started with Oracle Enterprise Performance Management Cloud for Administrators contains information on the tasks that Service Administrators can perform with EPM Cloud Services. This guide, which provides common administrative information for all EPM Cloud services, is now the primary source for tasks related to EPM Cloud administration including managing users and roles, setting up single sign-on, and backing up and restoring environments. This guide replaces the following guides:

Getting Started with Oracle Enterprise Performance Management Cloud for Users introduces end-users to Oracle EPM Cloud and provides information that enables them to quickly become proficient. This guide replaces the following guides:

Links in the Cloud Help Center and Oracle Learning Library have been modified to direct users to these guides. Please change your personal bookmarks and shortcuts so that they point to these new guides.

NOTE: Oracle Enterprise Data Management Cloud content is documented in several common Enterprise Performance Management Cloud guides. The service will be available in early 2018.

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.  State that you are inquiring or providing feedback, and indicate for which EPM Cloud service as well as the monthly patch cycle, in the body or title of the email.

Removal of Support

Classic Dimension Editor

With the March 2018 (18.03) update, the Dimensions link in the Navigator will link to the Simplified Dimension Editor. Effective March 2018 (March 2, 2018 for test and March 16, 2018 for production environments), the Simplified Dimension Editor will be the only interface available to edit and manage dimensions.

For detailed information on using the Simplified Dimension Editor, See “Editing Dimensions in the Simplified Dimension Editor” in Administering Oracle Financial Consolidation and Close Cloud.

File-Based Integration of Data Management with Oracle Fusion Financials Cloud

Oracle Fusion Financial Cloud Budgetary Control and Encumbrance Accounting is now fully integrated with Data Management.

This enhancement brings the integration of Oracle Fusion Financials Cloud with Oracle Enterprise Performance Management Cloud on par with the current, out of the box, file-based integration. As a result, the file-based integration is being phased out starting the September update to the service.

If you are using file-based integration between Oracle Fusion Financials Cloud and Oracle Enterprise Performance Management Cloud, Oracle recommends that you adopt this new integration as soon as possible.

Defects Fixed

Check this list again for the latest information when the update is applied to your test environment.

Defect Number

Description

27215592  

The Journal History dialog now opens correctly even if users have been deleted from the system.

26587052  

An administrator can unpost or reject a journal even if the Posted By User column is not valid.

26484227

You can import journals even if the journal user no longer exists in the user table.

26940836

Member formulas now correctly handle any number divided by zero in Exchange Rate calculations.

27031284

In Close Manager, an ID that is a member of both the Assignee and Approver teams can now claim a task.

27234042 

In Close Manager, the viewer of an organization unit assigned to a task can now open Task Actions for the task.

25405772

The Refresh the Database option now performs correctly even if there are no shared members under the Historical Override accounts.

26791407

You can now run a metadata validation report to find member property issues and ensure that your metadata is valid.

26274809

Approvers now receive an email notification when a journal is unposted.

26796660

You can now use functions in user variable attribute dimensions.

27152908

In Data Management, an error no longer occurs when reading an import expression for a data or amount column.

27009032

In Data Management, a data load no longer fails when an import mapping encounters UTF8 Byte Order Mark (BOM) characters.

27026977

Source filters associated with data load rules are now saved correctly.  

26985098

In Smart View, dimension members are no longer duplicated when zooming in, zooming out, or refreshing the parent member of a dimension.

26982965

In free-form mode, Smart View can now retrieve dynamic time series members that are shared members without using qualified names.

Considerations

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.

Balance Calculation

TIP: By default, the system automatically processes the Balance Calculation, which can impact consolidation performance.  To improve performance, you can disable the Balance Calculation so that the system does not automatically balance the Balance Sheet for you.   You can select one or more scenarios to disable.  If you do not want to have the calculation run for any scenarios, select all scenarios for disablement.  You can then create a new balance account member and write a custom calculation to run as needed.

Key Resources

See the “Balance the Balance Sheet” and “Creating Configurable Calculations” sections in the Oracle Financial Consolidation and Close Cloud Administrator’s Guide.

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.

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.

Adding Base Members from Dimension Editor

If you add a base member using the classic Dimension Editor and change the initially displayed Data Storage property on the Member Properties tab, please also check the Consol cube Data Storage option on the Member Formula tab. Ensure that the Data Storage option matches between the two settings. If it does not match, the member might not be usable. The Data Storage options can also be easily viewed and changed in the Simplified UI Dimension Editor.

Smart View

SUMMARY DIALOG DISPLAY

In Internet Explorer, you may experience issues using the Open Summary dialog in Smart View. To work around this issue:

USING FIREFOX ESR 52.4.2 WITH SMART VIEW

Mozilla Firefox has phased out support for XUL-based add-ons such as Smart View. Only add-ons and extensions built with new web extension technology will work in newer versions of Firefox. Therefore, Smart View 11.1.2.5.710 and newer only supports Firefox versions up to ESR 52.4.1. If you want to continue using Firefox with Smart View 11.1.2.5.710 and newer, do not upgrade your Firefox browser.

If your Firefox browser is set to automatically install updates, Oracle recommends changing the setting to “Check for updates, but let me choose whether to install them.” See the Firefox help for instructions on changing this setting.

Copying and Clearing Data

If you try to clear a shared entity, the base entity and all shared entities do not get cleared. To work around this issue, clear the primary entity in order to clear all shared entities.

After copying data from actual to forecast, if you select the Rate option along with the Data option when clearing the forecast data, the system will clear the data as per the POV specified, but it also clears the Rate data for all Scenarios and not just the rate data as per the POV specified.

Change in Calculation of CTA for Net Income/Retained Earnings Current Accounts

In the August, 2017 update (17.08), the seeded Net Income hierarchy included a new member named “Retained Earnings Current – Opening Balance – FX-CTA” as a sibling of Net Income. Opening Balance calculation was done for the new member, which was automatically added during the upgrade process. Due to this change, if you have not yet done so, you must reconsolidate your historical data by running the Consolidation process.

Comprehensive Income CTA Accounts

If you assigned an account as a CICTA Redirection Account, after you upgrade, the Redirection account attribute that you selected may be missing.

If you configure a Comprehensive Income CTA account (CICTA) to capture CTA adjustments, the CICTA values are not correctly translated to reporting currencies other than the Entity and Parent Currency.

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.

Editing Dates 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.

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:

If there are journals or Supplemental Data posted to those members, these changes can cause problems when accessing Journals or importing existing journals.