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 Q2 2018 Oracle FCCS Updates.
Oracle Cloud Product Announcements
ADDITIONAL CHARTS IN ACTIVITY REPORT
The Activity Report has been enhanced to include the following charts that help you understand the processing load in your environment. These additional charts include:
- Number of user interface requests by hour
- Duration of user interface requests by hour
- Number of Essbase operations by hour
- Duration of Essbase operations by hour
- CPU usage
- Memory usage
MIGRATION AND AUDIT CARDS MOVED TO TOOLS CLUSTER
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.
SUPPORT FOR INFOLETS
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.
SUPPORT FOR SUBTITLES IN INFOLETS
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.
NEW FINANCIAL REPORTING EXPLORE REPOSITORY
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.
NEW ROW AND COLUMN SUPPRESSION BEHAVIOR
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.
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.
EXPORTING OWNERSHIP MANAGEMENT INFORMATION
You can now import and export Ownership Management information.
NEW SEEDED MEMBER IN OTHER COMPREHENSIVE INCOME HIERARCHY
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).
SUPPORT FOR CUSTOM AUTOMATED AND EVENT MONITORING INTEGRATIONS
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.
SUPPORT FOR XLSX FORMAT IN CLOSE MANAGER AND SUPPLEMENTAL DATA MANAGER REPORTS
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.
SEEDED SYSTEM CONSOLIDATION RULE-SETS
This update provides nine system rule-sets for Ownership Elimination adjustments. The seeded rules are created by the application. 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)
NEW EPM AUTOMATE UTILITY VERSION
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.
MICROSOFT EXCEL VERSION USAGE IN ACTIVITY REPORT
The Activity Report has been enhanced to include the Microsoft Excel Versions in use and the number of users who use them.
RETAIN LAST ACCESSED TAB IN NAVIGATION FLOW CARDS
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.
ENHANCEMENTS TO DASHBOARDS
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.
ORACLE ACCOUNT RECONCILIATION CLOUD CLUSTERS AND CARDS AS NAVIGATION FLOWS TARGETS
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.
POWER USERS CAN LOCK AND UNLOCK DATA
Starting with this update, power user can lock and unlock data.
REFERENTIAL INTEGRITY FOR CONFIGURABLE CONSOLIDATION RULES
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.
NEW VERSION OF ORACLE SMART VIEW FOR OFFICE
Oracle Smart View for Office 188.8.131.52.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
UPDATES TO SNAPSHOT RETENTION POLICY
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.
FORMS LISTING AS A HIERARCHY IN NAVIGATION FLOWS ARTIFACT LIBRARY
Forms listed within the artifact library in Navigation Flows are now displayed in a hierarchical manner.
MORE INTUITIVE POV BAR IN DASHBOARDS
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.
SPECIFY A MAXIMUM EMAIL ATTACHMENT SIZE WHEN SCHEDULING BATCHES
In Financial Reporting, you can now specify a Maximum Email Attachment Size so that you can email more books using the Batch Scheduler.
REMOVE TIME STAMP FROM FILE NAME WHEN BURSTING BATCH REPORTS
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.
Click here for Q2 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.