us-analytics.png
Ask an Expert

FCCS Updates (July 2017): New Features in Navigation Flows, Exchange Rate Account Aliases, and More

Next week, Oracle will update Financial Close and Consolidation Cloud Service (FCCS). In this blog post, we’ll outline changes, new functionality, and fixed defects for July.

Every time a cloud update comes up for FCCS, or any other Oracle EPM cloud products, we’ll update it here on the US-Analytics Oracle EPM & BI Blog.

The monthly update for Oracle FCCS will occur on Friday, July 21 during your normal daily maintenance window.

 White Paper: Modernize Your Financial Close Process


Updated Provisioning Reports

The Provisioning Report has been redesigned to include the number of unique users provisioned with Oracle EPM Services roles. The report now identifies the total number of provisioned users.

Ability to Add Existing Cards, Clusters, Tabs, and Sub Tabs to Navigation Flows

While creating or editing your navigation flows, you can add existing cards, clusters, tabs, and sub tabs. To search for and add existing cards, clusters, tabs, and sub tabs, launch the Navigation Flow Designer (click Tools, and then click Navigation Flow). Create a new navigation flow or open an existing navigation flow to edit it. Click Add Existing Card/Cluster, and navigate to the card or cluster you want to add. Existing tabs and sub tabs can be selected for tabular cards by clicking the Add Existing Tab or Add Existing Sub Tabs option.

Member Name May Contain Comma

In this update, Data Management now supports member names with commas when loading data to FCCS.

Export a Grid Design in Financial Reporting Web Studio to Excel

Starting in this update, you can export a report's grid design information as it appears while viewing the grid in Financial Reporting Web Studio to Excel.

New Seeded Closing Balance Input Movement Member

A new seeded Closing Balance Input hierarchy has been added to the Movement dimension that allows the loading of a closing balance. New members include the FCCS_ClosingBalance_Input base member and the FCCS_ClosingBalance_Variance parent member.

Ability to Create New Data Source Members Outside of Total Data Source

You can add new Data Source member hierarchies as siblings to the Total Data Source hierarchies.

Copy/Clear Data

You can copy data from a source POV to a destination POV. You can also clear data for selected entities from a specific Scenario, Year and period or range of periods.

Ability to Customize Evaluation Order for Dimensions

You can customize the Evaluation Order for dimensions. This enables you to specify which data type prevails when a data intersection has conflicting data types.

Note: To modify the dimension Evaluation Order, do not use the Dimension Editor under the Navigator menu. You must modify the Evaluation Order only from the Application > Overview > Dimensions tab.

Exchange Rate Account Aliases

The aliases of the seeded exchange rate Account members have changed as follows:

Old Aliases  New Aliases
Ending Rate Ending Rate Input
Average Rate Average Rate Input

File-based Integration of Data Management with Oracle Fusions Financials Cloud

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

This enhancement brings the integration of Oracle Fusion Financials Cloud with Oracle EPM Cloud on par with the current, out of the box, file-based integration. As a result, the file-based integration will be phased out starting the September update to the service.

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

Fixed Defects

Defect Number

Description

25299040

 

You can now set an Evaluation Order for dimensions to specify which data type prevails in a data intersection with conflicting data types.

26288057

 

Financial Reporting Web Studio now allows negative indentation.

26222333

 

You no longer receive an error in Financial Reporting Web Studio when adding a second prompt using the same dimension but a different member.

26150043

 

When you use the batch scheduler to schedule a reporting batch to run and export to an external folder, you no longer get an error.

26120854

 

When you delete an application and then load another application, Financial Reporting reports are now displayed correctly in the Reports section of the application.

26086369

 

In a Chrome browser with the User POV set to "on", PDF and HTML preview now work correctly.

25408121

 

You are now able to copy members from one cell to another in Financial Reporting Web Studio.

 

25985836

 

You can now copy and paste an entire report containing a formula from Financial Reporting Web Studio into Excel.

26102309

 

If the Prompt for POVcheck box is enabled, when you change the POV member in a report by typing the member name in the POV pop-up (instead of selecting it), the newly-selected member and the report now display correctly.

 

25962540

 

Secondary hierarchy alias member names are retrieved as expected when the alias member names are the same as the primary hierarchy member names.

25877036

 

In a form with a custom attribute assigned to members on the row, attributes that are set to not display on the form now correctly do not display.

25716465

When the Time Zone is set to Japanese (JT), weekly-recurring jobs that are scheduled in the Job Console to run on a different date/time than the server date/time are now correctly launched.

25124701

 

When the Time Zone is set to Japanese (JT), the Job Console now correctly displays job information in the Japanese time zone instead of the UTC time zone (Coordinated Universal Time).

 


Considerations

Adding New Data Source Hierarchy and Consolidation

Starting with this update, Financial Consolidation and Close Cloud provides the ability to create Data Source hierarchies outside of Total Data Source. After consolidation, data might not be displayed or aggregated to parent entities for these new data source members that are outside Total Data Source. However, you can create dynamic calc data source members with member formulas that are based on Data Source members in Total Data Source.

FCCS Amount Override and Rate Override Accounts

If your application does not have any historical accounts defined, there will be no shared members under the seeded FCCS_Amount Override and FCCS_Rate_Override Accounts, which results in errors when refreshing the database.

A workaround is to add placeholder accounts. Under FCCS_Balance Sheet add FCCS_AmountOverride_Placeholder_Account and/or add FCCS_RateOverride_Placeholder_Account. Assign the exchange rate of Historical Amount Override for FCCS_AmountOverride Placeholder Account and Historical Rate Override for FCCS_RateOverride Placeholder Account.

Copying Supplemental Detail Data

When you copy Supplemental Detail during the Copy Data process, you cannot select a Data Source member for the Target destination that was already selected as a Source member.

Editing Dates in a Data Collection Period

In a Data Collection Period in Supplemental Data, editing Start, End, and Close Dates may result in an error that the date is outside the valid range.

Entity Member Names/Aliases with ICP Property

When you create an Entity with the ICP property enabled, the maximum length of the member name is 76 characters instead of 80, to allow for the ICP suffix.

Working with Metadata

Be aware of the following considerations:

  • You should not make metadata changes that result in the following:
    • Changing a base member to which a journal has been posted into a parent member
    • Deleting a member

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

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

Users are Unable to Access Folders and Reports

Because of some security changes made to Financial Reporting objects introduced in the 17.04 update, users who are granted the User predefined role in the service are no longer able to access Financial Reporting folders and reports.


White Paper: Modernize Your Financial Close Process