Oracle Planning
What's New
  1. January 2019 Update
  1. Revision History
  2. Oracle Planning and Budgeting Cloud, January Update
        1. Monthly Update Schedule
        2. Please Join Oracle Cloud Customer Connect
        3. Give Us Documentation Feedback
    1. Announcements
        1. New Aggregate Storage Functions in Calculation Manager
    2. Upcoming Changes
        1. Ability to Create New Composite Forms
        2. Classic Dimension Editor
        3. Removal of Block Storage Cube Runtime Statistics
        4. Proposed Changes to Application-Level Access Control
    3. Defects Fixed

January 2019 Update

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date Feature Notes
20 DEC 2018   Created initial document.

Oracle Planning and Budgeting Cloud, January Update

This document outlines the upcoming Oracle Planning and Budgeting Cloud update.

Monthly Update Schedule

Oracle will apply the latest updates to your test environments starting at 23:00 UTC (15:00 PST) on Friday, January 4, 2019 and to your production environment on Friday, January 18, 2019, also starting at 23:00 UTC. The updates will be applied to your environments during the first subsequent daily maintenance.

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

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.

Announcements

New Aggregate Storage Functions in Calculation Manager

The following Aggregate Storage functions have been added to Calculation Manager. These functions can be used in the Point of View of an Aggregate Storage custom calculation or allocation.

  • @COUSIN (Member Name, Cousin Member Name) returns a child member at the same position as a member from another ancestor.
  • @DISTINCT (List1) deletes duplicate tuples from a set.
  • @EXCEPT (List1, List2) returns a subset containing the differences between two sets, optionally retaining duplicates.
  • @FIRSTCHILD (Member Name) returns the first child of the input member.
  • @GEN (Member Name) returns the members specified by the input generation number of the specified member.
  • @GENMBRS (Member Name, Generation) returns the members specified by the specified generation number of the specified member.
  • @INTERSECT (List1, List2) returns the intersection of two input sets, optionally retaining duplicates.
  • @LASTCHILD (Member Name) returns the last child of the input member.
  • @NEXTMBR (Member Name) using the order of members existing in a database outline, returns the next member along the same generation or level.
  • @PREVMBR (Member Name) using the order of members existing in a database outline, returns the previous member along the same generation or level.

Key Resources

Upcoming Changes

Ability to Create New Composite Forms

Oracle will remove the ability to create new composite forms (forms that comprise multiple simple forms) starting with the March 2019 update to the service (March 01, 2019 for test environments and March 15, 2019 for production environments). After the March update, all existing composite forms can still be edited and used. Removal of the ability to create composite forms impacts only the creation of new composite forms in the service.

All customers are advised to use dashboards in place of composite forms. No more enhancements will be made to the composite forms functionality.

Classic Dimension Editor

With a view to allowing customers more time to familiarize themselves with the Simplified Dimension Editor, Oracle has decided to defer the removal of support for Classic Dimension Editor to a future update in 2019. Oracle will notify you at least two months prior to the removal of the feature.

Removal of Block Storage Cube Runtime Statistics

Starting in Release 19.02, run time statistics for Block Storage (BSO) cubes will no longer be available in the Database Properties module of Calculation Manager.

Proposed Changes to Application-Level Access Control

Using Groups created in Access Control, EPM Cloud supports application-level access control for planning, consolidation and close, tax reporting, and Oracle Enterprise Data Management Cloud applications. In addition to the custom groups created in Access Control, access control screens list predefined identity domain roles (Service Administrator, Power User, User and Viewer) as groups.

Pre-Defined Roles and Groups in Forms Access Control Screen

With a view to simplifying security across EPM Cloud and to ensure that application-level access control can be seamlessly migrated across environments, Oracle plans to remove the ability to display predefined roles as groups in access control screens. After this change, you will no longer see predefined roles listed when you search for groups in access control screens.

NOTE: The proposed change will not affect how you create and manage groups or use them for application-level access control.

Before making this change, Oracle wants to evaluate the impact, if any, that the proposed change will have on your environments. If you are concerned that the proposed change will affect your environment, please create a service request explaining your use case.

Defects Fixed

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