- Revision History
- Overview
- Feature Summary
- Enterprise Performance Management
-
- EPM Common
-
- New Tutorial
- Updates to the Oracle Enterprise Performance Management Cloud Operations Guide
- EPM Automate Updates
- Updates to the Recreate REST API
- REST API for Report Bursting
- REST API Compatibility for Enterprise Profitability and Cost Management
- New Version of Oracle Smart View for Office
- Customization of Logout URL in SSO-Enabled EPM Cloud (OCI Gen 2)
- Formalization of Snapshot States
- Task Manager Integration with Oracle Cloud ERP
- Dynamic Excel Sheet Names for Excel Report Export
- Ability to Delete the First Sheet in Reports
- Ability to Control Chart Label Positioning by Element in Reports
- Groovy Update for Suppression Options
- On Demand Rules in Data Integration
- Quick Mode Data Load Now Available
- Drill Landing Page in Data Integration/Data Management
-
- Account Reconciliation
- Enterprise Data Management
-
- Add Property to Node Types in Property Inspector
- Attributes for Account Dimension in Financial Consolidation and Close Adapter
- Audit Configuration Changes to User and Group Permissions
- Delete Views with All Deleted Viewpoints
- Expanded History for Imports, Exports, and Extracts
- Get Method for Node Collections in Expressions
- Import and Export Templates with Multiple Applications
- Improved Custom Validations for Remove and Delete Actions
- Improved Handling for Subscriptions During Viewpoint Archive and Delete
- Increased Request Item Limit for Subscription Requests
- System Settings for Email Notifications
- Uniqueness Constraints for Selected Properties and Node Types
- Viewpoint Queries on Defined Property Values
-
- Financial Consolidation and Close
- FreeForm
- Narrative Reporting
- Planning
- 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 | Product | Feature | Notes |
|---|---|---|---|
| 21 JUN 2022 | EPM Common | New Version of Oracle Smart View for Office | Updated document. Revised feature description. |
| 07 JUN 2022 | Tax Reporting | Introduction of Quick Start Checklists for Oracle EPM Tax Reporting | Updated document. Added information about a new User Assistance resource. |
| 31 MAY 2022 | Profitability and Cost Management | New Enterprise Profitability and Cost Management Application | Updated document. Revised feature description. |
| 26 MAY 2022 | 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, June 3, 2022.
Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 17, 2022.
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, June 3, 2022.
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 will be posted to My Oracle Support.
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 take our quick survey or 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.
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.
Follow EPM Cloud on YouTube, Twitter, Facebook, and LinkedIn.
These are great resources for the latest updates and information about EPM Cloud.
A new tutorial is available.
Performing Calc on the Fly in Cloud EPM
In this tutorial, you learn how to perform calc on the fly during ad hoc analysis using member formulas. You can work with calc on the fly within FreeForm, Planning and Planning Modules either in the web or with Smart View.
Applies to: FreeForm, Planning, Planning Modules
Business Benefit: Tutorials provide instructions with sequenced videos and documentation to help you learn a topic.
Updates to the Oracle Enterprise Performance Management Cloud Operations Guide
The Oracle Enterprise Performance Management Cloud Operations Guide has been updated with information on managing the export of EPM Cloud Smart List textual data during daily maintenance of environments. Export of this data in environments containing a high volume of data can cause the daily maintenance process to exceed the schedule maintenance window. Additionally, the "Getting Help" topic in troubleshooting sections have been enhanced to gather information on whether an issue started after the latest monthly update.
Applies to: Account Reconciliation, Enterprise Data Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Enterprise Profitability and Cost Management, Tax Reporting
Business Benefit: Information in the EPM Cloud Operations Guide helps you troubleshoot issues and report issues and requests to Oracle.
Key Resources
A new version of EPM Automate is now available. This version introduces the calculateModel, groupAssignmentAuditReport, and runIntegration commands. This version also contains changes to the recreate command. Additionally, the behavior of commands used to manage users, Access Control groups, and roles (addUsers, addUsersToGroup, addUserToGroups, assignRole, createGroups, deleteGroups, importSnapshot, removeUsers, removeUserFromGroups, removeUsersFromGroup, unassignRole, and updateUsers) have been updated so that the values of User Login, Group Name, and Role Name parameters are now treated as case insensitive. Further, the EPM Automate documentation has been updated to identify the commands that work with the Enterprise Profitability and Cost Management application.
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
calculateModel Command
This command calculates models in Enterprise Profitability and Cost Management applications.
groupAssignmentAuditReport Command
This command creates a report listing users and groups that were added to or removed from Access Control groups for a specified date range. Each row of the generated CSV file identifies the user or group that was added or removed, the group which the user or group was added to or removed from, the Service Administrator who performed the action, and the date and time when the action was completed.
A Sample groupAssignmentAuditReport
runIntegration Command
This command executes a Data Integration job to import data into an EPM Cloud business process or export data from a business process to an external system.
Updates to the recreate Command
This command has been enhanced to convert a Profitability and Cost Management environment to Planning, Enterprise Planning, or an Enterprise Profitability and Cost Management environment.
Updates to the Behavior of Commands Used to Manage Users, Access Control Groups, and Roles
The following commands have been updated to to ignore the case in which User Login, Group Name, and Role Name values are specified in the input text files. For example, the value of User Login John.doe@example.com is treated as being identical to John.Doe@example.com or any variation in its case.
- addUsers
- addUsersToGroup
- addUserToGroups
- assignRole
- createGroups
- deleteGroups
- importSnapshot
- removeUsers
- removeUserFromGroups
- removeUsersFromGroup
- unassignRole
- updateUsers
Business Benefit: The calculateModel command enables you to automate the calculation process in Enterprise Profitability and Cost Management.
The groupAssignmentAuditReport command can be used to support security audit operations in conjunction with the roleAssignmentAuditReport command.
Update to the recreate command helps you upgrade your Profitability and Cost Management environment to create an Enterprise Profitability and Cost Management business process..
Updates to the behavior of Manage Users, Access Control Groups, and Roles commands prevent duplication errors caused during the update of these artifacts.
Key Resources
- Working with EPM Automate for Oracle Enterprise Performance Management Cloud:
- Installing EPM Automate
- calculateModel
- groupAssignmentAuditReport
- recreate
- addUsers
- addUsersToGroup
- addUserToGroups
- assignRole
- createGroups
- deleteGroups
- importSnapshot
- removeUsers
- removeUserFromGroups
- removeUsersFromGroup
- unassignRole
- updateUsers
Updates to the Recreate REST API
You can now use the Recreate REST API to support the conversion of legacy Profitability and Cost Management environments to Planning, Planning Modules, or Enterprise Profitability and Cost Management environments. You can also recreate such converted environments to the original Profitability and Cost Management environments.
Applies to: Enterprise Profitability and Cost Management, FreeForm, Planning, Planning Modules, Profitability and Cost Management
Business Benefit: This lets you upgrade your Profitability and Cost Management environment to an Enterprise Profitability and Cost Management environment.
Key Resources
- Run Recreate on a Service in REST API for Oracle Enterprise Performance Management Cloud
Role Information
- Service Administrators
Customers can now execute bursting for a single report or book for more than one member of a single dimension, and publish a PDF or Excel output for each member.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Business Benefit: This lets you use a REST API to automate bursting.
Key Resources
-
Manage Jobs in REST API for Oracle Enterprise Performance Management Cloud
Role Information
- Service Administrators
REST API Compatibility for Enterprise Profitability and Cost Management
In the REST API for Oracle Enterprise Performance Management Cloud guide, the Quick Reference and Compatibility topics now include a heading for Enterprise Profitability and Cost Management.
Applies to: Enterprise Profitability and Cost Management
Business Benefit: This gives you an easy way to determine which REST APIs you can use for Enterprise Profitability and Cost Management environments.
Key Resources
- REST API for Oracle Enterprise Performance Management Cloud:
Role Information
- Service Administrators
New Version of Oracle Smart View for Office
Oracle Smart View for Office version 22.100 will be available soon.
Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
The following new features are included:
- Show or hide the Documents folder in the EPM Cloud Library
- Set and export default Smart View options in the Options dialog box
- New cell styles for Parent and Child members
- Support for a new EPM Cloud business process, Enterprise Profitability and Cost Management
- Enhanced Reports functionality, including:
- Create an ad hoc grid based on an imported report
- View properties for a report
- For Narrative Reporting users, Reports functionality no longer requires the Narrative Reporting extension (starting with the 22.06 Narrative Reporting extension update)
- Microsoft WebView2 and Edge support for importing Financial Reporting documents
- Microsoft .NET Framework Version now displayed in the Health Check dialog
Business Benefit: This Smart View release includes new features and fixed defects.
Steps to Enable
Download and install Smart View. See Downloading and Installing Clients in Getting Started with Oracle Enterprise Performance Management Cloud.
Key Resources
- Documentation updates will be available when 22.100 is generally available.
Customization of Logout URL in SSO-Enabled EPM Cloud (OCI Gen 2)
Starting with this update, you can use a custom logout URL for SSO-Enabled EPM Cloud OCI (Gen 2) environments. This feature allows you to specify a custom page of your choice (usually an identity provider page) as the landing page when you sign out. This custom logout page is maintained even if you recreate your environment.
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: Using a custom logout page helps you redirect users to a web page of your choice instead of the default page.
Key Resources
- Customizing Logout URL for SSO-Enabled OCI (Gen2) Environments in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators
Formalization of Snapshot States
EPM Cloud now uses standardized snapshot states to identify artifact export and archive operations in progress, for example, during the daily maintenance of the environment. EPM Cloud uses the snapshot state to display appropriate messages when you use EPM Automate commands that perform snapshot-related operations (copySnapshotFromInstance, cloneEnvironment, deleteFile, downlodFile, listFiles, and renameSnapshot) and the Clone Environment feature.
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
For example, if you attempt to clone an environment that is in the process of generating or archiving the current snapshot (Artifact Snapshot) during the daily maintenance, you will receive the File not found error. This error will also be displayed if you use the copySnapshotFromInstance, cloneEnvironment, deleteFile, downlodFile, listFiles, and renameSnapshot command while the daily maintenance of the environment is in progress.
Business Benefit: This update helps identify why a snapshot is not available during certain operations.
Key Resources
- Administering Migration for Oracle Enterprise Performance Management Cloud
- Working with EPM Automate for Oracle Enterprise Performance Management Cloud
Task Manager Integration with Oracle Cloud ERP
Task Manager has improved the current end user integrations with Oracle Cloud ERP. Now, the majority of the Oracle Cloud ERP web pages are displayed inline within the Task. Users no longer are required to click a link to launch the Oracle Cloud ERP web pages within a secondary browser control. The inline display simplifies the user interaction and improves the overall user experience. Additionally, the Oracle Fusion R13 integration applications are renamed to replace Oracle Fusion R13 with Oracle Cloud ERP. For example, Oracle Fusion R13 - General Ledger is now Oracle Cloud ERP – General Ledger.
Applies to: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting
Business Benefit: This updated capability provides an improved user experience for Task Manager and Oracle Cloud ERP users.
Key Resources
- Administering Financial Consolidation and Close:
Dynamic Excel Sheet Names for Excel Report Export
When downloading a Report to Excel (fully formatted) from the web, or importing a Report in Smart View, the worksheet names will reflect the report name followed by the first POV dimension with Print All Selections, truncating the sheet name as needed to meet Excel’s 31 character limit.
NOTE: "Print All Selections" must be enabled for one or more of the report’s POV dimensions.
Downloading a Report to Excel
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting
Business Benefit: This feature helps you to retain and differentiate the sheet name based on the POV selection.
Key Resources
- Working with Reports in Smart View in Working with Reports for Oracle Enterprise Performance Management Cloud
Ability to Delete the First Sheet in Reports
You can quickly delete the first sheet if there are at least one or more visible sheets. The body objects are deleted, and the header and footer objects from the first sheet are moved to the second one.
Quickly Delete the First Sheet
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting
Business Benefit: This provides additional flexibility for Report Administrator to delete unwanted sheets with ease.
Key Resources
- Designing with Reports for Oracle Enterprise Performance Management Cloud
Ability to Control Chart Label Positioning by Element in Reports
Previously, you could only set the chart label positioning for all elements in a chart, but not at the chart element level.
In this update, you will be able to optionally set the label location for each individual element in the chart.
NOTE: This feature only applies to the bar, line, and combo charts.
Label Location
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting
Business Benefit: This feature helps you set the Label Location in the Options section, which applies to all data set elements in the chart.
Key Resources
- Chart Properties in Designing with Reports for Oracle Enterprise Performance Management Cloud
Groovy Update for Suppression Options
When using Groovy with EPM, you can now use suppression options in DataGridDefinitionBuilder. To use Groovy business rules, follow the steps to create a Groovy business rule in "Creating a Groovy Business Rule" in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud.
This feature can be used by any application that has access to Groovy.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
Business Benefit: This gives you more options when using Groovy business rules.
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.
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
Role Information
- Calculation Manager Business Rule Designer
On Demand Rules in Data Integration
You can now invoke On-Demand Rules (ODR) as part of the Data Integration workflow process. The ODRs available in Data Integration are defined in Financial Consolidation and Close or Tax Reporting. If you want an ODR to be executed for a specific integration, then register the ODR on the Integration Options page. If you want the ODR to be executed for all integration loading data to the application, then register the ODR on the Application page. If a given Event has an ODR registered at both the integration and application levels, only the ODR registered on the Integration Options page is executed.
Applies to: Financial Consolidation and Close, Tax Reporting
Events are shipped out of the box and include:
- Before Import
- After Import
- Before Load
- After Load
- Before Check
- After Check
Business Benefit: You can perform business functions embedded in ODRs as part of the Data Integration workflow process instead of executing these steps manually.
Key Resources
-
Registering and Using Business Rules in Administering Data Integration for Oracle Enterprise Performance Management Cloud
Quick Mode Data Load Now Available
For Financial Consolidation and Close and Tax Reporting customers, the Quick Mode Data Load method provides significant performance improvement over the standard workflow method. It supports simple transformations using import expressions and does not support member mappings. Data is not loaded to a staging table so you cannot view the data in Workbench. Period processing in Quick Mode does not use periods defined in the Period Mapping option. Instead periods are handled like other dimensions.
Applies to: Financial Consolidation and Close, Tax Reporting
Business Benefit: The primary benefit of this method is that it enables you to load large data volumes faster than the non-quick load method. This feature also helps eliminate timeout issues when loading large data volumes.
Key Resources
- Administering Data Integration for Oracle Enterprise Performance Management Cloud
Drill Landing Page in Data Integration/Data Management
In Data Integration/Data Management, the Enhanced Drill Landing page is now the default starting page.
Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting, Profitability and Cost Management
Starting with the 22.09 update, the option to switch the Drill Type user interface will no longer be available, and the Enhanced version will be the only version available.
Business Benefit: The Enhanced Drill Landing page enables customers to select a custom view of columns without additional configuration.
Key Resources
- Using Drill Through to Source in the Administering Data Integration for Oracle Enterprise Performance Management Cloud
Due Date for a Reconciliation Includes Hours and Minutes
In the Reconciliation Actions dialog, the Days Until Due field also shows hours and minutes when a reconciliation is due in less than two days.
Business Benefit: This feature helps reviewers or preparers understand the exact amount of time in which a reconciliation is due.
Key Resources
- Preparing Reconciliations in Administering Account Reconciliation
Add Property to Node Types in Property Inspector
A property can be added to node types of applications directly from the Property inspector. This allows you to assign the property to one or more node types of the same or different applications without having to navigate to each Node Type inspector. Application and node type overrides for the parameters of the property can then be defined in the Property inspector to complete any remaining configuration necessary.
Business Benefit: When overriding property parameters at the application or node type level, it is a convenience to add the property to applications and node types directly from the Property inspector.
Key Resources
- Editing Property Parameters in Administering and Working with Oracle Enterprise Data Management Cloud
Attributes for Account Dimension in Financial Consolidation and Close Adapter
Attributes can be managed for the Account dimension of a Financial Consolidation and Close application in Enterprise Data Management. During registration of a Financial Consolidation and Close application, the Define Attributes screen is now available for Account dimensions where attributes can be set up as a Simple Attribute or an Attribute Dimension.
Business Benefit: The same attribute management functions for the Account dimension are available as were previously for the Entity, Custom, and Movement dimension types.
Key Resources
- Understanding Attributes in Administering and Working with Oracle Enterprise Data Management Cloud
Audit Configuration Changes to User and Group Permissions
Configuration changes to user and group permissions can be audited for governance and reporting purposes. The Permissions tab of the Audit page displays changes to permissions for all applications and their data chains. You can filter the results by data chain object, view, user, and time frame.
Business Benefit: Auditing permissions enables organizations to identify changes to user security over time for governance and compliance reasons.
Key Resources
- Auditing Permissions in Administering and Working with Oracle Enterprise Data Management Cloud
Delete Views with All Deleted Viewpoints
Views can now be deleted if they previously contained active viewpoints which were later archived and deleted. The view is deleted if it only contains deleted viewpoints. These views could not be deleted in previous releases.
Business Benefit: Views that were configured for a specific purpose which is no longer necessary may need to be deleted to minimize the number of views in an Enterprise Data Management environment.
Key Resources
- Archiving and Deleting Views in Administering and Working with Oracle Enterprise Data Management Cloud
Expanded History for Imports, Exports, and Extracts
History for imports, exports, and extracts has been expanded to display the last 5 jobs which were run for a selected dimension or viewpoint. This gives greater visibility to the frequency and status of these operations over a period of time.
Business Benefit: The expanded history provides a better understanding of when import, export, and extract jobs are run and the success rate of those operations.
Get Method for Node Collections in Expressions
A Get method is available for node collections such as Ancestors, Children, Locations, and Siblings to access a node object based on its position in a node collection using an expression.
Business Benefit: This can be useful in cases where you want evaluate or return information for the first or last node in a node collection.
Key Resources
- Node List in Administering and Working with Oracle Enterprise Data Management Cloud
Import and Export Templates with Multiple Applications
Templates can contain multiple applications and their related artifacts from a source environment. During template export, you can select multiple applications to include in a template file. When previewing or importing a template, dependencies between those applications, such as node type converters and subscriptions, can be now be resolved instead of resulting in a warning or error.
Business Benefit: Migrating applications which have dependencies between each other across Enterprise Data Management environments may require both applications to be included in a template to ensure those dependencies can be resolved in the target environment where the template is previewed or imported.
Key Resources
- Working with Templates in Administering and Working with Oracle Enterprise Data Management Cloud
Improved Custom Validations for Remove and Delete Actions
Custom validations which use the Remove and Delete trigger actions have been improved to prevent requests from being submitted, approved, or committed when nodes have been removed or deleted in a request.
Business Benefit: Business rules specific to the removal or deletion of a node can be enforced in the context of a request to prevent those changes from being applied.
Improved Handling for Subscriptions During Viewpoint Archive and Delete
When archiving a viewpoint which is used as a source viewpoint for a subscription, the user is notified that a subscription will be affected. When a viewpoint which has subscriptions is archived, the subscriptions for that viewpoint are now disabled. This allows the viewpoint to be deleted without individually disabling its subscriptions.
Business Benefit: Provides a better experience when archiving and deleting viewpoints referenced in a subscription.
Key Resources
- Archiving, Unarchiving, and Deleting Viewpoints in Administering and Working with Oracle Enterprise Data Management Cloud
Increased Request Item Limit for Subscription Requests
The request item limit for a subscription request has been increased to 12,000 items to accommodate the processing of descendants for nodes which were inserted or moved in a hierarchy viewpoint in the original request.
Business Benefit: This increase is necessary to ensure synchronization of descendant nodes between the source and target viewpoints for a given subscription.
Key Resources
- Request Types and Process Flow in Administering and Working with Oracle Enterprise Data Management Cloud
System Settings for Email Notifications
System settings are available for email notifications to control certain behavior such as:
- Whether or not notifications are sent
- A prefix to the email subject to identify the environment from which a notification has been sent
- A substitute recipient which should receive all notifications instead of the primary recipient(s)
System settings are restricted to Service Administrator role users and configured on the Settings page of the user interface.
Business Benefit: The email notification settings provide options to customize the behavior of notifications in Enterprise Data Management.
Key Resources
- Configuring System Settings in Administering and Working with Oracle Enterprise Data Management Cloud
Uniqueness Constraints for Selected Properties and Node Types
Uniqueness constraints can now be setup on any defined property in an application. A new Node Type Uniqueness constraint type is also available to check the uniqueness of a property value across a specified set of node types within an application.
Business Benefit: Uniqueness can be enforced on any defined property of an application, dimension, or a set of node types using a constraint.
Key Resources
- Working with Constraints in Administering and Working with Oracle Enterprise Data Management Cloud
Viewpoint Queries on Defined Property Values
Queries enable you to find nodes in a selected viewpoint whose properties match certain criteria. You can query all nodes in any viewpoint or below a selected node in a hierarchy viewpoint. One or more query filters can be added to narrow the scope and limit the number of query results returned. Query results are displayed next to the viewpoint and you can navigate from a result to its corresponding node in the viewpoint for more information and to take further action.
Viewpoint queries are limited to the following properties in this release:
- Properties with defined values which use a Default Type = None
- All property data types except for the Node data type
- Certain properties in the Core and CoreStats namespaces which have stored values
- Derived and Inherited properties are not available for selection
Business Benefit: Find nodes in viewpoints based on one or more filters using defined node and relationship properties. This allows nodes in a viewpoint to be identified based on other properties than Name or Description.
Key Resources
- Querying a Viewpoint in Administering and Working with Oracle Enterprise Data Management Cloud
Financial Consolidation and Close
Referential Integrity for Configurable Consolidation Rules
To prevent a referential integrity problem with configurable consolidation rules from occurring in the application, Financial Consolidation and Close Cloud verifies and prevents the deletion of a consolidation method if it is referenced in a configurable consolidation rule.
Business Benefit: Referential integrity checks prevent potential errors when the consolidation method has been updated or deleted.
Key Resources
-
Modifying Consolidation Methods in Administering Financial Consolidation and Close Cloud
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 variable 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 variable to True. If any degradation is noticed, you should delete this variable.
Business Benefit: These substitution variables help in improving performance.
NOTE: The degree of performance improvement varies widely across different applications as it is purely driven by the application design and data distribution.
There are no new features in this update except for the applicable features listed in the EPM Common section.
Removal of File Transfer Utility (EPMCTRL)
The removal of the File Transfer Utility, as previously planned for last month, was delayed by one month. In this update, the File Transfer Utility will be removed from the User Menu > Downloads section. Customers can continue to run previous versions of the File Transfer Utility until the August (22.08) update. Thereafter it will be entirely removed from the server and commands will no longer work.
Customers should use EPM Automate, which includes all the commands currently available in the File Transfer Utility (EPMCTRL), going forward. If you have any concerns about this change, please contact Oracle Support.
For more information, see Oracle Narrative Reporting File Transfer Utility Statement of Direction (Oracle Support Document 2835672.1)
NOTE: The commands for deprecated features, such as the Narrative Reporting Application and Disclosure Management are not supported in EPM Automate.
Business Benefit: EPM Automate enables you to remotely perform many tasks within Oracle Enterprise Performance Management Cloud environments.
Key Resources
- Working with EPM Automate for Oracle Enterprise Performance Management Cloud:
In this release, a new sample report, Sample Report 11 (Saved Selections) has been added and this sample report contains two grids with the Fiscal Calendar dimension in the columns, where the member selections are driven by a Saved Selection.
NOTE: A service administrator must install Samples before you can access the sample content.
Sample Report 11 (Saved Selections)
Business Benefit: Helps Report Designers to explore the “Saved Selections” using prompts.
Key Resources
- Installing Samples in Administering Narrative Reporting
- Reviewing the Sample Reports in Designing with Reports for Oracle Enterprise Performance Management Cloud
Updated Narrative Reporting Extension for Smart View
An updated Narrative Reporting extension for Oracle Smart View for Office is now available to download and install. This update includes a change in access to the Reports commands when connected to Narrative Reporting, along with general improvements and bug fixes.
Following are the recommended combinations and functionality available with different Smart View versions (the current 21.200 version and the upcoming 22.100 version), Narrative Reporting extension versions, and Narrative Reporting server versions:
| Smart View Version |
Narrative Reporting Extension Version |
Narrative Reporting Server Version |
Notes |
|---|---|---|---|
| 21.xxx | 22.04 | 22.05/22.06 | Narrative Reporting extension 22.06 moves the Reports import functionality to the Smart View ribbon in Smart View 22.100. Oracle recommends staying on the 22.04 extension until upgrading to Smart View 22.100 |
| 22.100 | 22.04 | 22.05 | Using Smart View 22.100 with the 22.04 extension and 22.05 Narrative Reporting server is an unsupported combination |
| 22.100 | 22.06 | 22.06 | This is the recommended combination |
Business Benefit: Downloading and installing the latest Narrative Reporting extension for Smart View gives you access to the latest features, improvements, and bug fixes.
Key Resources
- Installing the Narrative Reporting Extension in Working with Oracle Smart View for Office
Plot Missing Values as Zero in Dashboards 2.0 Charts
Dashboards 2.0 now supports the Plot Missing Values as Zero setting for certain chart types.
By default, missing or suppressed data is plotted as zeros. For certain chart types (Area, Bubble, Combination, Line, Radar, and Scatter), you can disable this setting by clearing the Plot Missing Values as Zero option in the chart's settings. When this option is cleared, the missing or suppressed data is ignored and is no longer plotted for those chart types.
Business Benefit: Bringing this Dashboards 1.0 functionality into Dashboards 2.0 provides an improved and consistent user experience.
Key Resources
- Concepts in Designing 2.0 Dashboards in Administering Planning
- Using Dashboards to Work with Data in Working with Planning
Support for In-Place Conversion of an EPM Cloud Service Application from Standard to Enterprise
You can now perform a conversion of an EPM Standard Cloud application to an EPM Enterprise Cloud application from within the Standard application.
Note: Only customers who have purchased an EPM Enterprise Cloud license can convert from Standard to Enterprise. You will be asked to confirm that you have an Enterprise order ID to complete the conversion.
Customers who upgrade to Enterprise have access to more custom cubes, increased customization thresholds, and can access Enterprise-only features such as Groovy rules and IPM Insights. After an application is converted to Enterprise, you cannot convert it back to Standard.
To convert an application from Standard to Enterprise, click Application, click Overview, click the Actions menu, and then select Convert to Enterprise. Confirm that you have the Enterprise order ID, and then click Convert to Enterprise to complete the conversion process.
Business Benefit: We've made it easier to upgrade your EPM Cloud Service application from Standard to Enterprise by providing an in-place conversion option.
Key Resources
-
Converting an EPM Standard Cloud Service to EPM Enterprise Cloud Service in Administering Planning
Updated Financials Prepare Forecast Rule
In Financials, the Prepare Forecast rule is updated so that data is cleared from all Plan Element members for closed periods in the Forecast scenario Working version before copying actuals data to the Forecast scenario.
Business Benefit: The updated rule ensures that the calculation works correctly and the forecast numbers (entered using direct entry method) don’t get added to actuals for closed periods.
Tips And Considerations
The new rule behavior is visible only if you enable any additional features, re-enable Financials, or import or export a snapshot.
Key Resources
- Administering Planning Modules
Profitability and Cost Management
Enterprise Profitability and Cost Management
New Enterprise Profitability and Cost Management Application
Users of the EPM Cloud Suite will now have access to Enterprise Profitability and Cost Management.
NOTE: Enterprise Profitability and Cost Management applications are separate and independent from Profitability and Cost Management applications. There is no impact to Profitability and Cost Management applications or environments.
Enterprise Profitability and Cost Management (EPCM) is an evolutionary step forward for Oracle Cloud EPM's Profitability and Cost Management business process. With a revamped business modeling process that incorporates customer best practices, along with the addition of powerful reporting, integration, and application management tools of the Cloud EPM Platform, Enterprise Profitability and Cost Management is a dramatic leap forward for the Profitability and Cost Management business process.
Redesigned Modeling Interfaces
Updated Reporting and Analysis
Business Benefit: The Enterprise Profitability and Cost Management modeling interfaces are redesigned to provide better support of modeling best practices. The application management and analytics interfaces use EPM Cloud standard tools and make cross EPM integration efforts easier. Additional Profitability and Cost Management cubes support separate calculation, reporting and data staging cubes.
Key Resources
- Enterprise Profitability and Cost Management Guide
- Documentation Library
- Videos:
Overview of Enterprise Profitability and Cost Management - This overview shows you how Enterprise Profitability and Cost Management can help unburden your general ledger and speed up your financial close, while providing transparency and traceability to your operational and management reporting.
Getting Started with Enterprise Profitability and Cost Management - This overview introduces you to the Enterprise Profitability and Cost Management user interface. You learn where to manage applications and data. You also learn where to set up models, rule sets, and rules, and where to validate models, run calculations, view calculation details, and view rule balancing reports. You learn how to access data analysis tools like profit curves, allocation trace, data forms, reports, dashboards, and infolets. You also learn how to download Smart View and EPM Automate. You also learn where to access administration tools and how to access the Academy page.
- Models and Modeling in Enterprise Profitability and Cost Management - This overview introduces you to the key concepts of data modeling in Enterprise Profitability and Cost Management. You learn what models and rules are, the differences between allocation rules and custom rules, what model validation checks for, how model calculations work, where to review your calculation history, and how Rule Balancing provides a high-level view of your calculations and links to Smart View for further investigation
Analyze Data in Enterprise Profitability and Cost Management - This overview introduces you to all the ways you can analyze data from Enterprise Profitability and Cost Management.
Creating Applications in Enterprise Profitability and Cost Management - In this video, you learn how to create applications in Enterprise Profitability and Cost Management.
Profitability and Cost Management
New Migrate to Enterprise Profitability and Cost Management Card in the Application Cluster
There is a new card in the Application cluster called Migrate to EPCM. It has steps that you can follow to generate a special snapshot of your Profitability and Cost Management application that can be imported into Enterprise Profitability and Cost Management.
Business Benefit: Provides a way to migrate from Profitability and Cost Management to Enterprise Profitability and Cost Management.
Key Resources
- Migrating from Profitability and Cost Management to Enterprise Profitability and Cost Management in Administering Profitability and Cost Management
There are no new features in this update except for the applicable features listed in the EPM Common section. Please be sure to review the Important Actions and Considerations section for Audit Purge related information.
Introduction of Quick Start Checklists for Oracle EPM Tax Reporting
Wondering how to start using Tax Reporting? Use these checklists on your first day. Follow the steps to do initial tasks like set up your environment, log in, enter data, analyze forms, and use reports. The checklists are organized by predefined roles for Service Administrators, Power Users, Users, and Viewers.
Tax Reporting Quick Start Checklists
Business Benefit: These quick start checklists help you learn how to speed up your first day using Tax Reporting.
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.
EPM COMMON
Rolling Back Changes Made to Page Title Display for Horizontal tabs
We are rolling back changes that were made in the April 22.04 update to the page title for horizontal tabs. The change was to not display the page title in horizontal tabs while using the Redwood Theme. From the feedback received on this change, we've decided to roll it back. The change will be available in the July (22.07) update.
Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting
Loaner Program for Cloud Infrastructure Generation 2 Testing and OCI Migration Assistance Early Adopter Program
Oracle EPM Cloud is now live on Oracle Cloud Infrastructure (OCI) Gen 2 environments. If you are interested in testing your application performance on an OCI environment, open a service request following the process at https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/tsepm/op_procs_loaner_envs.html and request for a loaner environment in an OCI data center for a duration of 30 days with the business justification as “Want to test application performance in an OCI Gen 2 data center”.
After you have performed the testing, submit Provide Feedback from the loaner environment. Create a service request using the normal support process, if you have any issues or feedback for the OCI environment. For more information, see What is a Gen 2 Cloud?
Additionally, Oracle has instituted a program to assist a limited number of early adopters on Oracle Cloud Classic to migrate to OCI. For more information, see Oracle Cloud Classic to Oracle Cloud Infrastructure (OCI) Migration Assistance Program for Early Adopters.
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
Alerts Cannot be Migrated to Prior Version
Due to a major upgrade in Alert functionality, any service that has defined Alert Types will not be able to migrate them or the Alerts that are based on them from the 22.04 update to an earlier update. This normally happens if artifacts are moved from Test to Production during the two week period when Test is upgraded to the 22.04 update while Production is still on the 22.03 update. All other objects in the migration are not affected.
Applies to: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting
Task Manager Email Notification Settings
Starting in the 22.04 update, the service changed the handling of Task Manager’s Email Notification settings during a migration. The target service’s Task Manager Email Notification settings were updated with the settings from the source service. If a customer wants to retain the target service’s Task Manager Notification settings, they can generate an LCM export with the notification settings from the target service, perform the source migration, then import the LCM file with the notification settings.
Applies to: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting
See LCM Export and LCM Import in REST API for Oracle Performance Management Cloud.
Date Format when Using the EPM Digital Assistant
When using the EPM Digital Assistant, note that the Date format is not taken from User Preferences, and the assistant does not ask which format to use for the date. The assistant attempts to detect the date format based on the user locale set in the browser and other common formats.
Applies to: Account Reconciliation, Financial Consolidation and Close, Planning, Planning Modules,Tax Reporting
Removing Dimensions Before Rebasing a Financial Consolidation and Close or Tax Reporting EPM Digital Assistant Skill
If you want to rebase your Financial Consolidation and Close or Tax Reporting skill to use the 21.11 update of EPM Digital Assistant, note that you must first remove some dimensions before rebasing.
- Financial Consolidation and Close dimensions to be removed before rebasing: Scenario, Years, Period, Entity, Account, Currency, View, Consolidation, Data Source, Multi-GAAP, Intercompany and Movement
- Tax Reporting skill dimensions to be removed before rebasing: Cube, Scenario, Years, Period, Entity, Account, Currency, View, Consolidation, Data Source, Multi-GAAP, Intercompany, Movement and Jurisdiction
Applies to: Financial Consolidation and Close, Tax Reporting
See Removing a Consolidation and Close or Tax Reporting Custom Dimension from an Extended Skill in Getting Started with the Digital Assistant for Oracle Cloud Enterprise Performance Management.
Performing Calculations Without Having to Submit Your Changes (Calc on the Fly)
In a future update, Financial Consolidation and Close and Tax Reporting will support calc on the fly. While the Application Settings option Enable User Formulas in Ad Hoc is available in this update, the feature is not yet supported for these products.
Applies to: Financial Consolidation and Close, Tax Reporting
Drill Landing Page in Data Integration / Data Management
The Enhanced Drill Landing page is the default starting in this update. Starting with the 22.09 update, the option to switch the Drill Type user interface will no longer be available, and the Enhanced version will be the only version.
Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting, Profitability and Cost Management
Upcoming Change to Planning Admin Extension Installation
In a future update, the installation process and file format will change for the Planning Admin Extension for Oracle Smart View for Office (also referred to as the Smart View Add-on for Administrator). This will not impact current and future usage of Admin Extensions that are already installed.
Currently, an MSI file is downloaded from the Downloads page of the supported business process. The new process will utilize an SVEXT file and allow users to take advantage of the extension update feature in the Smart View Options dialog, Extensions tab.
To use the new SVEXT file format when it becomes available, you are required to first uninstall the Planning Admin Extension using Windows Programs and Features. Then, you can install the new Planning Admin Extension SVEXT file in either of these ways:
- Download the SVEXT file to a temporary folder and double-click it.
- Use the "Check for Updates, New Installs, and Uninstalls" feature in the Smart View Options dialog, Extensions tab to automatically detect and install the Planning Admin Extension
Look for this change in the file format and the installation of the Planning Admin Extension in a future EPM Cloud update.
Applies to: Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
ACCOUNT RECONCILIATION
Data Management Option in the Clone Environment Screen
The Data Management option in the Clone Environment screen of the Account Reconciliation business process does not work. Consequently, this option has been disabled in this update. Oracle will enable this option in a future update.
New Job execution Routine
In a future update, a new Job execution routine will be implemented which will prevent any new Jobs from starting when the application snapshot export is executing. These Jobs will be shown with a “Delayed” status and will attempt to re-run after the snapshot export is complete. Customers may need to adjust their Job scheduling to accommodate for this new execution routine.
ENTERPRISE DATA MANAGEMENT
Top Node Filters for Subscriptions No Longer Apply to Delete Actions
Starting in 22.05, top node filters for subscriptions are no longer applied to Delete request actions in the source viewpoint. If a node matching a deleted source node is found in a target viewpoint, the node will be deleted from the target viewpoint regardless of where the node is located as part of a subscription request to ensure synchronization of existing nodes in both viewpoints.
FINANCIAL CONSOLIDATION AND CLOSE
Posting Data Against Global Assumptions
It is recommended that you do not post data against the Global Assumptions member in the Entity dimension. This member is used to store information such as currency rates. Starting with the 22.07 update, if you post data against Global Assumptions, an error will occur.
Phased Approvals
If you decide to enable Phased Approvals in your application, take note of the following considerations:
-
You will need to manually modify your Data Status forms to replace the dimension member "FCCS_Status_ApprovalStatus" with the new member "FCCS_Status_ConsolidatedApprovalStatus".
-
If you try to export the application from the 22.03 update and import it to the 22.02 update, you must update your Data Status form by changing the dimension member FCCS_Status_ConsolidatedApprovalStatus back to FCCS_Status_ApprovalStatus.
-
Additionally, you will encounter errors during the import because new artifacts related to Phased Approvals are not supported in release 22.02.
Resetting Customized Changes After an Update
If you have made changes to the seeded Account hierarchy, those changes will be reset. If you have moved seeded members, the move action is retained, but any re-ordering you have done will be reset, and a restructuring will happen when the ordering is reset. The restructuring could take time, so plan accordingly. You may have to manually re-order seeded members again after the update.
NARRATIVE REPORTING
Removal of Disclosure Management Videos
As stated in the April 2021 What’s New guide and in the Disclosure Management Statement of Direction (see link below), Oracle has made the decision to end future investments in Disclosure Management. Oracle will continue to provide product support to existing Disclosure Management customers through the end of their subscription term.
Please note that the Disclosure Management videos will be removed from Oracle documentation web site in the July (22.07) update.
Oracle Support Document 2762013.1 (Oracle Cloud Enterprise Performance Management (EPM) Narrative Reporting - Disclosure Management Statement of Direction) can be found at:
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2762013.1
PLANNING MODULES
Removal of Strategic Workforce Planning from EPM Cloud Workforce Planning
In a future update, the Strategic Workforce Planning (SWP) enablement option will be removed for all EPM Cloud Planning Modules (Standard and Enterprise) and Enterprise Planning applications that have not already enabled this feature in the Workforce Module. Customers who have already enabled this feature will see no change in their existing applications with this feature already enabled. No new applications will support this feature after this change.
Strategic Workforce Planning functionality is provided in the Strategic Workforce Planning Cloud Service (SWPCS) product, which contains robust SWP functionality that is not available in the existing EPM Cloud Planning Workforce module feature. SWPCS is an Oracle Human Capital Management (HCM) product built on EPM technology. For more information about SWPCS, please refer to the Strategic Workforce Planning information on www.oracle.com.
If you have any concerns about this change, please contact Oracle Support.
Planning Modules That Use a 13-Period Calendar
For Planning Modules applications that use a 13-period calendar, application snapshot files older than 22.07 will no longer work after 22.07 due to changes Oracle plans to make to the application properties for 13-period applications. The change is required to correct the Fiscal Year Start Date option in existing 13-period applications. After the 22.07 update, customers are advised to take a new snapshot of both test and production environments for backup and restore purposes.
TAX REPORTING
Support for Amount and Rate Override for Tax Accounts
Starting with the 22.08 update, three existing override FX rate/amount forms will be deprecated. The forms will no longer allow data entry. The deprecated forms are:
- NIBT FX Rates Override: FX Rates - NIBT Override
- NIBT FX Rates Override - WAR: FX Rates - NIBT Override – WAR
- Weighted Average Rates Override: FX Rates - Expense Override – WAR
In addition, the data intersections underlying the deprecated forms will no longer accept data including through data import, Smart View, or Data Management.
If you are using any of the above forms or the underlying data intersections to view or modify override FX rates/amount you will need to transition to the new override FX rate/amount forms and underlying data intersections.
The replacement forms are available under the Tax Administration\FX Rates folder and will allow entry and review of the respective FX rate or amount override values.
- FX Rates - NIBT Override: NIBT Foreign Exchange Override Rates (This form replaces NIBT FX Rates Override: FX Rates - NIBT Override)
- FX Rates - NIBT Override – WAR: NIBT Foreign Exchange Override Rates - Calculated Weighted Average (This form replaces NIBT FX Rates Override - WAR: FX Rates - NIBT Override – WAR)
- FX Rates - Expense Override – WAR: Foreign Exchange Rates Calculated Weighted Average (This form replaces Weighted Average Rates Override: FX Rates - Expense Override – WAR)
NOTE: The transition from the old override FX rate capability to the new override FX rate capability requires a migration. All applications created prior to 21.07 must manually run the migration no later than the upgrade to 22.08 on your test and production instances. As part of the migration, all the FX override rates (that is, NIBT override, WAR, and others) that are contained within the Tax Reporting application will be migrated to new intersections. You can tell if a migration is necessary by following the steps in Migrating Override FX Rate and Amount Data and verifying that the Migrate NIBT FX override rate, NIBT WAR and Expense WAR Data checkbox is unchecked. The migration is safe to run multiple times.
IMPORTANT: If you fail to run the migration before upgrading to 22.08, Consolidation will fail with the following error message: A method called by the script failed on line: 8, with error: No migration upgrade smartlist detected. Performing the migration will resolve this error.
IMPORTANT: Data integrations involving the deprecated override FX rate intersections, such as data import/export profiles, Data Management integrations, or Smart View sheets may require a manual update to point to the new override FX rate intersections. See the Migrating Override FX Rate and Amount Data for details on the intersections to migrate.
See
- Migrating Override FX Rate and Amount Data in Working with Tax Reporting
- Working with Amount and Rate Override for Tax Accounts in Working with Tax Reporting
Purging of Audit Information
Starting in the 22.10 update, audit records older than 365 days will be automatically purged at service start-up such as after the daily maintenance window, service reset, or outage (planned or unplanned). Purged audit records will not be stored or accessible. To prepare for this change, you may want to take a backup of the 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.