- Revision History
- Overview
- Feature Summary
- Enterprise Performance Management
-
- EPM Cloud Platform
- Account Reconciliation
- Enterprise Data Management
- Financial Consolidation and Close
- FreeForm
- Narrative Reporting
- Planning
- Profitability and Cost Management
- Enterprise Profitability and Cost Management
- Tax Reporting
- IMPORTANT Actions and Considerations
This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:
| Date | Module | Feature | Notes |
|---|---|---|---|
| 14 DEC 2023 | EPM Cloud Platform | Updated document. Updated feature description. | |
| 27 NOV 2023 |
EPM Cloud Platform | Forms 2.0 and Dashboard 2.0 | Updated document. Updated feature description. |
| 27 NOV 2023 |
Financial Consolidation and Close | Intercompany Report Display for Shared Entities | Updated document. Added a new feature. |
| 27 NOV 2023 | IMPORTANT Actions and Considerations | Narrative Reporting/Disclosure Management | Updated document. Added a consideration. |
| 03 NOV 2023 | EPM Cloud Platform | New Connector Option For EPM Cloud To NetSuite Connections | Updated document. Updated feature description. |
| 03 NOV 2023 | IMPORTANT Actions and Considerations | Tax Reporting/Pillar Two | Updated document. Added a consideration. |
| 03 NOV 2023 |
Planning | Updated document. Added a new feature. | |
| 03 NOV 2023 |
EPM Cloud Platform | Stronger Encryption Algorithm for Navigation Flows and Connections |
Updated document. Updated feature description. |
| 03 NOV 2023 |
EPM Cloud Platform |
Updated document. Added a new feature. | |
| 26 OCT 2023 |
Created initial document. |
HAVE AN IDEA?
We’re here and we’re listening. If you have a suggestion on how to make our cloud services even better then go ahead and tell us. There are several ways to submit your ideas, for example, through the Ideas Lab on Oracle Customer Connect. Wherever you see this icon after the feature name it means we delivered one of your ideas.
GIVE US FEEDBACK
We welcome your comments and suggestions to improve the content. Please send us your feedback at oracle_fusion_applications_help_ww_grp@oracle.com.
DISCLAIMER
The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.
This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.
Column Definitions:
Report = New or modified, Oracle-delivered, ready to run reports.
UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.
UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.
Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.
Enterprise Performance Management
Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, November 3, 2023.
Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, November 17, 2023.
NOTE: The monthly update will not be applied to any environment for which this monthly update is requested to be skipped using the EPM Automate skipUpdate command or service request to Oracle.
NOTE: Backing up the daily maintenance snapshot and restoring the environment as needed are self-service operations. Oracle strongly recommends that you download the maintenance snapshot every day to a local server.
The Oracle Help Center provides access to updated documentation. The updates will be available in the Help Center on Friday, November 3, 2023.
NOTE: 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.
Documentation Updates Available One Week After Readiness Documents
Updated documentation is published on the Oracle Help Center on the first Friday of each month, coinciding with the monthly updates to Test environments. Because there is a one week lag between the publishing of the readiness documents (What's New and New Feature Summary) and Oracle Help Center updates, some links included in the readiness documents will not work until the Oracle Help Center update is complete.
https://docs.oracle.com/en/cloud/saas/epm-cloud/index.html
Fixed Issues and Considerations
Software issues addressed each month and considerations are posted to a knowledge article on My Oracle Support. Click here to review. You must have a My Oracle Support login to access the article.
NOTE: Fixed issues for EPM Cloud Common components (Smart View for Office, EPM Automate, REST API, Migration, Access Control, Data Management/Data Integration, Reports, Financial Reporting, and Calculation Manager) are available in a separate document on the My Oracle Support “Release Highlights” page.
This provides visibility into EPM Cloud release contents.
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.
Create and Run an EPM Center of Excellence
A best practice for EPM is to create a Center of Excellence (CoE). An EPM CoE is a unified effort to ensure adoption and best practices.
Business Benefit: A CoE drives transformation in business processes related to performance management and the use of technology-enabled solutions.
Learn more:
- Visit the EPM Center of Excellence web page to learn about the benefits.
- Watch the webinars on Cloud Customer Connect: Creating and Running a Center of Excellence (CoE) for EPM Cloud and Planning Your Success with EPM Center of Excellence.
- Watch the videos: Overview: EPM Center of Excellence, Creating a Center of Excellence.
- Get best practices, guidance, and strategies for your own EPM CoE: Creating and Running an EPM Center of Excellence
Join Oracle Cloud Customer Connect
Please take a moment to join Cloud Customer Connect and its EPM Cloud forums. Customer Connect is a community gathering place for members to interact and collaborate on common goals and objectives. It's where you will find the latest release information, discussion forums, upcoming events, and answers to use-case questions. Joining takes just a few minutes. Join now!
To join, go to https://community.oracle.com/customerconnect/ and select Register in the upper right.
After you have joined and logged in, to access the forums (Categories), from the Cloud Customer Connect home page, select Categories, then Enterprise Resource Planning, and then make your selection under Enterprise Performance Management.
To ensure that you are always in the know, confirm that you have your notification preferences set for EPM Announcements as well as each Category you're following.
- To set notification preferences for EPM Announcements, go to Categories, then Announcements, and then Enterprise Performance Management. Next, select the Notification preferences drop down.
- To set notification preferences for each Category, navigate to the Category page and select the Notification preferences drop down. You must go to each category page separately and select the Notification preferences drop down.
NOTE: The Settings and Actions menu 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.
TIP: Bookmark the Enterprise Performance Management Resource Center to quickly find useful information on all things EPM. As a community member, you have access to important product announcements, best practices, known issues, training highlights, and more.
Follow Us on Social Media
Follow EPM Cloud on YouTube, Twitter, Facebook, and LinkedIn.
These are great resources for the latest updates and information about EPM Cloud.
Business Benefit: These resources can help you optimize your EPM implementation and user experience by providing valuable information and user assistance.
Use the Readiness App available on the Oracle Cloud Application Update Readiness site to review information about features released for Oracle Cloud. The app provides an .xlsx file listing all features released for one or more Cloud product(s), module(s) and update(s) that you designate. The EPM Cloud Features tool will not be updated beginning in this update.
From the Readiness site, click the red Try Our Readiness App! button in the upper right, or use this URL to access the app:
https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/app/index.html
NOTE: To ensure a complete feature listing, select EPM Common in addition to the business process(es) you wish to view. To determine whether an EPM Common feature applies to your business process, review the Applies To information in the Short Description column of the .xlsx file.
NOTE: The Readiness App includes features from Oct 2021 and later. The EPM Cloud Features tool includes EPM features from March 2018 through June 2, 2023 only.
Business Benefit: The Readiness App is an interactive tool that allows you to view a comprehensive listing of all features that have been released for one or more product(s), module(s) and update(s) that you designate.
Updated Translated User Assistance Resources Now Available
Localized versions of EPM Cloud guides and online help, covering all features up to September 1, 2023, are now available, with the exception of the Working with Oracle Smart View for Office guide, which covers all features up to May 5, 2023. EPM Cloud user documentation is translated into German, Spanish, French, Italian, Japanese, Korean, Portuguese (Brazilian), Simplified Chinese, and Traditional Chinese. Smart View Guides are also translated into Dutch.
Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Business Benefit: Translated guides and online help explain EPM Cloud features and operations in users’ preferred language.
Key Resources
To access translated User Assistance resources:
- Open an EPM Cloud Help Center, for example, the Planning Help Center.
- Click Translated Books in the left navigation pane, and then select a language.
New Resources for Your EPM Center of Excellence
To help you make the most of EPM Cloud, we've provided valuable new resources in the EPM Center of Excellence (CoE), including these new assets:
- Oracle Playbook for Financial Excellence
- Oracle Playbook for Operational Excellence
- EPM Environmental, social, and governance (ESG) sustainability information
Find blogs, videos, and documentation at the dedicated EPM CoE web page. Contact us at epmcoe_ww@oracle.com if you have questions, or if you'd like help with starting your own EPM Center of Excellence.
A CoE is a best practice for Cloud EPM. An EPM CoE is a unified effort to ensure adoption and best practices. It promotes the most effective use of Cloud EPM and helps you deliver better business results.
Learn more:
- Use the checklist to create an EPM CoE.
- Understand the benefits and value proposition of a CoE.
- Build your business strategy.
- Go to the Oracle EPM Center of Excellence web page.
Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Business Benefit: A CoE drives transformation in business processes related to performance management and the use of technology-enabled solutions.
Key Resources
- Watch the webinars on Cloud Customer Connect: Planning Your Success with EPM Center of Excellence and Creating and Running a Center of Excellence (CoE) for EPM Cloud
- Watch the videos: Overview: EPM Center of Excellence and Creating an EPM Center of Excellence
- Get best practices, guidance, and strategies for your own EPM CoE: Creating and Running an EPM Center of Excellence
- Learn more and contact us on the Oracle EPM Center of Excellence web page
Oracle Cloud Infrastructure Migration
OCI Migration: Oracle-Managed Migration Ending; Customer-Managed Migration Not Available Any Longer
One of Oracle's latest advancements, Oracle Cloud Infrastructure (OCI) is the foundation of Oracle's second generation cloud. OCI, a purpose-built, best-in-class platform for running enterprise applications, is engineered from the ground up to run mission-critical databases, workloads, and applications while providing end-to-end security. Oracle's data centers around the globe are standardizing on the new OCI architecture which will deliver even greater performance and reliability. There are a lot of EPM Cloud features that are available only in OCI. See Features Available only in OCI EPM Cloud Environments in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.
Oracle has been migrating all Classic Commercial environments to OCI and will finish this activity during this monthly update.
Oracle has sent notifications for Oracle-managed migrations specifying the migration schedule. By now, you must have received notifications for all Classic Commercial environments that were not scheduled for migration in earlier waves or migrated through the Customer-Managed Migration option. Follow the instructions in the notification. For Migration waves schedule information, see EPM Cloud Classic to OCI Migration Schedule in the Oracle Enterprise Performance Management Cloud Operations Guide.
For customers whose environments were included in Wave 8 (August 2023 Migration Notification): The migration of application data and users from Classic to OCI environments and the DNS configuration change to route the existing Classic service URLs to OCI environments will occur in the 23.11 (November) monthly update. You cannot use the skipUpdate EPM Automate command, the Skip Updates REST API or a service request to Oracle to delay this migration.
Wave 8 is the last migration wave. If your environments are included in this wave, data and user migration on the test environments will take place during the first daily maintenance that occurs at or after 22:00 UTC on Friday, November 3, 2023. Data and user migration on the production environments will take place during the first daily maintenance that occurs at or after 22:00 UTC on Friday, November 17, 2023.
-
If the Classic environment is on a one-off patch not merged in 23.11: The migration of the Classic environment to OCI environment will occur during the 23.11 update. The resulting OCI environments will then have the same one-off patch as the Classic environment.
-
If you are skipping the 23.11 monthly update on a Classic environment (by using the skipUpdate EPM Automate command, the Skip Updates REST API, or by submitting a service request to Oracle): The migration of this Classic environment to OCI environment will still occur during the 23.11 update. The resulting OCI environment will then have the same monthly update as the Classic environment; skip update will be active on this OCI environment.
All Customer-Managed Migrations must finish by these deadlines:
- Amsterdam (EM2) Data Center: End of October 2023. Oracle is terminating Classic environments in the Amsterdam (EM2) Data Center in November 2023.
- All other data centers: End of November 2023. Oracle will terminate Classic environments in other data centers in December 2023.
NOTE: At this time, the environments hosted in US-Gov and UK-Gov data centers are not eligible for migration to OCI.
Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Business Benefit: OCI provides you a purpose-built, best-in-class platform that is engineered from the ground up to run mission-critical databases, workloads, and business processes while providing end-to-end security. This new architecture delivers greater performance and reliability, and a number of EPM Cloud features that are not available in Classic EPM Cloud.
Steps to Enable
Review and follow instructions: EPM Cloud Classic to Oracle Cloud Infrastructure (OCI) Migration in Oracle Enterprise Performance Management Cloud Operations Guide
Key Resources
- EPM Cloud Classic to Oracle Cloud Infrastructure (OCI) Migration in Oracle Enterprise Performance Management Cloud Operations Guide
- Features Available only in OCI EPM Cloud Environments in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators
REST API to Create a Job to Copy Library Artifacts
You can now use REST APIs to create a job to copy library artifacts. The Copy Artifact From Library job copies the content of a library artifact to the default download location, where you can download it to your local computer. You can use the Inbox/Outbox Explorer to view the details of the exported file. Use the Download REST API to download the exported file.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Business Benefit: Using REST APIs allows you to automate the tasks of copying library artifacts and downloading them.
Steps to Enable
Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.
Key Resources
See these helpful resources in REST API for Oracle Enterprise Performance Management Cloud:
Access Requirements
- Service Administrators
Connections REST APIs Expose Identity Domain Information to Help Customers on Classic Environments
Customers who use REST APIs in Classic environments to work with connections require identity domain information. To address this, the connection REST APIs now expose identity domain information as part of the connection REST response.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Business Benefit: Using REST APIs allows you to automate the task working with connections, and you can now get the identity domain information more easily to use it in these REST APIs.
Steps to Enable
Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.
Key Resources
See these topics in in REST API for Oracle Enterprise Performance Management Cloud:
Access Requirements
- Service Administrators
Additional Groovy Examples and Information to Help with DataGridBuilder
You now have new and enhanced examples to help you build Groovy business rules when working with the DataGridBuilder class. The new example shows how a Groovy script executed by an end user (who may not be a Service Administrator) can load data on behalf of a system user (a Service Administrator) using DataGridBuilder. The examples now include more information explaining each use case and when to use it.
For details and examples, see DataGridBuilder in EPM Cloud Groovy Rules Java API Reference.
Applies to: Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Business Benefit: The new examples help you distinguish between the use cases of Groovy rules run by the current user and the Service Administrator.
Steps to Enable
You don't need to do anything to enable this feature.
Tips And Considerations
- To get a quick introduction to Groovy business rules, watch the Learning Groovy in EPM Cloud video.
-
To get started quickly using Groovy examples, click the examples link under Example Groovy Scripts in EPM Groovy Rules Java API Reference.
Key Resources
- Learning Groovy in EPM Cloud video
- Creating a Groovy Business Rule in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
- Introduction to Groovy Business Rules
- Groovy Tutorials
- EPM Cloud Groovy Rules Java API Reference
Access Requirements
-
Calculation Manager Business Rule Designer
Support Region Specific SPF Records for Email Delivery On OCI
Oracle publishes the Sender Protection Framework (SPF) policy that identifies the Oracle server IP addresses and subnets that are permitted to send cloud services emails. With this update, In OCI (Gen 2), you can add regions in your SPF records based on where your environment is located.
Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
| Americas |
v=spf1 include:rp.oracleemaildelivery.com ~all |
| Asia/Pacific |
v=spf1 include:ap.rp.oracleemaildelivery.com ~all |
| Europe |
v=spf1 include:eu.rp.oracleemaildelivery.com ~all |
| All Commercial Regions |
v=spf1 include:rp.oracleemaildelivery.com include:ap.rp.oracleemaildelivery.com include:eu.rp.oracleemaildelivery.com ~all |
Business Benefit: You can use the SPF policy information to assess the validity of the messages to determine whether or not to accept them. Additionally, you can use the information as a part of the message protection services.
Key Resources
- Configuring SPF Record for Oracle Fusion Cloud EPM Email Verification in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators
Stronger Encryption Algorithm for Navigation Flows and Connections
Starting with this update, the encryption algorithm used to store the credentials provided while creating Connections has been strengthened to AES-256. This change causes the password and secure parameters to be re-encrypted causing the time stamp and Modified By values shown in the Connections Listing screen to change.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Business Benefit: Using AES-256 to encrypt the credentials of remote environments provides higher security.
Key Resources
- Understanding EPM Cloud Security Compliance Features in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators
Standardized Application Role Names
In this update, application role names have been standardized across EPM Cloud. Here are the changes:
| Existing Application Role Name | New Application Role Name |
|---|---|
| Access Control Manager | Access Control - Manage |
| Ad Hoc Grid Creator | Ad Hoc - Create |
| Ad Hoc Read Only User | Ad Hoc - Read Only User |
| Ad Hoc User | Ad Hoc - User |
| Announcements Manage | Announcements - Manage |
| Application Creator | Application - Create |
| Approvals Administrator | Approvals - Administer |
| Approvals Ownership Assigner | Approvals - Assign Ownerships |
| Approvals Process Designer | Approvals - Design Process |
| Approvals Supervisor | Approvals - Supervise |
| Auditor | Audit |
| Clear POV Data | POV Data - Clear |
| Consolidation Journals - Approve | Consolidation Journals - Approve |
| Consolidation Journals - Auto-Post After Approval | Consolidation Journals - Auto-Post After Approval |
| Consolidation Journals - Create | Consolidation Journals - Create |
| Consolidation Journals - Manage Periods | Consolidation Journals - Manage Periods |
| Consolidation Journals - Post | Consolidation Journals - Post |
| Consolidation Journals - Submit | Consolidation Journals - Submit |
| Consolidation Journals - Un-Post | Consolidation Journals - Un-Post |
| Copy POV Data | POV Data - Copy |
| Create/ Edit Rule | Rule - Create/Edit |
| Create Integration | Data Integration - Create |
| Create Model | Model - Create |
| Create POV | POV- Create |
| Create Profit Curve | Profit Curve - Create |
| Data Integration Administrator | Data Integration - Administrator |
| Delete Calculation History | Calculation History - Delete |
| Delete Model | Model - Delete |
| Delete POV | POV - Delete |
| Delete Rule | Rule - Delete |
| Documents - Manage | Documents - Manage |
| Drill Through | Data Integration - Drill Through |
| Edit POV Status | POV Status - Edit |
| Edit Profit Curve | Profit Curve - Edit |
| Manage Alert Types | Alert Types - Manage |
| Manage Announcements | Announcements - Manage |
| Manage Data Loads | Data Loads - Manage |
| Manage Organizations | Organizations - Manage |
| Manage Periods | Periods - Manage |
| Manage Profiles and Reconciliations | Profiles and Reconciliations - Manage |
| Mass Allocation | Application - Mass Allocate |
| Mass Edit of Rules | Rules - Mass Edit |
| Migration Administrator | Migrations - Administer |
| Reconciliation Commentator | Reconciliation - Commentator |
| Reconciliation Manage Currencies | Currencies - Manage |
| Reconciliation Manage Dashboards | Dashboards - Manage |
| Reconciliation Manage Public Filters and Lists | Public Filters and Views - Manage |
| Reconciliation Manage Reports | Reports - Manage |
| Reconciliation Manage Teams | Teams - Manage |
| Reconciliation Manage Users | Users - Manage |
| Reconciliation Preparer | Reconciliation - Preparer |
| Reconciliation Reviewer | Reconciliation - Reviewer |
| Reconciliation View Jobs | Jobs - View |
| Reconciliation View Profiles | Profiles - View |
| Run Calculation | Calculation - Run |
| Run Integration | Data Integration - Run |
| Run Profit Curve | Profit Curve - Run |
| Run Rule Balancing | Rule Balancing - Run |
| Run Trace Allocation | Trace Allocation - Run |
| Run Validation | Model Validation - Run |
| Task List Access Manager | Task List - Manage Access |
| Task Manager - Approver | Task Manager - Approver |
| Task Manager - Assignee | Task Manager - Assignee |
| Task Manager - Manage Artifacts | Task Manager - Artifacts - Manage |
| Task Manager - Manage Dashboards | Task Manager - Operational Dashboards - Manage |
| Task Manager - Manage Public Filters and Lists | Task Manager - Public Filters and Views - Manage |
| Task Manager - Manage Reports | Task Manager - Custom Reports - Manage |
| Task Manager - Manage System Services and Settings | Task Manager - System Services and Settings - Manage |
| Task Manager - Manage Tasks | Task Manager - Tasks - Manage |
| Task Manager - Manage Users and Teams | Task Manager - Users and Teams - Manage |
| Task Manager - View Audit | Task Manager - Audit - View |
| View Audit | Audit - View |
| View Calculation History | Calculation History - View |
| View Creator | Views - Create |
| View Model | Model - View |
| View Periods | Periods - View |
Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Business Benefit: With standardized application role names, the functionality assigned to the user with an application role is easier to understand.
Key Resources
In Administering Access Control for Oracle Enterprise Performance Management Cloud, see:
- Account Reconciliation
- Enterprise Profitability and Cost Management
- Planning, Financial Consolidation and Close, Tax Reporting
- Profitability and Cost Management
- Oracle Enterprise Data Management Cloud
Forms 2.0 and Dashboard 2.0 functionality is now available.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Forms 2.0 features:
- Forms runtime-only improvements
- Usability improvements
- Better scalability and enhanced performance
- Standardized menus for performing global actions on forms, setting POV preferences, and a new Quick toolbar for performing such actions as Adjust, Spread, and adding Comments
- Greater consistency between Web forms and Smart View forms
- Sophisticated POV member selection with Jet Member Selector
- Easily switch from Forms 1.0 to Forms 2.0 and back using a new Forms Version setting in Application Settings
- Users can now use calc on the fly in the web and in Smart View, available when administrators enable a new Grid Properties setting
- Vertical and Horizonal Scroll in Form Grid are enhanced for easy maneuvering and better user experience
- New Line Item Details with improved capabilities in place of Supporting Details
Dashboard 2.0 features:
- Revitalized Dashboard Designer
- New Grid chart type that renders Forms 2.0 inside Dashboard 2.0 which supports data write-back
- New URL and Commentary types of Dashboard objects
- Conversion utility to easily convert 1.0 to 2.0 individually or at a folder level on the Dashboards page
- New user interface for associating business rules
- Ability to display multiple Gauge, Pie, and Doughnut charts inside one Dashboard component
- New menu options for opening and editing forms in Dynamic Tabs directly from the Dashboard
- New Information icon for the Dashboard and all Dashboard components
- Sophisticated POV member selection with Jet Member Selector
- Increased supported tiles from 6 to 10 in one component, and increased number of components on a dashboard from 9 to 12
- Enhanced Designer to include a Style property which renders the Dashboard in Default, Light, and Dark background colors with just one click
- Introduced new "Edit without Data" option
- Introduced a Save option at the Dashboard level which will write-back Grid Data updates. Also, Associated Business Rules will be run by enabling User to input Run-time Prompts
- Complies with defined Valid Intersections in Dashboard POV Member Selections
- Text Editor option introduced for formatting the Dashboard title
- Data limits for charts can be configured in the designer to support asymmetric grid shapes
- Option to hide Dashboard component borders for seamless display of various charts
To work with Forms 2.0 and Dashboard 2.0, you must enable the Redwood Experience. Forms 1.0 and 2.0 and Dashboard 1.0 and 2.0 versions will continue to coexist in the same business process at the same time.
If you've been using Forms 1.0, there's no migration needed to use Forms 2.0. You can switch between the two versions using an application setting. The forms will be rendered to whichever version you specify. To specify Forms 2.0, go to Application Settings and set the Forms Version to Forms 2.0.
To use a dashboard in Dashboard 2.0, you need to either create a new dashboard or convert an existing dashboard:
- To create a new dashboard, on the Dashboards listing page, click Create, then select Dashboard 2.0.
- To convert existing 1.0 dashboards, on the Dashboards listing page there's options next to folders or next to the individual dashboards to convert to 2.0:
- Converting folders: Convert All Dashboards to 2.0
- Converting individual folders: Convert to Dashboards 2.0
NOTE: Any Dashboard 2.0 dashboards that are saved in 23.11 cannot be imported to previous releases.
Business Benefit: Forms 2.0 and Dashboard 2.0 use Oracle JET technology for faster rendering, sophistication, ease of use, improved flexibility, better visualization, and additional designs.
Key Resources
- Enterprise Profitability and Cost Management
- Administering and Working with Enterprise Profitability and Cost Management
- Financial Consolidation and Close
- Administering Financial Consolidation and Close
- Working with Financial Consolidation and Close
- FreeForm
- Administering FreeForm
- Working with FreeForm
- Planning, Planning Modules
- Administering Planning
- Working with Planning
- Tax Reporting
- Administering Tax Reporting
- Working with Tax Reporting
Simplified Dimension Editor Now Supports Dimension Type for FreeForm Apps
If you created a FreeForm application using the Application Creation wizard, you can now use the simplified dimension editor to select the dimension type when creating a new dimension.
Dimension types can include:
- Account
- Entity
- Period
- Custom
Create Dimension
Applies to: FreeForm, Planning
Business Benefit: Previously, when creating a new dimension in a FreeForm app, you could only select the dimension type in the Classic dimension editor. Now you have the flexibility to select the dimension type if you're working in the simplified dimension editor.
Tips And Considerations
- A dimension type is not listed if you've already created it (for Account, Entity, Period) or if you've exceeded the maximum number of dimensions (for Custom).
- You can't edit the dimension type after you've created the dimension.
Key Resources
- Administering FreeForm
- Administering Planning
Displaying Real-Time Progress Status for Data Maps and Smart Push
When pushing data using data maps and smart push, the Job Details page now shows comprehensive information about each job's operations, including the completion status and duration.
Applies to: Enterprise Profitability and Cost Management, FreeForm, Planning, Planning Modules
As part of this feature, a new sub-status component provides the detail of the submitted job. For parent-child job relationships, the parent job displays the current ongoing child job, while each child job features the specific operation being performed as part of its execution.
Image Shows Job Details for a Data Map
Business Benefit: The enhanced job status for pushed data maps and Smart Push enables customers to monitor jobs by providing meaningful details instead of just the processing state and without having to open the details of each individual job. Customers can easily identify when a job is blocked. For example, if the processing state of a Data Map clear on an ASO cube is ongoing and the customer attempts a smart push on the same cube, the sub-status of the smart push job will indicate that the cube is waiting. Additionally, this feature provides real-time progress updates from the target application to the source application.
Tips And Considerations
For Enterprise Profitability and Cost Management customers, sub-status details are only available on the Jobs Detail page and not on the Jobs listing page.
Key Resources
- Checking Real Time Progress Status for Data Maps and Smart Push in Administering Data Integration for Oracle Enterprise Performance Management Cloud
New Connector Option For EPM Cloud To NetSuite Connections
Customers who wish to load data from NetSuite to their application in the EPM Cloud can now use the Oracle EPM Connector SuiteApp to do so. The new connector facilitates the connection between NetSuite and applications in the Oracle Enterprise Performance Management (EPM) Cloud. The Oracle EPM Connector Suite App is available for all EPM Cloud business processes except Oracle NetSuite Planning & Budgeting (NSPB).
Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
This Oracle EPM Connector SuiteApp option is available when the Consumer Key Type is selected as Custom on the NetSuite Connection page when setting up token-based authentications as shown below:
Image Shows the Netsuite Connection Page
For customers who already load data to their EPM Cloud application using NetSuite, the Consumer Key Type default value is NSPB Sync on the NetSuite Connection page.
If you already use NSPB Sync, you should continue to use the NSPB Sync. Otherwise, you should use the EPM Connector.
Business Benefit: The Oracle EPM Connector is a managed SuiteApp. When a new version is available, NetSuite automatically updates the account.
Tips And Considerations
Customers who already use Oracle NetSuite Planning & Budgeting (NSPB) Sync Suite App are not impacted by the new Oracle EPM Connector type.
Key Resources
- Configuring a NetSuite Connection for Token-based Authorizations in Administering Data Integration for Oracle Enterprise Performance Management Cloud
New Upload and Download File Options for File Operations Job Type
The Upload file operation enables to you to copy a file from a local EPM Cloud server to another EPM Cloud server. The Download file operation enables you to copy a file from a remote EPM Cloud server to a local EPM Cloud server. The local EPM Cloud server is the server where the Pipeline process is running.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
To use the Upload and Down file options, you must select a remote connection from the Connection drop-down.
When you download a file, the source directory and source file name identify the remote source directory and file name. The target directory and file name identify to where the file is downloaded locally.
When you upload a file, the target directory and target file name identify the remote target directory and file name. The source directory and file identify from where the file is located locally.
Business Benefit: The Upload and Download files options enable customers to transfer files between remote connection operations. The Copy/Move/Unzip/Delete file operations can only be used between local connections.
Key Resources
- Using a File Operations Job Type in Administering Data Integration for Oracle Enterprise Performance Management Cloud
Run Pipeline Integration Type and Task Type in Task Manager
Task Manager is enhanced with a new Process Automation integration called Run Pipeline. The new integration allows you to incorporate your Data Integration Pipelines within Task Manager business process executions. This integration is available for:
- Local and remote Financial Consolidation and Close, Planning, Planning Modules, and Tax Reporting
- Remote Enterprise Profitability and Cost Management
Applies To: Enterprise Profitability and Cost Management, Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting
Business Benefit: This feature allows you to incorporate Data Integration Pipelines into one business process execution within the EPM application or across multiple EPM applications, thus simplifying the load process.
Key Resources
- Financial Consolidation and Close
- Administering Financial Consolidation and Close
- Tax Reporting
- Administering Tax Reporting
- Planning
- Administering Planning
Ability to Migrate Financial Reporting (FR) Saved Objects to Reports in the Platform
For Reports in the EPM Cloud Platform business processes, you can now migrate Financial Reporting (FR) saved objects (grids, text boxes and images) to Reports.
NOTE: After migrating Financial Reporting saved objects in EPM Cloud Platform deployments, the migrated Shared Reports will need to be opened in edit mode and re-saved to avoid object insertion errors.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Business Benefit: You can now utilize saved objects created in Financial Reporting in Reports.
Key Resources
- Migrating Financial Reporting in EPM Cloud in Designing with Reports for Oracle Enterprise Performance Management Cloud
- Working with Shared Reports and Objects in Designing with Reports for Oracle Enterprise Performance Management Cloud
Group Attributes in Reconciliation Compliance and Transaction Matching
A group attribute is a set of dependent custom attributes, in which each attribute is called a member attribute. An example is a group attribute named Store with member attributes such as Store ID, Store Name, Store Location, Contact Number, and so on. The Store group attribute contains details of multiple stores.
Once a group attribute is defined, one or more of its member attributes can be used when:
- defining profiles
- working with reconciliations
- selecting columns and adding filters
- defining data sources
- validating data during transaction matching loads
- creating adjustment and support attributes
- analyzing data using charts and dashboards
Business Benefit: Group attributes provide an easy and effective way of managing dependent attributes that are related to a single entity. Using group attributes prevents errors when loading or updating a set of dependent attributes.
Key Resources
- Defining Group Attributes in Setting Up and Configuring Account Reconciliation
Additional Profile Attributes in Search Bar, Filters, and Dashboards
Certain additional profile attributes can be used when searching and filtering transactions in the Transactions tab of Transaction Matching. When creating dashboards using the Match Types object, these attributes are available for selection in the Attribute drop-down in the Layout tab.
Business Benefit: This feature enhances search and filter operations by providing additional criteria that can specified.
Key Resources
- Searching Transactions in Transaction Matching in Administering Account Reconciliation
- Selecting Columns While Searching Transactions in Transaction Matching in Administering Account Reconciliation
- Creating Custom Dashboards in Administering Account Reconciliation
New Application Roles for Managing and Viewing Match Types
Two new application roles, Match Types – Manage and Match Types – View, can be assigned to Power Users, Users, or Viewers.
The Match Type – Manage role enables users to manage match types, adjustment attributes, support attributes, journal columns, and group attributes. The Match Type – View role enables users to view details of the match types, adjustment attributes, support attributes, and journal columns.
Business Benefit: Organizations that require certain non-administrative users to manage match types, attributes, and journal columns can use these new roles instead of assigning these users the Service Administrator role.
Key Resources
- Creating Match Types in Setting Up and Configuring Account Reconciliation
A new tutorial is available:
Calculating and Storing the Parent of a Node
This 15-minute hands-on tutorial shows you how to define expressions to calculate a parent and then store that value for each request action where the parent cannot be found based on a property of the source node.
Business Benefit: Tutorials provide instructions with sequenced videos and documentation to help you learn a topic.
Financial Consolidation and Close
Consolidation Journal Enhancements
The size of the Consolidation Journals label has been increased to a maximum of 50 characters. The line item description size has been increased to a maximum of 100 characters.
Business Benefit: The increased label and line item description size provides more flexibility for creating journal labels and descriptions and eliminates problems with larger labels during the copy and clear process.
Key Resources
-
Creating Consolidation Journals in Administering Financial Consolidation and Close
Initiate Enterprise Journal Posting After Preparing Journals
The posting process can now be initiated immediately after preparation is complete, even when the journal has subsequent approver workflow. When defining the workflow option for a journal template, after selecting the Prepare: Approve option, you can select the new Post After Preparation check box that allows the journals created based on this template to be posted as soon as the preparation is complete.
If the approver rejects and the journal is in Post in Process or Posted status, then the journal will be locked. If the approver rejects and the journal is in Ready to Post status, then the posting status can be changed to Not Posted so that the journal can be edited.
Business Benefit: This feature helps to import the journal to the ERP immediately after the preparation is complete even before the journal is approved.
Key Resources
-
Specifying Enterprise Journals Workflow Parameters in Administering Financial Consolidation and Close
Support for Importing Descriptive Flexfields in Enterprise Journals
You can now select the option to import journal attributes to the descriptive flexfields to Cloud Financials when posting journals using Enterprise Journals.
NOTE: Before importing the descriptive flexfields, they must be configured in the Oracle Cloud Financials application.
Business Benefit: Descriptive flexfields are an important part of posting journals to Cloud Financials which can now be utilized when posting journals via Enterprise Journals.
Key Resources
-
Creating Targets for Enterprise Journals in Administering Financial Consolidation and Close
Intercompany Report Display for Shared Entities
When you create an Intercompany Matching report, the intercompany data from shared entities are now included in the report if they are in the selected scope. If the entity is shared, the report displays the member name in the Entity column using the [Parent].[Child] format.
Business Benefit: The Intercompany Matching report now displays the values for shared entities when the ownership percentage is different for primary and shared entities.
Key Resources
- Creating Intercompany Matching Reports in Working with Financial Consolidation and Close
There are no new features in this update except for the applicable features listed in the EPM Cloud Platform section.
There are no new features in this update except for the applicable features listed in the EPM Common section.
There are no new features in this update except for the applicable features listed in the EPM Common section.
A new tutorial is available.
Reporting on Data with Attribute Hierarchies
This tutorial shows you how to report on data with attribute hierarchies. You can view and report on data organized by attribute on the web on forms and dashboards, with MR reports, or in Smart View with ad hoc analysis.
Business Benefits: Tutorials provide instructions with sequenced videos and documentation to help you learn a topic.
Key Resources
- Administering Planning
- Working with Sales Planning
Column Header Names in Valid Intersections and Cell-level Security Export Files to be in English Only
Starting with this update, both Valid Intersection and Cell-level Security import and export files in .XLSX format will support the header column names in English only irrespective of user’s locale.
Applies to: Planning, Planning Modules, FreeForm
Business benefit: Using import and export column names in English ensures the accuracy of these processes.
Key Resources
- Planning and Planning Modules
- Importing and Exporting Intersections in Administering Planning
- Importing and Exporting Cell-Level Security Definitions in Administering Planning
- FreeForm
-
- Importing and Exporting Intersections in Administering FreeForm
- Importing and Exporting Cell-Level Security Definitions in Administering FreeForm
Profitability and Cost Management
There are no new features in this update except for the applicable features listed in the EPM Cloud Platform section. See Oracle Support Document 2955235.1 (Oracle Profitability and Cost Management Application Type Statement of Direction)
Enterprise Profitability and Cost Management
Total Number of Rules Processed Added to the Calculation Statistics Report
The Total Number of Rules Processed is now displayed in the Calculation Statistics report.
Business Benefit: Adding the Total Number of Rules Processed to the Calculation Statistics report will help you as you troubleshoot performance issues in your calculation records.
Key Resources
- Generating a Calculation Statistics Report in Administering and Working with Enterprise Profitability and Cost Management
There are no new features in this update except for the applicable features listed in the EPM Common section.
IMPORTANT Actions and Considerations
One-Week Lag Between Readiness Documents Live and Help Center Live
Because Oracle readiness documents (What's New and New Feature Summary) are live one week before the monthly update is applied to Test environments, some links to documentation included in the readiness documents will not work until after the Oracle Help Center update is complete when the monthly update is applied to Test environments.
In addition to the applicable Important Actions and Considerations discussed in the EPM Cloud Platform section below, this update includes Important Actions and Considerations specific to:
- Account Reconciliation
- Enterprise Data Management
- Financial Consolidation and Close
- Narrative Reporting
- Profitability and Cost Management
- Enterprise Profitability and Cost Management
- Tax Reporting
EPM CLOUD PLATFORM
Default Essbase Query Limit is not Being Changed
In the Previous What's New document, Oracle notified that starting with an upcoming update, the default value of Essbase query limit (the maximum amount of time that an Essbase query can run to retrieve and deliver information) would be set to 900 seconds (15 minutes). Oracle has decided to not implement this change at this time. Thus, Essbase queries continue to be allowed to run indefinitely. However, you can still change this default behavior using the setEssbaseQryGovExecTime EPM Automate command.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Plan to Discontinue Support for Non-Redwood Experience Themes
Oracle's Redwood UX Design is helping organizations improve user productivity, reduce training costs, and increase user satisfaction. As such, it has gained wide adoption across our Oracle Cloud user base.
Within Cloud EPM the Redwood Theme has had significant adoption, and major new platform innovations over the past few years have primarily been released only within the Redwood theme.
Going forward, future innovations in Cloud EPM and Redwood UX Design patterns are likewise targeted to be available within the Redwood theme only. Customers are encouraged to deploy their applications using Redwood theme only.
Towards the end of first quarter of 2024 (subject to change, safe harbor applies), the Redwood Experience will offer a default Oracle theme and these two additional appearance options: Custom Light and Custom Dark. The appearance of all EPM Cloud environments that currently use the Redwood Experience will automatically be shifted to either the default Oracle theme or the Custom Dark theme based on currently deployed background appearance of these environments.
In a later update planned for the second quarter of 2024, Oracle will automatically convert non-Redwood theme environments to the Redwood Experience.
If you're a customer and you're not already using Redwood Experience, you're encouraged to move to the Redwood Experience as soon as possible to take advantage of its user experience advantages.
Customers are encouraged to watch the Cloud Customer Connect session in April 2023: EPM – Why You Should Be Using The Redwood Theme in EPM Cloud
This session covers why users should be adopting the Redwood theme, customizations available within the theme (such as company logo), and the future plans around non-Redwood themes for Cloud EPM.
Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Future Deprecation of Native Mode Option for Smart View Ad Hoc Behavior Application Setting
Many applications on the Oracle EPM Cloud Platform still support Native Smart View Ad Hoc Behavior mode apart from the Standard mode.
Standard is the ad hoc mode upon which all enhancements in the EPM Cloud Platform are being delivered.
Oracle is planning to stop supporting Native mode within the next 6-12 months (March-September 2024 timeframe). Customers on Native mode are advised to convert the Smart View Ad Hoc Behavior application setting for their environments to Standard mode and test their use cases. Any gaps found should to be logged as an enhancement to the Standard mode. Enhancements should be logged in the Customer Connect EPM Platform idea Labs by end of November 2023, for Oracle to review.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Embedding Google Sheets, Google Drive Files, and Microsoft Office 365 Files in Navigation Flows
Customers can embed the third-party pages listed below in EPM Cloud Application navigation flows. Though not supported by Oracle, using instructions provided by the third-party sites, you can embed links to these resources within navigation flow cards, tabs, and sub tabs:
- Google Sheets
- Files stored in Google Drive (for example, PDF and Excel)
- Files stored in Microsoft Office 365
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
For more information about embedding third-party pages in EPM Cloud applications, see the following documentation:
- About Using URLs to Embed Third-Party Pages in EPM Cloud Applications in Administering and Working with Enterprise Profitability and Cost Management
- About Using URLs to Embed Third-Party Pages in EPM Cloud Applications in Administering Financial Consolidation and Close
- About Using URLs to Embed Third-Party Pages in EPM Cloud Applications in Administering FreeForm
- About Using URLs to Embed Third-Party Pages in EPM Cloud Applications in Administering Planning
- About Using URLs to Embed Third-Party Pages in EPM Cloud Applications in Administering Tax Reporting
Plan for the User Variables Dimension Column to Honor the Alias Setting in User Preferences
In a future update, the Dimension column on the User Variables page within User Preferences will honor the Alias Setting in User Preferences. So if an alias name is defined for a dimension, then the Dimension column on the User Variables page will show that dimension’s alias based on the alias table selected in User Preferences. If no alias is defined for the dimension, the dimension name will be displayed.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Transition from Identity Cloud Service (IDCS) to Identity and Access Management (IAM)
EPM Cloud environments on OCI (Gen 2) are transitioning from Identity Cloud Service (IDCS) to Identity and Access Management (IAM) domains. For information on IAM, see Overview of Identity and Access Management.
After this transition, existing IDCS administration and My Profile functionalities remain the same, but are hosted on Oracle Cloud Console. The Oracle Cloud sign-in page has an updated design to match the latest Oracle Cloud design guidelines. To learn more on what to expect with this transition, see Introducing OCI IAM Identity Domains: What customers need to know.
Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Removal of Enhanced Integration API and Drill Type UI Options in Data Management System Settings
As of the June (23.06) update, the Enhanced Integration API and Drill Type UI options have been removed from the list of options in the System Settings option of Data Management.
Formerly, the Enhanced Integration API setting was added temporarily to address backward compatibility considerations.
The Drill Type UI setting formerly enabled users to select either the Classic or Simplified user interface when drilling down in Oracle Enterprise Performance Management. The default drill type user interface is now the Simplified User Interface and the Classic option for the user interface of Drill Landing Page is no longer available.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Announcement: Data Management Feature Migration to Data Integration
The user interface pages listed in the table below are no longer available in Data Management, but are available in Data Integration. Data Integration is available from the Data Exchange card from the home screen in the Cloud EPM Business Process, and users can access these features in the current Cloud EPM update. Data Management is not going away – we are only moving a few features now that have 100% parity with Data Integration. Profitability and Cost Management customers are not affected by the migration and do not see a change in their Data Management user interface. REST APIs are not impacted by this change.
| Data Management | Data Integration | Data Integration Navigation Path |
|---|---|---|
| Source System |
Configure Connections |
From the Data Integration UI, select the Actions drop down, and then Applications. In Applications, there is an icon next to the drop down labeled Configure Connections. |
| Target Application |
Applications |
From the Data Integration UI, select the Actions drop down, and then Applications. |
| Period Mapping |
Period Mapping |
From the Data Integration UI, select the Actions drop down, and then Period Mapping. |
| Category Mapping |
Category Mapping |
From the Data Integration UI, select the Actions drop down, and then Category Mapping. |
Data Integration is the next generation of the Data Management user interface, enabling users to easily build and manage Cloud EPM integrations. As feature parity between Data Integration and Data Management becomes complete, Data Management features will be turned off, and users will use the new Data Integration user interface instead.
This transition is gradual; future What's New documents will include information about the first set of planned changes as well as updates about additional changes planned for the future.
All Data Integration features discussed in this document are currently generally available in the Cloud EPM business processes.
Integration definitions built with Data Management are also visible in Data Integration, which enables an easy transition. (Data Integration is a new user interface on the Data Management data model and does not require migration of content from Data Management to Data Integration).
Please note that additional new integration features will only be included in Data Integration, and will not be back-ported to Data Management. Critical bug fixes and security fixes will still be made to Data Management until all features are fully migrated. In addition, all features from Data Management will be migrated to Data Integration with the exception of the following:
- The batch feature will be replaced by the new Pipeline feature. The Pipeline feature was available in the June (23.06) update.
- The Report Definition feature will not be migrated, only the Report Execution feature. Please note that Account Reconciliation, Financial Consolidation and Close, Planning and Tax Reporting provide a feature to report against the Data Integration relational tables using a custom SQL and a BI Publisher report template via Task Manager.
- The ability to create new Custom Applications in Data Management will no longer available, and customers should use the “Data Export to File” application type instead. (Existing integrations using a custom application will not be impacted.) See Custom Application in Data Management under EPM Cloud Platform in the Important Actions and Considerations section of this document.
For reference, please see the Data Integration guide available from the documentation library for your specific EPM business process. Select the desired business process, then Books, and then scroll down to the Administering Data Integration for Oracle Enterprise Performance Management Cloud documentation link.
Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
See Administering Data Integration for Oracle Enterprise Performance Management Cloud for more information.
Removal of Support for Custom Application in Data Management
Since the September (23.09) update, custom target applications can no longer be added in Data Management. (Existing integrations that use a custom target application will not be impacted, and will still run without any changes.) This type of application was used to extract data from the EPM Cloud, and then the data was pushed into a flat file instead of being loaded to an EPM Cloud application. The custom application was superseded by the Data Export to File feature in an earlier update. The Data Export to File feature has enhanced functions and capabilities.
If you still have a custom target application, it is recommended that you use the Upgrade Custom Applications option to migrate your existing custom target application to a data export to file application. For more information, see Upgrade Custom Applications at: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/erpia/upgrade_custom_applications_100x438d5119.html.
The migration converts existing file formats from the custom target application to the file formats used in the data export to file option and retains all the existing setup. When the custom target application has been converted, you can run same integration as before. Data export file applications are available both in Data Management and Data Integration.
Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Calculation Manager Errors and Warnings Enforcement
In a future update, Calculation Manager will enforce the execution of the Errors & Warnings diagnostic tool for any rule being launched, validated, or deployed from it. If there are errors that result from this new process, Calculation Manager will not execute, validate, or deploy the rule. This new process will apply to all new applications once released. Existing applications will have a finite period of time to bypass this new process to allow you to modify the rules that violate the new Errors & Warnings diagnostic analysis. In all cases, existing rules that are already deployed will continue to run as-is without any change in behavior.
Applies to: Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Change in Behavior for Grids Created from Groovy and REST APIs for ASO Cubes
In a future update, the suppression behavior for grids created via Groovy DataGridDefinitionBuilder and the exportdataslice REST API for ASO cubes will be made consistent with that of the run time data grids created using the Form Designer. Previously, if a grid was built for an ASO cube in Groovy or REST API, then the system used the NON EMPTY MDX clause to suppress missing rows when the suppressMissingBlocks flag was true. Now, when a grid is built for an ASO cube, it will use the NON EMPTY MDX clause when suppressMissingRows is true, and suppressMissingBlocks will be ignored. This means that ASO grids with suppressMissingRows true and suppressMissingBlocks false will now start using MDX. Likewise, ASO grids with suppressMissingRows false and suppressMissingBlocks true will no longer use MDX. Grids where the suppressMissingRows and suppressMissingBlocks flags had the same value will not be impacted. These changes may result in a change in behavior or performance for some ASO grids. If this happens and is undesirable, consider toggling the value of suppressMissingRows from the builder or the JSON payload in case of the REST API.
Applies to: Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Purging of Audit Information
Since the March (23.03) update, audit records older than 365 days are automatically purged. Purged audit records are not stored or accessible. As a best practice, you may want to take a backup of historical audit data. To do this, select one of the following options:
-
Export: Select the Export option on the Actions menu from the Audit card by selecting the appropriate filters.
-
EPM Automate command: Use the exportAppAudit command. See exportAppAudit in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.
-
EPM Automate script: Use the Windows or Linux scripts to automate the process of exporting and archiving application audit data to a local computer. See Automate the Archiving of Application Audit Records in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.
Submit a service request if you encounter problems backing up historical audit data.
Applies to: Financial Consolidation and Close, Tax Reporting
Report Import/Export to Excel: Font Installation Requirements for Text Boxes in Excel
Due to performance and rendering quality enhancements to Report text boxes when exported to Excel, Report text boxes may appear distorted or with overlapping text while importing or exporting to Excel when the fonts used within the text boxes are not installed on the client machine. To fix this, install the missing fonts used within the text boxes on the client machine.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting
Oracle Financial Reporting Statement of Direction
Please refer to the Statement of Direction for Oracle Financial Reporting:
Oracle Support Document 2910806.1 (EPM Cloud Financial Reporting Statement of Direction)
Please note that the Oracle Financial Reporting tentative deprecation dates have been moved to mid-to-late CY24.
For more information:
- See Appendix B in the Designing with Reports Guide: Migrating Reports from Financial Reporting.
- On June 8, the most recent Oracle Cloud Customer Connect event, Migrating Your Financial Reporting to Reports, was presented. There is a presentation, an event recording, and an FAQ sheet accessible. In order to view the event recording and documentation, you must log in to Cloud Customer Connect.
ACCOUNT RECONCILIATION
Reverse Adjustments in Transaction Matching
Starting in a future update, when you unmatch a transaction that was matched with an adjustment, Account Reconciliation will create a reverse adjustment. This reverse adjustment can be posted to ERP using Export Journals.
Change to the Unmatched Transactions Tab
Starting with the October (23.10) update, in the Unmatched Transactions tab of the Matching dialog, the View Supporting Details icon has been removed. To view the supporting details for a transaction, click the link in the Support ID column. The details are displayed in the Supporting Details dialog.
ENTERPRISE DATA MANAGEMENT
Issue with Dates and Times Displaying Year in a 2-Digit Format
Starting in the September (23.09) update, there is an issue with the way dates and times are displayed in the user interface. For some locales, the year is represented in a 2-digit format instead of 4 (for example, DD.MM.YY instead of DD.MM.YYYY). This issue affects the user interface display only, and it will be resolved in a future update.
New Parameter on Transition Request API
Starting in the September (23.09) update, there is a new TransitionWithWarning parameter on the Transition Request to New Status API endpoint. The default value for this parameter is False, which will prevent requests from being submitted, approved, or committed if the request has warnings for custom validations or request attachments with skipped rows. To allow the request to proceed despite these warnings, set the TransitionWithWarning parameter to True.
Key Resource:
-
Transition request to a new status in REST API for Oracle Enterprise Data Management Cloud Service
FINANCIAL CONSOLIDATION AND CLOSE
Enterprise Journal Dimension Persistence
In a future update, all Enterprise Journal dimension attributes will persist their values once they are set in the Journal.
FCCS_Global Assumptions Member
As of the June (23.06) update, the FCCS_Global Assumptions member and its descendants (if any), from the Entity dimension are restricted member(s) for On Demand Rules. Financial Consolidation and Close users won’t be able to use the FCCS_Global Assumptions member and its descendants (if any) as Run Time Prompts (RTPs) while running On Demand Rules.
Future Updates to Ownership Management Locking / Unlocking
Currently there is a single Process Management Approval Unit for all instances of a shared entity. As a result, when data for one instance is Locked in Process Management, all instances are Locked. The same Locking logic will apply to Ownership Management. When data is locked for an Approval Unit POV, Ownership Management settings are also locked for the same Approval Unit POV. As noted above, this link from Process Management Locking / Unlocking to Ownership Management settings can be disabled using a Substitution Variable. Note that this ability to disable the link will be temporary.
When future updates to improve Organization-by-Period functionality are made available, there will be one Process Management Approval Unit for each instance of a shared entity rather than one Approval Unit for all instances. When this is first implemented, the same Locking / Unlocking logic will apply. When the Process Management Approval Unit is locked, then both data and Ownership Management settings will be Locked, but on an instance-by-instance basis for shared entities. At this point, the link between Approval Unit Locking / Unlocking and Ownership Management settings Locking / Unlocking will no longer be able to be disabled. This is to ensure that a change in Ownership settings cannot cause Locked data to be impacted.
A further update will then be implemented to provide a little more flexibility in Locking / Unlocking Ownership Management settings. These settings will be able to be Locked before the Process Management Approval Unit for the same POV is Locked. Ownership Management settings will only be able to be Unlocked if the matching Process Management Approval Unit is unlocked. This will allow users to work on updating data without worrying about ownership settings affecting their results. Again, the link and dependency between Locking / Unlocking data and Ownership Management settings will not be able to be disabled.
Substitution Variables
Substitution variables allow you to enable or disable new Financial Consolidation and Close features as needed. The following substitution variables are available:
- NewLoadYTDClosingBalanceInput
When enabled, Financial Consolidation and Close reverses the YTD closing balance from the prior period, and does not reverse FCCS_Net Income / FCCS_Owner’s Income in the first period. This allows you to be able to load to Closing Balance Input for both Balance Sheet and Income accounts.
Starting in the this update, the default value will be set to True, and this feature will be enabled by default. To disable the feature, you can change the value of the substitution variable to False.
- OBOC_BEFORE_CONFIG_CONSOL
When enabled, the Acquisition and Disposal Movement members will be populated before the Configurable Consolidation rules are run.
Starting in the January 2024 (24.01) update, the default value will be set to True, and this feature will be enabled by default. To disable the feature, you can change the value of the substitution variable to False.
- IncludeSmartListId
When enabled, the LCM export file contains the ID attribute in the Ownership.Data.xml file. When you perform the migration process, LCM will import these IDs to be used as Smart List entry IDs internally.
Starting in the February 2024 (24.02) update, the default value will be set to True, and this feature will be enabled by default. To disable the feature, you can change the value of the substitution variable to False.
- ReportingTransEPAEEA
When enabled, the FCCS_Entity Proportion Adj and FCCS_Entity Elimination Adj members are translated to Reporting Currency.
Starting in the March 2024 (24.03) update, the default value will be set to True, and this feature will be enabled by default. To disable the feature, you can change the value of the substitution variable to False.
Performance Substitution Variables
The OptimizeConcurrency, OptimizePelimCalculation, EnableYearlyConsol, ParallelCustomDimDSO and ParallelCustomDimTranslation substitution variables can be enabled to improve performance.
- OptimizeConcurrency = True
This substitution variable improves concurrency of the consolidation process by executing some of the calculations at the very beginning or at the end. The degree of improvement depends on the entity structure of a given customer. Customers with deeper entity hierarchies will benefit the most.
- OptimizePelimCalculation= True
This substitution variable improves Partner Eliminations (PElim) performance. If there is a consolidation performance degradation when deploying a user-created “Partner Eliminations Configurable Consolidation Rule” that has an account re-direction, adding this variable can provide significant performance improvement.
-
EnableYearlyConsol
= True
The EnableYearlyConsol substitution variable can be enabled to improve performance for multi-period consolidations in applications that use the Dense/Sparse Optimization option (where Period and Movement are the Dense dimensions).
This substitution variable is applicable if the application meets all of these conditions:
- The application uses the Dense/Sparse Optimization option (Period and Movement are Dense dimensions)
- You have two or more dirty periods, and two or more hierarchy levels
- The dirty entities are identical across periods
- Equity Pickup sequence is not enabled
ParallelCustomDimDSO = True
This substitution variable improves the performance of the consolidation process in applications with Dense/Sparse Optimization, where the Period and Movement dimensions are Dense dimensions. To see performance improvements, you should set this substitution variables to True.
ParallelCustomDimTranslation = True
This substitution variable can improve the performance of the consolidation process in applications with Dense/Sparse Optimization, where the Period and Movement dimensions are Dense dimensions. To see performance improvements, you should set this substitution variables to True. If any degradation is noticed, set the variable to False or delete it.
NOTE: The degree of performance improvement varies widely across different applications as it is purely driven by the application design and data distribution.
NARRATIVE REPORTING
Disclosure Management
Consistent with the Oracle Cloud Enterprise Performance Management Narrative Reporting Disclosure Management Statement of Direction (https://support.oracle.com/epmos/faces/DocumentDisplay?id=2762013.1), posted in March 2021, the Disclosure Management card has been officially removed from the user interface in Narrative Reporting 23.11.
PROFITABILITY AND COST MANAGEMENT
Oracle Profitability and Cost Management Application Type Statement of Direction
The Oracle Profitability and Cost Management Application Type Statement of Direction provides an overview of the strategic plans and future direction of Oracle Profitability and Cost Management Cloud Service and Oracle Enterprise Performance Management Enterprise Cloud Service Profitability and Cost Management Business Process. Included is information about the change in Development focus to the newer Enterprise Profitability and Cost Management Application Type available exclusively with Enterprise Performance Management Enterprise Cloud Service.
Oracle Support Document 2955235.1 (Oracle Profitability and Cost Management Application Type Statement of Direction)
ENTERPRISE PROFITABILITY AND COST MANAGEMENT
DataDrill Down
In an upcoming monthly update, the Data Drill Down in Rule Balancing is going to be enhanced to provide interoperable navigation options. When this update is available, you will be able drill down to Smart View or an Ad-Hoc Grid by selecting a rule on the Rule Balancing page. Because of this enhancement, the current hyperlinks displayed for individual rule balances are going to be removed; however, you can still select a single rule and then launch Smart View.
TAX REPORTING
Pillar Two
Pillar Two deferred covered tax supports reconciliation of deferred tax expense per financial statements to deferred covered tax. This information can be used for completion of the GloBE information return. TRCS_DeferredTaxasperBook can be automated to covered tax expense using covered tax automation. TRCS_TotalDefTaxAdj can be used as a parent to add adjustment accounts to determine deferred covered tax expense.