report book fccs

Document History

December 2018 Update

Revision History

Oracle Financial Consolidation and Close Cloud, December Update

Monthly Update Schedule

Please Join Oracle Cloud Customer Connect

Give Us Documentation Feedback

Ownership Management Enablement

New EPM Automate Utility Version

Data Management Dimension and Attribute Column Enhancements

HsSetValue Accepts Additional Data Types

System Maintenance Task Options Enhancements

Consolidation Report Enhancements

Supplemental Data Manager Governors

Supplemental Data Support for Negative Number Colors

Smart View Support for Dashboards

Proposed Changes to Application-Level Access Control

Classic Dimension Editor

Renaming Close Manager Feature Set

Ability to Create New Composite Forms

Defects Fixed

Removal of Block Storage Cube Runtime Statistics

Load Data to P&L Accounts Using FCCS_ClosingBalance_Input

Translation Override Rule Redirection

Simplified Dimension Editor and Metadata Validation

Consolidation Operator for Children of Dimension Name Members

Calculation Status

Metadata Aliases

Reconsolidating Data after Upgrading

Copying Data

Self Service Upgrade

Editing Dates in a Data Collection Period

Entity Member Names/Aliases with ICP Property

Working with Metadata

Smart View Summary Dialog Display

Setting the Aggregation Option for Dimension Children

Viewing the FCCS_VIEW_SYSTEM_MEMBERS

Refreshing the Database in Extended Dimensionality Environment

Viewing Members on Seeded Forms

Unable to Refresh the Cube

Setting the Data Storage Property

Adding or Changing an Entity After Autonomous Consolidation Is Enabled

Horizontal Scroll on a Non-Tabular Form

Adding Shared Members in Smart View

Do Not Use Member Formulas in View Member YTD

Setting the Data Collection Period

Errors When Importing Accounts

Exporting Data Collection Period Using Migration

November 2018 Update

Oracle Financial Consolidation and Close Cloud, November Update

Option to Select Custom Top Member for System Calculations

Running Intercompany Reports

Displaying Member Names and Aliases in Journal Reports

New Version of Oracle Smart View for Office

REST APIs for Managing Users

Improved Search for Forms, Dashboards, and Infolets

Improved Performance While Uploading and Downloading Files

Displaying the POV Member Selector for a Report

Reopening Locked Schedules

Ability to Enter Hex Values to Customize Font Colors in Financial Reporting Reports

Simplified Dimension Editor Errors

Reconsolidating Data After Upgrading

October 2018 Update

Oracle Financial Consolidation and Close Cloud, October Update

Intercompany Reports Currency Dimension Information

New Consolidation Audit Trail Report

Journals Approval Option

Viewing Close Manager Tasks on the Welcome Panel

Working with Multiple Close Manager Schedules

New Server Setting in Financial Reporting Web Studio

Extended Dimensionality

September 2018 Update

Oracle Financial Consolidation and Close Cloud, September Update

Security for Users to Run Consolidation Process

Data Load - Reverse Year-to-Date Value for Accounts Loaded in Replace Mode

Integrated, Comprehensive User Preferences

System Settings and Defaults Moved to Application Settings

Uniform Time Zone Settings

Supplemental Data Set Governors

Close Manager Support for Viewer Users

Toolkit for Hyperion Financial Management Migration to EPM Cloud

Loading Data Using an Incremental File Adapter

Drilling Down from Summary Members

Provisioning Changes to Simplify Role Usage

Entity Member Names / Aliases with ICP Property

August 2018 Update

Oracle Financial Consolidation and Close Cloud, August Update

Incremental Export and Import Behavior Change

Ability to Create Journals for Entities with Different Parents

Enabling Auto-Creation of Blocks for Configurable Calculations

Support for Journal Import and Export Tasks in Jobs

Enhancements to Close Manager and Supplemental Data User Interface

Close Manager - List and Gantt Views

Close Manager Expanded Search Functionality

Close Manager Drag and Drop Attachments

Close Manager Task Assignees

Close Manager Custom Currency Codes

Supplemental Data - Power (Exponential) Calculation Added

Supplemental Data - Close Date in Supplemental Data Calculation

Referential Integrity for Account Types in Posted Journals

Intercompany Matching Reports

Financial Reporting Studio Desktop Client

New Infolets Designer Properties Panel

Folder Support for Dashboards and Infolets

New Documentation on Optimizing Business Rules

Updated Vision Sample Application

Ability to Create Composite Forms

Close Manager Calendar View

Only for Smart View for Office with Microsoft Office 365 ProPlus

Financial Reporting User Preferences

Importing Tab-Delimited Journals

Consolidation Rules - Errors in Seeded System Rules

July 2018 Update

Oracle Financial Consolidation and Close Cloud, July Update

Manage Ownership Enhancements

Migration Export Scenarios: Clone and Incremental Export

Changes to Labels and Threshold Values in Activity Report

Option to Show Hidden Files in the Financial Reporting Web Studio Repository

Simpler Member Selector

Composite Form Creation Capability

Moving Seeded Members

Exchange Rate Type for Plug Accounts

Translation Rules

Copying and Clearing Data

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

June 2018 Update

Oracle Financial Consolidation and Close Cloud, June Update

Power Users Can Lock and Unlock Data

Referential Integrity for Configurable Consolidation Rules

Updates to Snapshot Retention Policy

Forms Listing as a Hierarchy in Navigation Flows Artifact Library

More Intuitive POV Bar in Dashboards

Specify a Maximum Email Attachment Size When Scheduling Batches

Remove Time Stamp From File Name When Bursting Batch Reports

New Data Exchange Card in Oracle EPM Cloud

Changing the Exchange Rate Type

Importing Journal Artifacts

Adding Base Members From Dimension Editor

May 2018 Update

Oracle Financial Consolidation and Close Cloud, May Update

Seeded System Consolidation Rule-Sets

Microsoft Excel Version Usage in Activity Report

Retain Last Accessed Tab in Navigation Flow Cards

Enhancements to Dashboards

Oracle Account Reconciliation Cloud Clusters and Cards as Navigation Flows Targets

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

Dashboard Folders

Migrating Rules with Shared Members

Member Formulas in the Simplified Dimension Editor

Auto Reversal Journals

Adding Base Members from Dimension Editor

Editing Dates in a Collection Period

April 2018 Update

Oracle Financial Consolidation and Close Cloud, April Update

Additional Charts in Activity Report

Migration and Audit Cards Moved to Tools Cluster

Support for Infolets

Support for Subtitles in Infolets

New Financial Reporting Explore Repository

New Row and Column Suppression Behavior

Configurable Consolidations

Exporting Ownership Management Information

New Seeded Member in Other Comprehensive Income Hierarchy

Support for Custom Automated and Event Monitoring Integrations

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

Restructuring Cubes

Configurable Consolidation Rules

Setting the Factor in Configurable Consolidation RuleSets

March 2018 Update

Oracle Financial Consolidation and Close Cloud, March Update

Updated EPM Cloud Application Creation Page

Supplemental Data Manager Multi-Cube Support

Reporting Translation Process

Provisioned Users Audit Report

Smart View Support for Integrated Business Process Navigation Flows

ClearEmptyBlock Rule

FX Calculations in Other Comprehensive Income Hierarchy

Comprehensive Income CTA Accounts

February 2018 Update

Oracle Financial Consolidation and Close Cloud, February Update

Support for Auto-Reversing Journals

Journal Attachments

Enabling the Balance Calculation

Exporting Tasks From Close Manager Task Lists to Excel

Selectable Parameters for EPM Integrations

Integration Tasks for Uploading and Downloading Files Within EPM

Application-Level Provisioning for Data Management

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

January 2018 Update

Oracle Financial Consolidation and Close Cloud, January Update

Validating Metadata Option

Restructure Cube Job

Relocate EPM Cloud Environments from One Identity Domain to Another

New EPM Getting Started Guides

Balance Calculation

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

This document outlines the upcoming Oracle Financial Consolidation and Close Cloud update.

Oracle will apply the latest updates to your test environments starting at 23:00 UTC (15:00 PST) on Friday, December 7, 2018 and to your production environment on Friday, December 21, 2018, also starting at 23:00 UTC. The updates will be applied to your environments during the first subsequent daily maintenance.

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

Backing up the daily maintenance snapshot and restoring the environment as needed are self-service operations. Oracle recommends that you download the maintenance snapshot every day to a local server.

Please 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

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 [email protected] . 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

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.

Key Resources

See Member and Alias Considerations in the Enabling Ownership Management in Applications section in Administering Oracle Financial Consolidation and Close Cloud.

A new version of the EPM Automate Utility, which includes the getdailymaintenancestarttime command, is available with this update. You use this command to display the Coordinated Universal Time (UTC) at which the daily maintenance of the environment is scheduled to start.

You must install this version of the utility to use the new command.

Working with EPM Automate for Oracle Enterprise Performance Management Cloud

Installing the Utility
Command Reference

Dimension and attribute columns can now accept a maximum of 300 characters. Formerly, the dimension column accepted a maximum of 80 characters, attribute columns 1-7 accepted a maximum of 70 characters, and attribute columns 8-14 accepted a maximum of 20 characters.

In addition, you can now import values into a maximum of 40 attribute columns. Formerly, you could only import a maximum of 14 attribute columns.

The HsSetValue function can now be used to set values from cells with Smart List, text, or date formats.

HsSetValue in Working with Oracle Smart View for Office

The Maintain FDMEE Data Tables option has been renamed to Maintain Data Tables by Application.

The new Maintain Data Table by Location option allows you to delete data for a specific location by period or category. You can still delete all locations for a target application by using the Maintain Data Tables by Application option.

A new Maintain Setup Data option has been added so that you can view and delete an orphan row or invalid data that cannot be accessed or deleted from the user interface. This data may include an orphan row from an import format, location, or data load rule. It can also include a duplicate row, or a Cloud user id or password defined for a local target application.

Administering Data Management for Oracle Enterprise Performance Management Cloud

Maintain Data Table by Location
Maintain Setup Data

The Consolidation Report has been enhanced with several new features:

Ability to save the report definition and run it at any time.When you create a report, you can run the report immediately, or save it as a job and schedule it for a later date.The Job status and logs are available from the Jobs console.
New report options include an option to display zero lines, and whether to display the Member name, Alias, or both the Name and Alias of the dimension member.
Ability to display all the eliminations per Data Source and support for custom rules (for example, the configurable calculation rule defined in FCCS_50).
Running a Consolidation Report in Administering Oracle Financial Consolidation and Close Cloud

In Supplemental Data, you can set governors on form template sections and attributes, and selectable columns in the Data Analysis dashboard, 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 these objects are created.

Setting Supplemental Data Governors in Administering Oracle Financial Consolidation and Close Cloud

For Supplemental Data, you can specify whether to display negative numbers in Red or Black. You set the negative number color in User Preferences on the Application card.

Setting Your Display Preferences in Working with Oracle Financial Consolidation and Close Cloud

You can now open Oracle EPM Cloud dashboards in Oracle Smart View for Office.

Dashboards give you an overview to key information and let you change and save data. When you open a dashboard in Smart View, a new Excel workbook is launched with each dashboard object displayed in a separate worksheet. Chart objects are displayed in grid format. Only grid and chart objects are supported; other dashboard objects are ignored.

Dashboards in the Oracle Smart View for Office User's Guide

Upcoming Changes

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.

Pre-Defined Roles and Groups in Forms Access Control Screen

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.

With a future update, the “Close Manager” feature set name is changing to “EPM Task Manager”. When the change is announced, the user interface and documentation will be updated.

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.

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

Considerations

Starting in Release 19.02, run time statistics for Block Storage (BSO) cubes will no longer be available in the Database Properties module of Calculation Manager.

The 18.10 update contained a Valid Intersection rule to restrict users from using FCCS_ClosingBalance_Input to load data to P&L accounts. This rule has been removed starting in 18.11, so users should be able to load to that member now. Alternatively, P&L data can be loaded to the YTD_Input View without requiring a rule to populate the relevant periodic movement.

When you create a Translation Override rule, redirection does not work properly when you use a shared Parent account for the Source. The workaround is to specify the primary Parent account.

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:

Data Source -> All children of "FCCS_Source Entities"
Entity -> "FCCS_Global Assumptions"

If you are using a Hybrid upgraded environment, the Simplified Dimension Editor does not show Dynamic Calc as an allowed value for Custom dimension parent member Data Storage. This issue does not occur in a newly installed Hybrid environment. You can use the Classic Dimension Editor, Import Metadata, or Smart View to change the Data Storage value.

In addition:

The Metadata Validator incorrectly shows validation errors for shared level 0 Scenario dimension members.
The Metadata Validator incorrectly shows validation errors for parent members of the Scenario dimension.
The Metadata Validator warning message for the Data Source dimension’s system members incorrectly refers to “Never Shared” instead of “Never Share”.

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.When you change Ownership Data that uses a Consolidation rule and then consolidate, the Calculation Status is not correct for the partner and entity.

Ensure that no alias entries are “Equity”. The use of “Equity” as an alias will cause issues with refreshing the database.

The Data Storage property has changed from Dynamic Calc to Never Share for these rate accounts in the Rates Cube:

FX Rates – Average
FX Rates – Ending

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.

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.

Be aware of the following considerations:

Changing a base member to which a journal has been posted into a parent member

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

When you use ad hoc grids in Smart View with Financial Consolidation and Close Cloud, do not add a root Period member on the grid. Make sure the root Period member is removed by either clicking Remove Only or selecting periods that are in the application and selecting Keep Only. If a Period member is left on the grid, then any changes to data that you make will fail to properly set the impact status of the Entities.

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

Use the keyboard arrow keys to make your selection, then close and reopen the dialog; or
Minimize and then reopen the dialog; or
Use a different browser.

All immediate children of the dimension name member must be set with an aggregation option of Ignore or Never.

Children under a Parent member that has the Label Only data storage property must have the aggregation operator set to Ignore.

If you are using an Extended Dimensionality environment, users other than the Administrator can view the FCCS_VIEW_SYSTEM_MEMBERS and its hierarchy in the data form and Intercompany reports.

If you are using an Extended Dimensionality environment, when you refresh the database, an error message will be displayed if you exceed governor limits.

If you are using an Extended Dimensionality environment, on seeded forms, use the View members, such as Periodic, QTD and YTD, instead of using functions to ensure the _RULE members are not accidentally added to the forms.

A Cube refresh will not complete if a level 0 currency dimension member has the "Label only" data storage property, but this is not currently detected in the Dimension Editor or Metadata Validator.

The Metadata Validator may not recognize if a level 0 data source dimension member is incorrectly set to "Never share" as the value for the default data storage and Consol data storage property. No validation message is displayed.

The Data Storage property for both the default and Consol data storage property should Shared, Store, Dynamic Calc for a Level 0 Datasource member.

If a new entity is added when Autonomous Consolidation is already turned on, the entity and parents will not be consolidated after data is entered.

If an entity name is changed when Auto Consol is turned on, the consolidation will fail when it reaches the amended entity.

In Supplemental Data forms, the horizontal scroll does not work on a non-tabular form, which is intended only for use on a single record. Do not use non-tabular layout if the form is meant for more than one record.

When using Smart View, after adding a Shared Member, Refresh and Submit may not work correctly.

Using a Member formula in the View Member YTD will cause consolidation to fail.

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

Sometimes when importing an account, error messages may be generated because there are several accounts that reference an intercompany account in the Plug Account column but that account has yet to be encountered in the account file.

Try to reimport the account.

In Supplemental Data, when SDM Data is exported through Migration by selecting a particular Data Collection Period (DCP), then all DCPs are incorrectly added to the listing file. Even though all DCPs are displayed on the snapshot selection, only the data for the selected DCP will be exported.

This document outlines the upcoming Oracle Financial Consolidation and Close Cloud update.

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

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

For user-defined Custom dimensions, you now have the option to select the Custom dimensions for which Top Member processing will be applied. When selected, the System Calculation option applies to all scenarios and years.

System Calculations in Administering Oracle Financial Consolidation and Close Cloud

After you create an Intercompany report, you can now save it as a Job and run it a later time. The Intercompany Reports page displays a list of available reports.

Creating Intercompany Matching Reports in Working with Oracle Financial Consolidation and Close Cloud

The option to display member names and aliases in Journal Reports has changed. You now specify these options as system settings in User Preferences under Tools .

Setting the Display of Member Names or Aliases in Working with Oracle Financial Consolidation and Close Cloud

A new version of the EPM Automate Utility is available with this update. This version includes the following new commands

addUsersToGroup, which adds a batch of users to an existing group in Access Control using an ANSI or UTF-8 encoded Comma Separated Value (CSV) file that was uploaded to the environment.
removeUsersFromGroup, which removes users listed in an ANSI or UTF-8 encoded CSV file from a group maintained in Access Control.

Additionally, this version includes enhancements to the following commands:

assignrole: this command has been enhanced to provision users with roles belonging to a planning,consolidation, tax reporting, or data management application.
unassignrole: this command has been enhanced to revoke the application roles granted to a list of users identified in a CSV file.
provisionreport: this command has been enhanced to, optionally, generate a Provisioning Report (.CSV format) that lists only the users who are assigned the Identity Domain Administrator role. This command has also been enhanced to, optionally, create a simplified version of the Provisioning Report, which lists only the pre-defined roles and inherited application roles to which users are assigned. By default, this command now generates the classic Provisioning Report, which lists component roles that are subsumed into the pre-defined roles.

NOTE: In a future update, Oracle will make the simplified Provisioning Report as the default report that is generated from Access Control as well as using the provisionreport command. You will still be able to create the classic Provisioning Report using this command.

Command Reference in Working with EPM Automate for Oracle Enterprise Performance Management Cloud

Oracle Smart View for Office 11.1.2.5.810 will be available in November 2018. This version includes new features such as:

Drill-Through to Excel Sheets from EPM Cloud
Attaching Files to Cells in Forms and Ad Hoc Grids
Additional Information Added to Health Check
Support for Oracle Sales Planning Cloud

This release also fixes a number of defects.

The Smart View 11.1.2.5.810 Readme, available on the Help Center, will contain a complete list of features and defects addressed in this version. You must install this version to ensure access to the new functionalities.

Downloading and Installing Clients in Getting Started with Oracle Enterprise Performance Management Cloud for Users

You can now use REST APIs to perform these user management-related operations:

Add users to a group
Remove users from a group
Add users to an identity domain
Assign users to predefined roles
Remove users' role assignment
Remove users from an identity domain
Managing Users in REST API for Oracle Enterprise Performance Management Cloud

Search functionality is now more intuitive when you search for forms, dashboards, and infolets. Before, Search displayed artifacts in context of their folder structure. Now, you can toggle between searching for these artifacts using a flat view or a hierarchical view.

Searching for Forms, Dashboards, and Infolets in Working with Financial Consolidation and Close Reporting Cloud

This update features improved performance while processing large files using the following EPM Automate commands:

copyfilefrominstance
downloadfile
EPM Automate Utility commands in Working with EPM Automate for Oracle Enterprise Performance Management Cloud

When you click Reports on the Home page, the Reports page enables you to select the report you want to display. If you select the Show POV Options check box on the page and select a report that has a POV, a POV member selector window is displayed.

Your selection for this check box applies to all reports in the list that have a POV and persists for the current session, until you log out.

If you clear the Show POV Options check box (which is selected by default), the report launches directly, without displaying the POV member selector window. The POV members in the report are the most recently used members on the form, or the dimension's root if there are no most recently used members. Even if you launch a report directly and bypass the POV member selector window, when the report is displayed, you can still change the members in the POV by clicking a link in the POV and selecting different members.

Opening Reports in Working with Oracle Financial Consolidation and Close Cloud

When working on a Close Manager schedule, you can now reopen a locked schedule, if required.

Select the locked schedule, and then under Set Status , select Open .

Setting Schedule Status in Administering Oracle Financial Consolidation and Close .
Locking Schedules in Administering Oracle Financial Consolidation and Close .

You can now enter hex values to customize the font color for text objects in Financial Reporting reports. You enter hex values (without the prefix) in the text editor in Financial Reporting Web Studio. Hex values can be entered in both the short RGB format and the long RRGGBB format.

Defining the Font Color for Text in Designing With Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud

Pre-defined Roles and Groups in Forms Access Control Screen

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.

Some of the Simplified Dimension Editor errors (cells outlined in red) are false-positive errors (that is, they are incorrectly reported as errors).

Data Storage errors for Entity -> "FCCS_Global Assumptions" should be ignored.

Seeded dimension members that are children of the dimension names must have the Consolidation Operator set as Ignore. None of the POV members used for retrieving data should be set to the Dimension name member.

When you change Ownership Data that uses a Consolidation rule and then consolidate, the Calculation Status is not correct for the partner and entity.

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: FX Rates – Average FX Rates – Ending 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.

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

Be aware of the following considerations when working with metadata: Do not change a base member to which a journal has been posted into a parent member If there are journals or Supplemental Data posted to those members, these changes can cause problems when accessing Journals or importing existing journals. When you use ad hoc grids in Smart View with Financial Consolidation and Close Cloud, do not add a root Period member on the grid. Make sure the root Period member is removed by either clicking Remove Only or selecting periods that are in the application and selecting Keep Only. If a Period member is left on the grid, then any changes to data that you make will fail to properly set the impact status of the Entities.

In Internet Explorer, you may experience issues using the Open Summary dialog in Smart View. To work around this issue: Use the keyboard arrow keys to make your selection, then close and reopen the dialog; or Minimize and then reopen the dialog; or Use a different browser.

This document outlines the upcoming Oracle Financial Consolidation and Close Cloud update.

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, October 5, 2018 and to your production environment on Friday, October 19, 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 provides access to updated documentation. The updates will be available in the Help Center on October 5, 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.

A new version of the EPM Automate Utility is available with this update. This version includes the renameSnapshot command, which enables you to rename a snapshot available in an environment to prevent the maintenance process from overwriting it. Customers who have small applications can use this command to archive snapshots in the environment subject to snapshot retention policies.

This version also includes updates to the rundailyMaintenance command, which has been enhanced to take skipNext as a new optional parameter. This parameter allows you to skip the next occurrence of the daily maintenance process. Use this parameter to prevent the daily maintenance process from interfering with long running ad hoc processes of unknown duration that you execute in an environment.

Overview of the Maintenance Snapshot in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

When you generate Intercompany Reports, the reports now display Currency information. The Currency dimension is displayed in the report header, which enables you to determine the Currency member used by the report.

Administrators and Power Users can now run a Consolidation Report that provides a detailed audit trail of the consolidation process.

The report displays for a selected parent entity, the original reported closing balances and all the adjustments, including manual journal entries, Multi-GAAP adjustments and automatic eliminations generated by Intercompany elimination and consolidation rules, detailing the net contribution of each immediate child entity, and any variance.

The report is available in HTML, PDF, and XLS formats.

Administrators have the ability to allow users with the user role to approve journals. The option applies to all journals.

If you disable this option, when a User tries to approve a journal, the system displays an error message that they are not authorized to perform the task.

Setting Journal Options in Administering Oracle Financial Consolidation and Close Cloud .

Administrators now have the ability to display either Close manager "Current Tasks" or "Current and Upcoming Tasks" in the Worklist and on the Welcome panel.

If administrators enable "Current and Upcoming Tasks", user can see items in the upcoming workflows, as well as items currently available to work on.

Displaying Upcoming Tasks in Administering Oracle Financial Consolidation and Close Cloud
Viewing Tasks in Working with Oracle Financial Consolidation and Close Cloud

Administrators can now perform various actions on multiple Close Manager schedules at a time. This can be helpful if your application has a large number of schedules.

You can perform these actions on multiple schedules: Set Status, Reassign Users, and Generate Report Binders.

Setting Schedule Status in Administering Oracle Financial Consolidation and Close Cloud
Reassigning Users in Schedules in Administering Oracle Financial Consolidation and Close Cloud
Generating Report Binders in Administering Oracle Financial Consolidation and Close Cloud

A new server setting, "Export to Excel Using Default Sheet Name", controls Excel sheet names upon export. When set to false, the sheet name uses the Financial Reporting report name. When set to true, the sheet name uses the Excel default name (Sheet1, Sheet2, etc.)

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

If you want to use more than two Custom Dimensions, you must request the Extended Dimensionality update from Oracle Support.

When you make the request to update the environment with the Extended dimension applications, you must supply Oracle Support with the location URLs to update the application in the usual way. You also need to confirm to Oracle Support that you understand the following:

When the update is applied, any existing application will no longer be available.
After the update is complete, any existing application snapshot cannot be loaded.

After the update is applied, you must create a new application. You cannot modify the number of dimensions in an existing application. When Extended Dimensionality is enabled, you will see the option to create four Custom dimensions. If the application is enabled with the Multi-GAAP reporting option, you will see the option to create three Custom Dimensions.

METADATA CHANGES

In the update for Extended Dimensionality, the View dimension now has new seeded base members under a new seeded parent – FCCS_View_System_Members, which are suffixed with _RULE. These members are used internally and they are of the type Dynamic Calc.

In any of the existing forms, if the rows or columns are referencing View members using functions such as (ILvl0Descendants(View)), these _RULE members will also be queried. Since these members are Dynamic Calc, the performance of the forms will be slow. Change the definition of the forms using one of the following options:

Reference the Periodic, YTD, QTD and HYTD members directly, or
Add Exclusions in the form definition to exclude the subtree of FCCS_View_System_Members.

MIGRATION CONSIDERATIONS

Extended Dimensionality is only available for new applications. The Migration Snapshot feature is not available between non-Extended Dimension and Extended Dimension applications.

You can, however, move certain artifacts to your new application. See “Creating Extended Dimension Applications” in Administering Oracle Financial Consolidation and Close Cloud.

NOTE: For subsequent releases, if you have Extended Dimensionality, you must also request an update from Oracle Support.

See “Custom Dimensions” in Application Features Descriptions in Administering Oracle Financial Consolidation and Close Cloud.
Creating Extended Dimension Applications in Administering Oracle Financial Consolidation and Close Cloud.

Some of the Simplified Dimension Editor errors (cells outlined in red) are false-positive errors (that is incorrectly reported as errors).

Data Storage errors for Entity -> "FCCS_Global Assumptions" should be ignored

If you are using an Extended Dimensionality environment, the Simplified Dimension Editor does not show Dynamic Calc as an allowed value for Custom dimension parent member Data Storage. This issue does not occur in a newly installed Extended Dimensionality environment. You can use the Classic Dimension Editor, Import Metadata, or Smart View to change the Data Storage value.

In addition, the Metadata Validator warning message for the Data Source dimension’s system members incorrectly refers to “Never Shared” instead of “Never Share”.

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

Be aware of the following considerations when working with metadata:

Do not change a base member to which a journal has been posted into a parent member If there are journals or Supplemental Data posted to those members, these changes can cause problems when accessing Journals or importing existing journals.
When you use ad hoc grids in Smart View with Financial Consolidation and Close Cloud, do not add a root Period member on the grid. Make sure the root Period member is removed by either clicking Remove Only or selecting periods that are in the application and selecting Keep Only . If a Period member is left on the grid, then any changes to data that you make will fail to properly set the impact status of the Entities.

This document outlines announcements in the upcoming Oracle Financial Consolidation and Close Cloud update.

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, September 7, 2018 and to your production environment on Friday, September 21, 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 provides access to updated documentation. The updates will be available in the Help Center on September 7, 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.

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.

Consolidating Data in Administering Oracle Financial Consolidation and Close Cloud

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.

Example: Data Import File – YTD Input and Replace Mode in Administering Oracle Financial Consolidation and Close Cloud

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.

Setting Your Preferences in Working with Oracle Financial Consolidation and Close Cloud

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.

Managing Application and System Settings in Administering Oracle Financial Consolidation and Close Cloud

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.

Setting General Preferences in Working with Oracle Financial Consolidation and Close Cloud

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.

Adding Teams and Members for Close Manager in Administering Oracle Financial Consolidation and Close Cloud

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.

Learn more and download the Accelerator here .

A new version of the EPM Automate Utility is available with this update. This version includes the following commands:

addUsers, which creates a batch of users in an identity domain using an ANSI or UTF-8 encoded Comma Separated Value (CSV) file that was uploaded to the environment.
assignRole, which assigns a predefined identity domain role to all the users included in an ANSI or UTF-8 encoded CSV file that was uploaded to the environment.
removeUsers, which deletes the identity domain user accounts identified in an ANSI or UTF-8 encoded CSV file that was uploaded to the environment.
unassignRole, which removes one role currently assigned to the users whose email IDs are included in the ANSI or UTF-8 encoded CSV file that is used with this command.

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.

Loading Data using an Incremental File Adapter in Administering Data Management for Oracle Enterprise Performance Management Cloud

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.

Registering Target Applications in Administering Data Management for Oracle Enterprise Performance Management Cloud

The following changes that affect provisioning are included in this update.

Only the identity domain users who are assigned to a predefined role (Service Administrator, Power User, User, and Viewer) can log into service environments.
Users who are not assigned to predefined roles but were previously assigned to groups in Access Control will no longer be able to sign into the environment.
Only users who are assigned to predefined roles can be added as group members in Access Control.
Users who are not assigned to predefined roles cannot be added to groups using the importSnapshot EPM Automate command.
Users who are not assigned to predefined roles cannot be assigned Access Control privileges (Read, Write, Execute) on application artifacts.
The Provisioning report will show only the users who are assigned to predefined roles.
Users who are not assigned to predefined roles are not included in the comma separated value file that results from exporting the Provisioning Report.
Exports using Migration will not export (in Groups.CSV content of group membership) users who were not provisioned with predefined roles but were assigned to groups in Access Control.

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.

Member and Alias Considerations in Enabling Ownership Management in Applications in Administering Oracle Financial Consolidation and Close Cloud
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.

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, August 3, 2018 and to your production environment on Friday, August 17, 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 provides access to updated documentation. The updates will be available in the Help Center on August 3, 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.

In the initial 18.07 update, Oracle changed the behavior of incremental export and import operations to prevent the selection of Essbase Data and a few other artifacts. Due to customer demand, Oracle reverted this change in a later 18.07 patch, which was applied to your test and production environments. The reverted behavior allows you to select all artifacts, including Essbase Data artifacts, during incremental exports and imports.

Due to this change, these artifacts can now be selected for incremental exports. These can also be imported from snapshots:

All artifacts in the Essbase Data folder located in Planning\Essbase Data
Text Values in Planning\Relational Data\Text Values
Supporting Detail in Planning\Relational Data\Supporting Detail
Cell Texts in Planning\Relational Data\Cell Texts
Account Annotations in Planning\Relational Data\Account Annotations
Attachment References in Planning\Relational Data\Attachment References
Journals in Planning\Relational Data\Journals (Oracle Financial Consolidation and Close Cloud only)

Exporting Artifacts and Application in Administering Migration for Oracle Enterprise Performance Management Cloud

You can now create and post journal entries for entities that have different parents.

Creating Journals in Working with Oracle Financial Consolidation and Close Cloud

When you create configurable calculations, you can enable the Auto Create Blocks option to have the system automatically create missing blocks. This can resolve issues with missing data when you run configurable calculations.

Enabling Auto Creation of Blocks for Configurable Calculations in Administering Oracle Financial Consolidation and Close Cloud

Journal import and export tasks are now available in the Jobs console. The tasks include Journal Import, Journal Export, Journal Template Import and Journal Template Export. You can select to run these jobs immediately or schedule them for a later date. Job status and logs are available from the Jobs console.

Jobs Overview in Administering Oracle Financial Consolidation and Close Cloud

This update includes enhancements to the Close Manager and Supplemental Data user interface. Close Manager and Supplemental Data functions that you previously accessed from the Navigator have moved to the Home page under the Applications card.

From the Applications card, after you select Close Manager or Supplemental Data, you then use tabs on the left side of the main page to access functions such as Templates, Task Types, and Schedules in Close Manager, or Data Sets and Forms and so on in Supplemental Data.

Examples of new user interface:

Creating Task Templates in Administering Oracle Financial Consolidation and Close Cloud
Creating Data Sets in Administering Oracle Financial Consolidation and Close Cloud

The Task List Hierarchy and Gantt Chart views that you previously accessed from the Navigator have moved to the main Close Manager interface. They are available as View types in the drop-down on the right side of the Close Tasks page.

Search functionality has been expanded for fields on the Worklist. Using the Search field, you can now search on all fields except Date.

In Close Manager, you can now add one or more attachments to tasks by using drag and drop functionality from the Add Attachments dialog box.

Adding Attachments in Administering Oracle Financial Consolidation and Close Cloud

In Close Manager tasks, the Related Tasks section enables you to view the predecessor and successors for a task. It also now shows the Task Assignees and Task Owners for the dependent tasks.

Viewing Related Tasks in Working with Oracle Financial Consolidation and Close Cloud

The ability to create or edit Close Manager-specific currency codes is no longer supported effective with this update. If your application contains a Close Manager-specific currency code, it will remain in the application but will no longer be editable.

In Supplemental Data and Close Manager, a new scripted calculation allows you to use POWER(x,y) to raise one number to the exponential power of another. The usage is: POWER(x,y), where x=BASE NUMBER, and y=EXPONENT. x and y can be attributes or calculations, as long as they are numeric.

Adding Data Set Attributes in Administering Oracle Financial Consolidation and Close Cloud
Defining Calculation Attributes in Administering Oracle Financial Consolidation and Close Cloud

In Supplemental Data Manager, Close Date is now available as a selectable attribute for Calculation in Data Sets. It is available from the “Add Attribute” drop-down list on the Calculation tab of Data Set Attributes, and can be used in calculations.

To prevent a referential integrity problem with journals from occurring in an application, the system now prevents users from changing the Account Type of an account member that is used in a Posted journal. If you need to change the Account Type of a member used in a Posted journal, you must first unpost the journal.

Journal Referential Integrity in Administering Oracle Financial Consolidation and Close Cloud

Power Users no longer require access to Intercompany dimension members. They still require access to Intercompany Entity members.

Run Batch With Signed On User Credentials, a new server setting, is available in Financial Reporting Web Studio. When this setting is set to true, there is no prompt for a username and password in the Batch Scheduler; instead, the batch is run with the credentials of the user who is currently signed in.

To set this property, open Financial Reporting Web Studio and select File , and then Manage , and then Server .

NOTE: You must restart the environment to enable the new setting. You can restart an environment using the resetservice EPM Automate command or by modifying the maintenance start time. If you do not restart the environment, the setting will take effect after the next scheduled daily maintenance of the environment.

Setting Service Maintenance Time in Getting Started with Oracle Enterprise Performance Management Cloud for Administrator

Starting with this monthly update, Oracle will stop distributing the Financial Reporting Desktop Studio installer. The command line utilities associated with Financial Reporting Desktop Studio will also be discontinued starting with the 18.08 update.

NOTE: Existing installations of the Financial Reporting Desktop Studio and command line utilities will no longer work with Financial Reporting starting with the 18.09 update.

Use Financial Reporting Web Studio instead of Financial Reporting Studio Desktop Client.

A new properties panel on the right side of the Infolets Designer enables you to view and work with various properties of infolets, such as the title, subtitle, chart type, size, and so on. The properties panel displays the properties of the infolet (and its displayed view) which is highlighted by the blue border.

To view the properties panel in the Infolets Designer, from the Home page, click Infolets , and then either create an infolet or edit an existing infolet.

Using the Infolets Designer in Administering Oracle Financial Consolidation and Close Cloud

The listing pages for dashboards and infolets now support folders. Folders enable you to assign permissions to all artifacts within a folder rather than assigning permissions to each individual artifact. The listing pages for dashboards and infolets will look and behave the same as the listing page for data (forms). All three artifact listing pages (forms, dashboards, and infolets) use the same folder hierarchy and all artifacts and folders reside under a root folder called Library .

To create a folder, click the Navigator , and then click Forms .
To assign permissions to a folder in the artifact listing, click the Actions menu associated with the folder.
To move an existing artifact into another folder, click the Actions menu associated with the artifact, click Move To , and then select the folder to which you want to move the artifact.

Search and Filter will also work for dashboards and infolets in the same way as they do for forms.

Designing Dashboards in Administering Financial Consolidation and Close Cloud
Working with Infolets in Administering Financial Consolidation and Close Cloud

Information on leveraging available Enterprise Management Cloud tools to diagnose and address performance issues with business rules is now available in the new "Optimizing Business Rules" section of Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud .

Optimizing Business Rules in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
Viewing and Downloading Activity Reports and Access Logs in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

An updated version of the Vision sample application is available starting with this update. The updated sample application contains features that were added in recent updates.

The sample application now supports Infolets, which provide the dashboard capability to enable data visualization. As a Service Administrator, you can create infolets for any cube to provide enhanced graphical data presentation to users using charts and texts.

ABILITY TO ENTER DATA INTO SUPPRESSED ROWS

The updated sample application allows Service Administrators to enable users to enter data in a web form for members on rows that are currently suppressed (because they have no data and the form layout option “Suppress Missing Data – Rows” option is selected).

NAVIGATION FLOWS

Service Administrators can set up connections that enable users to navigate across Oracle Enterprise Performance Management Cloud environments to create unified business process flows across multiple environments. Cross-environment navigation flows allow users of multiple EPM Cloud environments to sign into one environment, and then seamlessly navigate to others without going through additional authentication processes. Service Administrators can create mashups of artifacts from various environments into a single unified business process flow for their users. Clusters, cards, and tabs can be brought together into a single flow. These cards and tabs can contain forms, reports, and dashboards from various applications. Users will not see the clusters, cards and tabs in the process flow unless they are members of the groups to which these flows are assigned.

SMART FORMS

Three Smart Forms: one containing Excel formulas, one containing Excel functions, and one created in Smart View, are included.

REORGANIZED CLUSTERS AND CARDS THAT MATCH THE NEWEST EPM CLOUD INTERFACE

Clusters and cards in the sample application now match the current EPM Cloud interface.

To allow customers more time to adapt and move from composite forms to dashboards, Oracle will defer removing the ability to create new composite forms (forms that comprise multiple simple forms) to a future release update (January 2019 - 19.01). Oracle had previously announced that this feature will be removed in the June (18.06) update.

All customers are advised to use dashboards in place of composite forms. There will be no more enhancements to the composite forms functionality.

For users of Close Manager within Financial Consolidation and Close Cloud, the Calendar view will not be supported effective with this August, 2018 (18.08) update.

To allow customers more time to familiarize themselves with the Simplified Dimension Editor, Oracle will defer the removing support for Classic Dimension Editor to a future update. The current plan is to remove access to the Classic Dimension Editor starting with the 18.10 (October 2018) update to the service.

In 18.08, Lifecycle Management (LCM) migration to 18.07 will not be supported for Close Manager schedules, templates, tasks and task types. You also cannot restore an 18.08 update backup for Oracle Financial Consolidation and Close Cloud into 18.07 systems. The Journal artifacts in 18.08 are not compatible with 18.07. This covers the two week window when Test systems are upgraded to 18.08 and production is still on 18.07.

A known issue with Microsoft Office 365 ProPlus patch 16.0.10228.20051 updated through the insider slow channel prevents the use of Smart View for Office with Microsoft Office 365. This Microsoft patch was pushed to users who signed up for monthly channel updates between June 12 and June 14, 2018.

Workaround: Do not update Microsoft Office 365 with patch 16.0.10228.20051 if you are using Smart View for Office with Microsoft Office 365 ProPlus. Instead, use Microsoft Office 365 monthly channel Version 1806 (Build 10228.20080), which contains the fix for this issue.

All existing customers will be migrated to the new Financial Reporting Repository (implemented in the 18.05 update for new customers). The process does not migrate Financial Reporting user preferences.

Workaround: Each end user must manually set Financial Reporting user preferences when using the Repository for the first time.

If you create a Journal Job that imports a tab-delimited journal from the server (Inbox), the job fails and journals are not imported. Importing tab-delimited journals works correctly as a Local import.

The seeded consolidation rules do not properly cater for disposals of investments in all cases, notably full disposals after acquisitions over several periods.

This document outlines announcements and upcoming changes in the upcoming Oracle Financial Consolidation and Close Cloud update.

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, July 6, 2018 and to your production environment on Friday, July 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 provides access to updated documentation. The updates will be available in the Help Center on July 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.

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

For the following Ownership Management actions, if the process takes longer than 60 seconds, then the remainder of the process will be continued in the background and the user can navigate to other screens if required. To view the progress of the process, open the Jobs console.

Recompute Ownership Data
Import Ownership Data
Copy Ownership Data to Next Year
Recomputing Ownership Management in Administering Oracle Financial Consolidation and Close Cloud
Importing Ownership Data in Administering Oracle Financial Consolidation and Close Cloud
Ownership Settings Year to Year in Administering Oracle Financial Consolidation and Close Cloud

A new version of the EPM Automate Utility is available with this update. This version includes the copyfilefrominstance command, which copies a file from a source environment to the environment (target) from which you run the command.

This version also includes changes to the following commands to make them consistent with other file operation commands:

listfiles: now lists snapshots and files available in an environment
deletefile: now deletes snapshots and files from an environment

Migration has been enhanced to differentiate two export scenarios:

Backup to create a snapshot that can be used to clone an environment, for example to migrate an application from a production instance to a test instance for troubleshooting or additional development work.

When you backup the environment, you create a snapshot of the entire environment, similar to the daily maintenance snapshot, by exporting the application with all of its data and artifacts including artifacts belonging to Document Repository, Data Management, Calculation Manager, Relational and Essbase data, and Groups and Membership.

Export to create an incremental backup of specific artifacts in an environment. Generally, you use incremental snapshots to create backups that can be used to update another environment. For example, you can export artifacts that you tested in a test environment to create an interim snapshot, which you can import into a production environment.

Artifacts that can be exported only as a part of backup operation are greyed out and cannot be selected during export.

Unavailable Artifacts for Incremental Export

Oracle has lowered the display threshold for the following metrics in the Activity Report to 2 seconds.Additionally, the labels of these metrics have been modified to reflect these changes.

Percentage of UI Requests over 2 Seconds
Top 30 Worst Performing User Interface Actions over 2 Seconds
Users Average Response Time by Hour

Using Activity Reports and Access Logs to Monitor Usage in Working with EPM Automate for Oracle Enterprise Performance Management Cloud

By default, hidden artifacts are not displayed in Financial Reporting Web Studio. If you need to edit an artifact that is hidden, you can now "unhide" the artifact and edit it directly in the Financial Reporting Web Studio repository.

Viewing Hidden Artifacts in Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud

To select items in the Member Selector, you are no longer required to click the checkmark. You can now simply select an item by clicking on it or by selecting the checkmark as before.

As announced in preceding Readiness Documents, Oracle will stop distributing the Financial Reporting Desktop Studio installer starting the 18.08 update (August 3, 2018 for test and August 17, 2018 for production environments). The command line utilities associated with Financial Reporting Desktop Studio will also be discontinued starting with the 18.08 update.

Oracle recommends that you transition to using Financial Reporting Web Studio as soon as possible. Please send questions and concerns to Oracle using the Provide Feedback option in the service.

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. The current plan is to remove access to the Classic Dimension Editor starting with the 18.10 (October 2018) update to the service.

Editing Dimensions in the Simplified Dimension Editor in Administering Planning for Oracle Planning and Budgeting Cloud

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 release update (January 2019 - 19.01). Oracle had previously announced that this feature will be removed in the June (18.06) update.

You can move seeded members to a different location within the hierarchy, and reorder them either under the same parent or under a different parent. After you upgrade to 18.07, seeded members may be reset to their original positions and you must reorder them again.

Note: After moving to 18.07, seeded member movement changes you make will be retained during subsequent updates.

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 are any of the three Historical Exchange Rate Types, then the plug account must also be one (any) of the Historical Exchange Rate Types.

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.

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.

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

When copying override rates or amounts from one entity to another, the Calculation Status of the target entity should change from No Data to Impacted, but currently it does not. The source entity's Calculation Status is also incorrectly impacted.

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.

Workaround: Each end user must manually set Financial Reporting user preferences when using the Repository for the first time.

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

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, June 1, 2018 and to your production environment on Friday, June 15, 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 provides access to updated documentation. The updates will be available in the Help Center on June 1, 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.

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.

Starting with this update, power user can lock and unlock data.

To prevent a referential integrity problem with configurable consolidation rules from occurring in an application, the system now verifies and prevents the deletion of any metadata member that is referenced in the rules.

Duplicating and Deleting Rulesets in Administering Oracle Financial Consolidation and Close Cloud

Oracle Smart View for Office 11.1.2.5.800 will be available by mid-June. This version includes new features such as:

Move Formatting behavior enhancement to notify you of performance impact
Improved resolution on high-definition devices, such as Microsoft Surface Pro tablets
New Health Check, where you can view information about your system, and configure Smart View options and Windows Registry settings geared toward improving performance and reducing flickering

The Smart View 11.1.2.5.800 Readme, available on the Help Center at the time of release, contains a complete list of features and defects addressed in this version. You must install this version to ensure compatibility with the June 2018 update features and to access the new functionalities.

Downloading and Installing Clients in Getting Started with Oracle Enterprise Performance Management Cloud for Users

The daily maintenance process has been enhanced to prevent large accumulation of snapshots (over 150 GB) in EPM Cloud environments.

By default, the snapshots that you create through the export process or upload to an environment are stored for a period not exceeding 60 days after which they are automatically removed. Starting with this update, the daily maintenance process will automatically remove snapshots prior to sixty days, oldest first, to prevent the total size of all snapshots from exceeding 150 GB, which may adversely impact your environment. The daily maintenance snapshot, irrespective of its size, is always retained in EPM Cloud environments.

Exporting Artifacts from Environments in Administering Migration for Oracle Enterprise Performance Management Cloud

Forms listed within the artifact library in Navigation Flows are now displayed in a hierarchical manner.

The Go arrow in the POV for dashboards (which commits changes made on the page) displays only if the user has made changes. Changes to the page display in yellow.

In Financial Reporting, you can now specify a Maximum Email Attachment Size so that you can email more books using the Batch Scheduler.

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

In Financial Reporting, you now have the option to remove the time stamp from the zip file names created by batch job outputs to external directory. This change does not apply to normal batch output in Financial Reporting.

To facilitate easier access to Data Management features, starting with the 18.07 update, EPM Cloud will feature a new Data Exchange card in the Application Cluster. This card will launch a page from which you can access these Data Management features:

Data Maps --Launches the existing Data Maps user interface so that users can manage maps between a source application and a reporting application. No functional changes will result from the Data Maps reassignment to the Data Exchange card.
Data Integration --Launches the Integrations tab of the Simplified Interface. The Integrations tab consolidates all import/export tasks under a single tab. Formerly in the Standard Interface, integration tasks were accessed from the Data Management tab.

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. Current plan is to remove access to the Classic Dimension Editor starting with the 18.10 (October 2018) update to the service.

Editing Dimensions in the Simplified Dimension Editor in Administering Oracle Financial Consolidation and Close Cloud

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 tentatively planned for the 18.09 update (September 07, 2018 for test and September 21, 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.

When you change the Exchange Rate Type for an account from “No Rate” to “Historical Amount Override” or “Historical Rate Override” in the releases prior to patch 18.04.64, the shared member is not created under FCCS_Historical Accounts. You must set the account back to “No Rate”, and then change to “Historical Amount Override” or “Historical Rate Override” to create the Historical Amount or Rate accounts.

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 .

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.

You should not make metadata changes that results in changing a base member to which a journal has been posted into a parent member.

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

Oracle will apply the latest updates to your test environments starting at 22:00 UTC (15:00 PDT) on Friday, May 4, 2018 and to your production environment on Friday, May 18, 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 May 4, 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.

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.

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 . You can also access Oracle Customer Cloud Connect directly from Oracle Financial Consolidation and Close Cloud by clicking the User Assistance icon.

This update provides nine system rule-sets for Ownership Elimination adjustments. The seeded rules are created by the application.

NOTE : Three of the rule-sets replace the previous three hard-coded rules available in prior updates. If you deployed any of the three previous rules, you will need to re-deploy them and also review the other six rules.

The seeded system rule-sets are as follows:

Investment (replacing existing rule)
Investment PP
Owner's Equity (Subsidiary/Proportional) (replacing existing rule)
Owner's Equity (Subsidiary/Proportional) PP
Owner’s Equity (Equity)
Owner’s Equity (Equity) PP
Owner's Equity (Holding) (replacing existing rule)
Net Income (Subsidiary)
Net Income (Equity)
Seeded Consolidation Rules in Administering Oracle Financial Consolidation and Close Cloud

A new version of the EPM Automate Utility is available with this update. This version includes the runDailyMaintenance command, which enables Service Administrators to run the daily service maintenance process as needed. For example, Service Administrators can use this command to update their service as soon as a patch to an environment is available instead of waiting for the daily maintenance window.

EPM Automate Utility Commands in Working with EPM Automate for Oracle Enterprise Performance Management Cloud
Setting Service Maintenance Time in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

The Activity Report has been enhanced to include the Microsoft Excel Versions in use and the number of users who use them.

Browser, Smart View, and Excel Usage Information in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

When working with cards in navigation flows that have multiple tabs or sub tabs, the last tab accessed by a user will be retained the next time the user accesses the card in the same session.

Designing Custom Navigation Flows in Administering Oracle Financial Consolidation and Close Cloud

Dashboards have been enhanced in several ways:

Dashboards now present a more streamlined look. For example, scroll bars aren’t displayed if they aren’t needed.
For many chart types, you can now opt to show or hide grid lines.
You can set the horizontal alignment for values in tile chart types: Left, Center, or Right.
To simplify how large currency values are displayed in tile chart types, you can now scale values. For example, select the M scaling option to display the value 123,456,789 as 123M.
Designing Dashboards in Administering Oracle Financial Consolidation and Close Cloud

EPM Cloud source subscriptions can now customize navigation flows to access Oracle Account Reconciliation Cloud clusters and cards (note that Oracle Account Reconciliation Cloud is only a target service when connecting subscriptions). Clusters and cards can now be directly selected from Oracle Account Reconciliation Cloud using the Add Existing Card/Cluster option.

Connecting Subscriptions in EPM Cloud in Administering Oracle Financial Consolidation and Close Cloud

Removal of Support

For users of Close Manager within Financial Consolidation and Close Cloud, the Calendar view will not be supported effective with the August, 2018 (18.08) update.

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

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.

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

In a future update (tentatively planned for the June (18.06) update), Service Administrators will have the ability to organize dashboards in folders. These folders will enable Service Administrators to apply security and permissions to folders rather than to each dashboard.

Existing dashboards will be visible under the root folder in dashboards and infolets listing pages after this new feature is introduced. The form folders available in the environment will also be available for organizing dashboards because folders are shared across artifact types. All folders will be managed using a unified folder management screen.

When you perform a Migration extract of a rule that contains a Target Redirection to a shared member, the extract file does not include information on the shared Dimension for that rule. When you import the extracted file, the rule is not created properly.

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.

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.

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.

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.

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.

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.

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.

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

Number of User Interface Requests by Hour

Duration of user interface requests by hour

Duration of User Interface Requests by Hour

Number of Essbase operations by hour

Number of Essbase Operations By Hour

Duration of Essbase operations by hour

Duration of Essbase Operations By Hour

Memory usage

Memory Usage

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

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.

Auditing Tasks and Data in Administering Oracle Financial Consolidation and Close Cloud
Administering Migration for Oracle Enterprise Performance Management Cloud

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.

Designing Infolets in Administering Oracle Financial Consolidation and Close Cloud
Viewing Key Information with Infolets in Working with Oracle Financial Consolidation and Close Cloud

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.

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

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.

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

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.

This feature was introduced with the 18.03 update.

Smart View Administrators: See Specifying Smart View Settings in Administering Financial Consolidation and Close Cloud .
Smart View Users: See Data Options in Working with Oracle Smart View for Office.

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.

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

You can now import and export Ownership Management information.

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

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

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.

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.

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

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.

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

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.

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

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.

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.

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.

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

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

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

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.

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

Human Capital

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

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

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.

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

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.

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

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.

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

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.

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

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.

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:

“Shared Connections and Private Connections”
“Connecting to Data Sources”
“Creating Shared Connections”

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.

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.

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 .

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

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

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.

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

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.

Oracle Help Center
For more information about migration, see Administering Migration for Oracle Enterprise Performance Management Cloud.

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.

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

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.

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

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:

On the Home page, click Application , and then click Consolidation .
Select the Consolidation Process tab.
From the Local Currency tab, select the Balance the Balance Sheet calculation.
From the right panel, under Disable by Scenario , use one of these methods:
Add the selected Scenarios to the EXCLUDE clause (for example, Budget,Actual). This means that all Scenarios are disabled EXCEPT for Budget and Actual.
Modify the entry by including only the Scenarios for which you want the calculation disabled, for example, Consol,Forecast,ActBudDiff.
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.

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

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.

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

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.

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

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.

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

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.

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

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.

Create Integration
Run Integration
Drill Through

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

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

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

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

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.

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.

For more information about migration, see Administering Migration for Oracle Enterprise Performance Management Cloud .

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 [email protected] . 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.

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:

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

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.

To run the Restructure Cube job:

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

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.

See “Relocating an EPM Cloud Environment to a Different Identity Domain” in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for detailed information.

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
Getting Started with Oracle Enterprise Performance Management Cloud for Users

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:

Using Oracle Planning and Budgeting Cloud
Getting Started with Oracle Financial Consolidation and Close Cloud
Getting Started with Account Reconciliation Cloud for Administrators
Getting Started with Oracle Profitability and Cost Management Cloud for Administrators
Getting Started with Oracle Tax Reporting Cloud
Getting Started for Administrators for Oracle Enterprise Performance Reporting Cloud

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:

Getting Started with Account Reconciliation Cloud for Users
Getting Started with Oracle Profitability and Cost Management Cloud for Users
Getting Started for Users for Oracle Enterprise Performance Reporting Cloud

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.

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.

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.

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

SUMMARY DIALOG DISPLAY

Use the keyboard arrow keys to make your selection, then close and reopen the Summary dialog; or
Minimize and then reopen the Summary dialog; or

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.

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.

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

This document is provided for information purposes only, and the contents hereof are subject to change without notice.This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation.All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Full Copyright Notice

Digital Engineering & Experience

Data, automation & ai.

Cloud Enhancement & Managed Services
Products Platforms & Innovation icxPro - Intelligent Part Assistant iLeaseFinPro Vehicle Leasing Software Enterprise Workforce Scheduler Connected Enterprise

Oracle Cloud & Enterprise Apps

Salesforce cloud & industry solutions, platforms & innovation.

INDUSTRIES Public Sector & Government Healthcare & Life Sciences Retail & Consumer Manufacturing & Technology Financial Services Higher Education Construction & Engineering Hospitality Transportation & Logistics High Tech Professional Services Wholesale Distribution Media & Entertainment Oil & Gas
PARTNERS About Partnerships Salesforce Partner UiPath Partner ServiceNow Partner Snowflake Premier Partner Oracle Partner Microsoft Partner AWS Partner
Insights News Press Releases Blog Resources Webinars & Events
MST SOLUTIONS
BIZANALYTICA
Digital Engineering & Experience Cloud Migration Low Code DevSecOps Quality Engineering MACH Platform Engineering
Data, Automation & AI Cloud Data Modernization Data Management Data Governance Business Intelligence & Analytics Intelligent Automation Decision Sciences & ML, AI
Oracle Oracle Cloud Applications Glide 4.0 Oracle E-Business Suite Oracle Consulting AdvantEdge IaaS SAP to Cloud Migration PeopleSoft to Cloud Migration Oracle Analytics Cloud Oracle Cloud Infrastructure Oracle Autonomous Data Warehouse
Salesforce MuleSoft Experience Cloud Sales Cloud Servide Cloud Marketing Cloud Industry Cloud Commerce Cloud Data Cloud CRM
Platforms & Innovation
icxPro – Intelligent Part Assistant
iLeaseFinPro Vehicle Leasing Software
Enterprise Workforce Scheduler
Connected Enterprise
Public Sector & Government
Healthcare & Life Sciences
Retail & Consumer
Manufacturing & Technology
Financial Services
Higher Education
Construction & Engineering
Hospitality
Transportation & Logistics
Professional Services
Wholesale Distribution
Media & Entertainment
Oil & Gas
About Partnerships
Salesforce Partner
UiPath Partner
ServiceNow Partner
Snowflake Premier Partner
Oracle Partner
Microsoft Partner
AWS Partner
Press Releases
Webinars & Events

Mastek Blog

Oracle financial consolidation & close service (fccs) guide.

30-Nov-2022 00:04:49 / by Mohammed Umar

For companies that have complex structures comprising multiple subsidiaries and offices spanning the globe, carrying out financial consolidation and closing in an efficient manner is of great importance.

Given the fact that consolidated financial statements help stakeholders, auditors and investors assess and understand your finances, there’s no margin for error. Each cycle needs to be executed with accuracy and accountability, while also ensuring on-time turnarounds.

T his blog will explore the challenges companies face when using conventional tools to consolidate and close their finances and how Oracle Financial Consolidation and Close Cloud Service (FCCS), a part of Oracle EPM Cloud suite, can help them overcome these challenges.

Key C hallenges Companies Face with Their Financial Consolidation and Close Cycles

Most companies use Excel or similar platforms for preparing various financial statements and executing their consolidation and closing. This involves a lot of manual work, leading to validation errors.

Usually, financial statements and data are shared by employees across the company using emails. This can unintentionally lead to someone gaining unauthorized access to the data and can also make fixing accountability and tracking changes difficult.

Communication between subsidiaries and the holding company takes place in isolation; there’s a lack of set standards and principles that govern the consolidation cycle. Different people liaising with different subsidiaries make it difficult for the holding company to track the overall status of the consolidation cycle.

4. Delays and Rework Validation errors and the need for back-and-forth communication can take up a lot of time and effort, skewing timeline estimates for financial consolidation and close. Also, the need for an exhaustive amount of data from each subsidiary can cause delays and rework if the information is missing or yet to be audited.

5. Difficulties in Reporting For each consolidation cycle, companies need to prepare standalone reports for each subsidiary as well as consolidated reports, taking into consideration the accounting and reporting standards of the different countries they operate in. Also, the currencies of different countries need to be considered and converted to the holding company’s currency. All this needs to be done with great accuracy, which is difficult to achieve with conventional tools.

The Solution - Oracle Financial Consolidation and Close Cloud Service (FCCS)

Oracle Financial Consolidation and Close Cloud Service (FCCS) can help you overcome the above-stated challenges and make your consolidation cycles shorter and more efficient. It is a pre-built Oracle Cloud Application that handles most of your financial close needs based on the best practice management and solution. It takes all the global standards, International Financial Reporting Standards (IFRS), and Generally Accepted Accounting Principles (GAAP) into consideration so that companies can close their books faster with more accuracy and flexibility.

Oracle FCCS is an extremely flexible solution; although it is a part of the Oracle EPM Cloud suite, it can be implemented independently, ensuring that you don’t have to implement the entire EPM solution. It also has an intuitive and logical process flow that is easy to adapt even for first-time users; this process flow has been detailed in the following section.

Oracle FCCS Process Flow

Since Oracle Financial Consolidation and Close Cloud Service (FCCS) is not a transactional system, data needs to be provided to it. Oracle FCCS also offers the option of loading data from your source system for seamless integration where all monthly/periodic/quarterly balances can be pulled from your respective source system to Oracle FCCS. This facility can be used with any transaction system including Excel and can be implemented at the subsidiary as well as holding company level.

This data loading and integration process can also be automated by setting up a schedule. This eliminates any dependency between subsidiaries and reduces manual intervention as there’s no need for follow-ups with subsidiaries, and the system notifies you once the data has been loaded.

2. Manage ownership Oracle FCCS provides you with the ability to manage all investing companies by displaying the status of each company and the relation between companies - subsidiary/associate. It also provides you with the consolidation method by taking into consideration all the accountancy treatments that need to be followed in various consolidation methods.

3. Review data Oracle FCCS offers you the flexibility of passing the journal to check if any manual changes or adjustments are required since it fetches all the data for you automatically. It enables you to review all the trial balances and additional information schedules including – receivables, ageing, fixed assets movement, that need to be consolidated on a quarterly or annual basis.

4. Review inter-company balances With Oracle Financial Consolidation and Close Cloud Service (FCCS), you can review and also correct the inter-company balances with great ease. It also tracks all the changes made to ensure accountability.

Consolidation takes place at multiple levels, starting from the base level company, moving up the ladder to the immediate controlling company, and finally to the holding company. The system takes care of tasks like inter-company elimination, currency translation, all you need to do is run one simple rule and everything else happens automatically.

6. Review financial statements Oracle FCCS provides you with reports and customizable dashboards in a standalone as well as consolidated format, eliminating the need for preparing different sets for subsidiaries or reporting companies. All of these reports adhere to the various disclosure requirements as per different accounting standards and can be reviewed by you whenever required. Oracle FCCS also lets you view and download dynamic reports that can retrieve data from any subsidiary.

Mastek’s Oracle FCCS Implementation Approach

MicrosoftTeams-image (85)Mastek Oracle FCCS Implementation Approach

Oracle FCCS is the end-to-end consolidation and close solution you have always been looking for and Mastek can help you implement it in as little as 10-12 weeks depending on your requirement. With deep expertise in Oracle Cloud Applications and years of experience serving 1 3 00+ clients from diverse industries, Mastek can offer you an unparalleled Oracle implementation experience.

Topics: Oracle , Financial Consolidation and Close , FCCS , EPM Cloud

Written by Mohammed Umar

Sr. Principal Consultant, Mastek

Subscribe to Email Updates

Lists by topic.

Digital Transformation (66)
Retail (34)
Salesforce (29)
Healthcare (20)
Oracle (20)
Retail Tech (19)
Government (17)
Financial Services (14)
Testing (14)
Vertical Vibe (13)
Banking (11)
Health Cloud (10)
Artificial Intelligence (9)
Customer Experience (9)
Public Sector (9)
CEO Insight (8)
Cloud Technology (8)
Cloud migration (8)
Machine Learning (8)
UK Public Sector (8)
Digital Service Design (7)
data analysis (7)
Business Process Automation (6)
Cloud Enhancement Services (6)
Data Virtualisation (6)
Future Tech (6)
TechNovation (6)
customer data platforms (6)
retail operations (6)
Data Security (5)
Managed Services (5)
UK Central Government (5)
research (5)
Blockchain (4)
Digital Workforce (4)
Digital commerce (4)
Intelligent Automation (4)
Supply Chain (4)
Test Automation (4)
Transformation (4)
cloud implementation (4)
mortgages (4)
mulesoft (4)
AI technologies (3)
Data management (3)
Fintech (3)
Government Digital services (3)
Government Tech (3)
Graduate Programme (3)
Oracle ERP Cloud (3)
Oracle Partner (3)
RPA Implementation (3)
Robotic Automation (3)
business acceleration (3)
business outcomes (3)
consumer market (3)
edge computing (3)
metaverse (3)
work management (3)
workplace (3)
AI Strategy (2)
Automation Testing (2)
Business Intelligence (2)
Cloud Adoption (2)
Cloud-based AI (2)
Customer Engagement (2)
Customer Insight (2)
Data Science (2)
Data Visualisation (2)
DataOps (2)
DevOps culture (2)
Digital Banking (2)
Global Highlights (2)
Identity & Access Management (2)
Intelligent Automation tools (2)
Intelligent Automation vs RPA (2)
Intelligent Process Automation (2)
Manufacturing (2)
Mobile Testing (2)
Operational Resilience (2)
Oracle Cloud Application (2)
Security (2)
Spend Analytics (2)
analytics (2)
automating systems and processes (2)
business analysis (2)
business uncertainty (2)
cybersecurity (2)
data modernisation (2)
data protection (2)
data quality (2)
data-driven intelligence (2)
diversity and inclusion (2)
ecommmerce (2)
erp cloud implementation (2)
erp consultant (2)
governance (2)
leadership (2)
post pandemic (2)
strategy (2)
thoughtleadership (2)
work from home (2)
#DevSecOps #SecOps #IAST #DAST #SAST #RASP (1)
AI Algorithms (1)
AI in the social sector (1)
Agile BI (1)
Agile Testing (1)
Agile with GDS (1)
Automated Testing (1)
Automation (1)
BizAnalytica (1)
Chat Bots (1)
Cognitive Computing (1)
Cognitive RPA (1)
Cognitive Technologies (1)
Compatibility Testing (1)
Continous Delivery (1)
DART Framework (1)
Data Storage (1)
Data availability (1)
Deep Learning (1)
DevSecOps (1)
EPM Cloud (1)
Education (1)
Engineering colleges in Mumbai (1)
Financial Consolidation and Close (1)
IT consulting (1)
Innovation (1)
Low-Code (1)
MOT Framework (1)
Mobile Content (1)
Natural Language Processing (1)
Oracle EPBCS (1)
Oracle ERP (1)
Oracle Field Service Cloud (1)
Project Deep Blue (1)
Project Management (1)
Recovery Testing (1)
SAP ECC (1)
Salesforce Lightning (1)
Scalability (1)
Scaling AI (1)
Semiconductor (1)
Serverless Cloud Architectures (1)
Service Management (1)
Smart Cities (1)
Smart Contracts (1)
Solution Showcase (1)
Tech consultant (1)
Technology (1)
Test Maturity (1)
Trends in Testing (1)
Workers Compensation (1)
analytics practice (1)
biometrics (1)
careers decomplexed (1)
cloud modernization (1)
data governance (1)
data migration (1)
data modelling (1)
data table (1)
development (1)
employee engagement (1)
employee experience (1)
financial crime (1)
higher education (1)
human resources (1)
magento (1)
oracle HCM (1)
outsystems (1)
planning and budgeting (1)
predective analytics (1)
productivity (1)
provider (1)
public safety (1)
talent acquisition (1)
testing partnership (1)
time management (1)

Posts by Topic

FAQ: Oracle Financial Consolidation & Close Cloud Service (FCCS)

Everyone in the industry is talking about EPM Cloud, yet it can be hard to break through the noise and get quick answers. If you have questions about Oracle’s Financial Consolidation and Close Cloud Service (FCCS), read on for answers to common questions we hear about FCCS.

hbspt.cta._relativeUrls=true;hbspt.cta.load(135305, '46e75ffc-7101-40d6-8e29-cb802a1e217d', {"useNewLoader":"true","region":"na1"});

Is fccs hfm in the cloud.

There are still many differences between HFM and FCCS. If you’re a current HFM user, you probably won’t be able to completely replace HFM, yet. Oracle is working to close the gaps between the two applications, with FCCS updated automatically every month.

FCCS is an out-of-the-box consolidation solution with 11 predefined system dimensions and two custom dimensions, while HFM has unlimited custom dimensions. FCCS also has standardized features, such as entity and account hierarchies, as well as calculations and reports. In FCCS, you won’t be able to create customized rule files using VB script like you would in HFM, but you can create member formulas in FCCS.

What features are included in FCCS?

FCCS customers currently get the following functionality:

Intercompany Eliminations – Includes default Intercompany Eliminations
Journals with Workflow – Includes journal capabilities with configurable workflow
Currency Translation – Default currency translation uses PVA method for Flow activities and VAL method for Balance activities
Built-in Foreign Exchange/Currency Translation Adjustment Calculations – Automatic calculation of Foreign Exchange on Opening Balance and Movements for each balance sheet account, along with automated Currency Translation Adjustment calculation
Automated Cash Flow Reporting – The movement dimension provides automated cash flow reporting through hierarchies and system calculations that require no further rules
Multi-GAAP Reporting – Prebuilt functionality includes reporting for Local GAAP and IFRS with the ability to add additional GAAPs for reporting'
Detailed Data Source Tracking – Using a dimension for tracking sources of data, including Data
Data management capabilities for integration with source systems
Workflow support for the close process
Audit controls for all activities
Reporting, monitoring, and analysis via web and Microsoft Office

How can I integrate FCCS with my existing cloud or on-premises ERP systems?

Data and metadata can be integrated into FCCS using data management capabilities within the cloud offering. This includes seamless loads of data and metadata and also capabilities to drill back to the source information.

How are upgrades and patches handled?

Each customer chooses a 1-hour window for daily system maintenance and patching. Patches are made automatically during this window, if needed. When available, upgrades are provided at the same time. Customers are provided with advance notice of an upcoming upgrade so they have time to prepare. Critical patch fixes are done on the environment as needed. Typical updates are done once a month, and software enhancements are done approximately once every quarter.

How fast can FCCS be deployed?

Going to the cloud eliminates the need for on-premises hardware, operating systems, databases, and other technology. Like the other applications available in Oracle’s suite of EPM cloud products, FCCS can be deployed in weeks versus months for on-premises applications.

What web browsers are supported by FCCS?

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

Evaluating EPM or BI technologies
Comparing on-prem vs. cloud
Planning upgrades and migrations
Estimating project costs and timeframes
And much more — ask us anything!

Let our experts tackle your toughest questions for you.

More blogs on this

SCCM Connect
Log In Log In Forgot Password? Forgot Username? New User? Sign Up Free

Forgot username? Forgot password? New User? Sign Up Free

Membership and Community
Critical Care Congress
Clinical Resources
Overview Membership and Community
Become a Member
Get Involved
Career and Leadership
Connect with SCCM Members
SCCM Apparel and Merchandise
Overview Education
Educational Programming
Airway and Mechanical Ventilation Management
Adult Critical Care Review and Assessment
Pediatric Critical Care Review and Assessment
Learning Categories
Latest Updates
Hosted Training
Accredited Education and Subject Matter Expert Resources
Overview Critical Care Congress
2025 Critical Care Congress

2024 Critical Care Congress
How to Claim ACE/MOC
Past Congress Resources
Abstracts and Case Reports
Session Proposals
Congress FAQs
Future Congress Dates
Congress Highlights
Congress Digital
Congress Literature Releases
Exhibitor, Support, and Advertising Opportunities
Overview Research
Discovery, the Critical Care Research Network
Research Grants
Research Surveys
SCCM-Weil Research Trust
Overview Clinical Resources
Quality Improvement
ICU Liberation Campaign
Sepsis Resources
Diagnostic Excellence
Choosing Wisely
Well-Being Resources
Drug Shortages
Patient Management During Outbreaks and Disasters
Patient-Centered Outcomes Research Institute Projects
Global Health
Crisis Response
Humanitarian Activities
Collaboratives
Browse the LearnICU Catalog
SCCM Resource Library
Critical Care Quick Study
Overview Become a Member
Associate Member Benefits
Professional Member Benefits
Select Member Benefits
Renew or Upgrade
Overview Get Involved
Specialty Sections
Knowledge Education Groups
Committees and Volunteer Opportunities
SCCM Social Media
Overview Career and Leadership
Career Central
American College of Critical Care Medicine
Early Career Professionals
Leadership, Empowerment, and Development
Overview Connect with SCCM Members
Overview SCCM Apparel and Merchandise
Overview Educational Programming
Critical Care Ultrasound
Critical Care Pharmacotherapy
Critical Care Echocardiography
Advanced Critical Care Ultrasound: Echocardiography Learning Lab
Neurocritical Care
Critical Care Knowledge Assessment
Virtual Critical Care Rounds
Fundamentals
Current Concepts
Overview Learning Categories
Overview Latest Updates
Overview Hosted Training
Opportunities
Hosted Training Calendar
Instructors, Directors, and Consultants
Free Critical Care Training
Overview Accredited Education and Subject Matter Expert Resources
Overview 2025 Critical Care Congress
Overview 2024 Critical Care Congress
Overview Abstracts and Case Reports
Overview Congress Highlights
Overview Congress Digital
Overview Congress Literature Releases
Overview Exhibitor, Support, and Advertising Opportunities
Overview Discovery, the Critical Care Research Network
Discovery Town Hall
Data Science Campaign
Submit a Clinical Investigator Proposal
Discovery Research Collaboratives
Discovery Resources
Clinical Investigators Meetings
Overview Journals
Critical Care Medicine Journal
Pediatric Critical Care Medicine Journal
Critical Care Explorations Journal
SCCM COVID-19 Journal Articles
Journal Audio Summaries
Overview Research Grants
Overview Research Surveys
Overview SCCM-Weil Research Trust
Overview Quality Improvement
ICU Centers of Excellence Program
Overview Global Health
Overview Collaboratives
Overview LearnICU

SCCM is performing maintenance on its websites. For the best browsing experience, please use Microsoft Edge or Safari. Those using Chrome or Firefox may experience access issues at this time.

Fundamental Critical Care Support

Prepares nonintensivists to manage critically ill patients.

I Want to Host an FCCS Course

Improve clinician knowledge and confidence.

I Want to Learn On My Own

Review management of critically ill or injured patients at your own pace.

WEATHER ALERT Coastal Flood Warning Full Story
WEATHER ALERT Coastal Flood Advisory Full Story

Report: LGBTQ content drove book banning efforts in 2023

The American Library Association released its annual list of the top 10 most targeted books of 2023 on Monday, the majority of which were challenges because of their LGBTQ content.

"Gender Queer" by Maia Kobabe topped the list for the third year in a row. The graphic memoir, which chronicles the author's experience with sexuality and gender from childhood to adulthood, was challenged for its LGBTQ content and for claims that it is sexually explicit.

"At ALA, we are fighting for the freedom to choose what you want to read," said ALA President Emily Drabinski in the announcement. "Shining a light on the harmful workings of these pressure groups is one of the actions we must take to protect our right to read."

In 2023, the ALA recorded 4,240 unique titles that have been targeted for removal or restriction in libraries and schools. It's a record-breaking 65% increase from 2022, the highest totals recorded by the ALA since it began collecting data more than 20 years ago.

Jennie Pu, ALA member and Hoboken Public Library Director, told ABC News that "this list affirms the pattern that we're seeing, that it's a small group of people who don't want their stories to be told and the retargeting of historically underrepresented and marginalized voices."

Hoboken's library system was declared a book sanctuary in 2023.

Across the country, classroom and library content has been at the center of contentious debates between educators, librarians, parents and politicians. Conservative-led legislative efforts to restrict what discussions and content could be had in classrooms regarding race, gender, sex, and sexual orientation has ignited a debate about the materials students and their families have access to.

Advocates of such legislation say these policies ensure that "inappropriate" content is weeded out of classrooms to protect children from "indoctrination," Florida Gov. Ron DeSantis and Texas Gov. Greg Abbott have said.

Politicized groups or individuals have been at the center of large swaths of book challenges nationwide, sometimes demanding the censorship of multiple titles -- often dozens or hundreds at a time. This helped drive the surge in book challenges, according to the ALA.

The other most-targeted titles, in order of the number of challenges, are:

2. "All Boys Aren't Blue," by George M. Johnson, for LGBTQ content and claims of sexually explicit content.

3. "This Book is Gay," by Juno Dawson, for LGBTQ content, sex education, and claims of sexually explicit content.

4. "The Perks of Being a Wallflower," by Stephen Chbosky, for LGBTQ content, rape, drugs, profanity and claims of sexually explicit content.

5. "Flamer," by Mike Curato, for LGBTQ content and claims of sexually explicit content.

6. "The Bluest Eye," by Toni Morrison, for themes about rape, incest, DEI content and claims of sexually explicit content.

7. "Tricks," by Ellen Hopkins, for LGBTQ content, themes concerning drugs, rape, and claims of sexually explicit content, tied with "Me and Earl and the Dying Girl," by Jesse Andrews for claims of sexually explicit content.

9. "Let's Talk About It," by Erika Moen and Matthew Nolan, for LGBTQ content, sex education, and claims of sexually explicit content.

10. "Sold," by Patricia McCormick, for claims of sexually explicit content and themes concerning rape.

The ALA compiles its data from reports filed with its Office for Intellectual Freedom by library professionals and news reports. However, the organization says the data is only a "snapshot" of book censorship attempts because it's not likely that all attempts are reported to the ALA or covered by the press.

The latest report marks the start of the organization's National Library Week.

Man dies after being stabbed, run over in Philadelphia

Despite clouds, many still manage to spot solar eclipse in Philly area

2 hours ago

More Rite Aid stores closing in our area amid bankruptcy filing

6 minutes ago

Local paramedic accused of stealing $20K in items from Home Depot

Adam Joseph describes experiencing total solar eclipse in upstate New York

Vandals seen stomping on cars, smashing windshields

Therapist weighs in on why people are drawn to the solar eclipse

Officer stabbed in face, another injured after being attacked in NJ

FCC to vote to restore net neutrality rules, reversing Trump

People look at data on their mobiles as internet wire cables on switch hub are shown in background

The Technology Roundup newsletter brings the latest news and trends straight to your inbox. Sign up here.

Reporting by David Shepardson in Washington Editing by Chris Reese and Matthew Lewis

Our Standards: The Thomson Reuters Trust Principles. , opens new tab

Ireland's Minister for Higher Education Simon Harris speaks to the media after being announced as the new leader of Fine Gael, in Athlone

Samsung Elec shares priced for $326 mln block sale, sources say

About 5.25 million shares in Samsung Electronics were priced in a block sale worth about 441 billion won ($326 million), according to two sources with knowledge of the matter on Tuesday.

The first launch of the Angara A5 space rocket from Russia's Vostochny Cosmodrome will take place on Tuesday, the state space agency Roscosmos said on Monday, in what could be a milestone for President Vladimir Putin's space ambitions.

Calls grow louder for B.C. mayor to resign over residential school book incident

First nations in b.c.'s cariboo region say they won't work with quesnel until mayor ron paull steps down.

A large crowd of people walks down a city street on their way to Quesnel city hall.

Social Sharing

There are growing calls for Quesnel Mayor Ron Paull to resign after revelations his wife has been handing out a book that, according to promotional material from its publisher, questions whether residential schools were fundamentally harmful to Indigenous communities and people who attended them.

More than 200 people marched outside city hall Tuesday evening before packing into an emotionally charged council meeting in the city of roughly 23,000 people, located in B.C.'s Cariboo region about 400 kilometres north of Vancouver.

"We can no longer work with this mayor and we will not work with the City of Quesnel until [the] issue has been resolved," said Lhtako Dene Chief Clifford Lebrun.

"We can't have a community that hands out hate literature and expect people to listen to us and to take it seriously."

Calls grow louder for Quesnel mayor to step down

The meeting also heard from the mayor's wife, Pat Morton, and one of the authors featured in the book who had travelled to Quesnel to speak to council.

The controversy is a blow to reconciliation efforts, which have been at the forefront of city business.

Council began a process of working with the Lhtako Dene in 2015, formally acknowledging them as partners on whose land the city was built. In the years since, it has taken other steps toward what it calls "true reconciliation," which include restoring ownership of a downtown park to the First Nation and being the first city to officially co-host the B.C. Winter Games with an Indigenous community earlier this year.

A crowd of people, some holding cell phones, flags, or drums, form a circle around Indigenous dancers wearing regalia, during a protest march to city hall.

But those efforts have been threatened after a March 19 meeting where council received a letter of concern from the Lhtako Dene about a book being distributed in the community by Morton.

The book, titled Grave Error: How the Media Misled Us (and the Truth about Residential Schools), by authors C.P. Champion and Tom Flanagan, contains essays that its publisher says challenge several assertions made about the harms of residential schools.

In publicity material for the book, publishers True North and Dorchester Books say statements that residential schools traumatized Indigenous people across generations and destroyed Indigenous languages and culture are either "totally false or grossly exaggerated."

Quesnel city council condemns controversial residential school book distributed by mayor's wife

It also promises to challenge the notion that Indigenous people were forced to attend residential schools and whether the residential school system can appropriately be defined as genocide.

"Whoever wrote that book, they didn't go through residential school with us," Lhtako Dene Elder Bryant Paul told council this past Tuesday, while holding an eagle feather. "[At residential school] they beat us, sexually abused us."

Residential school survivor calls for Quesnel mayor to resign

Nazko First Nation Chief Leah Stump choked back tears as she addressed the council table.

"We deserve better than having to come here to prove we went to residential school, to prove that we were hurt and broken," she said.

In 2021, the federally-appointed Truth and Reconciliation Commission of Canada released a report into the schools after six years of testimony received from more than 6,000 attendees across the country.

Residential schools, day schools, day scholars: what you need to know

It found more than 4,100 children died while attending these schools, most due to malnourishment or disease.

It also heard testimony that many of the children who attended the schools were physically, sexually or psychologically abused, ultimately characterizing the system as a "cultural genocide."

A First Nations chief in glasses and a baseball hat wears a black jacket with his band's name and the word chief embroidered on it.

The book was unanimously denounced by Paull and council at its March 19 meeting, when the council reaffirmed their relationship with the Lhtako Dene and formally accepted the findings of the Truth and Reconciliation Commission.

The rally held at city hall on April 2 was described as one in support for truth and reconciliation. Afterward, council was addressed by First Nations leaders and elders, some of whom held back tears as they described the personal impacts of residential schools.

"We have a whole room full of elders and survivors here," Chief Lebrun said during the meeting. "They could go on all night and tell you what they went through. It hurts them that much that they would relive that, just to let you know."

More people aware of residential school harms but work still needed, report finds

Lebrun said the Lhtako Dene would be stepping back from their partnerships with the city until further notice.

Morton, the mayor's wife, also stepped up to the microphone to speak.

"I'll say I'm sorry my actions sharing this book have upset you," she said. "I'm hurt I'm put in this position. I believe in love not hate."

Mayor's wife gets into heated exchange with Quesnel councillors

She asked two of the city councillors why they hadn't come to speak to her directly if they had concerns about the book, rather than bringing it up during a council meeting.

Frances Widdowson, one of the contributors to the book, also travelled to Quesnel to speak to council.

She accused the city of spreading misinformation because council had read a letter from the B.C. Assembly of First Nations into the record, which included a reference to unmarked graves at the former Kamloops Residential School.

In 2021, the Tk'emlúps te Secwépemc First Nation announced preliminary results of ground-penetrating radar work at that school, which they said showed approximately 200 potential burial sites on the grounds of the former Kamloops Indian Residential School.

Writer accuses Quesnel council of misinformation

One of the criticisms in Grave Error is that a number of early media reports referred to these sites as unmarked graves without including context that they were unconfirmed, which the authors say have helped shape a false public narrative even as work continues at Kamloops and sites across the country to confirm the preliminary findings.

"There is no evidence of unmarked graves," Widdowson told council, a statement she repeated as people in the gallery started to drown her out with drumming. "Does council support misinformation?"

In response, Coun. Laurey-Anne Roodenburg pointed out Widdowson had been fired from Mount Royal University in Calgary after espousing the benefits of residential schools.

"You really have no place here," Roodenburg told Widdowson. "We really don't want to hear from you."

Educate or prosecute? Two Anishnaabe weigh in on how to deal with residential school deniers

Roodenburg was one of three councillors, along with Scott Elliot and Tony Goulet, who formally asked Paull to resign during the meeting.

"Mr. Mayor, you have lost the trust of our First Nations, myself, and the vast majority of our community," Elliot said. "I have no choice but to ask for your official resignation, so we can repair the damage done by you and your wife."

Elliot and Goulet accused the mayor of handing out the book at a local government meeting, a charge that Paull denied, saying he had simply brought it up during a discussion of what books should or should not be available at a local library.

"I have not distributed the book," he said. "If you're going to accuse me of a lie, I'm going to fire right back at you because you lied. "

Near the end of the meeting, Paull apologized and said he wanted to make reparations, but that he would not stand down.

"I'm not a quitter," he said. "Quesnel is in my heart and I'm not about to abandon it."

"I see this whole incident as being an opportunity ... This incident has spawned a whole new desire in pursuing reconciliation," he added.

While there is no mechanism to force a mayor to resign, Quesnel council directed staff to report back with options for censure and sanctions. Paull was elected to office in 2022 after previously sitting as a councillor.

Support is available for anyone affected by their experience at residential schools or by the latest reports.

A national Indian Residential School Crisis Line has been set up to provide support for survivors and those affected. People can access emotional and crisis referral services by calling the 24-hour national crisis line: 1-866-925-4419.

Mental health counselling and crisis support is also available 24 hours a day, seven days a week through the Hope for Wellness hotline at 1-855-242-3310 or by online chat at www.hopeforwellness.ca .

Corrections

A previous version of this story stated that Frances Widdowson had been fired from Royal Roads University. In fact, she had been fired from Mount Royal University. Apr 06, 2024 9:03 AM PT

Oracle EPM Financial Consolidation and Close

WTOP Book Report: Writing for ‘The Girls’: TV trailblazer Stan Zimmerman discusses iconic career

Terik King | [email protected]

April 7, 2024, 12:56 PM

Share This:
share on facebook
share on threads
share on linkedin
share on email

Television aficionados and fans of iconic sitcoms have much to feast upon in “The Girls: From Golden to Gilmore” (Indigo River), the new memoir from renowned television writer/producer, and theater director Stan Zimmerman, whose credits include The Golden Girls, Roseanne, The Gilmore Girls and A Very Brady Sequel.

Zimmerman’s memoir delves into his multi-decade career, spotlighting the vibrant women who have played pivotal roles in his professional journey and personal life.

“I always wanted to answer the question, ‘Why me?'” said Zimmerman in an interview with the WTOP Book Report, “And how did I get to write for so many wonderful women?” The idea for the memoir, he said, had been brewing for over eight years. “I (decided to) go back to my old journals, which I’ve been keeping since college,” Zimmerman said, “And luckily I wrote a lot of my journals during each of the TV shows that I was on.”

Zimmerman said he hoped that through writing, he could decipher the reasons behind his unique connection with female characters and talents.

From Detroit to Hollywood

The memoir traces Zimmerman’s trajectory from his upbringing in a small Detroit suburb to his pursuit of a career in the entertainment industry. Reflecting on his childhood surrounded by strong, supportive women, Zimmerman remarked, “I was surrounded by three strong, intelligent women — my mother, my grandmother, and my sister — all of whom supported my imagination and creativity.”

He reminisced about his early forays into theater, noting, “Instead of playing outside, I spent time in my basement directing and acting in plays with the neighborhood kids.”

Zimmerman would enroll at NYU, where he met Jim Berg, a fellow student with whom he quickly discovered he shared a passion for television. “We would walk through the streets in New York making each other laugh,” Zimmerman said.

Recognizing their complementary talents, the duo forged a partnership that would define much of Zimmerman’s career. “We brought both of our talents together, and started writing TV scripts,” Zimmerman explained.

With their sights set on breaking into the television industry, Zimmerman and Berg embarked on the challenging task of writing unpaid examples of scripts for existing shows — an endeavor commonly known as “writing on spec.”

T hey cut their teeth, writing scripts for shows like Alice , The Facts of Life , Love, Sydney and the Fame TV series, most notably penning an episode of the classic musical series that featured a young Janet Jackson performing the title track of her 1984 album “Dream Street” under the direction of Debbie Allen. However, it was their spec script for the fledgling sitcom “Cheers” that proved to be a turning point in their careers.

Living Life Like It’s ‘Golden’

“Our Cheers script got to them and we were invited to go in and pitch episodes for a one-time writing assignment on this new show starring four older ladies that live in Miami,” said Zimmerman.

“They had us come in and pitch episodes. And they hated all of them.” That is until Zimmerman, on his way out the door, offhandedly asked the producers, “’What if Rose’s mother came to visit?’ There was a long pause, and they said, ‘Come sit back down.’”

Zimmerman’s tenure on The Golden Girls emerges as a prominent theme in his memoir, with anecdotes and reflections highlighting his interactions with the beloved cast. “Nobody at that time thought ( The Golden Girls ) would be a hit show,” said Zimmerman.

“They knew how lucky they were to be on a hit show at that age, in that climate.” In his interview with the Book Report , he shared free-association insights into his interactions with the legendary ladies: Bea Arthur (“Terrifying, but a pussycat”), Rue McClanahan (“A consummate actress”), Betty White (“Sweet, but complicated”) and Estelle Getty (“A mother and friend”).

Zimmerman’s memoir also traces his time as a writer on Roseanne , where he and Berg wrote “Don’t Ask, Don’t Tell” — commonly known as “the lesbian kiss episode” — where Barr’s character is stunned by a surprise kiss from a lesbian character played by Mariel Hemingway. “It was a huge fight to get that on commercial television, (and to prove) that it wouldn’t turn away viewers ,” said Zimmerman, “That’s what they thought would happen.”

Zimmerman said he was intimidate by the atmosphere of the writers’ room on Roseanne, and reflecting on what he would have done differently, said, “I think more than anything, because you want it to be so good … what I would have done differently on ‘Roseanne’ is just embrace my weirdness and just said whatever.”

A stroke of alliterative good fortune would come with the transition to his time on the hourlong comedy-drama The Gilmore Girls , Zimmerman found additional creative freedom in crafting stories centered around the dynamic relationships among three generations of women.

Reflecting on his time writing for the show, Zimmerman remarked, “I just loved that there was a town full of weird, quirky people to go to (for stories).”

Anchoring his glitzy, otherworldly journey is the constant voice of support of his mother, the original primary nurturer of his creativity and imagination. It is there, Zimmerman concludes, that he finds his answer why he was able to effectively write for such durable female TV characters.

“I am attracted to really smart, passionate, intelligent, verbal women, and I love being around them,” Zimmerman said. “And I always have since (I was) a young child … my grandmother, my mother, (and) my sister really created a world where they supported and encouraged my creativity.”

With each chapter brimming with anecdotes and reflections, “The Girls: From Golden to Gilmore” promises to be a poignant testament to Zimmerman’s resilience, creativity, and enduring love for the craft of storytelling.

Zimmerman said his memoir is for “anybody that loves to laugh has watched comedy television in the last 80 years. Anybody that has a mother, anybody that has struggled at a job and thought ‘I’m going to get fired’ or does get fired and (discovers) how they pick themselves up.”

Zimmerman’s memoir is set to resonate with a wide audience, from die-hard television buffs to anyone navigating the complexities of life and career. “It’s not just my life in show business but just survival skills,” said Zimmerman. “You know, ups and downs, picking yourself up and keep going and rediscovering and keeping life interesting every day, no matter what age you are.”

“The Girls: From Golden to Gilmore” invites readers to embark on a nostalgic, insightful and laughter-filled journey through the annals of television history.

Get breaking news and daily headlines delivered to your email inbox by signing up here .

Terik King is an Associate Producer for WTOP. Before joining WTOP in 2022 he held roles producing podcasts, unscripted television and content for MTV, the NFL and independent documentary production companies.

Related News

WTOP Book Report: MSNBC’s Joy Reid tells WTOP the love story of Civil Rights leaders ‘Medgar & Myrlie’

WTOP Book Report: ‘Diva’ retells turbulent life of Maria Callas, aims to set record straight about legendary opera star

WTOP Book Report: ‘The MAGA Diaries’ dives deep into conservative movement ideology

Recommended.

Fiery dump truck crash on Beltway in Maryland sends 2 children, several others to hospital

How Colgan High is using music to prepare students for life after graduation

PHOTOS: Relive eclipse mania and hear how WTOP covered it live

Related categories:.

We've detected unusual activity from your computer network

To continue, please click the box below to let us know you're not a robot.

Why did this happen?

Please make sure your browser supports JavaScript and cookies and that you are not blocking them from loading. For more information you can review our Terms of Service and Cookie Policy .

For inquiries related to this message please contact our support team and provide the reference ID below.

Moscow Sky Lights Up With Strange Glow After Explosion at Electrical Substation: Reports

N ew footage has emerged showing bright flashes lighting up the night sky in southern Moscow during the early morning hours of November 22.

Knewz.com has learned that there was an explosion at an electrical substation on the outskirts of Russia's capital city followed by an alleged power outage in "several" homes.

Video snippets, shared on Russian news channels like ASTRA , captured a series of flashes that caused the sky to change color. Smoke could also be seen rising from a building.

Corroborating the video, several Russian Telegram accounts reported an explosion near the south of Moscow and a subsequent fire at the Lyublino electrical substation, southeast of central Moscow, per Newsweek .

The local authorities from the area have since confirmed that an explosion occurred in the village of Molokovo, but they reassured the public that all vital facilities were operating as normal.

Russian outlet MSK1.ru reported the blaze at the substation and noted “several” power outages.

The town of Lytkarino, located to the southeast of Moscow, was one of the affected areas, as reported by the independent outlet, Meduza .

Additional power failures were reported in the southern Domodedovo section of the city. However, electricity was later restored to these areas.

One local resident speculated that a drone may have been responsible for the explosion, but additional sources are yet to support this theory.

Newsweek reported that messages on the ASTRA Telegram account run by independent Russian journalists showed residents near the substation panicking. One concerned Russian called it a "nightmare."

The incident follows an attack by Russia on a power station in southwestern Ukraine that left 2,000 people without electricity .

Knewz.com reported previously:

“ Russian forces launched a total of 38 Iranian-made Shahed-136/131 drones during the later hours of November 17 and 18.

The Ukrainian Air Force Command reported that 29 of these drones were shot down [...].

One civilian was injured as a result of the attack that targeted energy infrastructure in the southwestern Odesa Oblast.”

The assault came after repeated warnings by Ukraine’s President Volodymyr Zelensky that Russia would try to cripple its power grid as winter approaches.

Ukraine's leader warned that if Russia resorted to attacking its power utilities, it would respond in kind.

Ukraine has conducted numerous long-range aerial drone strikes on Moscow since May 2023.

Most recently on November 20, it was reported that one such incursion was intercepted close to the city, per Kyiv Post .

Moscow’s Mayor Sergei Sobyanin confirmed this and elaborated that the region's air defense systems intercepted the unmanned craft over the city of Elektrostal to the east of Moscow, as well as another over the Bogorodsky district, northeast of central Moscow.

The details of the recently surfaced video footage have yet to be independently verified.

The Moscow skyline lit up on November 22 causing panic. By: Meduza

IMAGES

Fundamental Critical Care Support Courses
professional book report outline template example in 2021
The Report Card
FCC Record, Volume 23, No. 19, Pages 15223 to 16004, October 20
Oracle FCCS Balance Sheet Report
College Book Report Template (8)

VIDEO

#DDU-GKY #Brainwareskill West Bengal student making video and output
Maths Methods VCAA Exam 2 (Multi Choice) 2012
1979 vintage bullet
Part-2. Reactions of Alkenes
TENRA BANSHO ZERO
Episode 310: Duking It Out

COMMENTS

Working with the Reports Solution
Reports also includes books and bursting. Books provide the ability to group together one or more reports, books, and other documents, to generate a single PDF output. The bursting feature enables you to run a single report or book for more than one member of a single dimension for one data source, and publish a PDF output for each member.
Creating Consolidation Journal Reports
Click Consolidation Journal Reports. Click Create. From the Point of View, select the Scenario, Year, Period, Consolidation, and View members for the report. For Period, you can select one or more periods from the same year, or across years. If you select multiple year and period combinations, the system will generate the report for the ...
PDF Oracle Financial Consolidation and Close Cloud
Financial Consolidation and Close is an end-to-end close process that not only provides a world-class consolidation solution, but also provides a solution to manage and monitor the entire close process. The solution includes the following features and functionality: Application Creation Wizard - This streamlines the creation and ...
Oracle Financial Consolidation and Close Cloud 2018
Even if you launch a report directly and bypass the POV member selector window, when the report is displayed, you can still change the members in the POV by clicking a link in the POV and selecting different members. Key Resources. Opening Reports in Working with Oracle Financial Consolidation and Close Cloud; Reopening Locked Schedules
Oracle FCCS Balance Sheet Report
This video tutorial is created in order to demonstration how Financial reports can be built on top of FCCS. In this case we have shown complete financial rep...
Oracle Financial Consolidation & Close Service (FCCS) Guide
Oracle FCCS also lets you view and download dynamic reports that can retrieve data from any subsidiary. Mastek's Oracle FCCS Implementation Approach Oracle FCCS is the end-to-end consolidation and close solution you have always been looking for and Mastek can help you implement it in as little as 10-12 weeks depending on your requirement.
FAQ: Oracle Financial Consolidation & Close Cloud Service (FCCS)
Oracle is working to close the gaps between the two applications, with FCCS updated automatically every month. FCCS is an out-of-the-box consolidation solution with 11 predefined system dimensions and two custom dimensions, while HFM has unlimited custom dimensions. FCCS also has standardized features, such as entity and account hierarchies, as ...
How To Generate A Report In Financial Consolidation & Close Cloud
How To Generate A Report In Financial Consolidation & Close Cloud Service (FCCS) To Show User Provisioning Changes (Doc ID 2466476.1) Last updated on DECEMBER 28, 2023. Applies to: Oracle Financial Consolidation and Close Cloud Service - Version N/A to N/A [Release 11.1] Information in this document applies to any platform. Goal
Fundamental Critical Care Support Courses
Fundamental Critical Care Support (FCCS) - 7th Edition eBook. Fundamental Critical Care Support (FCCS) is designed to build and reinforce the skills needed by healthcare professionals to identify, assess, and manage critically ill or injured patients for the first 24 hours or until appropriate critical care consultation can be arranged.
Fundamental Critical Care Support Courses
The Fundamental Critical Care Support (FCCS) course provides healthcare professionals, including nonintensivists, with the training to manage critically ill patients for the first 24 hours or until appropriate critical care consultation can be arranged. The course concentrates on adult critical care but also includes separate sections on ...
Guides
To promote competition and consumer choice, the FCC... Filing an Informal Complaint. Mar 28, 2024. ... 911 Fee Report/9-1-1 Fee Report. Communications Marketplace Report. Broadband Progress Reports. Budget Report. Cable Industry Prices Report. Cross Border Interoperability Report.
Child Abuse & Neglect
Child Abuse & Neglect. To make a report of child abuse or neglect in Franklin County, Ohio: Call the 24-Hour Child Abuse Hotline at (614) 229-7000. Visit the offices of Intake, Assessment, and Investigations at: 4071 E. Main Street. Whitehall, OH 43213. Child abuse affects more than three million children annually and causes the deaths of three ...
April 2024 Open Meeting Agenda
Here's everything we have lined up for our April Open Meeting. We're promoting a fast, open, and fair internet. Net neutrality preserves internet openness by prohibiting internet providers from blocking, throttling, or prioritizing lawful content. The Commission will vote on rules to restore the FCC's overwhelmingly popular net neutrality ...
Report: LGBTQ content drove book banning efforts in 2023
According to the American Library Association, LGBTQ content drove book-banning efforts in 2023. "Gender Queer," by Maia Kobabe topped the list for the third year.
Agtech Public Comp Sheet and Valuation Guide
April 8, 2024. Fill out the form to download a preview of this report. The full report is available through the PitchBook Platform. Tracking public comparables for agtech. Our Q1 2024 Agtech Public Comp Sheet and Valuation Guide tracks stock performance, valuations, and market caps for key publicly traded companies. Table of contents.
PitchBook-NVCA Venture Monitor First Look
PitchBook-NVCA Venture Monitor First Look. April 2, 2024. Venture still waiting for its revival. Two large tech IPOs are already out the door, and two more, Ibotta and Rubrik, have dropped their S-1 filings in an encouraging sign for 2024 venture exit activity. On the dealmaking side, valuations ticked back up in Q1, driven in part by the ...
No heat in Elektrostal city of Moscow region since middile December
Ukrainian military had 64 combat engagements with Russian forces near Synkivka of Kharkiv region, south to Terny and Vesele of Donetsk region, Klischiyivka and Andriyivka of Donetsk region, near Novobakhmutivka, Avdiyivka, Syeverne, Pervomayske and Nevelske of Donetsk region, Heorhiyivka, Pobyeda and Novomykhaylivka of Donetsk region, Staromayorske of Donetsk region, at the east bank of Dnipro ...
FCC to vote to restore net neutrality rules, reversing Trump
The U.S. Federal Communications Commission will vote to reinstate landmark net neutrality rules and assume new regulatory oversight of broadband internet that was rescinded under former President ...
One of world's earliest known books expected to fetch more than $2.6m
One of the world's oldest books is going up for auction. Christie's Images LTD. 2024. CNN —. One of the earliest books in existence is expected to fetch upwards of $2.6m when it goes up for ...
Calls grow louder for B.C. mayor to resign over residential school book
5:12. Pat Morton, who is married to the mayor of Quesnel, B.C., exchanged tense words with city councillors who are calling for her husband's resignation. The calls come after revelations Morton ...
Oracle EPM Financial Consolidation and Close
User. Working with Financial Consolidation and Close. Working with Financial Reporting for Oracle Enterprise Performance Management Cloud. Working with Oracle Smart View for Office (Mac and Browser) Working with Oracle Smart View for Office 22.100. Working with Oracle Smart View for Office 23.100. Working with Oracle Smart View for Office 23.200.
LLC "TFN" Company Profile
Other Miscellaneous Retailers Other Miscellaneous Manufacturing Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers Retail Trade. Printer Friendly View ... Get a D&B credit report on this company . Get a D&B credit report on this company . Stay on top of your Business Credit File.
WTOP Book Report: Writing for 'The Girls': TV trailblazer Stan
In his interview with the Book Report, he shared free-association insights into his interactions with the legendary ladies: Bea Arthur ("Terrifying, but a pussycat"), Rue McClanahan ("A ...
Spotify (SPOT) to Raise Prices, Introduce New Plans for Books and Music
It will raise prices in the US, its largest territory, later this year, said the people, who asked not to be identified discussing confidential plans. Spotify shares jumped 4.6% to $281.92 at 9:35 ...
Moscow Sky Lights Up With Strange Glow After Explosion at ...
New footage has emerged showing bright flashes lighting up the night sky in southern Moscow during the early morning hours of November 22. Knewz.com has learned that there was an explosion at an ...
Report: Snapdragon X Elite beats MacBook performance
Sources speaking to The Verge claim that Microsoft is preparing demos of Snapdragon X Elite that show the Windows chip beating the Apple M3 in the latest generation of MacBook Air when it comes to ...

Digital Engineering & Experience

Oracle Cloud & Enterprise Apps

Mastek Blog

Key C hallenges Companies Face with Their Financial Consolidation and Close Cycles

The Solution - Oracle Financial Consolidation and Close Cloud Service (FCCS)

Oracle FCCS Process Flow

Mastek’s Oracle FCCS Implementation Approach

Written by Mohammed Umar

Subscribe to Email Updates

Posts by Topic

FAQ: Oracle Financial Consolidation & Close Cloud Service (FCCS)

hbspt.cta._relativeUrls=true;hbspt.cta.load(135305, '46e75ffc-7101-40d6-8e29-cb802a1e217d', {"useNewLoader":"true","region":"na1"});

What features are included in FCCS?

How can I integrate FCCS with my existing cloud or on-premises ERP systems?

How are upgrades and patches handled?

How fast can FCCS be deployed?

What web browsers are supported by FCCS?

Ask an EPM/BI Advisor

More blogs on this

Fundamental Critical Care Support

I Want to Host an FCCS Course

I Want to Learn On My Own

Report: LGBTQ content drove book banning efforts in 2023

Related Topics

Man dies after being stabbed, run over in Philadelphia

Despite clouds, many still manage to spot solar eclipse in Philly area

More Rite Aid stores closing in our area amid bankruptcy filing

Local paramedic accused of stealing $20K in items from Home Depot

Adam Joseph describes experiencing total solar eclipse in upstate New York

FCC to vote to restore net neutrality rules, reversing Trump

Samsung Elec shares priced for $326 mln block sale, sources say

Calls grow louder for B.C. mayor to resign over residential school book incident

Social Sharing

Calls grow louder for Quesnel mayor to step down

Residential school survivor calls for Quesnel mayor to resign

Mayor's wife gets into heated exchange with Quesnel councillors

Writer accuses Quesnel council of misinformation

Corrections

Related Stories

Oracle EPM Financial Consolidation and Close

WTOP Book Report: Writing for ‘The Girls’: TV trailblazer Stan Zimmerman discusses iconic career

From Detroit to Hollywood

Living Life Like It’s ‘Golden’

Related News

WTOP Book Report: MSNBC’s Joy Reid tells WTOP the love story of Civil Rights leaders ‘Medgar & Myrlie’

WTOP Book Report: ‘Diva’ retells turbulent life of Maria Callas, aims to set record straight about legendary opera star

WTOP Book Report: ‘The MAGA Diaries’ dives deep into conservative movement ideology

Fiery dump truck crash on Beltway in Maryland sends 2 children, several others to hospital

How Colgan High is using music to prepare students for life after graduation

PHOTOS: Relive eclipse mania and hear how WTOP covered it live

We've detected unusual activity from your computer network

Why did this happen?

Moscow Sky Lights Up With Strange Glow After Explosion at Electrical Substation: Reports

IMAGES

VIDEO

COMMENTS