Liberate your data

Intelligence is all about knowledge. This website is dedicated sharing expertise on Oracle BI. More ยป


Advisor Webcast: What’s New in Financial Reporting

The following Advisor Webcast is now scheduled for September 6, 2018....Don't forget to register!!

What's New in Financial Reporting


Thursday , September 06, 2018 08:00 AM (US Pacific Time)
Thursday , September 06, 2018 11:00 AM (US Eastern Time)
Thursday , September 06, 2018 05:00 PM (Central European Time)
Thursday , September 06, 2018 08:30 PM (India Standard Time)



  • This one-hour advisor webcast is recommended for technical users, functional users, system administrators, Database Administrators, etc. who administer reporting analysis and financial reporting and those who monitor and patch the associated Financial Reporting servers.

Topics Include:

  • Changes in Financial Reporting
  • How these changes affect the Financial Reporting module
  • What's happened to the RAF module?
  • What's different in FR vs.
  • How would these changes affect somebody monitoring/administering the FR server?
  • Any prerequisites that need to be adhered to prior to implementing


For Additional Information and Registration Details:

Financial Consolidation Cloud Service (FCCS) – Consolidation Performance and Failure Diagnosis

How to self diagnose consolidation failures and performance issues in Financial Consolidation Cloud Service (FCCS)? Thank you to the following people for the presentation on this topic.

Prasad Tungaturthy, Director, EPM
Shailesh Kumar, Senior Director, EPM
Vinay Gupta, Consulting Member of Technical Staff

Below are the causes of Consolidation Performance and Functional Issues:

1. Bad application design:

2. Unnecessary calculations:

  • The consolidation process and steps are clearly documented in FCCS.
  • By default, FCCS performs many calculations during the consolidation process that may not be needed for the customer.
  • Turning some of these calculations off could improve performance:
    • Balance Sheet Calculation - If the Balance Sheet is out of balance, a balancing amount is calculated and posted to a seeded account called "Balance". This is a predefined miscellaneous liability account which is used solely for the purpose of keeping the Balance Sheet balanced. You have the option to disable this calculation if you do not want the system to automatically balance the Balance Sheet for you.
    • Ratios Calculations - Disabling the Ratios Calculations will also give a boost in performance. You cannot disable Ratios on an existing app; therefore, the app will have to be recreated with Ratios unchecked when specifying the creation application options.

3. Poorly written configurations/extensions:

  • The default consolidation logic can be extended by the customer or partner.
  • The customer specific logic is inserted as part of the overall consolidation process and can be written as:
    • Member formulas
    • Calculation logic
    • Translation/consolidation overrides
  • Poorly written logic in these extensions/configurations can severely cause performance degradation

4. Lack of needed house keeping:

  • Clearing Empty Blocks - Keeping the Essbase engine tuned by removing unnecessary data blocks and ensuring the structure is efficiently stored is important for optimal consolidation performance.
  • Dense restructure
  • Doing the necessary house keeping can improve consolidation performance.

5. Software bug/issue:

6. Consolidation Functional Issues:

  • After performing step 1-5 and making the necessary corrections, the consolidation performance may have improved but you may still see some functional issues. Check the Presentation for more information.



Whitepaper – Integrating between Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) …

  The following My Oracle Support Knowledge Article is available:

Whitepaper - Integrating between Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) and Oracle Project Portfolio Management Cloud (PPM Cloud)

(Doc ID 2407735.1)

To assist in locating an article of interest for future reference, consider adding a bookmark.

        To Bookmark - click on the star to the left of the title.

Once bookmarked the star will become yellow, and the article can be quickly accessed from the "Favorites" drop down menu.

Can Enterprise Performance Management (EPM) Cloud Customers Integrate with Oracle Analytics …

For information in integrating EPM Cloud with OAC, check out the following links:

EPM Patch Set Updates – July 2018

The following are the Enterprise Performance Management (EPM) Patch Set Updates (PSU) released last month (July 2018).

The "Patch" ID links will access the patch directly for download from "My Oracle Support" (login required).

Hyperion Product Patch Link Hyperion Essbase Patch Set Update is Available View


Oracle Smart View for Office Patch Link None this month View



  • Some patches listed may have been released a few days outside of the stated month.
  • Be sure to review the related Readme files available per Patch Set Update.
  • For the latest Enterprise Performance Management Patch Set Updates visit Oracle Hyperion EPM Products [ Doc ID 1400559.1 ]

To view the patches released over previous months visit the earlier Blog posts: