Revision History

This document will continue to evolve as existing sections change and new information is added. All updates are logged below, with the most recent updates at the top.

Date	What's Changed	Notes
28 SEP 2016		Initial Document Creation

Oracle Financial Consolidation and Close Cloud, October Update

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

Announcements and New Features

Forms and Dashboards

Several additional forms are available on the Forms page, in three new folders: FCCS_Balance Sheet, FCCS_Cash Flow, and FCC_Income Statement. In addition, the Income Statement Dashboard is available under Dashboards.

Smart View Extension for Supplemental Data

A new Smart View extension is available from Downloads. The Smart View Extension for Supplemental Data enables you to manage the data collection process and work with supplemental data forms directly in Smart View. 

Activity Report

The Activity Report, which is automatically generated every day, enables Service Administrators to understand application usage over a period of five, ten, thirty or sixty days. It helps streamline application design by identifying calculation scripts and user requests that impact application performance. Information contained in this report includes:

• Number of users who signed into the application each day
• Percentage of requests that took more than 10 seconds to complete
• Top seven requests that took the most time to complete
• Top 30 worst performing actions that took over 10 Seconds to complete
• Number of users per hour
• Number of users based on how long they were signed into the application
• Top 10 users based on how long they were signed into the application
• Application design changes that occurred over the reporting period

To view the Activity Report:

1. Sign into a service instance.
2. Click Application, then Overview, and then Activity.
3. For Reports from last, select a report duration (5 days, 10 days, 30 days or 60 days).
4. Click a report name.

New EPM Automate Utility

A new version of the EPM Automate Utility is available with this update. This version supports the following new commands for Data Management:

• importMapping
• exportMapping
• runDMReport

You must install this update to use the new commands. See these sections in Working with EPM Automate for Oracle Enterprise Performance Management Cloud:

• Installation instructions: Installing the Utility
• Instructions to run commands: Command Reference

New REST APIs

Importing and Exporting Data Maps and Executing Reports

You can now use EPM Cloud REST APIs to perform these tasks: Import Data Map, Export Data Map, and Execute Report. This allows you to use Data Management to import and export data maps for a selected dimension or all dimensions, and to execute a report. Import member mappings API supports merge and replace modes as well as validate or no validate options for target members.

Updating the Scheduled Maintenance Window Time

You can now use EPM Cloud REST APIs to update the scheduled maintenance window time by performing these tasks: Get Build Version and Maintenance Window Time and Update Maintenance Window Time.

See the Oracle Cloud REST API for Oracle Enterprise Performance Management Cloud guide and the Oracle Cloud Enterprise Performance Management Integration Guide.

Changes to Daily Maintenance Screen

The navigation path to the Daily Maintenance screen where you set the maintenance window start time has changed. Additionally, the Daily Maintenance screen no longer contains the Version number of the current update, which linked to the Release readiness web site.

To open the Daily Maintenance screen:

1. Access the service.
2. Click or tap Tools, and then Daily Maintenance.

To view update version number and access release readiness information:

1. Access the service.
2. Click your user name at the top right corner of the screen to open Settings and Actions.
3. Select About, and then Version.
4. To view readiness information, click Oracle Enterprise Performance Management Release Readiness.
   The Enterprise Performance Management Release Readiness web site is displayed.
5. Click Financial Consolidation and Close and then a document format (HTML, PDF or ePUB).

Ability to Exclude Dynamic Members While Exporting Data

To improve performance during data exports, you can now exclude dynamic members from exported data. The option to exclude dynamic members is available in the Export Data screen. To access the Export data screen:

1. Access the service.
2. Click or tap Application and then Overview.
3. Click Action and then select Export Data.

Export HTML Report to Microsoft Excel

You can now export HTML formatted Financial Reporting reports to Microsoft Excel.

Multi-Column Loading of Numeric Data and Multi-Period Loading of Header Records

Data Management now supports a multi-column load of numeric data for any dimension. Prior to this update, Data Management supported only the loading of multi-period column data. In addition, a multi-period load using the header record is now available.

Email Sender Policy Framework Information

You can now use email sender policy framework to configure your corporate email system to ensure that important Oracle notifications regarding your service are not filtered out by your corporate email filtering system.

Financial Reporting Batch Scheduler Output

You can now store a PDF version of Financial Reporting batch scheduler output in Planning Inbox/Scheduler Output folder. To save the output in this folder, you select the Export to an external directory option when scheduling jobs. You can download and delete the output using Inbox/Outbox Explorer.

To download scheduler output to a local computer:

1. Access the service.
2. Click or tap Application and then Overview.
3. Click Action and then select Inbox/Outbox Explorer.
4. In Inbox/Outbox Explorer, select Scheduler Output.

About Daily Backups

The service, during daily maintenance, automatically creates a backup of data and artifacts. This service replaces the daily backup every time the maintenance is completed.

Set up an automated job using the EPM Automate Utility to download the backup to a local computer. See “Scheduling Maintenance” in Administering Oracle Financial Consolidation and Close Cloud.

Financial Web Studio New Features

Assign Multiple Database Connections to a Grid

You can retrieve data from different database connections and define the database connection for each data row or data column. You can preserve the members selected in the grid for the database connection on a grid row or column. See “Assigning Multiple Database Connections to a Grid” in Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud.

Save Report Objects

When you save a report object, you create a link between the source object in the report and the source object in the repository. When you save report object in the repository, you can reuse them as desired. This saves time and allows you to build a library of report objects to use when creating reports. When you save report objects in the repository, only the report object is saved, not the entire report design. See “Saving Report Objects” in Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud.

Sort Rows, Columns, and Pages in Grids

You can sort a range of consecutive rows or columns in a grid based on the values in a specific column or row. You can also sort columns, rows, and pages based on their headings. If you select a range of columns, Financial Reporting Web Studio sorts the columns based on the values in a specified row. If you select a range of rows, Financial Reporting Web Studio sorts the rows based on the values in a specified column. If the column or row by which you sort contains multiple members, the sort is based only on the values of the first member.

You can sort columns or rows in ascending or descending order. When you sort in ascending order, the lowest number, the beginning of the alphabet or the earliest date appears first in the sorted list. When you sort in descending order, the highest number, the end of the alphabet or the latest date appears first in the sorted list. See “Sorting Rows, Columns, or Pages in Grid” in Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud.

Enhanced Data Integration with Fusion Financials Cloud

The current integration between the Fusion Financials Cloud (GL) and EPM Cloud applications has been enhanced to provide a more seamless integration experience. The updated integration allows users to pick the desired source ledger from the Fusion Financials Cloud, set up a few simple mappings, and then push a button to pull the data into EPM Cloud applications. This integration, which can be run manually or scheduled for a specific time, no longer requires manual steps in Fusion Financials Cloud and EPM Cloud. The updated integration also sets up the drill definition automatically, which eliminates errors that may be caused when manually defining a drill definition.

If you are using an earlier version of the integration, you can continue to use it. You cannot automatically migrate an existing integration to the enhanced version of the integration. You can create a new integration definition with the new method as needed.

This integration is available for customers using Fusion Financials Cloud Release 11 or higher.

Data Load Into Other Services

In the September 2016 update, this document indicated incorrectly that data from Financial Consolidation and Close Cloud could be used as a source for other Cloud services. This capability will be available in a future update.

Data from Planning and Budgeting Cloud and Enterprise Planning and Budgeting Cloud can be loaded directly into Financial Consolidation and Close Cloud and Account Reconciliation Cloud. Additionally, you can load data from the Fusion GL Cloud into Financial Consolidation and Close Cloud, and Account Reconciliation Cloud. In prior releases data load was supported only for Planning and Budgeting Cloud and Enterprise Planning and Budgeting Cloud.

Data Management

Service Administrators can now use Data Management to import data into Financial Consolidation and Close Cloud using “Replace” mode.

Considerations

Be aware of the following considerations when working with Data Management:

• After you create an application and use Migration to import an extract, the Data Integration link may not appear in the Navigator after enabling a data load. If you log out and log in again, it will appear.

Working with Metadata

Considerations

Be aware of the following considerations:

• You should not make metadata changes that result in the following:
• Making a base member to whom a journal has been posted 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.

• Deleting a member
• 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.

Defects Fixed

Defect Number	Description
24616442	Sample applications cannot be created unless a Power User has been defined in addition to the Service Administrator.
24654659	Following a service upgrade, some member formulas no longer appear.
24569520	Formulas may fail if you modify a member’s alias.
24660237	When three or more intercompany accounts have been defined, data for all the accounts does not always display.