This document will continue to evolve as existing sections change and new information is added. All updates are logged below, with the most recent updates at the top.
26 JAN 2017
Initial Document Creation
This document outlines the announcements and known issues in the upcoming Oracle Profitability and Cost Management Cloud Service update. Oracle applies the monthly service update to your test environment on the first Friday of every month and to your production environment on the third Friday of every month.
We would like to inform you of the upcoming monthly update for your Oracle Cloud environments. We will apply the latest updates to your test environment on Friday, February 3, 2017 and to your production environment on Friday, February 17, 2017. The update will be applied during your normal daily one-hour maintenance window.
This release includes the user interface translated into Danish, German, Spanish, Finnish, French, Italian, Japanese, Korean, Dutch, Polish, Portuguese (Brazilian), Russian, Swedish, Turkish, Simplified Chinese, and Traditional Chinese.
Native (user-defined) groups are now enabled for use with Data Grants. See Chapter 2 of Administering Profitability and Cost Management Cloud for details.
Formula syntax is changed in these ways:
- Members and tuples are no longer surrounded by </ /> special characters.
- The Result (left-hand) and Target (right-hand) parts of the formula are separated by :=.
- Members must be enclosed in square brackets, [ ], and tuples in parentheses, ( ).
- Tuples with one or more members can be used on the Result side of the formula as well as the Target side.
- Formulas now support any MDX operation allowed in Essbase as well as basic math and conditional operations.
- Formulas end in semicolon ;.
- A Rule dimension or member must be used in the Target side of the formula for arithmetic operations.
See Chapter 5 of Administering Profitability and Cost Management Cloud for details.
You can now paste dimension-member combinations from Microsoft Excel into the Dimensions area of the following Rule Definition screen tabs: Source, Destination, and Driver Basis. This feature reduces the keystrokes needed to create new rules or modify existing rules. It is helpful for cases where users manually generate rules, for example, by using a spreadsheet.
To use this feature, click Text Entry in the Dimensions area. Then, copy and paste dimension-member combinations for that tab into the Dimension Member Editor box using the following format:
Use one row per member. You can include combinations for multiple dimensions in the same box. When entries are complete, click OK.
If you try to input a dimension or member that does not exist or one that is not available for that tab, an error message is displayed.
Note that you must use the Member Selection area to remove dimension-member combinations created by pasting.
Profitability and Cost Management Cloud query results display in Smart View grids. In the following cases, users may not want to include attribute dimensions:
- When a user should not see them or be allowed to select them
- When the query would result in invalid cells, especially in cases where the members of the base dimension do not all have attributes assigned
- When the query will be used for data entry in Smart View
By default, attribute dimensions are excluded from query results. To include them, select Include Attribute Dimensions on the Dimensions tab of the Queries Definition screen. (See “Creating Custom Queries in Applications” in Chapter 11 of Administering Profitability and Cost Management Cloud.)
You can set decimal precision for allocation calculations, from +7 to -6 places. The default is 2. For details, see “Editing an Application’s Description and Default Dimension Settings” in Chapter 4 of Administering Profitability and Cost Management Cloud.
In Essbase, the solve order number determines the order by which members are evaluated in the dimension. You can now include the MEMBER SOLVE ORDER property in flat files for updating dimensions. For details, see “About Flat File Properties” in Chapter 4 of Administering Profitability and Cost Management Cloud.
Starting this update, you can configure single sign-on access between Oracle Enterprise Performance Management Cloud and Oracle Fusion Applications Cloud. Configuring SSO requires you to configure SAML 2.0 Identity Provider (IdP) between Oracle EPM Cloud and Oracle Fusion Applications Cloud.
A new version of the EPM Automate Utility is available with this update. This version enhances the importsnapshot command to allow the import of identity domain artifacts from application snapshots. This enhancement simplifies the cloning of a service instance by avoiding the step of manually importing users and roles into the identity domain.
The activities that you can complete using importsnapshot command depend on your role.
- Service Administrators can import only application artifacts into a service instance.
- Identity Domain Administrators can import only identity domain artifacts.
If a user who is not in the identity domain is referenced in the snapshot being imported, the utility creates a user in the identity domain and assigns the default password that you specify in the command.
- Service Administrators who are also assigned the Identity Domain Administrator role can import application content into the service instance and identity domain artifacts (users and their role assignments) into the identity domain of the service instance.
You must install this version of the utility to use the enhanced command. See these sections in Working with EPM Automate for Oracle Enterprise Performance Management Cloud:
Smart View for Office Release 188.8.131.52.620 is now available. This release contains new features such as Smart Form support for some Smart View functions, qualified name support for alternate hierarchies, Excel filter retention during ad hoc analysis, selectively deleting connections, and the ability to sort files and folders in the Smart View Panel, among other features. The Smart View 184.108.40.206.620 Readme, available on the Help Center, contains a complete list of new features in this release.
Starting with this release, reports opened in Financial Reporting Web Studio now display a red indicator at the top right corner of cells that have related content.
Oracle is committed to providing a simple and intuitive experience to the users of the service. To achieve this goal, Financial Reporting Web Studio will be established as the only tool for designing and building reports. In this update, Financial Reporting Web Studio will achieve parity with most of the functional capabilities provided with Financial Reporting Studio desktop client. You will be able to create new reports and modify existing reports using Financial Reporting Web Studio.
Support for Financial Reporting Studio desktop client will tentatively be stopped in the May 2017 update. Oracle will not distribute Financial Reporting Studio desktop client after May 2017. Please send questions and concerns to Oracle using the Provide Feedback option in the service.
Oracle recommends that you transition to using Financial Reporting Web Studio at the earliest opportunity.
Copyright © 2017, Oracle and/or its affiliates. All rights reserved.
This document is provided for information purposes only, and the contents hereof are subject to change without notice.This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced ortransmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation.All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.