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
27 OCT 2016		Initial Document Creation

Oracle Financial Consolidation and Close Cloud, November Update

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

Announcements and New Features

Enabling Close Manager and Supplemental Data Management Only

When you create an application, you can choose to whether to enable the Consolidation feature.  You can also choose to enable Supplemental Data Manager.  The Close Manager feature is always enabled.   If the Consolidation feature is disabled, consolidation rules, Account Balance Sheet hierarchy, the Financials dashboard, and other consolidation-related features are not available. Once the application is created, consolidation and supplemental options can be enabled. See Administering Oracle Financial Consolidation and Close Cloud.

Journal Templates and System Reports

You can use journal templates to post adjustments that have common information.  You can create either Standard templates for frequently created journals, or Recurring templates for journals that need to be created for every period.

You can create and manage reports of journal activity that has occurred in the application.  You can save report definitions, import report definitions through Migration, and run reports in PDF, HTML, or XLS format. See Working with Oracle Financial Consolidation and Close Cloud.

Loading Journals to Oracle Financial Consolidation and Close Cloud

In Data Management, you can now load journals to Oracle Financial Consolidation and Close Cloud applications. Journals enable you to adjust data after it has been entered or loaded into base level entities. They also provide an audit trail of changes made in the application and indicate which users made adjustments and which accounts, entities, and time periods are affected.

Data Management supports an explicit load method when loading journals to Oracle Financial Consolidation and Close Cloud applications. Journals are loaded by defining a data rule of the type “Journals.” Both Excel and text-based journal loads are supported. See Administering Data Management for Oracle Enterprise Performance Management Cloud.

New EPM Automate Utility Version

A new version of the EPM Automate Utility is available with this update. This version supports the getsubstvar command, which enables you to view the current value of a substitution variable or the value of all variables at the cube or application level.

This version also implements simplified exit codes and detailed error messages that provide specific information in case of command execution failures. The utility now supports these error codes only:

1 to indicate functional errors reported by the REST APIs that the utility uses

6 to indicate that the service is not available

7 to indicate errors caused by the use of invalid command or parameter

9 to indicate failures due to invalid credentials

11 to indicate internal server errors

Error codes 2, 3, 4, 5, 8, and 10 are no longer applicable. If your scripts use these codes, replace them with a new code.

You must install this version of the utility 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
• Information on simplified exit codes: Exit Codes

Ability to Filter Members in Smart View Member Selector by Additional Criteria

In the Smart View Member Selection dialog box, you can now filter ad hoc report members by User Defined Attributes (UDA), generation, level, and level 0 descendant members. From the Filter drop-down list in the Member Selection dialog box, these options are now available when Smart View is connected to Financial Consolidation and Close Cloud:

• UDA to display the UDA dialog box, where you select a UDA (available only if the UDA was defined by an administrator)
• Generation to display the Generation dialog box, where you select one generation in the hierarchy of members
• Level to display the Level dialog box, where you select one level in the hierarchy of members
• Level 0 Descendant to display all descendants of the selected member that have no children

Row and Column Template in Financial Reporting Web Studio

Using row and column templates, you can select a contiguous set of rows or columns and save them as an object in the repository to reuse in reports. Row and column templates include one or more row or column definitions.

Same As Option in Financial Reporting Web Studio

The Same As option allows you to create a column or row member selection with the same member selection setting as another column or row.

Data Management

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:

• The replace export option will replace all data for the combination of scenario, year, period, entity and data source member.  Make sure that users with the Power User role have access to all data for the combination of these dimensions for which they are loading data.
• 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
• Deleting a 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.

Defects Fixed

Defect Number	Description
24803109	Financial Consolidation and Close applications should be updated to FCCS and Consolidation, rather than PCBS and Planning.
24797299	Overrides only work for data at FCCS_Data Input member of data source dimension.  If data is any other member, it is not overridden.  Override should override the "FCCS_Total Data Source" and write it to the FCCS_Data Input member.
24662901	The export process to Financial Consolidation and Close from Data Management takes a long time to complete.