Welcome to the Strafford Blog

Welcome to the Strafford Blog

Oracle FCCS – What’s New: Quarterly Recap

Posted by Pam Gazley

Mar 27, 2018 11:57:33 AM

Oracle Cloud Product Announcements

We are committed to keeping our Oracle clients updated on Oracle Cloud product features and enhancements. In case you missed it, here's a recap of the Q1 2018 Oracle FCCS product announcements.

Oracle Cloud Product Announcements

January 2018

  • Validating Metadata Option
    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”.

  • Restructure Cube Job
    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.

  • Relocate EPM Cloud Environments from One Identity Domain to Another
    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.

  • EPM Getting Started Guides
    Starting with the December update (17.12), Service Administrator and end user “getting started” information for all EPM Cloud Services is available from new guides.

  • Removal of Support
    • Classic Dimension Editor
    • File-Based Integration of Data Management with Oracle Fusion Financials Cloud

Resources and Full Details >

February 2018

  • Support for Auto-Reversing Journals
    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.

  • Journal Attachments
    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.

  • Enabling the Balance Calculation
    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.

  • Exporting Tasks From Close Manager Task Lists to Excel
    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.

  • Selectable Parameters for EPM Integrations
    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.

  • Integration Tasks for Uploading and Downloading Files Within EPM
    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.

  • New EPM Automate Utility Version
    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.

  • Application-Level Provisioning for Data Management
    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. The roles: 1) Create Integration, 2) Run Integration, 3) Drill Through

  • Removal of Support
    • Classic Dimension Editor
    • File-Based Integration of Data Management with Oracle Fusion Financials Cloud

Resources and Full Details >

March 2018

  • Supplemental Data Manager Multi-Cube Support
    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.

  • Reporting Translation Process
    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.

  • Provisioned Users Audit Report
    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.

  • New Server Setting in Financial Reporting Web Studio
    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.

  • Smart View Support for Integrated Business Process Navigation Flows
    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.

  • ClearEmptyBlock Rule
    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.

  • FX Calculations in Other Comprehensive Income Hierarchy
    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.

  • Removal of Support
    • Classic Dimension Editor
    • Financial Reporting Studio Desktop Client
    • Financial Reporting Studio Desktop Client

Resources and Full Details >

Click here for Q1 2018 Oracle PBCS Quarterly Update.

FAST. RELIABLE. SUPPORTED. Can you say that about your existing EPM environment? Contact us to see how Strafford can help you improve your budgeting, planning, consolidation and reporting processes.

Topics: Consolidation and Close, Financial Reporting, Oracle FCCS, Oracle Products