Narrative Reporting
What's New
  1. June 2019 Update
  1. Revision History
  2. Oracle Narrative Reporting, June Update
        1. Monthly Update Schedule
        2. Please Join Oracle Cloud Customer Connect
        3. Give Us Documentation Feedback
        4. Follow Us on Social Media
        5. New Videos and Tutorials
    1. Announcements
        1. Oracle Enterprise Performance Reporting Cloud is Now Narrative Reporting
        2. New Oracle Enterprise Performance Management Cloud Services
        3. New EPM Cloud URL
        4. New Connection Type and Advanced Options for External Connections
        5. Connections Interface Updates
        6. Working with Butterfly Report Format
        7. Report Package – Publish to Library
        8. Removal of Support for Transport Layer Security Protocol 1.0 and 1.1
        9. TLS 1.2 Support for Outbound EPM Cloud Emails
    2. Upcoming Changes
        1. Removal of Instance Name from Predefined Role Names
    3. Defects Fixed
    4. Considerations
        1. Access Control
        2. Management Reporting
        3. Report Packages
        4. Disclosure Management
        5. Smart View
        6. Only for Smart View for Office with Microsoft Office 365 ProPlus

June 2019 Update

Revision History

Date Feature Notes
30 MAY 2019   Created initial document.

Oracle Narrative Reporting, June Update

This document outlines the upcoming Oracle Narrative Reporting update.

Monthly Update Schedule

Oracle will apply the latest monthly updates to your Test environments during the first daily maintenance that occurs at or after 22:00 UTC (15:00 PDT) on Friday, June 7,  2019. Oracle will apply the latest monthly updates to your Production environments during the first daily maintenance that occurs at or after 22:00 UTC (15:00 PDT) on Friday, June 21,  2019.

The Oracle Help Center provides access to updated documentation. The updates will be available in the Help Center on Friday, June 7,  2019. Some of the links to new feature documentation included in this readiness document will not work until after the Oracle Help Center update is complete.

NOTE: 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 Join Oracle Cloud Customer Connect

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

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.

Give Us Documentation Feedback

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 EPMdoc_ww@oracle.com. 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.

Follow Us on Social Media

For the latest updates and information about EPM Cloud, follow us on YouTube, Twitter, Facebook, and LinkedIn at Hyperion EPM Info.

New Videos and Tutorials

New Videos:

This video shows the highlights of Narrative Reporting in EPM Cloud.

In this video, you learn how a report administrator creates a note template, inserts it into a report, and defines the POV, initial text and formatting.

In this video, you learn how a user with the appropriate permissions selects a POV in a report, runs the report in HTML, and enters formatted text to create a note.

  • Learning Paths - By viewing these learning path links, you can get complete hands-on example of how to design and view reports in Management Reporting. Learning Paths are now available on the Oracle Enterprise Performance Reporting Cloud Help Center.

Announcements

Oracle Enterprise Performance Reporting Cloud is Now Narrative Reporting

Product Name changes are introduced in 19.06 as part of a new approach to structuring Oracle Enterprise Performance Management Cloud business processes.

The new Oracle Enterprise Performance Management Cloud provides end-to-end business processes to meet the requirements of most organizations and ensure a connected and agile experience across multiple business processes.

Starting in 19.06, Oracle Enterprise Performance Reporting Cloud is referred to as the Narrative Reporting business process. The functionality is unchanged. Narrative Reporting continues to provide a secure, process-driven approach for defining, authoring, reviewing and publishing financial and management report packages.

NOTE: In Oracle Help Center, most of the documents may contain images that are referring to Enterprise Performance Reporting but going forward we will be replacing new images with Narrative Reporting text in it.

In Oracle Smart View for Office, you will see these changes:

  • Starting in 19.06, the extension is named “Narrative Reporting.” After installing the extension, you will see Narrative Reporting listed in the Extensions dialog.
  • The Performance Reporting and Performance Reporting Ad Hoc ribbons are now named Narrative Reporting and Narrative Reporting Ad Hoc, respectively.
  • Dialogs and other interface elements that referred to the Enterprise Performance Reporting will now refer to Narrative Reporting.

NOTE: You must download and install the extension update in order to the see the product name changes.

For additional information about new changes to Oracle Enterprise Performance Management Cloud details, you can refer to the New EPM Cloud Services chapter in Getting Started guide with Oracle Enterprise Performance Management Cloud for Administrators.

Key Resources

  • New EPM Cloud Services in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

New Oracle Enterprise Performance Management Cloud Services

Oracle has introduced two new Oracle Enterprise Performance Management Cloud services: Oracle Enterprise Performance Management Standard Cloud Service and Oracle Enterprise Performance Management Enterprise Cloud Service. Changes introduced with the new services mainly affect new customers only; current customers will continue using their existing, familiar EPM Cloud environments. Going forward, the two new EPM Cloud Services will replace the existing EPM Cloud Service offerings for new purchases. The Business Processes and features available to you depend on the specific EPM Cloud service that you purchase. Users will notice some changes to certain naming and terminology used in documentation, videos and other collateral as we adopt the new Cloud Services (Standard and Enterprise).

For additional information and details, please refer to the "New EPM Cloud Services" chapter in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Key Resources

  • New EPM Cloud Services in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

New EPM Cloud URL

Starting with this release, all EPM Cloud Service instances will use URLs epmcloud as the context for accessing environments. Existing users may continue using the current URLs to access EPM Cloud environments or update then with this new application context. For example, if the current URL is https://example-idDomaineprcs.dom1.oraclecloud.com/epm, you can update the URL to https://example-idDomaineprcs.dom1.oraclecloud.com/epmcloud.

New Connection Type and Advanced Options for External Connections

Service Administrators can now create connections to external Web services and specify optional query or header parameters while defining external connections. These connections can be referenced or used in a Groovy script to create a communications link between the Groovy script and the external Web resource.

Key Resources

  • Connecting to External Web Services in your Administering guide at Cloud Documentation
  • Specifying Advanced Options for External Connections in your Administering guide at Cloud Documentation

Connections Interface Updates

Updates to the Connections interface include grouping all EPM service providers into a  single provider called Oracle Enterprise Performance Management Cloud.

  • On the Select Provider to Create Connection page, all Enterprise Performance Management service providers will be grouped into a single service provider called Oracle Enterprise Performance Management Cloud.
  • On the Connection Details page, based on the URL provided, Application Type will be automatically identified and displayed.

  • On the Manage Connections page, the name and description will be grouped together under one column called Name, and the application type and provider will be grouped together under one column called Application.

Working with Butterfly Report Format

You can define a “butterfly report”, with a column of members between two columns of data cells.

Key Resources

Report Package – Publish to Library

You can publish the report in Word or PowerPoint format, or in PDF format, depending on the report package type.

  • Published report can be either saved to Local or Library location.
  • Published doclet can be either saved to Local or Library location.

Key Resources

Removal of Support for Transport Layer Security Protocol 1.0 and 1.1

As announced in previous readiness documents, Oracle supports only Transport Layer Security protocol version 1.2 (TLS 1.2) to communicate with EPM Cloud. To ensure the highest level of authentication and data encryption security, support for TLS 1.0 and TLS 1.1 have been removed.

Because most modern operating systems and browsers support TLS 1.2; users of such systems and browsers are not affected by the deprecation of TLS 1.0 and 1.1. EPM Automate and Smart View are also not affected by this change.

You cannot use client operating systems that do not support TLS 1.2 (for example, Red Hat Enterprise Linux 5 and Microsoft Windows 2002) to run operating system-specific commands (for example, code to run cURL tools to transfer data and custom code that integrates with the REST APIs) against EPM Cloud. Additionally, Smart View installed on such systems will also fail to communicate with EPM Cloud. Similarly, you cannot use browsers that do not support TLS 1.2 protocol to access EPM Cloud environments.

If you are using on-premises FDMEE to integrate with EPM Cloud you must update your on-premises EPM 11.1.2.4 deployment to support TLS 1.2. Refer to the following Oracle Support document to enable TLS 1.2 support:

TLS 1.2 Support for Outbound EPM Cloud Emails

EPM Cloud has been enhanced to send outbound emails using Transport Layer Security (TLS) protocol 1.2. This update enables EPM Cloud to route emails, for example, from Financial Reporting Batches, correctly even if your email server accepts only TLS 1.2 compliant emails.

Upcoming Changes

Removal of Instance Name from Predefined Role Names

Currently, the predefined role names displayed in the Access Control screens of EPM Cloud environments prefix the instance name to the role name in INSTANCE_NAME ROLE_NAME format. They are also stored in this format in the snapshots making it difficult to migrate snapshots from one instance to another.

To facilitate the migration of security across EPM Cloud environments, Oracle plans to rename predefined role names displayed within EPM Cloud applications by removing the instance name prefix in the August update. For example, if the instance name is Planning1, predefined role names are Planning1 Service Administrator, Planning1 Power User, Planning1 User and Planning1 Viewer. The new role names will be Service Administrator, Power User, User, and Viewer.

NOTE: This change does not affect how the role names are displayed in the MyServices customer portal.

This change will affect customers who use the predefined roles for managing application-level provisioning and access to artifacts; you will need to reassign such assignments using the updated role name after the roles are renamed. This change makes it easy to migrate EPM Cloud artifacts across environments.

Additionally, all predefined role names; Domain Administrator, Service Administrator, Power User, User, and Viewer will be treated as EPM Cloud keywords, which should not be used in the name of any custom artifacts that you create; for example, group name in Access Control. If you have any group with these keywords, rename them before this change comes into effect.

This change is being implemented to address customer feedback. If you have any concerns about this change, please contact Oracle Support.

Defects Fixed

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

Considerations

Access Control

  • In Access Control, Service Administrator can manage group using “*” (asterisk) as the wildcard character to retrieve all available groups. For example, "John*" should be added to search user in the search field. However, in Oracle Enterprise Performance Reporting Cloud (EPRCS) search capability automatically display characters that are matching in the "contains” field. See Creating Groups in Administering Access Control for Oracle Enterprise Performance Management Cloud.

  • In Access Control, Service Administrator can create and manage group, where as in Oracle Enterprise Performance Reporting Cloud, an Application Administrator can create and maintain all artifacts, such as applications, models, dimensions, and data grants. You may not able to view each individual Application-Level provisioning roles in Oracle Enterprise Performance Reporting Cloud. See Understanding Pre-Defined Roles in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

  • If a Service Administrator creates a user and did not assign any role to that user. If the newly created user tries to login to the application, then an error message is displayed, “You have been authenticated but you do not have access to Enterprise Performance Reporting Cloud Service. Contact your Service Administrator.

  • In Oracle Enterprise Performance Reporting Cloud, if a user has Reports Administrator rights then the user can view the folder and can perform import or export option on that folder, else the user will not have rights to view all the folders in the library. See Understanding Pre-Defined Roles in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Key Resources

Management Reporting

Be aware of the following consideration when working with Management Reporting.

  • When uploaded for use with Management Reporting, Microsoft Internet Explorer requires installable fonts. If custom fonts are not installable, then Internet Explorer will substitute a different font. Google Chrome and Mozilla Firefox do not require installable fonts.

Report Packages

Be aware of the following considerations when working with Report Packages.

  • In Report Package, if you are adding a table of contents with a report package that uses multi-byte fonts, a service error may occur when executing a link within the table of contents if the associated fonts have not been uploaded to the service.  As a workaround, uploading the required fonts to the service.

  • It’s recommended to limit the number of variables that are inserted into an individual doclet. The maximum limit to insert variables with in the doclet should be less than 250.  If a doclet contains more than 250 variables, then you may encounter extended processing time while checking in doclet, and many times the doclet may fail to check-in.

  • With the latest Oracle Application Development Framework (ADF) software update, Time zone preference set to UTC - 08:00 by default. If a user tries to set the date selection in any of the Report Package's time line fields, the time zone code (GMT+/-00:00) is shown at the end of the input field. For example, if the user sets the due date for the start of the author phase to be January 1, 2019 at 9 AM in the Pacific US time zone, the date field is displayed as Jan 1, 2019 9:00:00 AM GMT-08:00.

  • In PDF-based Report Packages, Reviewers are unable to add comments to the report content sourced from Microsoft Excel doclets. Review commenting on the Excel doclet contents will be supported within a future release.

  • Publishing a report package to PDF that contains embedded charts that were created in Microsoft Word results in errors.

Workaround: Either convert the Word charts to images, or replace the Word charts with embedded content from a reference file or doclet.

  • Previewing a report that has a PowerPoint style sample with a custom slide that has numbering starting at zero will display an error.

Workaround: Download the PowerPoint style sample document and change the numbering on the Slide Master to start with one, instead of zero. Then, edit your report package properties and select the updated style sample document.

  • When you add embedded content that contains internal hyperlinks to a report package, if you select Download Preview to view the document, the hyperlinks within the embedded content do not open when clicked.  

  • When creating embedded content, if you use the horizontal text alignment format Center Across Selection in Excel, the selection does not carry forward into the embedded content when the doclet is embedded in Word.  The text remains within the original cell.

Workaround:  To achieve the same visual layout, use Merge cells and Center align to align the text in the merge cell.

  • When you insert a reference variable value that references a document that was created using Word 2007, a line break is inserted in the text, creating an extra line.

Workaround:  If you encounter this issue, delete the extra line.

  • If an Excel worksheet uses a double-line bottom border on the last row of a named range, an extra row appears in the embedded content within a consuming doclet.

Workaround: To work around this issue, try one of the following options:

  1. Do not use a double line bottom border in the last row of a named range, but select an alternative bottom border.

  2. Navigate to a cell that is below the named range, and add dummy text or a blank space. You can then upload and check in the reference doclet. When the embedded content is generated, the empty row is no longer included.

  3. Resize the row below the row that contains the double-line bottom border. You can keep the double line border in the last row intact, but resize the next row to be very small (but not hidden). Click any cell in the relevant row and choose Home, then Format, and then Row Height and enter a small value such as 2 or 3. The extra space is included in the embedded content, but it has a minimal impact.
  • If a PowerPoint slide is created from a layout that contains placeholders for tables, charts, smart art or media files, those objects seem to disappear when uploaded to the service.The content is not lost however. After downloading the files, a reset on the slide will cause the content to reappear.

Workaround: To work around this issue, create the slide by adding the content directly to the slide rather than use a layout with place holders.

  • If the user enters a simple URL format (for example, www.oracle.com) within the Rich Text Editor, a service error will be displayed when the link is executed.

Workaround: If a user enters a fully qualified URL format (for example, http://www.oracle.com) within the Rich Text Editor, the URL link will open within a new browser tab.

  • When using an iPad with the Safari browser to preview a report package, Safari stops responding when you magnify the screen and tap preview.    

  • When downloading files using Safari 9, any spaces in the filename will appear as special characters.    

  • When performing a review of a PowerPoint report package using Safari, a service error is displayed if the user places the comment anchor in the blue area outside slide.    

  • When you open a review instance within Smart View, add a comment, switch to another review instance, and then switch back to the first review instance using the Content Selector, the comment is not updated correctly.

Workaround: Click “Refresh Comments” or click the Content Selector refresh button to display the comment correctly.

Disclosure Management

Be aware of the following considerations when working with Disclosure Management.

  • Bidirectional language functionality is not supported in Disclosure Management for this release. 

  • When publishing a taxonomy in Taxonomy Designer, you must enter the full path for the ZIP file when specifying the location to publish to. An error is displayed if you specify the ZIP file name only without the path.  

  • When auto preview is enabled and you select Exhibit Linking after publish, Exhibit Linking does not work.

Workaround: Close Preview and select Exhibit Linking

  • When publishing a taxonomy in Taxonomy Designer, you must enter the full path for the ZIP file when specifying the location to publish to. An error is displayed if you specify the ZIP file name only without the path.

  • Ribbons are grayed out.

    Workaround: Reopen the same report. No need to restart the entire Microsoft Word instance. Only the report needs to be closed and reopened from the Private Connection. Once the report is reopened the ribbon is in an enabled state. At this time you can undo the checkout so the issue doesn’t occur again. The issue occurs due to the report being checked out earlier and never checked back in, or, the Undo Checkout was selected while the application was in an unstable state

  • Arelle from the client cannot connect to the internet.

Workaround: Run Arelle on a PC that has access to internet or open an SR and DEV (or support) will deliver the http cache and should be unzipped at:

<USER_HOME>\AppData\Local\Arelle\cache

  • Do not convert PDF formatted Disclosure Management reports to Word document.

Best Practice: Use original Word documents where available or re-create the content in a Word instance. Converting a PDF report to Word format is prohibited and will prevent the user from checking in the repository item when working in Disclosure Management.

  • The Auto Tag process can only detect one dimension now. The dimension name should be located on the horizontal or vertical column header.

  • You must ensure that the document is checked-in before clicking Auto Tag. If not, the current mappings in the Review Pane may disappear.

  • If you are restoring a database back up from 18.08 or 18.09, then the taxonomy registrations will not be restored. All the taxonomies need to be registered again. For open taxonomies that was edited using Taxonomy Designer template, you need to publish the taxonomy and register it again. For close taxonomies, you need to download the taxonomy from the issuing jurisdiction and register it again.

  • Auto-Tag process will only detect Level 4 tags in tables. It will not be able to detect tags in narratives.

  • Document Entity Information tags, Level 3 tags should be made first before attempting Auto-Tagging.

  • In Disclosure Management, you should remove spaces inside of the negative number before auto tagging. As a workaround, you must update individual doclet table cell from removing space. For example, you need to change table cell as follows:

    • From: "(74 )" – An extra space is displayed in the table cell.

    • To: "(74)" – Remove an extra space in the table cell.

Smart View

Be aware of the following considerations when working with Smart View.

  • In the Mozilla Firefox browser, if you are trying to download the Smart View extensions, this may result in a new tab opening with a large amount of code being displayed. This is due to a security policy within the Mozilla Firefox browser related to certain file extensions.

Workaround: Download the Smart View extensions using an alternate supported browser (Microsoft Internet Explorer or Google Chrome) or you can install the extension from Smart View directly.

Then, follow the install instructions in “Installing the Enterprise Performance Reporting Cloud Extension” of the Oracle Smart View for Office User's Guide.

  • In Word 2016, 32- or 64-bit, when you close a document, Word stops responding (displays the spinning wheel) until you either click in the ribbon area of the interface, or press the Alt key.  

  • On Microsoft Windows 10 with Office 32- or 64-bit, in the Add Report Content dialog, range names display incorrectly.

Workaround: Go to the Control Panel, then Display, then click the link for “Set a custom scaling level” and ensure that the setting in the “Custom sizing options” dialog is 100%. If it is not, set it to 100%, and then log out of Windows and log back in.

  • A connection created in one language cannot be used if Smart View is changed to a different language.

Workaround:  Create multiple private connections using the Add Connection Wizard. Before creating each connection, change the Smart View language display (in the Options dialog box, Advanced tab, Language drop-down list). Then, follow the instructions “Using the Private Connection Wizard” in the Oracle Smart View for Office User's Guide.

  • When downloading a new Smart View extension from Microsoft Internet Explorer, the filename extension defaults to .ZIP instead of .SVEXT. This prevents you from being able to double-click to install the extension.

Workaround: When Internet Explorer prompts you to save the file, choose “Save As”, change the Type to “All Files”, and then change the extension from .ZIP to .SVEXT. Then, double-click the downloaded file to install the extension.

  • When any of the allowable special characters are used in a report package name (such as commas, semicolons, or ampersands), there may be a discrepancy between how the name displays in the library tree and how it displays in the Report Center panel.  

  • If you have open or close bracket characters in an Excel reference or supplemental doclet, Excel changes the brackets to parentheses when you save the file.  

  • When you upload an Excel reference doclet with many named ranges, not all of the named ranges are listed as available content.

Workaround: Upload the doclet and then go to the web and add the embedded contents within the doclet inspect dialog.

Be aware of the following consideration when working with Smart View for ad hoc analysis.

  • When users sign in to the service for the first time, they will be prompted to change the password. Oracle recommends that users sign in first to the web to change their password before connecting through Smart View.

Only for Smart View for Office with Microsoft Office 365 ProPlus

A known issue with Microsoft Office 365 ProPlus patch 16.0.10228.20051, updated through the insider slow channel, prevents users from accessing Oracle Smart View for Office with Office 365, resulting in the “Member not found” message being displayed. This Microsoft patch was pushed to users who signed up for monthly channel updates between June 12 and June 14, 2018.

Workaround: Update Office with Microsoft Office 365 Version 1806 (Build 10228.20080), which contains the fix for this issue.