X

Proactive insights, news and tips from Oracle Hyperion EPM and BI Support. Learn Oracle from Oracle.

Recent Posts

Essbase Cloud

Key Concepts for Basic Understanding of Essbase Block Storage Option (BSO)

What is Essbase BSO?  Key Concepts for Basic Understanding Thank you to Jane Story for the presentation on this topic. The presentation covers the following topics in more detail so be sure to check it out! What is the Magic of Essbase? What are Dimensions and Members? . What is a Block? How is Data Stored in BSO?  Where is Data Stored in BSO? Types of Blocks. All Blocks are the same size but what makes them different? Where to find BSO Cube Statistics? And how do they relate to what we know?   What is the Magic of Essbase? ASO - Aggregate Storage Option : Large outlines, primarily aggregation BSO - Block Storage Option: Small outlines, complex analysis/calculation   What are Dimensions and Members? A dimension is a view-point on the data. Members relating to that dimension/view-point are created within the dimension as a hierarchy. Members can be stored, dynamic or navigational aids (label only) or shared to create reporting hierarchies.   Declared members  is the total of ALL members in the dimension (+ Dynamic Time Series for Period). Stored members does not include dynamic calc, label only or shared members. Each standard dimension in a BSO cube is either DENSE or SPARSE.   What is a Block? Refer to the presentation for detailed explanation and screenshots. The data storage unit in a BSO cube is a BLOCK. DENSE & SPARSE determines how big each block is and how many blocks could exist. Each standard dimension in a BSO cube can either be DENSE or SPARSE. The decision whether a dimension is DENSE or SPARSE is made at design stage. DENSE & SPARSE determines how the data is stored in a BSO cube. The size and number of BLOCKS, at a high level, will determine how the BSO cube executes operations (retrieves, calculations, reports etc.) and the performance thereof. The number of stored members in the DENSE dimensions determines the SIZE of the block. The number of stored SPARSE combinations determines the potential number of blocks. A new block is created every time data is loaded for that SPARSE combination.   How is Data Stored in BSO?  Refer to the presentation for detailed explanation and screenshots. Blocks are created as a combination of Sparse dimensions Every Block containing dense dimension references has an Index Point containing sparse dimension references. The number of stored members in a dense dimension determines the size of the block. The number of stored members in a sparse dimension determines the potential number of blocks, and an index entry is created for each sparse combination. The number of each stored member in each dimension is used in these calculations. Every block is the same size. Dense member data is in EVERY block. Sparse member data is only in the blocks for those sparse combinations   Where is Data Stored in BSO? Ind/Pag files Dense dimensions define data blocks cell location. Sparse dimensions define the index, i.e., which block.   Types of Blocks. All Blocks are the same size but what makes them different?   Where to find BSO Cube Statistics? And how do they relate to what we know? Activity Report can be used.   ========================================================================= References: Presentation - by Jane Story

What is Essbase BSO?  Key Concepts for Basic Understanding Thank you to Jane Story for the presentation on this topic. The presentation covers the following topics in more detail so be sure to check it...

BI On Premise

Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.4.210714 is Available

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.4.x This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.4.210714 Patch 33115118 This is the most recent and recommended cumulative Critical Patch Update (CPU) and bundle patch for the on-premises 12.2.1.4 release. The patch should be applied according to the readme. You should consider migrating to Oracle Analytics Cloud for the most current feature release OR upgrade or migrate to Oracle Analytics Server  (OBI rebranded) for the newest on-premises features. Readme: Prior to proceeding with this OBIEE Bundle Patch implementation and related downloads, refer to the Readme file for important information. It is important to verify that the requirements, installation instructions; support paths; notes; etc for this patch are met as outlined within the Readme file; which is available from the Patches & Updates download screen. Patch Information: Oracle BI Bundle Patches are cumulative. To install the Oracle BI Bundle Patch 12.2.1.4.210714, Oracle BI 12.2.1.4.0 must be installed in the Oracle BI Home directory. Subsequent Oracle BI patches can be installed on Oracle BI 12.2.1.4.0 or any Oracle BI bundle patch with a lower fifth numeral version than the one being installed. For example, you can install 12.2.1.4.210714 on 12.2.1.4.0. Bugs Fixed by this Patch: For a detailed report of new bug fixes in Oracle BI Bundle Patch 12.2.1.4.210714, see Section 10: Bugs Fixed by This Patch Important Notes to Read Before Installing the Bundle Patch: Take some time to review and assess various issues that may impact your installation process in Section 3 of the readme. "Section 3.1: For Customers Moving From 11.1.1.7.x or 11.1.1.9.x to 12.2.1.4.210714" "Section 3.2: Interim Patch Conflict Detection and Resolution" "Section 3.3: For Clustered Environments" "Section 3.4: Upgrade of Mapviewer component for JQuery Library" "Section 3.5: Deprecation of Adobe Flash Player"  "Section 3.6: Upgrade of common-fileupload.jar to 1.3.3 and JQuery version in WLS 12.2.1.3.0" "Section 3.7: Creating Analysis using SQL from Advanced tab is restricted for non-admin users as part of Security bug 31024106" "Section 3.8: Update on Oracle Business Intelligence Developer Client Tool Installer for 12.2.1.4.210714 Bundle Patch" "Section 3.9: Export the results of Analysis" "Section 3.10: Pre requisite for Bug 30414648 fix" "Section 3.11: Pre requisite for Bug 32231333 fix" "Section 3.12: Pre requisite for Bug 31085639 fix" "Section 3.13: Pre requisite for Bug 31930413 fix" =========================================================================== For More Information..... Required and Recommended Patches and Patch Sets For Oracle Business Intelligence 12c and Oracle Analytics Server - Doc ID 2070465.1 OBIEE Suite Bundle Patches - Doc ID 1591422.1 Critical Patch Updates, Security Alerts and Bulletins Master Note for Database Proactive Patch Program (756671.1) Master Note for Enterprise Manager Proactive Patch Program (822485.1)  Master Notes on Fusion Middleware Proactive Patching (1494151.1) Critical Patch Update (CPU) Program Jul 2021 Patch Availability Document (PAD) (Doc ID 2773670.1)   Note: The information in the readme always takes precedence because it contains the latest information and steps.

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.4.x This bundle patch download is available from the My Oracle Support | Patches &...

BI On Premise

Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.210709 is Available

This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.210709 Patch 33098627 Prior to proceeding with this OAS Bundle Patch, refer to the Readme file for important information. It is important to verify that the requirements, installation instructions; support paths; notes; etc for this patch are met as outlined within the Readme file; which is available from the Patches & Updates download screen. Patch Information: Oracle Analytics Bundle Patches are cumulative. For a detailed report of new bug fixes in Oracle Analytics Bundle Patch 5.5.0.0.210709, see Section 9 : Bugs Fixed by This Patch Important Notes to Read Before Installing the Bundle Patch: Take some time to review and assess various issues that may impact your installation process in Section 3 of the readme. "Section 3.1: Interim Patch Conflict Detection and Resolution" "Section 3.2: For Clustered Environments" "Section 3.3: Prerequisite for Bug 32231333 fix" "Section 3.4: Prerequisite for Bug 31085639 fix" "Section 3.5: Prerequisite for Bug 31930413 fix" =========================================================================== For More Information..... Required and Recommended Patches and Patch Sets For Oracle Business Intelligence 12c and Oracle Analytics Server - Doc ID 2070465.1 OBIEE Suite Bundle Patches - Doc ID 1591422.1 Critical Patch Updates, Security Alerts and Bulletins Master Note for Database Proactive Patch Program (756671.1) Master Note for Enterprise Manager Proactive Patch Program (822485.1)  Master Notes on Fusion Middleware Proactive Patching (1494151.1) Critical Patch Update (CPU) Program Jul 2021 Patch Availability Document (PAD) (Doc ID 2773670.1) Note: The information in the readme always takes precedence because it contains the latest information and steps.

This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.210709 Patch 33098627 Prior to proceeding with this OAS...

EPM Cloud

Tax Reporting - August 2021 Cloud Updates

Tax Reporting - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 6, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 20, 2021. Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide EPM Automate Updates Server-side Execution of EPM Automate Commands Update to REST API Syntax for User Access Report and User Audit Report Update to Add Users REST API Update to Send Email REST API Updates to the Clone Environment Feature Activity Report Enhancements Redwood Look and Feel Enhancements Ability to Change Dynamic User Variables in Dashboard 2.0 POV Bars Smart View Ad Hoc Behavior Application Setting Now Defaults to Standard EPM Cloud Integration with the Oracle Autonomous Database Reports System Level Option to Set Default Chart Colors Upgraded PDF Viewer for Reports and Books Audit Log Now Includes Audit Configuration Changes Ability to Reuse Previously Deleted Object Names   Tax Reporting: This section contains information related to Tax Reporting. There are no new features in this update except for the applicable features listed in the EPM Cloud Common section.   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ======================================================================================== Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Tax Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Tax Reporting - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Profitability and Cost Management - August 2021 Cloud Updates

Profitability and Cost Management - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 6, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 20, 2021. Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide EPM Automate Updates Server-side Execution of EPM Automate Commands Update to REST API Syntax for User Access Report and User Audit Report Update to Add Users REST API Update to Send Email REST API Updates to the Clone Environment Feature Activity Report Enhancements Redwood Look and Feel Enhancements Ability to Change Dynamic User Variables in Dashboard 2.0 POV Bars Smart View Ad Hoc Behavior Application Setting Now Defaults to Standard EPM Cloud Integration with the Oracle Autonomous Database Reports System Level Option to Set Default Chart Colors Upgraded PDF Viewer for Reports and Books Audit Log Now Includes Audit Configuration Changes Ability to Reuse Previously Deleted Object Names   Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There are no new features in this update except for the applicable features listed in the EPM Cloud Common section.   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ======================================================================================== Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Profitability and Cost Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Profitability and Cost Management - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Oracle Planning - August 2021 Cloud Updates

Planning - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 6, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 20, 2021. Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide EPM Automate Updates Server-side Execution of EPM Automate Commands Update to REST API Syntax for User Access Report and User Audit Report Update to Add Users REST API Update to Send Email REST API Updates to the Clone Environment Feature Activity Report Enhancements Redwood Look and Feel Enhancements Ability to Change Dynamic User Variables in Dashboard 2.0 POV Bars Smart View Ad Hoc Behavior Application Setting Now Defaults to Standard EPM Cloud Integration with the Oracle Autonomous Database Reports System Level Option to Set Default Chart Colors Upgraded PDF Viewer for Reports and Books Audit Log Now Includes Audit Configuration Changes Ability to Reuse Previously Deleted Object Names   Planning: This section contains information related to Planning. New Videos New Tutorials Updates to Oracle EPM Cloud Groovy Rules Java API Reference: New Strategic Modeling Groovy Options Workforce Enhancements for Flexible Account Mapping to Financials Workforce Enhancements for Merit Assumptions Workforce Custom Dimension Support in Reporting Cube Support for Mapping Strategic Modeling with Business Cases as the Target New Strategic Modeling Data Map Options Ability to Save Models as a Local File on the Strategic Modeling Web Interface   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ======================================================================================== Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. EPM Cloud Planning - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Planning - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Financial Consolidation and Close - August 2021 Cloud Updates

Financial Consolidation and Close - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 6, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 20, 2021. Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide EPM Automate Updates Server-side Execution of EPM Automate Commands Update to REST API Syntax for User Access Report and User Audit Report Update to Add Users REST API Update to Send Email REST API Updates to the Clone Environment Feature Activity Report Enhancements Redwood Look and Feel Enhancements Ability to Change Dynamic User Variables in Dashboard 2.0 POV Bars Smart View Ad Hoc Behavior Application Setting Now Defaults to Standard EPM Cloud Integration with the Oracle Autonomous Database Reports System Level Option to Set Default Chart Colors Upgraded PDF Viewer for Reports and Books Audit Log Now Includes Audit Configuration Changes Ability to Reuse Previously Deleted Object Names   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. Support for Applications with Movement and Period As Dense Dimensions Translation Logic Change for Acquisition and Disposal Movement Members   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Financial Consolidation and Close Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1    

Financial Consolidation and Close - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Narrative Reporting - August 2021 Cloud Updates

Oracle Narrative Reporting - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 6, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 20, 2021. Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide EPM Automate Updates Server-side Execution of EPM Automate Commands Update to REST API Syntax for User Access Report and User Audit Report Update to Add Users REST API Update to Send Email REST API Updates to the Clone Environment Feature Activity Report Enhancements Redwood Look and Feel Enhancements Ability to Change Dynamic User Variables in Dashboard 2.0 POV Bars Smart View Ad Hoc Behavior Application Setting Now Defaults to Standard EPM Cloud Integration with the Oracle Autonomous Database Reports System Level Option to Set Default Chart Colors Upgraded PDF Viewer for Reports and Books Audit Log Now Includes Audit Configuration Changes Ability to Reuse Previously Deleted Object Names   Narrative Reporting Upgraded PDF Viewer for Report Packages, Reports, and Books   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ======================================================================================== Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Performance Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Oracle Narrative Reporting - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

EPM Cloud

Account Reconciliation - August 2021 Cloud Updates

Account Reconciliation - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 6, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 20, 2021. Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide EPM Automate Updates Server-side Execution of EPM Automate Commands Update to REST API Syntax for User Access Report and User Audit Report Update to Add Users REST API Update to Send Email REST API Updates to the Clone Environment Feature Activity Report Enhancements Redwood Look and Feel Enhancements Ability to Change Dynamic User Variables in Dashboard 2.0 POV Bars Smart View Ad Hoc Behavior Application Setting Now Defaults to Standard EPM Cloud Integration with the Oracle Autonomous Database Reports System Level Option to Set Default Chart Colors Upgraded PDF Viewer for Reports and Books Audit Log Now Includes Audit Configuration Changes Ability to Reuse Previously Deleted Object Names   Account Reconciliation: Reorganized Available Options Under Configuration > Periods and Application > Periods Option Added for Administrators to Hide Adjustment Types from Users in Transaction Matching Mandatory Setting of Batch Size for Most Auto Match Rules in Transaction Matching Setting the Maximum Number of Iterations When Performing 1 to Many Subset Auto Matches in Transaction Matching   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ========================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Account Reconciliation Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Account Reconciliation - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Oracle Enterprise Data Management Cloud (EDMCS) - August 2021 Updates

Enterprise Data Management Cloud (EDMCS) - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 6, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 20, 2021. Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide EPM Automate Updates Server-side Execution of EPM Automate Commands Update to REST API Syntax for User Access Report and User Audit Report Update to Add Users REST API Update to Send Email REST API Updates to the Clone Environment Feature Activity Report Enhancements Redwood Look and Feel Enhancements Ability to Change Dynamic User Variables in Dashboard 2.0 POV Bars Smart View Ad Hoc Behavior Application Setting Now Defaults to Standard EPM Cloud Integration with the Oracle Autonomous Database Reports System Level Option to Set Default Chart Colors Upgraded PDF Viewer for Reports and Books Audit Log Now Includes Audit Configuration Changes Ability to Reuse Previously Deleted Object Names   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). Created by and Created Date Properties for Nodes   Defects Fixed: Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1) ========================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Data Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Enterprise Data Management Cloud (EDMCS) - August 2021 Enterprise Performance Management (EPM) Cloud Common - August 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly...

BI Cloud

Advisor Webcast: Oracle Analytics Cloud (OAC) Advance Configuration of Usage Tracking, Custom Themes and Prompt/View Options

Register for the following Advisor Webcast! Oracle Analytics Cloud (OAC) - Advance Configuration of Usage Tracking, Custom Themes and Prompt/View Options Schedule Wednesday, August 11, 2021 08:00 AM (US Pacific Time) Wednesday, August 11, 2021 11:00 AM (US Eastern Time) Wednesday, August 11, 2021 05:00 PM (Central European Time) Wednesday, August 11, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast which will cover introduction to concepts on Usage Tracking , Custom themes, Prompt/View options and their set up ,configuration and validation in OAC followed by troubleshooting steps for the common issue scenarios faced by the users post configuration. Topics Include: Introduction to USAGE TRACKING Setup of USAGE TRACKING in OAC Introduction to Custom Themes Setup of Themes in OAC Different Prompt and View Options in OAC Troubleshooting or issue scenarios for Usage Tracking, Custom Themes and Prompt/View Options. Q&A ======================================================================== For Additional Information and Registration Details: ADVISOR WEBCAST: BI - OAC Advance Configuration of Usage Tracking ,Custom Themes and Prompt/View Options on August 11, 2021 (Doc ID 2789880.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! Oracle Analytics Cloud (OAC) - Advance Configuration of Usage Tracking, Custom Themes and Prompt/View Options Schedule Wednesday, August 11, 2021 08:00 AM (US...

EPM On Premise

Enterprise Performance Management (EPM) 11.2.6 is Available

Enterprise Performance Management (EPM) System On-Premise Release 11.2.6 is available! Before installing this release, it is critical that you review the 11.2.6 readme in its entirety. The readme includes important, late-breaking information about this release of Oracle Enterprise Performance Management System. It is available for download on Oracle Software Delivery Cloud. Release 11.2.6 includes the following new features: Certification of SQL Server 2019. Removal of Oracle Essbase Studio from EPM System Installer. Automation of the process of uninstalling or updating Fusion Middleware patches as needed during Apply Update. Delivery of updated HTTP client. Support for any identity management product that supports header-based authentication. Certification of Oracle Hyperion Planning Release 11.2.x with OGNL 3.2.18. Documentation of database password change procedure in the Oracle Enterprise Performance Management System Deployment Options Guide. Profitability and Cost Management New Features "Enable Native ML Application" REST API. The "Enable Native ML Application" REST API has been generalized to enable any native application, including detailed and Standard native applications, and it has been renamed in the REST API Developer's Guide as "Enable Native Application". "Create ML Application Using Native Method" REST API. The "Create ML Application Using Native Method" REST API has been generalized to create any native application, including Standard and Detailed native applications, and it has been renamed in the REST API Developer's Guide as "Create Application Using Native Method". The API has been expanded to accept new parameters needed for Standard and Detailed applications. Planning New Features Support for Custom Grid Spread. Planning now supports custom grid spread functionality, accessible from the Grid Spread dialog box.   Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements and details. ====================================================================================== References: 11.2.6 readme Available Release Updates (RU) for Oracle Hyperion Enterprise Performance Management (EPM) 11.2 (Doc ID 2790173.1) Certification Matrix: Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements. Oracle Software Delivery Cloud      

Enterprise Performance Management (EPM) System On-Premise Release 11.2.6 is available! Before installing this release, it is critical that you review the 11.2.6 readme in its entirety. The...

Essbase On Premise

Essbase Patch Set Update 11.1.2.4.044 is Available

The Hyperion Product Management recently advised the release of Patch Set Updates (PSU) for Oracle Hyperion Essbase 11.1.2.4.x. These PSU downloads are available from the  My Oracle Support > Patches & Updates section. Hyperion Essbase Server 11.1.2.4.044 32498522 - HYPERION ESSBASE SERVER Hyperion Essbase Client 11.1.2.4.044 32498512 - HYPERION ESSBASE RTC 32498514 - HYPERION ESSBASE CLIENT 32498519 - HYPERION ESSBASE CLIENT MSI Hyperion Essbase Administration Services 11.1.2.4.044 32498539 - Hyperion Essbase Administration Services Server 32676030 - Hyperion Essbase Administration Services Client MSI Hyperion Analytic Provider Services 11.1.2.4.044 32498528 - HYPERION ANALYTIC PROVIDER SERVICES   README FILE: Refer to the Readme files prior to proceeding with these PSU implementations for important information that includes the supported paths per component, along with a full list of the defects fixed, additional support information, prerequisites, details for applying patch and troubleshooting FAQ's. It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file. The Readme file is available from the Patches & Updates download screen for each of the Hyperion Essbase components. Recommendations: Caution: Oracle recommends using the same version of all Essbase portfolio products (Essbase, Essbase Administration Services, Hyperion Provider Services, and Essbase Studio) and components (server, client, runtime client, API, and JAPI). When only some Essbase portfolio products are included in a patch release, the last released versions of the products that are not included in the patch are supported. Essbase Administration Services 11.1.2.4.044, Provider Services 11.1.2.4.044, and Essbase Studio 11.1.2.4.031 are supported for use with Essbase 11.1.2.4.044.  Furthermore, Essbase Runtime Client needs to be updated on systems that Essbase Administration Services is installed starting with this patch. Recommendation: After you apply a patch within the same release codeline, Oracle recommends as a best practice that you export the data from your databases, clear the data from the databases, and then reload the data. ====================================================================================== For your references: Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase Doc ID 1396084.1 Oracle EPM System Documentation

The Hyperion Product Management recently advised the release of Patch Set Updates (PSU) for Oracle Hyperion Essbase 11.1.2.4.x. These PSU downloads are available from the  My Oracle Support > Patches &...

EPM Cloud

Activity Report Usage to Troubleshoot Financial Consolidation and Close (FCCS) Performance Issues

Activity Report Usage to Troubleshoot Financial Consolidation and Close (FCCS) Performance Issues Thank you to Shailesh Kumar, EPM Cloud Development, for the presentation on this topic. Click here to watch the Customer Connect recording on Leveraging the Activity Report for Tuning and Debugging Financial Consolidation and Close Applications. What is the purpose of the Activity Report? The Activity Report enables Service Administrators to understand application usage and help streamline  application design by identifying requests that impact application performance.   Activity Report Retention Policy Oracle Enterprise Performance Management Cloud retains Activity Reports and Access Logs for the  last 60 days only. Oracle recommends that you download and create backup copies on a local  computer to analyze them for historical trends.   How to Save HTML Version of Activity Report using Firefox Web Browser   Refer to the presentation for Activity Report Customer Use Cases ================================================================================= References: Presentation - provided by Shailesh Kumar, EPM Cloud Development Recording of the presentation on Customer Connect EPM Cloud Operations Guide Documentation related to Activity Report Hybrid BSO Essbase Performance Tuning Guide

Activity Report Usage to Troubleshoot Financial Consolidation and Close (FCCS) Performance Issues Thank you to Shailesh Kumar, EPM Cloud Development, for the presentation on this topic. Click here to...

BI Cloud

Oracle Analytics Cloud (OAC) 6.1 is Released

Oracle Analytics Cloud (OAC) 6.1 Explore New Features in Oracle Analytics Cloud Release 6.1. Oracle Analytics Cloud (OAC) introduces a new and modern user experience with the Redwood theme as well as offering a rules engine that enables flexible conditional formatting. You’ll also appreciate the easy on/off toggle for automated joins for multiple-table data sets, and the expanded features for formatting, filtering, sorting, exporting, and printing visualization data.  All these combine to simplify and streamline working with Oracle Analytics, so you spend less time preparing and formatting data and dashboards and more time sharing insights with your organization. For more information, refer to the following: Explore New Features in Oracle Analytics Cloud Release 6.1 - Blog by Suzanne Gill Oracle Analytics Cloud (OAC) 6.1 List of Bug Fixes Included In Release 6.x of Oracle Analytics Cloud (OAC) and Oracle Analytics Cloud - Classic (Doc ID 2768545.1) OAC 6.1 Select Feature Playlist   What's New in 6.1? General Product Updates Enable Oracle’s Redwood experience Support for Back button in browsers Visualization Conditional formatting Null values in list filters Automatic refresh of list filters Control interactivity for consumers Sort data in visualizations by columns that aren't in the visualization Print visualizations on canvases with enhanced options Export visualizations to CSV with the same limits as Classic Repeat Rows on Excel Exports for Tables and Pivots Sort Null Values First Data Preparation Auto-join option in data sets with multiple tables Pixel-Perfect Reporting Protect pixel-perfect PDF report files with AES256 encryption Administration Hide or display dimension members in EPM Cloud dimensions

Oracle Analytics Cloud (OAC) 6.1 Explore New Features in Oracle Analytics Cloud Release 6.1. Oracle Analytics Cloud (OAC) introduces a new and modern user experience with the Redwood theme as well as...

EPM On Premise

Hyperion Shared Services 11.1.2.4.104 is Available

The following Patch Set Update (PSU) has been released for Hyperion Shared Services 11.1.2.4.x and is available from the My Oracle Support | Patches & Updates section. Hyperion Shared Services PSU 11.1.2.4.104 Patch 33028338 The Readme file describes all of the requirements and instructions for applying this patch. Please review in its entirety. About this Patch: This PSU adds support for Google Chrome Web browser and Microsoft Edge Web browser. Patch Type - This is a patch set update (PSU). This patch replaces files in the existing installation and does not require a full installation. Supported Paths to this Patch - You can apply this patch to any EPM System Release 11.1.2.4 deployment to which Shared Services PSU 11.1.2.4.100 (patch 31319089) or PSU 11.1.2.4.101 (patch 31721076) or PSU 11.1.2.4.102(patch 32729100) or 11.1.2.4.103(patch 32968264) has already been applied. Defects Fixed in this Patch: 33026751 - REQUEST ONE-OFF PATCH (BACKPORT TO 11.1.2.4) FOR BUG 32696869 33026807 - REQUEST ONE-OFF PATCH (BACKPORT TO 11.1.2.4) FOR BUG 32696838 32936659 - CROSS SITE REQUEST FORGERY (CSRF) IN SHARED SERVICES 30399567 - STORED CROSS-SITE SCRIPTING FOR HFCM APPLICATION (INCIDENT REFERENCE WITH ORACLE : S1208730 --CAS/CSS 33013925 - SENSITIVE DATA PASSED IN THE URL –LCM ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ To locate the latest Patch Sets and Patch Set Updates for the EPM products visit the My Oracle Support (MOS) Knowledge Article: Available Patch Sets and Patch Set Updates for Oracle Hyperion Enterprise Performance Management Products Doc ID 1400559.1

The following Patch Set Update (PSU) has been released for Hyperion Shared Services 11.1.2.4.x and is available from the My Oracle Support | Patches & Updates section. Hyperion Shared Services PSU...

EPM On Premise

Hyperion Financial Close Management and Tax Governance 11.1.2.4.256 is Available

Hyperion Financial Close Management and Tax Governance PSU 11.1.2.4.256  Patch 32842799 11.1.2.4.256 PSU for Financial Close Management and Tax Governance are the same patch but have different readme steps. NOTE: If you have Tax Governance and Financial Close Management installed on same environment, please follow the readme steps from FCM 11.1.2.4.256 instead. NOTE: If you have Tax Governance and Financial Close Management installed on same environment and have applied FCM 11.1.2.4.256 PSU (32842799), you need not apply this patch on that environment. NOTE: If you have Tax Governance and Financial Close Management installed on same machine and have applied TAX 11.1.2.4.256 PSU (32842799), you need not apply this patch on that machine.     Before Installing or applying this patch: Caution: You are urged to carefully read and understand the following requirements. Failure to comply may result in applying a patch that can cause your application to malfunction, including interruption of service and/or loss of data. Before installing or applying this patch: Verify that the issue described in the Readme matches the issue that you are encountering.  Review the Bug Number referenced in the Readme for additional information. Verify that your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme The Readme file is available from the Patches & Updates download screen. This PSU download is available from the  My Oracle Support > Patches & Updates section.   ========================================================================================================= Have a question for FCM specifically .... The My Oracle Support Community "Hyperion Financial Close Management" is the ideal first stop to seek & find product specific answers. Check it out at Hyperion Financial Close Management (MOSC) To locate the latest Patch Sets and Patch Set Updates for the EPM products visit the My Oracle Support (MOS) Knowledge Article Oracle Hyperion Enterprise Performance Management Products Doc ID 1400559.1  

Hyperion Financial Close Management and Tax Governance PSU 11.1.2.4.256  Patch 32842799 11.1.2.4.256 PSU for Financial Close Management and Tax Governance are the same patch but have different...

EPM Cloud

Advisor Webcast: Enterprise Performance Management (EPM) 11.2.5 Overview

Register for the following Advisor Webcast! Enterprise Performance Management (EPM) 11.2.5 Overview Schedule Wednesday, July 21, 2021 08:00 AM (US Pacific Time)     Wednesday, July 21, 2021 11:00 AM (US Eastern Time)     Wednesday, July 21, 2021 05:00 PM (Central European Time)     Wednesday, July 21, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast is recommended for EPM functional users and system administrators who are responsible for EPM Hyperion deployment and maintenance. Topics Include: New features Defects Fixed Support Matrices Deployments, Installation and configuration - An Overview Important Docs links Q & A ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: Enterprise Performance Management (EPM) 11.2.5 Overview on July 21, 2021 (Doc ID 2784391.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! Enterprise Performance Management (EPM) 11.2.5 Overview Schedule Wednesday, July 21, 2021 08:00 AM (US Pacific Time)    Wednesday, July 21, 2021 11:00 AM (US...

Monthly Index

Business Analytics Monthly Index - June 2021

Welcome to the Monthly Index for June 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence, Hyperion EPM and Essbase from the past month.   General Summary Business Analytics Monthly Index - May 2021 Oracle Smart View for Office 21.100 is Available   Business Intelligence (BI) Summary No posts this month   Business Intelligence (BI) Cloud Summary Oracle Fusion Analytics Warehouse Release 21.R2.P2 is Available     Enterprise Performance Management (EPM) Summary EPM Patch Set Updates - May 2021 EPM 11.2 Support for ODI Knowledge Modules - Statement of Direction Premier Support End Date is Approaching for Enterprise Performance Management (EPM) System Release 11.1.2   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - July 2021 Updates Account Reconciliation - July 2021 Cloud Updates Narrative Reporting - July 2021 Cloud Updates Financial Consolidation and Close - July 2021 Cloud Updates Oracle Planning - July 2021 Cloud Updates Profitability and Cost Management - July 2021 Cloud Updates Tax Reporting - July 2021 Cloud Updates Video on Translations in Financial Consolidation and Close BSO Essbase Restructure in Oracle Planning Enterprise Performance Management (EPM) Cloud Cell-Level Security   Essbase On Premise No posts this month   Essbase Cloud No posts this month   Advisor Webcasts Advisor Webcast: OAC Advance Configuration of PORTAL PATH, Currency and SMTP Server Setup Advisor Webcast: Configuring Vanity URL for Oracle Analytics Cloud (OAC)

Welcome to the Monthly Index for June 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence, Hyperion EPM and Essbase from the past month.   General...

EPM Cloud

Tax Reporting - July 2021 Cloud Updates

Tax Reporting - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide Documentation of Differences Between Classic and OCI (Gen 2) EPM Cloud Documentation of Mapping of Application Roles to Predefined Roles EPM Automate Updates Updates to the Clone Environment Feature New Version of Oracle Smart View for Office Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications Member Selection Support on Flex Forms in Smart View Preserve POV or User Variable Changes on Refresh in Smart View Flex Forms Improved Security for Reports in Account Reconciliation, Task Manager, and Supplemental Data Manager REST API to Generate a Role Assignment Audit Report for OCI (Gen 2) Environments REST API to Generate an Invalid Login Report for OCI (Gen 2) Environments Enhanced User Reporting by Adding Fields to Manage Users Dialog Under Access Control Renaming Collection Attributes in Supplemental Data Manager Schedule Day Labels Now Transferred from Template’s Day Labels in Task Manager Budgetary Control Source Budget Type Name Update   Tax Reporting: This section contains information related to Tax Reporting. Support for Amount and Rate Override for Tax Accounts Enhanced Copy Data Country-by-Country (CbCR) Filing Forms Include OECD Version 2.0   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Tax Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Tax Reporting - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Profitability and Cost Management - July 2021 Cloud Updates

Profitability and Cost Management - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide Documentation of Differences Between Classic and OCI (Gen 2) EPM Cloud Documentation of Mapping of Application Roles to Predefined Roles EPM Automate Updates Updates to the Clone Environment Feature New Version of Oracle Smart View for Office Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications Member Selection Support on Flex Forms in Smart View Preserve POV or User Variable Changes on Refresh in Smart View Flex Forms Improved Security for Reports in Account Reconciliation, Task Manager, and Supplemental Data Manager REST API to Generate a Role Assignment Audit Report for OCI (Gen 2) Environments REST API to Generate an Invalid Login Report for OCI (Gen 2) Environments Enhanced User Reporting by Adding Fields to Manage Users Dialog Under Access Control Renaming Collection Attributes in Supplemental Data Manager Schedule Day Labels Now Transferred from Template’s Day Labels in Task Manager Budgetary Control Source Budget Type Name Update   Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There are no new features in this update except for the applicable features listed in the EPM Cloud Common section.   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Profitability and Cost Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Profitability and Cost Management - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Oracle Planning - July 2021 Cloud Updates

Planning - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide Documentation of Differences Between Classic and OCI (Gen 2) EPM Cloud Documentation of Mapping of Application Roles to Predefined Roles EPM Automate Updates Updates to the Clone Environment Feature New Version of Oracle Smart View for Office Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications Member Selection Support on Flex Forms in Smart View Preserve POV or User Variable Changes on Refresh in Smart View Flex Forms Improved Security for Reports in Account Reconciliation, Task Manager, and Supplemental Data Manager REST API to Generate a Role Assignment Audit Report for OCI (Gen 2) Environments REST API to Generate an Invalid Login Report for OCI (Gen 2) Environments Enhanced User Reporting by Adding Fields to Manage Users Dialog Under Access Control Renaming Collection Attributes in Supplemental Data Manager Schedule Day Labels Now Transferred from Template’s Day Labels in Task Manager Budgetary Control Source Budget Type Name Update   Planning: This section contains information related to Planning. New Videos   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. EPM Cloud Planning - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Planning - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance...

EPM Cloud

Financial Consolidation and Close - July 2021 Cloud Updates

Financial Consolidation and Close - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide Documentation of Differences Between Classic and OCI (Gen 2) EPM Cloud Documentation of Mapping of Application Roles to Predefined Roles EPM Automate Updates Updates to the Clone Environment Feature New Version of Oracle Smart View for Office Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications Member Selection Support on Flex Forms in Smart View Preserve POV or User Variable Changes on Refresh in Smart View Flex Forms Improved Security for Reports in Account Reconciliation, Task Manager, and Supplemental Data Manager REST API to Generate a Role Assignment Audit Report for OCI (Gen 2) Environments REST API to Generate an Invalid Login Report for OCI (Gen 2) Environments Enhanced User Reporting by Adding Fields to Manage Users Dialog Under Access Control Renaming Collection Attributes in Supplemental Data Manager Schedule Day Labels Now Transferred from Template’s Day Labels in Task Manager Budgetary Control Source Budget Type Name Update   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. Introduction of Enterprise Journals Ability to Display Currency in Journal Reports Ability to Apply Translation Override Rule to Specific Currency   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Financial Consolidation and Close Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1    

Financial Consolidation and Close - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Narrative Reporting - July 2021 Cloud Updates

Oracle Narrative Reporting - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide Documentation of Differences Between Classic and OCI (Gen 2) EPM Cloud Documentation of Mapping of Application Roles to Predefined Roles EPM Automate Updates Updates to the Clone Environment Feature New Version of Oracle Smart View for Office Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications Member Selection Support on Flex Forms in Smart View Preserve POV or User Variable Changes on Refresh in Smart View Flex Forms Improved Security for Reports in Account Reconciliation, Task Manager, and Supplemental Data Manager REST API to Generate a Role Assignment Audit Report for OCI (Gen 2) Environments REST API to Generate an Invalid Login Report for OCI (Gen 2) Environments Enhanced User Reporting by Adding Fields to Manage Users Dialog Under Access Control Renaming Collection Attributes in Supplemental Data Manager Schedule Day Labels Now Transferred from Template’s Day Labels in Task Manager Budgetary Control Source Budget Type Name Update   Narrative Reporting Migrating Note Templates, Notes, and Note Formats Updated Narrative Reporting Extension for Smart View Save Office Documents to EPM Cloud in Narrative Reporting in Smart View   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Performance Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Oracle Narrative Reporting - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Account Reconciliation - July 2021 Cloud Updates

Account Reconciliation - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide Documentation of Differences Between Classic and OCI (Gen 2) EPM Cloud Documentation of Mapping of Application Roles to Predefined Roles EPM Automate Updates Updates to the Clone Environment Feature New Version of Oracle Smart View for Office Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications Member Selection Support on Flex Forms in Smart View Preserve POV or User Variable Changes on Refresh in Smart View Flex Forms Improved Security for Reports in Account Reconciliation, Task Manager, and Supplemental Data Manager REST API to Generate a Role Assignment Audit Report for OCI (Gen 2) Environments REST API to Generate an Invalid Login Report for OCI (Gen 2) Environments Enhanced User Reporting by Adding Fields to Manage Users Dialog Under Access Control Renaming Collection Attributes in Supplemental Data Manager Schedule Day Labels Now Transferred from Template’s Day Labels in Task Manager Budgetary Control Source Budget Type Name Update   Account Reconciliation: Reconciliation Compliance Transactions Can Now Be Loaded Using Data Management   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Account Reconciliation Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Account Reconciliation - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Oracle Enterprise Data Management Cloud (EDMCS) - July 2021 Updates

Enterprise Data Management Cloud (EDMCS) - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, July 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Topics in EPM Cloud Operations Guide Documentation of Differences Between Classic and OCI (Gen 2) EPM Cloud Documentation of Mapping of Application Roles to Predefined Roles EPM Automate Updates Updates to the Clone Environment Feature New Version of Oracle Smart View for Office Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications Member Selection Support on Flex Forms in Smart View Preserve POV or User Variable Changes on Refresh in Smart View Flex Forms Improved Security for Reports in Account Reconciliation, Task Manager, and Supplemental Data Manager REST API to Generate a Role Assignment Audit Report for OCI (Gen 2) Environments REST API to Generate an Invalid Login Report for OCI (Gen 2) Environments Enhanced User Reporting by Adding Fields to Manage Users Dialog Under Access Control Renaming Collection Attributes in Supplemental Data Manager Schedule Day Labels Now Transferred from Template’s Day Labels in Task Manager Budgetary Control Source Budget Type Name Update   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). Additional Fields for Node Data Type Properties in Expressions Application Templates Archive and Reactivate in Dimension Inspector Boundancestors and Boundlocations in Expressions Convert Timestamps to Dates in Expressions Delete Archived Viewpoints Delete Lookup Sets Edit Name and Description in Property Inspector Exclude Implicit Shared Nodes for Extracts Expand Allowed Values for Properties on Import Expanded Job Results for Import, Export, and Extract APIs Import Subset of Trees from Financials Cloud Include Descendants in Subscriptions Using Top Node Filters Integer and Float Methods for Node Lists in Expressions Multiple Approvals Per Group for Serial Policies Out of Office Handling for Approval Policies Out of Order Record Processing During Request File Load Record Count Log Report Redwood Experience as a Default Theme Request Activity Improvements Search Below Selected Node in Viewpoint Search for Property in Node Type Inspector Search Results for Different Parents in Node Selector Specify Folder for EPM Cloud Global Connections and Extracts User Filter for Views Page Withdraw Request Approval During Approve Stage   Defects Fixed: Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1) ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Data Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Enterprise Data Management Cloud (EDMCS) - July 2021 Enterprise Performance Management (EPM) Cloud Common - July 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

BI Cloud

Oracle Fusion Analytics Warehouse Release 21.R2.P2 is Available

Oracle Fusion Analytics Warehouse Release 21.R2.P2 Released June 2021 The following features are included in this release: Oracle Fusion ERP Analytics: Additional subject areas Enhanced subject areas Updated subject areas Additional visualization projects and KPIs Attributes added to existing subject areas Metrics added to existing subject areas Data Validation enhancements Additional job-specific group Updated job-specific groups Additional application roles Updated application role Deprecated fact tables   Oracle Fusion HCM Analytics: Additional subject areas Enhanced subject areas Updated subject areas Additional dimension Updated Self Record context Additional job-specific group Additional application roles   For more information, refer to the following: FAW.ERP: Fusion Analytics Warehouse - List of Bugs Fixed in FAW ERP version 21.R2.P2 - 7.4.0 (Doc ID 2787104.1) Check out What’s New for Oracle Fusion Analytics Warehouse for an overview of the features and enhancements that were added recently to improve your Oracle Fusion Analytics Warehouse experience. ========================================================================================== References: Oracle Fusion Analytics Warehouse Release 21.R2.P2 FAW.ERP: Fusion Analytics Warehouse - List of Bugs Fixed in FAW ERP version 21.R2.P2 - 7.4.0 (Doc ID 2787104.1) What’s New for Oracle Fusion Analytics Warehouse Oracle Fusion Analytics Warehouse - Getting Started and Documentation What is Oracle Fusion  Analytics Warehouse? Oracle Analytics for Applications (OAX) is Renamed to Fusion Analytics Warehouse (FAW)

Oracle Fusion Analytics Warehouse Release 21.R2.P2 Released June 2021 The following features are included in this release: Oracle Fusion ERP Analytics: Additional subject areas Enhanced subject areas Updated...

EPM On Premise

Premier Support End Date is Approaching for Enterprise Performance Management (EPM) System Release 11.1.2

Please review the following  document: Premier Support End Date is Approaching for Enterprise Performance Management (EPM) System Release 11.1.2 Doc ID 2785143.1 Please be advised that Premier Support for Enterprise Performance Management (EPM) System 11.1.2 ends December 2021, after which Sustaining Support will be available.  Please see the Lifetime Support Policy: Oracle Applications for information on Support services and timeframes for currently supported products. With Sustaining Support, you receive technical support, including access to our online support tools, knowledgebase, and technical support experts. You benefit from: Major product and technology releases Technical support Access to My Oracle Support Fixes, updates, and critical patch updates created during the Premier Support stage Upgrade scripts created during the Premier Support stage Sustaining Support does not include: New updates, fixes, security alerts, data fixes, and critical patch updates New tax, legal, and regulatory updates New upgrade scripts Certification with new third-party products/versions Certification with new Oracle products In short, beginning January 2022, Oracle Support can no longer file product defect reports (bugs) for this product version, nor can Oracle Support provide patches for existing bugs unless the patches already exist.   This also means that if a particular bug fix is not available for your platform, a patch cannot be requested.  For more specifics on Premier Support, Extended Support, and Sustaining Support, please refer to the Oracle Software Technical Support Policies. Oracle recommends customers prepare a migration plan to Oracle EPM Cloud or an upgrade to Enterprise Performance Management System release 11.2. Please Note: Restricted use Essbase Plus licenses included with Hyperion Financial Close Suite, Hyperion Planning Plus and Hyperion Profitability and Cost Management will follow the Error Correction policy for the related EPM licensed product.  For additional information about support for Essbase with the Enterprise Performance Management System, please see Support for Oracle Essbase 11.1.2.4 with Enterprise Performance Management (EPM) System Releases 11.1.2.4 and 11.2 (Doc ID 2766084.1). Please refer to your Support Contract to determine your specific entitlement. Some exceptions may apply to your account.  Please do not ask Oracle Support for information about your account or entitlements as that information is not available to them.  For questions about your account and/or Support contract, please contact your Account Manager or Sales Representative. References: Premier Support End Date is Approaching for Enterprise Performance Management (EPM) System Release 11.1.2 (Doc ID 2785143.1) Support for Oracle Essbase 11.1.2.4 with Enterprise Performance Management (EPM) System Releases 11.1.2.4 and 11.2 (Doc ID 2766084.1). Lifetime Support Policy: Oracle Applications Oracle Software Technical Support Policies   As a reminder.... To assist in locating an article of interest for future reference, consider adding it as a bookmark.         To Bookmark - click on the star to the left of the title. Once bookmarked the star will become yellow, and the article can be quickly accessed from the "Favorites" drop down menu.    

Please review the following  document: Premier Support End Date is Approaching for Enterprise Performance Management (EPM) System Release 11.1.2 Doc ID 2785143.1 Please be advised that Premier Support...

BI Cloud

Advisor Webcast: Configuring Vanity URL for Oracle Analytics Cloud (OAC)

Register for the following Advisor Webcast! Configuring Vanity URL for OAC Schedule Thursday , July 08, 2021 08:00 AM (US Pacific Time) Thursday , July 08, 2021 11:00 AM (US Eastern Time) Thursday , July 08, 2021 05:00 PM (Central European Time) Thursday , July 08, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast is recommended for system administrators, who administer the OAC Instance. Topics Include: About Vanity URL support for OAC. Prerequisites for Vanity URL configuration. How to configure Vanity URL for OAC. ============================================================================================ For Additional Information and Registration Details: ADVISOR WEBCAST: BI - Configuring Vanity URL for OAC on July 8, 2021 (Doc ID 2782250.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! Configuring Vanity URL for OAC Schedule Thursday , July 08, 2021 08:00 AM (US Pacific Time) Thursday , July 08, 2021 11:00 AM (US Eastern Time)Thursday , July...

BI Cloud

Advisor Webcast: OAC Advance Configuration of PORTAL PATH, Currency and SMTP Server Setup

Register for the following Advisor Webcast! OAC Advance Configuration of PORTAL PATH ,Currency and SMTP Server Setup Schedule Wednesday, July 07, 2021 08:00 AM (US Pacific Time)     Wednesday, July 07, 2021 11:00 AM (US Eastern Time)     Wednesday, July 07, 2021 05:00 PM (Central European Time)     Wednesday, July 07, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast which will cover introduction to concepts on PORTAL PATH , Currency , SMTP Server and their end to end set up ,configuration and validation in OAC followed by troubleshooting steps for the common issue scenarios faced by the users post configuration. Topics Include: Introduction to PORTAL PATH  Setup of Portal PATH in OAC  Introduction to Currency  Setup of Currency in OAC  Introduction to SMTP Server  Setup of SMTP Server  Troubleshooting or issue scenarios for PORTAL PATH, currency and SMTP Server Q&A ============================================================================================ For Additional Information and Registration Details: ADVISOR WEBCAST: BI - OAC Advance Configuration of PORTAL PATH ,Currency and SMTP Server Setup on July 7, 2021 (Doc ID 2782242.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! OAC Advance Configuration of PORTAL PATH ,Currency and SMTP Server Setup Schedule Wednesday, July 07, 2021 08:00 AM (US Pacific Time)    Wednesday, July 07,...

BI Cloud

Oracle Smart View for Office 21.100 is Available

Hyperion Product Management recently advised the release of a Patch Set Update (PSU) for Oracle Smart View for Office. Oracle Smart View for Office 21.100 Patch 32983201   This PSU download is available from the  My Oracle Support | Patches & Updates section. Review the Readme thoroughly and in its entirety before installing Smart View.  This document contains important information that includes supported paths, implementing and configuration steps, list of new features and defects fixed, along with additional support information. New Features: Flex Form Enhancements Enhanced Ad Hoc Operations Available in EPM Cloud Standard Mode Applications New VBA Functions New Smart View Function, HsGetSharedConnectionURL URL Connection Support in Smart View Functions New Options for Filtering Business Rules Change the Alias Table when Setting User Variables in User Preferences Improved Duplicate Alias Handling in Row Drop-down Member Selector New Default Behavior for Opening Saved Ad Hoc Grids Support for Microsoft Edge WebView2 Narrative Reporting Features and Updates   Installation Information: Complete installation instructions are in the Oracle Smart View for Office Installation and Configuration Guide . This guide is available in the Smart View 21.100 library on the Oracle Help Center. Google Chrome, Mozilla Firefox, and Microsoft Edge require a browser extension. See the topics in Browser Support for information on downloading and installing the Smart View extension for those browsers.   Defects Fixed in this Release Click here for the full list   Supported Platforms: Check the readme for information on the following related topics: Smart View Version Support Microsoft Windows Operating System Support Microsoft .NET Framework Support Microsoft Office Support Browser Support Smart View and Virtualized Environments Mobile Device Support   Supported Paths to this Release: ========================================================================== More Information: Available Patch Sets and Patch Set Updates for Oracle Smart View for Office (Doc ID 2220997.1) Smart View Support Matrix and Compatibility FAQ (Doc ID 1923582.1) Smart View 21.100 library  

Hyperion Product Management recently advised the release of a Patch Set Update (PSU) for Oracle Smart View for Office. Oracle Smart View for Office 21.100 Patch 32983201   This PSU download is available...

EPM Cloud

BSO Essbase Restructure in Oracle Planning

BSO Essbase Restructure in Oracle Planning What is a Restructure? How is it different from a Planning Db Refresh? Thank you to Jane Story, Oracle Development, for the presentation on this topic. From an Essbase perspective, each Planning cube has 2 main Essbase parts which may be altered by a refresh and/or restructure: Metadata, such as dimensions, members, structures, hierarchies.  These are stored in an Essbase outline. Data is stored in two parts: Blocks (consisting of a combination of DENSE members) Index to those blocks (a new block for every SPARSE combination). When changes are made in Planning to dimensions, members, member properties, these are “pushed” to Essbase in a Planning DB refresh.The Refresh implicitly triggers a restructure in Essbase to update the Essbase elements. The outline will ALWAYS be restructured.  If the changes affect the indexing or location of the data/blocks (e.g. moving a sparse member, adding, or deleting a dense member) then a data restructure will also be implicitly triggered.  A data restructure can be “index only” or “index and block” (full) restructuring or not required. An implicit restructure will NOT remove #missing blocks.A refresh is executed for all cubes in one operation. A user can also explicitly trigger a Restructure for an individual cube via a Job or via Calc Manager. An explicit restructure will not push changes from Planning to Essbase. It will ALWAYS re-write the OTL, IND and PAG files (i.e. metadata AND data), regardless of changes. An explicit restructure WILL remove #missing blocks. An explicit restructure is executed per cube based on user action. Therefore.... A db Refresh is a push of metadata changes from Planning to Essbase and will trigger an Implicit Restructure in Essbase. A user can execute an Explicit Restructure, independent of member/dimension changes and this will execute a full Essbase restructure. Only an Explicit Restructure will remove #missing blocks (or blocks tagged for delete by a CLEARBLOCK calc). In conclusion.....an Essbase Restructure will affect: Outline (always) and Data (Ind and/or Pag) (if data exists and restructure is required)   ================================================================================= References:  Presentation - provided by Jane Story, Oracle Development

BSO Essbase Restructure in Oracle Planning What is a Restructure? How is it different from a Planning Db Refresh? Thank you to Jane Story, Oracle Development, for the presentation on this topic. From an...

EPM Cloud

Enterprise Performance Management (EPM) Cloud Cell-Level Security

EPM Cloud Cell-Level Security Thank you to Mark Rinaldi, EPM Product Management for the presentation about this long awaited feature to be able to utilize cell-level security in your EPM applications . Watch the recording that was presented on Cloud Customer Connect. Cell-Level Security – History Cell Level Security was the #1 Enhancement Request. Classic Use Case / Problem Statement User X Requires Write Access to All Operating Expense Accounts for  Their Own Entity User X Also Requires Write Access to Facilities Allocation Account in All  Entities Current Metadata Security Grants Write Access to All Operating Expense  Accounts for All Entities Workaround Options: Multiple Applications Multiple User IDs Multiple Dimension Members with Prefix/Suffix Cross-Dimensional AKA Cell-Level Security (CLS) Not Previously  Available Native Essbase Security Filters Allow “Or” / Cross-Dimensional Security Major Issue in Workforce / Salary Use Cases No Ability to Apply Security Per Cube in Planning Previously A Lot of Enhancement Requests Related to / Dependent on CLS Cell-Level Security Cross-Dimensional AKA Cell-Level Security Now Available 21.03 EPM Planning, Planning Modules, and Tax Only (New & Old SKU) EPM Financial Consolidation & Close Targeting Later CY21 Need to Apply to Journals, SDM, etc. Apply Security Per Cube Apply Security to Unsecured Dimensions! CLS Restricts Existing Security Deny Read (Default) Deny Write Apply CLS to Users and/or User Groups Leverages Valid Intersection Framework Learning Curve Should be Shallow for Those Who Know Valid  Intersections Listing Page Filtering Options Import / Export from Listing Page or Cell-Level Security  Definition (CLSD) UI Save as Job EPM Automate & REST API (21.04) Includes Valid Intersection Import / Export Supports Impersonating a User Use Existing Forms to See Security Impact Per User as an Administrator Great Way to Troubleshoot User Security Concerns Works Without CLS! Supports Importing .xlsx files No Need to Save As .txt or .csv! Uses 2 Worksheets Rules Worksheet for Header Definitions (e.g. Name, Dimensions, Dimension  Settings) Sub Rules Worksheet for Restriction Details (e.g. User, Restriction, Members) CLS is Meant to be Exception-Based Security NOT Primary  Security Design / Implementation Approach   Cell Level Security Applies To: Forms, Dashboards, Infolets Reports – FR & MR Deny Read Currently Shows as #Missing Smart View Web Ad Hoc Does NOT Apply To: Hard-coded Calcs Administrator Security   Cell-Level Security – EPM Automate 21.04 Proposed EPM Automate Syntax epmautomate exportCellLevelSecurity FILE_NAME.zip [Names=SECURITY_RECORD_NAMES] Names = Optional Comma Separated List of CLSD If No Names Provided, Exports All CLSD epmautomate importCellLevelSecurity FILE_NAME.zip [ErrorFile=FILE_NAME.txt] Same Will Apply to Valid Intersections. ================================================================================= References: Presentation provided by Mark Rinaldi, EPM Product Management Watch the recording of the presentation on Cloud Customer Connect 21.03 21.04

EPM Cloud Cell-Level Security Thank you to Mark Rinaldi, EPM Product Management for the presentation about this long awaited feature to be able to utilize cell-level security in your EPM applications...

Monthly Index

Business Analytics Monthly Index - May 2021

Welcome to the Monthly Index for May 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence, Hyperion EPM and Essbase from the past month.   General Summary Business Analytics Monthly Index - April 2021   Business Intelligence (BI) Summary No posts this month   Business Intelligence (BI) Cloud Summary No posts this month     Enterprise Performance Management (EPM) Summary EPM Patch Set Updates - April 2021 Oracle Hyperion Profitability and Cost Management 11.1.2.4.134 is available   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - June 2021 Updates Account Reconciliation - June 2021 Cloud Updates Narrative Reporting - June 2021 Cloud Updates Financial Consolidation and Close - June 2021 Cloud Updates Oracle Planning - June 2021 Cloud Updates Profitability and Cost Management - June 2021 Cloud Updates Tax Reporting - June 2021 Cloud Updates Enterprise Performance Management (EPM) Cloud Release Management Reporting and Smart View Update Application Design for EPM Planning Part III: Data Maps and Smart Push Video Series on Understanding Security in Enterprise Data Management Cloud New Video Tutorials : Performing New EPM Grid Operations and Navigating with Dynamic Tabs Video on Workflow Approvals in Enterprise Data Management Financial Consolidation and Close Performance Tuning EPM Planning Capital Module - Lease Planning New Enhancements How to Skip Applying EPM Monthly Updates   Essbase On Premise Oracle Essbase 21.2 is Available   Essbase Cloud Oracle Essbase 21.2 is Available   Advisor Webcasts Advisor Webcast: What is New in Financial Consolidation and Close (FCCS) Since 21.02

Welcome to the Monthly Index for May 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence, Hyperion EPM and Essbase from the past month.   General...

EPM Cloud

How to Skip Applying EPM Monthly Updates

How to Skip Applying EPM Monthly Updates Review the information below on how to skip applying EPM Monthly updates with EPM Automate or with REST APIs. Thank you to Mathew Abraham Mathew for the presentation on this topic. EPM Automate skipUpdate Command This EPM Automate command allows you to skip monthly updates for a maximum of two months. You can also list the skipped updates and remove the skipped updates as required. USAGE : epmautomate skipUpdate add|remove|list [version=UPDATE_NUMBER comment="COMMENT"] You cannot skip an update if the environment is on a one-off patch. You cannot skip a monthly update that is more than 2 months apart from the current update. The skip update command is effective immediately. skipUpdate - add epmautomate skipUpdate add version={version} comment={comment} This lets you skip a monthly update for an environment. Daily maintenance skips specified monthly updates. version parameter specifies the monthly update which has to be skipped.      Example: 21.02 for skipping February 2021 update Example: 21.03 for skipping March 2021 update Comment – you can add a comment to describe by they are skipping the update Example: epmautomate skipUpdate add version=21.04 comment="We are in the financial close of the quarter"   skipUpdate - list epmautomate skipUpdate list This lists the information of all skip updates. The following information is displayed for each skipped update:         -  The date when the skip update was requested         –  The monthly update for which the skip update is in effect         –  The user name that requested the skip update         –  The comment included in the skip update request skipUpdate - remove epmautomate skipUpdate remove Removes all skip updates so that the environment can be brought to the main code line during the next daily maintenance.   Skip Update using REST APIs You can also use Skip Update with REST APIs to Add, List, or Remove the monthly update. POST /interop/rest/v1/services/skipupdate Supported Media Types: application/json Type: form Request parameters supported are type=add OR type=list OR type=remove version=<version to be skipped such as 21.03> (to be passed only when type=add) comment=<The business reason for skipping an update> (to be passed only when type=add) Customer use case example A customer wants to skip a monthly update because they are in the financial close cycle and do not want any disruption on their environment.   Current version: 21.02 Close cycle: March   After the customer issues skipUpdate add for 21.03, Oracle will not apply the March update and the environment will continue to be on 21.02. After the 3rd week of April, the close cycle is complete and the customer now wants to apply the update. After they issue skipUpdate remove, Oracle will apply 21.03 and 21.04.   References: Skip Updates with EPM Automate: Skip Updates with REST APIs EPM Cloud Service Monthly Patch Update Postponement Requests (Doc ID 2462684.1) presentation - Mathew Abraham Mathew  

How to Skip Applying EPM Monthly Updates Review the information below on how to skip applying EPM Monthly updates with EPM Automate or with REST APIs. Thank you to Mathew Abraham Mathew for the presenta...

EPM Cloud

Tax Reporting - June 2021 Cloud Updates

Tax Reporting - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 4, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 18, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video Updates to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for OCI (Gen 2) Audit and User Reports Available in OCI (Gen 2) REST APIs for EPM Cloud Now Support OAuth 2 on OCI (Gen 2) REST API for Get Applications Now Shows the Application Login Level Removal of Some Migration Options Update to EPM Automate Guide Dashboards 1.0 Enhancements OAuth 2 Enablement for EPM Digital Assistant Microsoft Teams, Slack Support for EPM Skills for Digital Assistant Easier Report List Search and Ability to Preserve or Clear Parameters When Generating Reports Task Manager Integration Parameters for Account Reconciliations New EPM Integration Agent Diagnostic Mode Importing Data from Files in the EPM Integration Inbox New EPM Integration Agent File Adapter Changes to Oracle Netsuite Authentication Exporting Dynamic Calculated Values from Financial Consolidation and Close   Tax Reporting: This section contains information related to Tax Reporting. There are no new features in this update except for the applicable features listed in the EPM Cloud Common section.   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Tax Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Tax Reporting - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Profitability and Cost Management - June 2021 Cloud Updates

Profitability and Cost Management - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 4, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 18, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video Updates to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for OCI (Gen 2) Audit and User Reports Available in OCI (Gen 2) REST APIs for EPM Cloud Now Support OAuth 2 on OCI (Gen 2) REST API for Get Applications Now Shows the Application Login Level Removal of Some Migration Options Update to EPM Automate Guide Dashboards 1.0 Enhancements OAuth 2 Enablement for EPM Digital Assistant Microsoft Teams, Slack Support for EPM Skills for Digital Assistant Easier Report List Search and Ability to Preserve or Clear Parameters When Generating Reports Task Manager Integration Parameters for Account Reconciliations New EPM Integration Agent Diagnostic Mode Importing Data from Files in the EPM Integration Inbox New EPM Integration Agent File Adapter Changes to Oracle Netsuite Authentication Exporting Dynamic Calculated Values from Financial Consolidation and Close   Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There are no new features in this update except for the applicable features listed in the EPM Cloud Common section.   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Profitability and Cost Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Profitability and Cost Management - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Oracle Planning - June 2021 Cloud Updates

Planning - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 4, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 18, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video Updates to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for OCI (Gen 2) Audit and User Reports Available in OCI (Gen 2) REST APIs for EPM Cloud Now Support OAuth 2 on OCI (Gen 2) REST API for Get Applications Now Shows the Application Login Level Removal of Some Migration Options Update to EPM Automate Guide Dashboards 1.0 Enhancements OAuth 2 Enablement for EPM Digital Assistant Microsoft Teams, Slack Support for EPM Skills for Digital Assistant Easier Report List Search and Ability to Preserve or Clear Parameters When Generating Reports Task Manager Integration Parameters for Account Reconciliations New EPM Integration Agent Diagnostic Mode Importing Data from Files in the EPM Integration Inbox New EPM Integration Agent File Adapter Changes to Oracle Netsuite Authentication Exporting Dynamic Calculated Values from Financial Consolidation and Close   Planning: This section contains information related to Planning. Updated Videos   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. EPM Cloud Planning - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Planning - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance...

EPM Cloud

Financial Consolidation and Close - June 2021 Cloud Updates

Financial Consolidation and Close - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 4, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 18, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video Updates to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for OCI (Gen 2) Audit and User Reports Available in OCI (Gen 2) REST APIs for EPM Cloud Now Support OAuth 2 on OCI (Gen 2) REST API for Get Applications Now Shows the Application Login Level Removal of Some Migration Options Update to EPM Automate Guide Dashboards 1.0 Enhancements OAuth 2 Enablement for EPM Digital Assistant Microsoft Teams, Slack Support for EPM Skills for Digital Assistant Easier Report List Search and Ability to Preserve or Clear Parameters When Generating Reports Task Manager Integration Parameters for Account Reconciliations New EPM Integration Agent Diagnostic Mode Importing Data from Files in the EPM Integration Inbox New EPM Integration Agent File Adapter Changes to Oracle Netsuite Authentication Exporting Dynamic Calculated Values from Financial Consolidation and Close   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. Control To-Date View Storage Option Journal Report Enhancements   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Financial Consolidation and Close Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1    

Financial Consolidation and Close - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Narrative Reporting - June 2021 Cloud Updates

Oracle Narrative Reporting - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 4, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 18, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video Updates to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for OCI (Gen 2) Audit and User Reports Available in OCI (Gen 2) REST APIs for EPM Cloud Now Support OAuth 2 on OCI (Gen 2) REST API for Get Applications Now Shows the Application Login Level Removal of Some Migration Options Update to EPM Automate Guide Dashboards 1.0 Enhancements OAuth 2 Enablement for EPM Digital Assistant Microsoft Teams, Slack Support for EPM Skills for Digital Assistant Easier Report List Search and Ability to Preserve or Clear Parameters When Generating Reports Task Manager Integration Parameters for Account Reconciliations New EPM Integration Agent Diagnostic Mode Importing Data from Files in the EPM Integration Inbox New EPM Integration Agent File Adapter Changes to Oracle Netsuite Authentication Exporting Dynamic Calculated Values from Financial Consolidation and Close   Narrative Reporting Copy a Library Artifact URL to the Clipboard Rest API to Publish a Word Report Package to Word Updated Narrative Reporting Extension for Smart View   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Performance Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Oracle Narrative Reporting - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Account Reconciliation - June 2021 Cloud Updates

Account Reconciliation - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 4, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 18, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video Updates to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for OCI (Gen 2) Audit and User Reports Available in OCI (Gen 2) REST APIs for EPM Cloud Now Support OAuth 2 on OCI (Gen 2) REST API for Get Applications Now Shows the Application Login Level Removal of Some Migration Options Update to EPM Automate Guide Dashboards 1.0 Enhancements OAuth 2 Enablement for EPM Digital Assistant Microsoft Teams, Slack Support for EPM Skills for Digital Assistant Easier Report List Search and Ability to Preserve or Clear Parameters When Generating Reports Task Manager Integration Parameters for Account Reconciliations New EPM Integration Agent Diagnostic Mode Importing Data from Files in the EPM Integration Inbox New EPM Integration Agent File Adapter Changes to Oracle Netsuite Authentication Exporting Dynamic Calculated Values from Financial Consolidation and Close   Account Reconciliation: New Tutorials Ability to Activate/Deactivate a Rule While Configuring the Match Type REST API and EPM Automate Command Available for Purge Transactions in Transaction Matching   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Account Reconciliation Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Account Reconciliation - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Oracle Enterprise Data Management Cloud (EDMCS) - June 2021 Updates

Enterprise Data Management Cloud (EDMCS) - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 4, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, June 18, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video Updates to Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for OCI (Gen 2) Audit and User Reports Available in OCI (Gen 2) REST APIs for EPM Cloud Now Support OAuth 2 on OCI (Gen 2) REST API for Get Applications Now Shows the Application Login Level Removal of Some Migration Options Update to EPM Automate Guide Dashboards 1.0 Enhancements OAuth 2 Enablement for EPM Digital Assistant Microsoft Teams, Slack Support for EPM Skills for Digital Assistant Easier Report List Search and Ability to Preserve or Clear Parameters When Generating Reports Task Manager Integration Parameters for Account Reconciliations New EPM Integration Agent Diagnostic Mode Importing Data from Files in the EPM Integration Inbox New EPM Integration Agent File Adapter Changes to Oracle Netsuite Authentication Exporting Dynamic Calculated Values from Financial Consolidation and Close   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). Updated Videos   Defects Fixed: Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1) ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Data Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Enterprise Data Management Cloud (EDMCS) - June 2021 Enterprise Performance Management (EPM) Cloud Common - June 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Financial Consolidation and Close Performance Tuning

Financial Consolidation and Close Performance Tuning Thank you to Rich Wilkie, Rick McIntyre, Dheeraj Anand, Shailesh Kumar, part of the EPM Development team, for the presentation on this topic.  You can also watch the recorded webcast. The presentation covers the following topics: Periodic Consolidations   Operations Guide Troubleshooting Process Troubleshooting Activities Change Management Options Performance Improvement Variables Custom Calculations Best Practices - refer to the presentation for detailed examples Calculation Concepts Performance Customer Case Studies Extended Dimensionality (Hybrid) Scripting Techniques   Periodic Consolidations   Controlling ‘To date view storage’ Starting 21.06, there will be a feature available that gives flexibility to store/not store ‘To Date’ View members – QTD, HYTD and YTD Once enabled, users will see new flavor of Consolidate/Translate rules: Consolidate – by selected View/Translate – by selected View View dimension is now a parameter in these rules where user can select the required view members (Periodic is default). Choosing not to compute and store View members helps in increased performance of consolidation routine, reduces the application size, reduces restructure timing To see the data in required View members, users should use the associated _RULE member The member formulas for the _RULE members have been significantly tuned to provide the best performance Please review the documentation that will be published along with 21.06 release for more details Consolidate By View Enablement Not enabled by default, to enable From Navigator, select Configuration from the Application column. On the Configure: Consolidation screen, click on the Enable Features button on right On the Consolidation-Enable Features dialog, click on the Enable button on the right Close when the "consolidation features selected have been enabled" message returns. Confirmation From Navigator, select Rules Confirm that the following new Rules are available Consolidate - by selected View ForceConsolidate - by selected View Translate - by selected View ForceTranslate - by selected View Update View Calculations How to Implement From Rules, Run Consolidate – by selected View on all months loaded to the application. The process will delete all QTD, HYTD and YTD data currently stored in the application From Rules, Run Clear Empty Blocks From Navigator, select Jobs from the Application column. Click on Schedule Jobs and run a  Restructure Cube, Now Run a database refresh, then test consolidation times using the Consolidate – by Selected View rule. Retrievals Considerations Build spreadsheets using adhoc HSGetValue formulas are supported, but use them only where necessary Enable Ignore Constants functionality included in 20.11 update to improve performance Generally most small, medium and even larger reports will perform at acceptable times EPM Performance Engineering and FCCS Development can help optimize problematic spreadsheets Use the Update View Calculations Rule on slow spreadsheets to store that specific slice of data  as Periodic, QTD, HYTD, and YTD to perform.   Operations Guide and Troubleshooting Information Troubleshooting Process Backups (UDR) Important to have a snapshot for troubleshooting Provide Feedback Useful when logging SR’s Helps save time for troubleshooting activities Best Practices Maintenance Mode Limit Service Admin role Client Compatibility Issues Activity Report tracks client access   Troubleshooting Activities Business Rule Errors Database Refresh Issues Performance Issues Imports and Exports EPM Automate Reporting Errors Smart View Consolidation Errors Resolving Data Issues Change Management Current Process Monthly Update Weekly Patch One-Off Patch Emergency Regressions found in Test Update Fixed in Weekly or One-off before Production update Regressions found in Production Update One-off or emergency Change Migration Process Options Upgrade delays -Available via EPM Automate Patching - Follow steps to ensure smooth processing Loaner Pods -Available via SR process for testing Implementation Success Program -Ensure project success via Development assistance Performance Validations -Available before Go-Live Regression Testing -Development created automation for monthly regression testing Governors -Process for increasing dimension governor limits RCA -Requesting Root Cause Analysis for resolved issues Health Checks -Ensure environment is healthy and free of issues   Performance improvement variables Below performance variables that are currently available: OptimizeConcurrency = True Some of the will calculations are reorganized to execute at the very beginning or at the end. There is no guarantee that these will improve performance in all applications. The degree of  improvement depends on the entity structure of a given customer. Customers with deeper entity hierarchies would benefit most. The idea is to try them out and use them if they work for your application OLURatesLoad = True This substitution variable improves refresh database performance. The more scenarios, currencies and rate accounts in an application, the more noticeable the improvement will be. DeltaDBRefresh = True This Substitution variable improves database refresh performance by doing only necessary actions based on metadata change. Not applicable for Legacy Non “Extended  Dimensionality” applications. With this variable set, if a database refresh is performed without changing entity dimension, users will not be required to do a re-compute of ownership. (if enabled). ===================================================================================================== References: Presentation - presented by Rich Wilkie, Rick McIntyre, Dheeraj Anand, Shailesh Kumar, part of the EPM Development team Recording of the webcast Cloud EPM Operations Guide    

Financial Consolidation and Close Performance Tuning Thank you to Rich Wilkie, Rick McIntyre, Dheeraj Anand, Shailesh Kumar, part of the EPM Development team, for the presentation on this topic.  You...

EPM Cloud

Application Design for EPM Planning Part III: Data Maps and Smart Push

Application Design for EPM Planning Part III: Data Maps and Smart Push Thank you to Venu Machiraju and Shankar Viswanathan, Oracle EPM Cloud Development, for the presentation on this topic. Click here to watch the recorded webinar. Data Map Type Definitions Dimension to Dimension Mapping Source member names should match with member names or aliases on target Member to member mapping for Strategic Modeling Smart List from Source Mapped to Target Dimension Smart List labels should match with member names in target Source Unmapped  Dimensions Can contain functions – data from source sums up in target Target Unmapped Dimension Only single member allowed   Data Map Options - How and when to use them   Smart Push Defined One or more data maps associated to the form Honors user ‘read’ security while extracting data from source Honors ‘write’ security while writing to target Optimum performance when trickle fed data into the reporting cube Works with web and smart view Can be invoked on save actions or through user actions   Member Exclusion in Data Push & Smart Push Define Member Exclusion during Data Map Definition Remove members that belong to source but do not belong to target Members that are not present on target cause data maps to run with warning status Data for Excluded Members is omitted from being pushed Honors exclude selection defined in Form and 'Use Form Context' should ignore excluded member  selection during SmartPush Exclude member selection has to be always sub set of main selection other wise validation error will be thrown   Groovy for Data Maps and Smart Push Benefits Gives users the ability to select parameters to target the smart push on – example: edited cells only Track edited cells that the user edited and only push those intersections over to the target cube Execute using any of the business rule options; with/out target clear Reduces the number of data maps Use DataMap API to execute the Data Map as Admin with Limited Scope through runtime prompts Create on the fly Smart Push using DataMap API and execute the Smart Push without linked to forms Execute the Smart Push linked to forms with Overwrite Selection Use Groovy Functions to exclude Dynamic Calc Members to improve performance when executing  Smart Push Use Overwrite selection input to the APIs to limit the data movement; identify the modified data and move data only for modified data For multi user use  cases, catch the threshold exceptions when executing Smart Push and then modify the selection to paginate the records for better performance   Job Details   Data Integration Implementation Guideline   The presentation also covers the following: Other Technical Considerations ASO Design Impacts Optimal Performance Considerations Roadmap Strategic Modeling Data Maps Features Other Sessions Include the following topics: Part I: App Deployment, Dimensions, and Forms Part II: Calculation Manager Rules and Hybrid BSO Part IV: App Types & Migration from legacy SKUs =============================================================================== References: presentation - by Mark Rinaldi, Oracle EPM Product Development Customer Connect - Watch the recorded webinar Part I: App Deployment, Dimensions, and Forms Part II: Calculation Manager Rules and Hybrid BSO      

Application Design for EPM Planning Part III: Data Maps and Smart Push Thank you to Venu Machiraju and Shankar Viswanathan, Oracle EPM Cloud Development, for the presentation on this topic. Click here to...

EPM Cloud

Reporting and Smart View Update

Reporting and Smart View Update As of April 2021 Thank you to Dave Roberts, Shaji Puthanveettil, Tom Lefebvre and Al Marciante, Oracle EPM Cloud, for the presentation on this topic. You can also watch the recording of the presentation. What We Announced via a Disclosure Management Statement of Direction Recognition of the high-touch and expert-level CPA support and  consultative services for XBRL-based that reporting customers and the  market demand Commitment to support existing features for customers through their  current subscription term Announcing the end of investment to future enhancements in the Disclosure Management Module Alignment to solution partners that provide a full-service offering, such  as Ez-XBRL Please refer Oracle Cloud Enterprise Performance Management (EPM) Narrative Reporting - Disclosure Management Statement of Direction (Doc ID 2762013.1) for additional information Also contained in the Cloud EPM 21.04 “What’s New” Note: You can still use Narrative Reporting report packages to create  your financial statements and narratives as part of the disclosure  process.   Narrative Reporting Report Packages Report Package – New Doclet Versioning Optimization (21.03) The Doclet versioning process has been updated to minimize the impact of repetitive  automated check-ins. Previously, any system update to a Doclet file, like updating variable values or embedded content,  resulted in a new Doclet version being generated. Now the system will only generate a new Doclet version on an automated update if the prior version was  created by a user initiated check in. Repetitive automated check-ins will be fully audited but will no longer cause new versions to be  generated. This optimization improves the retention of user updated Doclet versions.  Allowing users to better revert back to a prior version they uploaded to the  Doclet.   Reports (aka Management Reporting) Reports New Features New Chart Property To Exclude Plotting Zero Data Values Dynamic Custom Min/Max for Y-axis in Charts Formula Bar Auto-complete for Manual Entry of Functions and Members Auto Align Prefix/Suffix in Cell Number Format Suppress #missing reports in a Book Bursting to Static Excel for Reports Smart View New Features (Windows 20.200) Support for Drill-Through to Source Vanity URL Support Health Check for Microsoft Office Documents Job Console Auto Refresh Cell Styles Now Support Multiple Style Properties New Indentation Option for Standard Mode Ad Hoc Grids Saving ad-hoc Grids in Standard mode URL Mapping   Smart View New Features (Mac/Browser) UX Enhancements - React UI Planning admin Extension bug fixes Function builder Support for HsAlias Fix Links Task List And Insert attribute Submit and Calc – Business rules as a dialog Context menu layout   What’s Coming in Narrative Reporting Oracle Safe Harbor applies   Report Package Features in Development Shared Report Package content Linked Regular Doclets (similar to Linked MR doclets) Linked Excel Reference Doclets Global Variables Improved Doclet Processing Heavy processing actions moved to background process Improved end user interaction Embedded Content Resolution Improved resolution of embedded images   ==================================================================================== References: Presentation - presented by Dave Roberts, Shaji Puthanveettil, Tom Lefebvre and Al Marciante, Oracle EPM Cloud team Oracle Cloud Enterprise Performance Management (EPM) Narrative Reporting - Disclosure Management Statement of Direction (Doc ID 2762013.1) Cloud EPM 21.04 “What’s New”

Reporting and Smart View Update As of April 2021 Thank you to Dave Roberts, Shaji Puthanveettil, Tom Lefebvre and Al Marciante, Oracle EPM Cloud, for the presentation on this topic. You can also...

EPM Cloud

Enterprise Performance Management (EPM) Cloud Release Management

Enterprise Performance Management (EPM) Cloud Release Management Thank you to Vinay Gupta, Rohini Potukuchi and Mathew Abraham for the presentation on this topic. You can also watch a recording of the webcast. The presentation covers the Cloud EPM release change management processes. It will explain monthly updates, weekly patches, one-off patches, and emergency patches. It will also explain how Oracle addresses regression bugs to ensure that they don’t make their way to the production environments. The session will explain different types of requests customers can make related to release management. Oracle has now introduced the functionality for customers to be able to skip a monthly update. This session provides details of that functionality and how it can be used. It also covers the Operations Guide, and why you want to continue to utilize this valuable resources as it is continually updated with new and important information. Oracle and Customer Responsibility   How does Oracle deliver software updates? Monthly Update: Contains a set of features and bug fixes for all business processes Applied to test environments on first Friday and to prod environments on third Friday of the month Weekly Patch: Includes fixes mainly for regression bugs found in test environments Applied to test environments on second Friday of the month One-Off Patch: Contains fixes for regression bugs, customer blocking bugs, or new features Applied to specific test environments on request After testing and approval by customer, applied to prod environments Emergency Patch: Contains one emergency bug fix Can be applied to test, production, or both as required   How does Oracle resolve regression bugs in test environments? Weekly patch on test environments Emergency patch on test environments Delay the update of prod environments of all impacted customers to allow time to test the bug fix in test environments Cancel the monthly update of production environments   How does Oracle resolve regression or blocking bugs in prod environments? One-off patch on test environments followed by prod environments after customer’s testing and approval Emergency patch on test environments followed by prod environments after 3 days Emergency patch on test and prod environments simultaneously Reverting the monthly update   How does Oracle send notifications for the monthly updates? Notification E-mail is sent to all Service Administrators on last Friday of the month (one week before test environments are updated). The email includes: Exact dates and times when the test and prod environments will be updated Link to Readiness document which provides new features included in the monthly update   How can you control the updates? Request upgrade delay Request one-off patch Request rollback Request merge back Request prod environment to be updated before third Friday   Upgrade Delay Why would you request upgrade delay? You identified a regression in the test environment and there is no fix available from Oracle You are in the critical phase of your implementation project You do not have the time to test the monthly update You are approaching quarter close or year end close Are there repercussions of upgrade delay? An environment that has not been updated in a monthly cycle requires a longer time to upgrade to the main code line After the prod environment is brought to the main code line, you will need to test features and changes from multiple monthly updates Security updates and bug fixes are applied to environments only when they are upgraded to the main code line How can you request upgrade delay? Delay for 1 or 2 consecutive monthly updates -> Self-service via EPM Automate skipUpdate command Delay for more than 2 consecutive monthly updates -> Create a service request via Support EPM Automate skipUpdate Command   When will the environment be merged back after upgrade delay? If you have issued EPM Automate skipUpdate add commands, the environment will be merged when either you issue EPM Automate skipUpdate remove command OR during the next month after the last skipped monthly update. If you have created a Service Request, the environment will be merged during the next month after the monthly updates that you requested to be skipped.   One-Off Patch Why would you request a one-off patch? Oracle creates a fix for an issue you reported, and you want it to be applied to your test environment before it is included in the main code line. Oracle informs you that a fix for an issue you reported is already available as a one-off patch, and you want it to be applied to your test environment. After testing the one-off patch in your test environment, you want it to be applied to your prod environment or additional test environments. When will the environment be merged back after one-off patch? An environment on a one-off patch is merged back to the main code line without any customer approval The merge back occurs in the monthly cycle in which the issue is fixed in the main code line   Rollback, Merge Back, Prod Environment Update Before Third Friday Rollback - A fix for a critical issue in an updated prod environment is not immediately available. Merge Back - You requested upgrade delay through a Service Request, but you want to merge the environment to the main code line before your originally request. Prod Environment Update Before Third Friday - You want a feature or bug fix which you have already tested on test environment, to be applied to prod environment before third Friday of the month.   Operations Guide What is the Cloud EPM Operations Guide? Part of Oracle’s “shift-left” strategy Resolve your issues, satisfy your requests, and answer your questions more efficiently Help you self-diagnose issues and provide all information to Oracle if you cannot resolve an issue yourself Help you provide all information needed by Oracle for various requests Provide you with the resources available to get the answers to your questions Explain release management process How can you use the Cloud EPM Operations Guide? Example: ===================================================================================================== References: Presentation - presented by Vinay Gupta, Rohini Potukuchi and Mathew Abraham Recording of the webcast Cloud EPM Operations Guide    

Enterprise Performance Management (EPM) Cloud Release Management Thank you to Vinay Gupta, Rohini Potukuchi and Mathew Abraham for the presentation on this topic. You can also watch a recording of the...

EPM On Premise

Oracle Hyperion Profitability and Cost Management 11.1.2.4.134 is available

Oracle Hyperion Profitability and Cost Management (HPCM) 11.1.2.4.134 Patch 32626562   Follow Instructions in the Readme File: The Readme file is available from the Patches & Updates download screen. Always refer to the readme and review it in its entirety to verify that your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme. About this Patch: This PSU download is available from the  My Oracle Support > Patches & Updates section. This is a patch set update (PSU).  It requires a full installation of Profitability and Cost Management Services for Release 11.1.2.4.000, 11.1.2.4.700, or 11.1.2.4.900. You can apply this patch to any 11.1.2.4.xxx release.   Required Patches: Oracle Hyperion Shared Services: Patch 11.1.2.4.002 or later is required. Patch 11.1.2.4.100 is recommended, and for Google Chrome Web browser and Microsoft Edge Chromium Web browser support it is required.  It is cumulative so it does not require prior the prior patches to be applied first. However, Patches 11.1.2.4.002, 11.1.2.4.005, 11.1.2.4.006, 11.1.2.4.008, or 11.1.2.4.009 are also supported.  These are not cumulative, so they require the previous patches to be applied first, and they do not support the new browsers. Oracle Hyperion Workspace patch 11.1.2.4.825 is also required if you want to use the Google Chrome Web browser and Microsoft Edge Chromium Web browsers (see the Supported Browsers section in the readme). Essbase Patches: Oracle Hyperion Essbase Server 11.1.2.4.014, 11.1.2.4.018, 11.1.2.4.019, 11.1.2.4.021, 11.1.2.4.022, 11.1.2.4.033, 11.1.2.4.040 or 11.1.2.4.042. Oracle Hyperion Essbase RTC 11.1.2.4.014, 11.1.2.4.018, 11.1.2.4.019, 11.1.2.4.021, 11.1.2.4.022, 11.1.2.4.033, 11.1.2.4.040 or 11.1.2.4.042. Oracle Hyperion Essbase Administration Services 11.1.2.4.014, 11.1.2.4.016, 11.1.2.4.020, 11.1.2.4.022, 11.1.2.4.031 or 11.1.2.4.037. Oracle Hyperion Analytic Provider Services 11.1.2.4.014, 11.1.2.4.018, 11.1.2.4.020, 11.1.2.4.022, 11.1.2.4.033, 11.1.2.4.040 or 11.1.2.4.042. Note that for Essbase, versions 11.1.2.4.015, 11.1.2.4.016, 11.1.2.4.017, 11.1.2.4.025, 11.1.2.4.026, and 11.1.2.4.036 have known issues for Profitability and Cost Management and are not supported. Start with a supported version of Essbase Server, then match the versions as nearly as possible across all other components. For example, if you install the 11.1.2.4.042 Essbase Server patch, you should also install the 11.1.2.4.042 Essbase RTC and Analytic Provider Services patches, and the 11.1.2.4.037 Essbase Administration Services patch.   Required User Rights: The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights: Windows: Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: “Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.” UNIX/Linux: Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products. OPatches are not intended to be applied using a root user. Supported Browsers: Support for Google Chrome Web browser and Microsoft Edge Web browser is now available.  Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements and Oracle Support Document 2675883.1. To use Profitability and Cost Management with these browsers, you must apply these patches: Oracle Hyperion Shared Services 11.1.2.4.100 (Patch 31319089) Oracle Hyperion Workspace 11.1.2.4.825 (Patch 31124100) New Features in this Release: Check the readme   ==========================================================================   For more information: Available Patch Sets and Patch Set Updates for Oracle Hyperion Enterprise Performance Management Products (Doc ID 1400559.1) Available Patch Sets and Patch Set Updates for Oracle Crystal Ball, DRM, FCM, HPCM, and HSF 11.1.x (Doc ID 1525518.1) The patch install reviews and other patch related information can viewed within the My Oracle Support Communities - Hyperion Patch Reviews    

Oracle Hyperion Profitability and Cost Management (HPCM) 11.1.2.4.134 Patch 32626562   Follow Instructions in the Readme File: The Readme file is available from the Patches & Updates download screen....

Monthly Index

Business Analytics Monthly Index - April 2021

Welcome to the Monthly Index for April 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence and Hyperion EPM from the past month.   General Summary Business Analytics Monthly Index - March 2021   Business Intelligence (BI) Summary Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.4.210402 is Available Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.3.210405 is Available Oracle Business Intelligence Enterprise Edition Suite (OBIEE) Bundle Patch 11.1.1.9.210420 is Available Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.210331 is Available   Business Intelligence (BI) Cloud Summary No posts this month     Enterprise Performance Management (EPM) Summary EPM Patch Set Updates - March 2021 Enterprise Performance Management (EPM) 11.2.5 is Available   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - May 2021 Updates Account Reconciliation - May 2021 Cloud Updates Narrative Reporting - May 2021 Cloud Updates Financial Consolidation and Close - May 2021 Cloud Updates Oracle Planning - May 2021 Cloud Updates Profitability and Cost Management - May 2021 Cloud Updates Tax Reporting - May 2021 Cloud Updates Enterprise Data Management Cloud (EDMCS) - What is New and Coming as of April 2021 Tax Reporting (TRCS) - Roadmap Hands-on Tutorials for Oracle Enterprise Performance Management (EPM) Cloud Planning   Essbase On Premise No posts this month   Essbase Cloud Essbase Marketplace 19.3.0.4.5 is Available   Advisor Webcasts Advisor Webcast: Financial Reporting Web Studio – Introduction with Troubleshooting Advisor Webcast: Configure Oracle Analytics Cloud Connection to OTBI as a Data Source

Welcome to the Monthly Index for April 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence and Hyperion EPM from the past month.   General...

EPM On Premise

Advisor Webcast: What is New in Financial Consolidation and Close (FCCS) Since 21.02

Register for the following Advisor Webcast! What is New in FCCS Since 21.02 Schedule Tuesday , May 18, 2021 08:00 AM (US Pacific Time) Tuesday , May 18, 2021 11:00 AM (US Eastern Time) Tuesday , May 18, 2021 05:00 PM (Central European Time) Tuesday , May 18, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour Advisor Webcast is recommended for technical users, functional users, system administrators, Database Administrators, etc. who work with Financial Consolidation and Close Cloud. Topics Include: Product Feature Review from FCCS 21.03 Product Feature Review from FCCS 21.04 What's New in FCCS 21.05 Questions & Answers   ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: EPM - What is New in FCCS Since 21.02 on May 18, 2021 (Doc ID 2767471.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! What is New in FCCS Since 21.02 Schedule Tuesday , May 18, 2021 08:00 AM (US Pacific Time) Tuesday , May 18, 2021 11:00 AM (US Eastern Time)Tuesday , May 18,...

EPM Cloud

Tax Reporting - May 2021 Cloud Updates

Tax Reporting - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 7, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 21, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials Updates to the Clone Environment Feature EPM Automate Updates Users Running the Role Assignment REST API Can Include Their Own Roles REST API to Set Default Password, Force Password Reset, and Set Temporary Password While Importing Snapshot REST API to Disable Emergency Access to Database User Management REST APIs Now Show Details on Which Records Failed and Why They Failed Assign and Unassign Role: Change of Behavior in Access Control Instructions for Configuring Azure AD as Identity Provider for OCI (Gen 2) Environments New Topics in EPM Cloud Operations Guide Activity Report Now Identifies the Cloud Infrastructure in Use Additions and Changes to the Export URLs File Function Validation in Smart View (Mac and Browser) Filter Business Rules in Smart View (Mac and Browser) Improved POV Member Search and Selection in Smart View (Mac and Browser) Adding a Custom View to the Drill Through Landing Page in Data Management Viewing and Fixing Mapping Validation Errors from the Data Integration Workbench Reports Support for Cell-Level Security Reports Grid Property for Conditional Formatting/Suppression Data Value Handling Ability to Copy Member Selections from One Grid Segment to Another Smart View Extensions for Task Manager and Supplemental Data Manager Task Manager Report List Enhancement Auditing for User-Defined and Substitution Variables Ability to Choose Where to Display Label Values in Financial Reporting Bar Charts   Tax Reporting: This section contains information related to Tax Reporting. Periodic Translation Method Support of All Regional Jurisdiction as Dynamic Current Tax Payable Automation   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Tax Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Tax Reporting - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Profitability and Cost Management - May 2021 Cloud Updates

Profitability and Cost Management - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 7, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 21, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials Updates to the Clone Environment Feature EPM Automate Updates Users Running the Role Assignment REST API Can Include Their Own Roles REST API to Set Default Password, Force Password Reset, and Set Temporary Password While Importing Snapshot REST API to Disable Emergency Access to Database User Management REST APIs Now Show Details on Which Records Failed and Why They Failed Assign and Unassign Role: Change of Behavior in Access Control Instructions for Configuring Azure AD as Identity Provider for OCI (Gen 2) Environments New Topics in EPM Cloud Operations Guide Activity Report Now Identifies the Cloud Infrastructure in Use Additions and Changes to the Export URLs File Function Validation in Smart View (Mac and Browser) Filter Business Rules in Smart View (Mac and Browser) Improved POV Member Search and Selection in Smart View (Mac and Browser) Adding a Custom View to the Drill Through Landing Page in Data Management Viewing and Fixing Mapping Validation Errors from the Data Integration Workbench Reports Support for Cell-Level Security Reports Grid Property for Conditional Formatting/Suppression Data Value Handling Ability to Copy Member Selections from One Grid Segment to Another Smart View Extensions for Task Manager and Supplemental Data Manager Task Manager Report List Enhancement Auditing for User-Defined and Substitution Variables Ability to Choose Where to Display Label Values in Financial Reporting Bar Charts   Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There are no new features for Profitability and Cost Management this month.   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Profitability and Cost Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Profitability and Cost Management - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

EPM Cloud

Oracle Planning - May 2021 Cloud Updates

Planning - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 7, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 21, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials Updates to the Clone Environment Feature EPM Automate Updates Users Running the Role Assignment REST API Can Include Their Own Roles REST API to Set Default Password, Force Password Reset, and Set Temporary Password While Importing Snapshot REST API to Disable Emergency Access to Database User Management REST APIs Now Show Details on Which Records Failed and Why They Failed Assign and Unassign Role: Change of Behavior in Access Control Instructions for Configuring Azure AD as Identity Provider for OCI (Gen 2) Environments New Topics in EPM Cloud Operations Guide Activity Report Now Identifies the Cloud Infrastructure in Use Additions and Changes to the Export URLs File Function Validation in Smart View (Mac and Browser) Filter Business Rules in Smart View (Mac and Browser) Improved POV Member Search and Selection in Smart View (Mac and Browser) Adding a Custom View to the Drill Through Landing Page in Data Management Viewing and Fixing Mapping Validation Errors from the Data Integration Workbench Reports Support for Cell-Level Security Reports Grid Property for Conditional Formatting/Suppression Data Value Handling Ability to Copy Member Selections from One Grid Segment to Another Smart View Extensions for Task Manager and Supplemental Data Manager Task Manager Report List Enhancement Auditing for User-Defined and Substitution Variables Ability to Choose Where to Display Label Values in Financial Reporting Bar Charts   Planning: This section contains information related to Planning. New Tutorials Capital Module Enhancements for IFRS-16 Lease Asset Planning   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. EPM Cloud Planning - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Planning - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance...

EPM Cloud

Financial Consolidation and Close - May 2021 Cloud Updates

Financial Consolidation and Close - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 7, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 21, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials Updates to the Clone Environment Feature EPM Automate Updates Users Running the Role Assignment REST API Can Include Their Own Roles REST API to Set Default Password, Force Password Reset, and Set Temporary Password While Importing Snapshot REST API to Disable Emergency Access to Database User Management REST APIs Now Show Details on Which Records Failed and Why They Failed Assign and Unassign Role: Change of Behavior in Access Control Instructions for Configuring Azure AD as Identity Provider for OCI (Gen 2) Environments New Topics in EPM Cloud Operations Guide Activity Report Now Identifies the Cloud Infrastructure in Use Additions and Changes to the Export URLs File Function Validation in Smart View (Mac and Browser) Filter Business Rules in Smart View (Mac and Browser) Improved POV Member Search and Selection in Smart View (Mac and Browser) Adding a Custom View to the Drill Through Landing Page in Data Management Viewing and Fixing Mapping Validation Errors from the Data Integration Workbench Reports Support for Cell-Level Security Reports Grid Property for Conditional Formatting/Suppression Data Value Handling Ability to Copy Member Selections from One Grid Segment to Another Smart View Extensions for Task Manager and Supplemental Data Manager Task Manager Report List Enhancement Auditing for User-Defined and Substitution Variables Ability to Choose Where to Display Label Values in Financial Reporting Bar Charts   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. New Video Translated Currency Input Data Elimination Support for Groovy Script in On-Demand Rules Task Manager Integrations for Ownership Management Creating Additional Global Rate Accounts Enhanced Metadata Validation for Member Formulas Ability to Run On-Demand Rules from Calculation Manager   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Financial Consolidation and Close Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1    

Financial Consolidation and Close - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

EPM Cloud

Narrative Reporting - May 2021 Cloud Updates

Oracle Narrative Reporting - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 7, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 21, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials Updates to the Clone Environment Feature EPM Automate Updates Users Running the Role Assignment REST API Can Include Their Own Roles REST API to Set Default Password, Force Password Reset, and Set Temporary Password While Importing Snapshot REST API to Disable Emergency Access to Database User Management REST APIs Now Show Details on Which Records Failed and Why They Failed Assign and Unassign Role: Change of Behavior in Access Control Instructions for Configuring Azure AD as Identity Provider for OCI (Gen 2) Environments New Topics in EPM Cloud Operations Guide Activity Report Now Identifies the Cloud Infrastructure in Use Additions and Changes to the Export URLs File Function Validation in Smart View (Mac and Browser) Filter Business Rules in Smart View (Mac and Browser) Improved POV Member Search and Selection in Smart View (Mac and Browser) Adding a Custom View to the Drill Through Landing Page in Data Management Viewing and Fixing Mapping Validation Errors from the Data Integration Workbench Reports Support for Cell-Level Security Reports Grid Property for Conditional Formatting/Suppression Data Value Handling Ability to Copy Member Selections from One Grid Segment to Another Smart View Extensions for Task Manager and Supplemental Data Manager Task Manager Report List Enhancement Auditing for User-Defined and Substitution Variables Ability to Choose Where to Display Label Values in Financial Reporting Bar Charts   Narrative Reporting Updated Narrative Reporting Extension for Smart View   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Performance Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Oracle Narrative Reporting - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Account Reconciliation - May 2021 Cloud Updates

Account Reconciliation - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 7, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 21, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials Updates to the Clone Environment Feature EPM Automate Updates Users Running the Role Assignment REST API Can Include Their Own Roles REST API to Set Default Password, Force Password Reset, and Set Temporary Password While Importing Snapshot REST API to Disable Emergency Access to Database User Management REST APIs Now Show Details on Which Records Failed and Why They Failed Assign and Unassign Role: Change of Behavior in Access Control Instructions for Configuring Azure AD as Identity Provider for OCI (Gen 2) Environments New Topics in EPM Cloud Operations Guide Activity Report Now Identifies the Cloud Infrastructure in Use Additions and Changes to the Export URLs File Function Validation in Smart View (Mac and Browser) Filter Business Rules in Smart View (Mac and Browser) Improved POV Member Search and Selection in Smart View (Mac and Browser) Adding a Custom View to the Drill Through Landing Page in Data Management Viewing and Fixing Mapping Validation Errors from the Data Integration Workbench Reports Support for Cell-Level Security Reports Grid Property for Conditional Formatting/Suppression Data Value Handling Ability to Copy Member Selections from One Grid Segment to Another Smart View Extensions for Task Manager and Supplemental Data Manager Task Manager Report List Enhancement Auditing for User-Defined and Substitution Variables Ability to Choose Where to Display Label Values in Financial Reporting Bar Charts   Account Reconciliation: Account Reconciliation Integration with Smart View Data Management Adapter Improved for BAI and SWIFT MT 940 Format Files for Account Reconciliation Object Storage Now Available for Account Reconciliation Attachments Additional Columns Added to Unmatched Transactions, Data Source Filters, and Reports Report Groups Display for Users with Access to Only One Report Group Adding a Custom View to the Drill Through Landing Page in Data Management   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Account Reconciliation Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Account Reconciliation - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Oracle Enterprise Data Management Cloud (EDMCS) - May 2021 Updates

Enterprise Data Management Cloud (EDMCS) - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 7, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, May 21, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials Updates to the Clone Environment Feature EPM Automate Updates Users Running the Role Assignment REST API Can Include Their Own Roles REST API to Set Default Password, Force Password Reset, and Set Temporary Password While Importing Snapshot REST API to Disable Emergency Access to Database User Management REST APIs Now Show Details on Which Records Failed and Why They Failed Assign and Unassign Role: Change of Behavior in Access Control Instructions for Configuring Azure AD as Identity Provider for OCI (Gen 2) Environments New Topics in EPM Cloud Operations Guide Activity Report Now Identifies the Cloud Infrastructure in Use Additions and Changes to the Export URLs File Function Validation in Smart View (Mac and Browser) Filter Business Rules in Smart View (Mac and Browser) Improved POV Member Search and Selection in Smart View (Mac and Browser) Adding a Custom View to the Drill Through Landing Page in Data Management Viewing and Fixing Mapping Validation Errors from the Data Integration Workbench Reports Support for Cell-Level Security Reports Grid Property for Conditional Formatting/Suppression Data Value Handling Ability to Copy Member Selections from One Grid Segment to Another Smart View Extensions for Task Manager and Supplemental Data Manager Task Manager Report List Enhancement Auditing for User-Defined and Substitution Variables Ability to Choose Where to Display Label Values in Financial Reporting Bar Charts   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). Updated Videos   Defects Fixed: Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1) ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Data Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Enterprise Data Management Cloud (EDMCS) - May 2021 Enterprise Performance Management (EPM) Cloud Common - May 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM On Premise

Enterprise Performance Management (EPM) 11.2.5 is Available

Enterprise Performance Management (EPM) System On-Premise Release 11.2.5 is available! Before installing this release, it is critical that you review the 11.2.5 readme in its entirety. The readme includes important, late-breaking information about this release of Oracle Enterprise Performance Management System. It is available for download on Oracle Software Delivery Cloud. Release 11.2.5 includes the following new features: Delivery of Fusion Middleware 12.2.1.4 (certification matrix) and Java version 1.8.0_251. Certification of SQL Server 2017. Certification of Essbase 21c for Oracle Smart View for Office, Oracle Hyperion Financial Reporting, and Oracle Hyperion Shared Services. Certification of upgrade and migration from Solaris to Linux. Certification of upgrade and migration from Solaris to Windows. Certification of the ability to upgrade Java to the latest patch level. The ability to apply an update directly from Release 11.2.3 and Release 11.2.4. Financial Close Management New Features Beginning with Release 11.2.5, you can configure a content management system for Oracle Hyperion Financial Close Management. Planning New Features Support for Adding Dynamic Members in Smart View Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements and details. ============================================================================================= References: 11.2.5 readme Certification Matrix: Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements. Oracle Software Delivery Cloud      

Enterprise Performance Management (EPM) System On-Premise Release 11.2.5 is available! Before installing this release, it is critical that you review the 11.2.5 readme in its entirety. The...

BI On Premise

Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.210331 is Available

This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.210331 Patch 32709138 Prior to proceeding with this OAS Bundle Patch, refer to the Readme file for important information. It is important to verify that the requirements, installation instructions; support paths; notes; etc for this patch are met as outlined within the Readme file; which is available from the Patches & Updates download screen. Patch Information: Oracle Analytics Bundle Patches are cumulative. For a detailed report of new bug fixes in Oracle Analytics Bundle Patch 5.5.0.0.210331, see Section 9 : Bugs Fixed by This Patch Important Notes to Read Before Installing the Bundle Patch: Take some time to review and assess various issues that may impact your installation process in Section 3 of the readme. "Section 3.1: Interim Patch Conflict Detection and Resolution" "Section 3.2: For Clustered Environments" "Section 3.3: Prerequisite for Bug 32231333 fix" "Section 3.4: Prerequisite for Bug 31085639 fix" "Section 3.5: Prerequisite for Bug 31930413 fix" =============================================================================== For More Information..... Required and Recommended Patches and Patch Sets For Oracle Business Intelligence 12c and Oracle Analytics Server - Doc ID 2070465.1 OBIEE Suite Bundle Patches - Doc ID 1591422.1 Critical Patch Updates, Security Alerts and Bulletins Master Note for Database Proactive Patch Program (756671.1) Master Note for Enterprise Manager Proactive Patch Program (822485.1)  Master Notes on Fusion Middleware Proactive Patching (1494151.1) Critical Patch Update (CPU) Program Apr 2021 Patch Availability Document (PAD) (Doc ID 2749094.1) Note: The information in the readme always takes precedence because it contains the latest information and steps.

This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.210331 Patch 32709138 Prior to proceeding with this OAS...

BI On Premise

Oracle Business Intelligence Enterprise Edition Suite (OBIEE) Bundle Patch 11.1.1.9.210420 is Available

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.x This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Business Intelligence Enterprise Edition (OBIEE) Suite Bundle Patch 11.1.1.9.210420 Patch 32744336 Prior to proceeding with this OBIEE Bundle Patch implementation and related downloads, refer to the Readme file for important information. It is important to verify that the requirements, installation instructions; support paths; notes; etc for this patch are met as outlined within the Readme file; which is available from the Patches & Updates download screen. About this Patch: Oracle BI EE Suite Bundle Patches are cumulative. That is, the content of all previous 11.1.1.9.x bundle patches is included in the latest bundle patch. To install the Oracle BI EE Suite Bundle Patch 11.1.1.9.210420 patch, Oracle BI EE 11.1.1.9.0 must be installed in the Oracle BI Home directory. Subsequent Oracle BI EE patches can be installed on Oracle BI EE 11.1.1.9.0 or any Oracle BI EE bundle patch with a lower fifth numeral version than the one being installed. For example, you can install 11.1.1.9.210420 on 11.1.1.9.0. A Bundle Patch is a collection of cumulative patches for the Oracle BI EE components. The patches in a Bundle Patch have been tested to work together. Therefore, you must apply every patch in the Bundle Patch. Patch 32744336  is the top-level patch and it contains all of the cumulative component patches. This provides a single patch to download from My Oracle Support, although there are several component patches that must be installed in the Oracle BI Home directory. Note that some component patches might not have changed since the last Bundle Patch was installed but all are included in the Bundle Patch. Only component patches that have NEW changes will be installed by OPatch. For Oracle BI EE Suite Bundle Patch 11.1.1.9.210420, the component patches listed in the table below in BOLD are new.   The Oracle BI EE Suite Bundle Patch 11.1.1.9.210420 under the top-level Patch 32744336  consists of the following component patches: 24346370    BIADFCOMPS Bundle Patch 11.1.1.9.160808    Oracle Business Intelligence ADF Components (BIADFCOMPS) 32756333    BIFNDN BUNDLE PATCH 11.1.1.9.210411    Oracle Business Intelligence Presentation Services (BIPS) (BIFNDN) 32508654    BIP Bundle Patch 11.1.1.9.210215    Oracle Business Intelligence Publisher (BIP) 27325397    BIFNDNEPM 11.1.1.9.0 Runtime Patch 45    Oracle Enterprise Performance Management Components Installed from Oracle BI Installer 11.1.1.9.0 (BIFNDNEPM) 31877519    BIMAD Bundle Patch 11.1.1.9.200911    Oracle BI Mobile App Designer (BIMAD) 31924963    BISERVER BUNDLE PATCH 11.1.1.9.200922    Oracle Business Intelligence Server (BISERVER) 28241036    BISHIPHOME Patch for 11.1.1.9.181016    Oracle Business Intelligence Platform Client Installers and MapViewer 30786634    BITHIRDPARTY Bundle Patch 11.1.1.9.200414    Oracle Business Intelligence Third Party Bugs Fixed By this Patch: Oracle BI EE Suite Bundle Patch 11.1.1.9.210420 includes all the bug fixes released in Oracle BI EE Suite Bundle Patch 11.1.1.9.210119 and new bug fixes. For a detailed report of new bug fixes in Oracle BI EE Suite Bundle Patch 11.1.1.9.210420, see Section 7: Bugs Fixed by This Patch. Take some time to review and assess various issues that may impact your installation process in Section 2 of the readme: "Section 2.1: For Customers Moving From 11.1.1.7.x to 11.1.1.9.210420" "Section 2.2: Interim Patch Conflict Detection and Resolution" "Section 2.3: For Clustered Environments" “Section 2.4: Version Changes from 11.1.1.9.161018” “Section 2.5: Deprecation of Adobe Flash Player” “Section 2.6:Creating Analysis using SQL from Advanced tab is restricted for non-admin users as part of Security bug 31024106” Please note that Premier Support for all 11g releases ended December 2018. Customers wishing to continue error correction beyond December 2018, for any 11g version, must be on the terminal release (11.1.1.9) and must purchase Extended Support. It is recommended you begin your out-of-place migration plans to Oracle Analytics Cloud or the latest available on-premises version that is within Premier Support. ============================================================================================= For More Information..... To locate the latest available Patch information for OBIEE, refer to OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets (Doc ID 1488475.1) Required and Recommended Patches and Patch Sets For Oracle Business Intelligence 12c and Oracle Analytics Server (Doc ID 2070465.1) OBIEE Suite Bundle Patches - Doc ID 1591422.1 Critical Patch Updates, Security Alerts and Bulletins Master Note for Database Proactive Patch Program (756671.1) Master Note for Enterprise Manager Proactive Patch Program (822485.1)  Critical Patch Update (CPU) Program Apr 2021 Patch Availability Document (PAD) (Doc ID 2749094.1)   Note: The information in the readme always takes precedence because it contains the latest information and steps.  

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.x This bundle patch download is available from the My Oracle Support | Patches &...

BI On Premise

Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.3.210405 is Available

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.3.x This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.3.210405 Patch 32726874 Please note: Error Correction Support for this version ended April 2019. This is the current recommended bundle/critical patch update. The last CPU for 12.2.1.3 is October 2021. You are recommended to migrate to Oracle Analytics Cloud (OAC) or Oracle Analytics Server (OAS). Readme: Prior to proceeding with this OBIEE Bundle Patch implementation and related downloads, refer to the Readme file for important information. It is important to verify that the requirements, installation instructions; support paths; notes; etc for this patch are met as outlined within the Readme file; which is available from the Patches & Updates download screen. Patch Information: Oracle BI Bundle Patches are cumulative. To install the Oracle BI Bundle Patch 12.2.1.3.210405 patch, Oracle BI 12.2.1.3.0 must be installed in the Oracle BI Home directory. Subsequent Oracle BI patches can be installed on Oracle BI 12.2.1.3.0 or any Oracle BI bundle patch with a lower fifth numeral version than the one being installed. For example, you can install 12.2.1.3.210405 on 12.2.1.3.0. Bugs Fixed by this Patch: For a detailed report of new bug fixes in Oracle BI Bundle Patch 12.2.1.3.210405, see Section 10: Bugs Fixed by This Patch   Important Notes to Read Before Installing the Bundle Patch: Take some time to review and assess various issues that may impact your installation process in Section 3 of the readme. "Section 3.1: For Customers Moving From 11.1.1.7.x or 11.1.1.9.x to 12.2.1.3.210405" "Section 3.2: Interim Patch Conflict Detection and Resolution" "Section 3.3: For Clustered Environments" "Section 3.4:  Upgrade of JQuery library in Oracle Mapviewer in OBIEE" "Section 3.5: Deprecation of Adobe Flash Player"  "Section 3.6: Upgrade of common-fileupload.jar to 1.3.3 and JQuery version in WLS 12.2.1.3.0" "Section 3.7: Creating Analysis using SQL from Advanced tab is restricted for non-admin users as part of Security bug 31024106   ================================================================== For More Information..... Required and Recommended Patches and Patch Sets For Oracle Business Intelligence 12c and Oracle Analytics Server - Doc ID 2070465.1 OBIEE Suite Bundle Patches - Doc ID 1591422.1 Critical Patch Updates, Security Alerts and Bulletins Master Note for Database Proactive Patch Program (756671.1) Master Note for Enterprise Manager Proactive Patch Program (822485.1)  Critical Patch Update (CPU) Program Apr 2021 Patch Availability Document (PAD) (Doc ID 2749094.1), Note: The information in the readme always takes precedence because it contains the latest information and steps.

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.3.x This bundle patch download is available from the My Oracle Support | Patches &...

BI On Premise

Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.4.210402 is Available

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.4.x This bundle patch download is available from the My Oracle Support | Patches & Updates section. Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.4.210402 Patch 32718479 This is the most recent and recommended cumulative Critical Patch Update (CPU) and bundle patch for the on-premises 12.2.1.4 release. The patch should be applied according to the readme. You should consider migrating to Oracle Analytics Cloud for the most current feature release OR upgrade or migrate to Oracle Analytics Server  (OBI rebranded) for the newest on-premises features. Readme: Prior to proceeding with this OBIEE Bundle Patch implementation and related downloads, refer to the Readme file for important information. It is important to verify that the requirements, installation instructions; support paths; notes; etc for this patch are met as outlined within the Readme file; which is available from the Patches & Updates download screen. Patch Information: Oracle BI Bundle Patches are cumulative. To install the Oracle BI Bundle Patch 12.2.1.4.210402, Oracle BI 12.2.1.4.0 must be installed in the Oracle BI Home directory. Subsequent Oracle BI patches can be installed on Oracle BI 12.2.1.4.0 or any Oracle BI bundle patch with a lower fifth numeral version than the one being installed. For example, you can install 12.2.1.4.210402 on 12.2.1.4.0.. Bugs Fixed by this Patch: For a detailed report of new bug fixes in Oracle BI Bundle Patch 12.2.1.4.210402, see Section 10: Bugs Fixed by This Patch Important Notes to Read Before Installing the Bundle Patch: Take some time to review and assess various issues that may impact your installation process in Section 3 of the readme. "Section 3.1: For Customers Moving From 11.1.1.7.x or 11.1.1.9.x to 12.2.1.4.210402" "Section 3.2: Interim Patch Conflict Detection and Resolution" "Section 3.3: For Clustered Environments" "Section 3.4: Upgrade of Mapviewer component for JQuery Library" "Section 3.5: Deprecation of Adobe Flash Player"  "Section 3.6: Upgrade of common-fileupload.jar to 1.3.3 and JQuery version in WLS 12.2.1.3.0" "Section 3.7: Creating Analysis using SQL from Advanced tab is restricted for non-admin users as part of Security bug 31024106" "Section 3.8: Update on Oracle Business Intelligence Developer Client Tool Installer for 12.2.1.4.210402 Bundle Patch" "Section 3.9: Export the results of Analysis" "Section 3.10: Pre requisite for Bug 30414648 fix" "Section 3.11: Pre requisite for Bug 32231333 fix" "Section 3.12: Pre requisite for Bug 31085639 fix" "Section 3.13: Pre requisite for Bug 31930413 fix" =============================================================================== For More Information..... Required and Recommended Patches and Patch Sets For Oracle Business Intelligence 12c and Oracle Analytics Server - Doc ID 2070465.1 OBIEE Suite Bundle Patches - Doc ID 1591422.1 Critical Patch Updates, Security Alerts and Bulletins Master Note for Database Proactive Patch Program (756671.1) Master Note for Enterprise Manager Proactive Patch Program (822485.1)  Master Notes on Fusion Middleware Proactive Patching (1494151.1) Critical Patch Update (CPU) Program Apr 2021 Patch Availability Document (PAD) (Doc ID 2749094.1)   Note: The information in the readme always takes precedence because it contains the latest information and steps.

The following Bundle Patch has been released for Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.4.x This bundle patch download is available from the My Oracle Support | Patches &...

BI Cloud

Advisor Webcast: Configure Oracle Analytics Cloud Connection to OTBI as a Data Source

Register for the following Advisor Webcast! Configure Oracle Analytics Cloud connection to OTBI as a Data Source Schedule Wednesday, April 28, 2021 08:00 AM (US Pacific Time) Wednesday, April 28, 2021 11:00 AM (US Eastern Time) Wednesday, April 28, 2021 05:00 PM (Central European Time) Wednesday, April 28, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast is recommended for technical users, system administrators, Database Administrators, etc. who would like a brief understanding about configuration of the Oracle Analytics Cloud (OAC) connection to OTBI as a Data Source. Topics Include: Overview Configuring OTBI Connection Data Level and Object Level Security Troubleshooting Questions and Answers   ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: BI - Configure Oracle Analytics Cloud connection to OTBI as a Data Source on April 28, 2021 (Doc ID 2758646.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! Configure Oracle Analytics Cloud connection to OTBI as a Data Source Schedule Wednesday, April 28, 2021 08:00 AM (US Pacific Time)Wednesday, April 28, 2021...

EPM On Premise

Advisor Webcast: Financial Reporting Web Studio – Introduction with Troubleshooting

Register for the following Advisor Webcast! Financial Reporting Web Studio – Introduction with Troubleshooting Schedule Tuesday , April 27, 2021 08:00 AM (US Pacific Time) Tuesday , April 27, 2021 11:00 AM (US Eastern Time) Tuesday , April 27, 2021 05:00 PM (Central European Time) Tuesday , April 27, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast is recommended for Financial Reporting technical users and functional users who will create FR reports and administer EPM environments. Topics Include: Financial Reporting Web Studio - Introduction and features FR Studio thick client versus FR Web studio FR Web studio installation and configuration FR Web studio troubleshooting Q & A   ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: EPM - Financial Reporting Web Studio – Introduction with Troubleshooting on April 27, 2021 (Doc ID 2755365.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! Financial Reporting Web Studio – Introduction with Troubleshooting Schedule Tuesday , April 27, 2021 08:00 AM (US Pacific Time)Tuesday , April 27, 2021 11:00...

Essbase Cloud

Essbase Marketplace 19.3.0.4.5 is Available

Essbase Marketplace 19.3.0.4.5 Released April 2021 Oracle Essbase is a business analytics solution that uses a proven, flexible, best-in-class architecture for analysis, reporting, and collaboration. Oracle Essbase delivers instant value and greater productivity for your business users, analysts, modelers, and decision-makers, across all lines of business within your organization. New Features and Enhancements: Flexible Shapes support for Essbase compute, allows you to customize the number of OCPUs when launching or resizing your VM. Changes: Attaching to existing private ADB instances is now supported. Supported Paths to this Patch: You can apply this patch to any Oracle Essbase Marketplace stack version 19.3.0.x.x. Recommendation: Before you apply a patch, back up your Boot Volume. ================================================ For more information, refer to the following: Essbase 19.3.0.4.5 Release Notes - Oracle recommends you review its contents, and related documentation, before installing, or working with the product. Learn about new features and enhancements which were added to improve your Oracle Essbase experience. You can also learn about relevant issues, patches, listing changes, and bug fixes at the time of the release. Patch 31907358: ORACLE ESSBASE 19.3.0.4.5 Essbase 19c Marketplace: Defects Fixed / Known Issues in 19.3.x (Doc ID 2621654.1)

Essbase Marketplace 19.3.0.4.5 Released April 2021 Oracle Essbase is a business analytics solution that uses a proven, flexible, best-in-class architecture for analysis, reporting, and collaboration....

Monthly Index

Business Analytics Monthly Index - March 2021

Welcome to the Monthly Index for March 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence and Hyperion EPM from the past month.   General Summary Business Analytics Monthly Index - February 2021   Business Intelligence (BI) Summary Explore New Features in Oracle Analytics Server Release 5.9   Business Intelligence (BI) Cloud Summary No posts this month     Enterprise Performance Management (EPM) Summary EPM Patch Set Updates - February 2021 Oracle Hyperion Calculation Manager 11.1.2.4.015 is Available Oracle Applications Unlimited Extended Through at Least 2032   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - April 2021 Updates Account Reconciliation - April 2021 Cloud Updates Narrative Reporting - April 2021 Cloud Updates Financial Consolidation and Close - April 2021 Cloud Updates Oracle Planning - April 2021 Cloud Updates Profitability and Cost Management - April 2021 Cloud Updates Tax Reporting - April 2021 Cloud Updates Vanity URL Support in Enterprise Performance Management (EPM) Cloud Oracle Digital Assistant (ODA) for Enterprise Performance Management (EPM) Application Design for EPM Planning Part II: Calculation Manager Rules and Hybrid BSO   Essbase On Premise No posts this month   Essbase Cloud No posts this month   Advisor Webcasts Advisor Webcast: Financial Reporting Print Service 11.1.2.1 Advisor Webcast: OBIA 12c: BIApps 11.1.1.10.3 Updates and Applying Patch Bundle 1

Welcome to the Monthly Index for March 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence and Hyperion EPM from the past month.   General...

EPM Cloud

Application Design for EPM Planning Part II: Calculation Manager Rules and Hybrid BSO

Application Design for EPM Planning Part II: Calculation Manager Rules and Hybrid BSO Thank you to Mark Rinaldi, Oracle EPM Product Management, for the presentation on this topic. You can also watch the recorded webinar. To ensure high performing applications, review the best practices in writing calc scripts and avoid common mistakes when creating rules. The presentation covers the following topics with examples for each scenario. Rules Best Practices; including but not limited to: Example Rule – Multiple passes through the database Example Rule – Single pass through the database Example of a Rule that copies & creates 0’s Removing Zero’s from BSO cube Benefits of following Best Practices Best Practices for Hybrid BSO; including comparison between BSO & Hybrid BSO Best Practices for ASO Monitoring Application   Rules Best Practices Poorly written rules have a major impact on all aspects of an application. Can cause block contention which has a dramatic impact on End User Rule Performance Increase data on disk or application size which impacts rule performance & increases AMW time Rule performance cannot be gauged without concurrency. Rule performance cannot be gauged with limited data in application.   Top 10 Best Practices for Rules SET COMMANDS Do not use “SET CREATEBLOCKONEQ ON” & “SET CREATENONMISSINGBLK ON” at the top of the rule Do not use  administrative type commands like “SET CLEARBLOCK EMPTY” in end user rules as it requires a restructure Avoid or test the rules using “SET CALCTASKDIMS”. Essbase typically does this automatically – best to let Essbase decide The Data Copy rule should include “SET COPYMISSINGBLOCK OFF” to prevent copying empty blocks within the Fix. Block Creation should be done using either Datacopy or Sparse Member assignment. Functions (@createblockoneq and @createblock) are very expensive and should be used as a last resort inside limited Fix statement. Missing dimension references in fix (e.g. in Data Copy Rule) can waste processing time and increase contention and create unnecessary blocks for all levels of the missing dimensions. Remove parallel calc in Business Rules associated to Forms. CALC Parallel or Fix Parallel should be used only with administrative/batch rules. Creating unnecessary zero’s will lead to block/data explosion. Carefully review business logic & add necessary if conditions to check for zero’s. Convert zero’s to #missing. Eliminate multiple passes on the same blocks. Instead  set a proper outer fix and move in and  out as necessary. Combine “If” statements instead of If’ing & re’Ifing on the same intersections. Avoid using Cross dimensional references on the left hand side of an equation.  This has a performance impact. Dimensions should be aggregated in order of creation of the most blocks to the least blocks in the script e.g. Agg (1st Most Blocks Dimension, 2nd Most Blocks Dimension, 3rd Most Blocks Dimension). Agg is faster than Calc Dim and is a preferred mechanism for aggregation. Aggregation using @ancestors in end user rules all the way to the top of the dimension can lead to block contention. Use RTP’s instead of creating multiple rules with same underlying logic. More rules means more maintenance. Use Templates for breaking down & reusing business logic. However, templates should not be fully functioning rules with Fix, EndFix. The rule combining various templates should have proper outer fix and move in & out of smaller pieces as necessary.   Calculation Manager Diagnostics Run Errors and Warnings before deploying rule Provides information on # of passes thru the database Gives warnings Information on number of blocks and if dimensions are missing Rules need to be optimized accordingly   Why Hybdrid BSO? Hybrid BSO provides multiple options for configuring/tuning applications Application size reduces significantly with Hybrid BSO because of dynamic sparse dimensions which has positive impact on performance & usability Hybrid BSO is definitely better than BSO but does not replace ASO for reporting purpose Best practices framework monitors application health & provides advance warnings for taking corrective actions for ensuring Optimal Application Performance   Best Practices for Hybrid BSO All BSO Best Practices apply to Hybrid BSO. However, there are some new considerations as well. Making all sparse dimension parent members dynamic can be considered as an option only for small size application. A mixed approach with some sparse dimension parent members being store or some intermediate parent members in sparse dimensions being store gives better performance for large size applications. For very large-sized applications with large number of reporting dimensions and instantaneous aggregation/reporting requirements, Hybrid BSO- ASO with Smart Push & Aggregate Views in ASO can be leveraged. Leaf level members in sparse dimensions should not be made dynamic especially when there is no member formula associated with the member. This can have adverse impact on form performance and also make the Essbase query run as suppress missing rows/columns instead of suppress missing blocks. Query Solve Order can be set per dimension/member for ensuring accurate results and tuning the performance of calculation scripts (aggregate before calculate wherever possible). The higher the solve order setting for a member, the lower in the order the member is calculated. The following is the default solve order value: Stored members 0          Sparse dimension 10 Sparse dimension – Two Pass 20 Dense dimension – Account 30        Dense dimension – Time 40           Dense dimension 50           Dense dimension – Two Pass Account 60        Dense dimension – Two Pass Time 70        Dense dimension – Two Pass 80      Attribute dimension 90 Form/Report Layout Symmetric vs Asymmetric - Asymmetric grids are broken into multiple Symmetric Grids by Hybrid Query Engine thereby affecting query performance. This is due to the serial nature of asymmetric report processing.  Avoid creating Asymmetric forms.   Best Practices Framework The following best practices are monitored by the framework: Block Size Number of Blocks Number of Dense Dimensions Max number of children under any dynamic/store parent Parents with single children Level 1 and above not set to dynamic calc/Label only in Dense dimensions. Usage of dynamic x-refs Percentage Customization   Best Practices for ASO Optimizing data retrieval from ASO: Merge Data Slices & Remove Zero’s Compact Outline Build optimal number of Aggregate Views Reviewing Dimension Hierarchy Types   Monitoring Application The Activity Report is automatically generated for each day and it enables Service Administrators to understand application usage. Identifies Calculation Scripts and User Requests that impact application performance Compare service usage and performance from past reports The activity report is available from the UI: Application->Overview->Activity Reports. Watch the recorded webcast on Essential Tools and Resources for Managing Your EPM Applications.   Other Sessions Include the following topics: Part I: App Deployment, Dimensions, and Forms Part III: ASO, Datamaps & Smart Push Part IV: App Types & Migration from legacy SKUs =============================================================================== References: Presentation - by Mark Rinaldi, Oracle EPM Product Development Customer Connect - Watch the recorded webinar Part I: App Deployment, Dimensions, and Forms Essential Tools and Resources for Managing Your EPM Applications - recorded webcast      

Application Design for EPM Planning Part II: Calculation Manager Rules and Hybrid BSO Thank you to Mark Rinaldi, Oracle EPM Product Management, for the presentation on this topic. You can also watch the re...

EPM Cloud

Oracle Applications Unlimited Extended Through at Least 2032

Oracle Applications Unlimited Extended Through at Least 2032 We are announcing an extension of Applications Unlimited from 2031 to 2032 for our Oracle Applications Unlimited Products; which includes Hyperion Enterprise Performance Management System. Doing so provides customers with more than a decade of ongoing product development, new features, innovations on the Continuous Innovation releases, and continued Oracle Premier Support. Refer to the Lifetime Support Policy for Oracle Applications. Applications Unlimited is Oracle's commitment to continuous innovation while also providing a commitment to offer Oracle Premier Support through at least 2032. Oracle Premier Support provides comprehensive maintenance and software upgrades for your Application Unlimited products through at least 2032, on the current Continuous Innovation releases. Oracle will deliver new functionality to covered Oracle Applications as updates to the existing Continuous Innovation release, and upgrades will not be required to gain access to new features and capabilities. Fixes and updates are cumulative and will be available to all customers in the most current release.   Commitment to Customers: Oracle Premier Support through at least 2032 Commitment to Innovation: Receive ongoing new features Run same application on-premises or in Oracle Cloud Infrastructure (OCI) Commitment to Products: Transparent product roadmap Ongoing R&D investment Key Benefits: Gain peace of mind with no surprises. New features without upgrades. No forced migrations. Ample time for future planning budgeting and allocating resources. Tailor to your enterprise’s business and IT strategies. Get more value from existing application environment.   ======================================================================================================= References: Lifetime Support Policy for Oracle Applications Lifetime Support for your Oracle Applications Unlimited products Oracle Applications Unlimited and Oracle Premier Support Oracle's Lifetime Support Policy Oracle Premier Support Applications Unlimited Hyperion Enterprise Performance Management (EPM) Officially Joins Oracle Applications Unlimited - What Does This Mean?

Oracle Applications Unlimited Extended Through at Least 2032 We are announcing an extension of Applications Unlimited from 2031 to 2032 for our Oracle Applications Unlimited Products; which includes Hyp...

EPM Cloud

Tax Reporting - April 2021 Cloud Updates

Tax Reporting - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Topics in EPM Cloud Operations Guide EPM Automate Updates REST API to Send Email REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Import Valid Intersections REST API to Export Valid Intersections REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API Updates to the Clone Environment Feature New Web Ad Hoc Experience in EPM Cloud Ability to Display Colored Circle Icons on Horizontal Tab Labels in Navigation Flows Enhanced Business Rules Dialog in Smart View (Mac and Browser) Task Manager Improved Data Extract in Data Integration New Idle Time Setting for Agents During Automated Maintenance Window (AMW) Downtime   Tax Reporting: This section contains information related to Tax Reporting. New Tutorial   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Tax Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Tax Reporting - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Profitability and Cost Management - April 2021 Cloud Updates

Profitability and Cost Management - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Topics in EPM Cloud Operations Guide EPM Automate Updates REST API to Send Email REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Import Valid Intersections REST API to Export Valid Intersections REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API Updates to the Clone Environment Feature New Web Ad Hoc Experience in EPM Cloud Ability to Display Colored Circle Icons on Horizontal Tab Labels in Navigation Flows Enhanced Business Rules Dialog in Smart View (Mac and Browser) Task Manager Improved Data Extract in Data Integration New Idle Time Setting for Agents During Automated Maintenance Window (AMW) Downtime     Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There are no new features for Profitability and Cost Management this month.   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Profitability and Cost Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Profitability and Cost Management - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Oracle Planning - April 2021 Cloud Updates

Planning - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Topics in EPM Cloud Operations Guide EPM Automate Updates REST API to Send Email REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Import Valid Intersections REST API to Export Valid Intersections REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API Updates to the Clone Environment Feature New Web Ad Hoc Experience in EPM Cloud Ability to Display Colored Circle Icons on Horizontal Tab Labels in Navigation Flows Enhanced Business Rules Dialog in Smart View (Mac and Browser) Task Manager Improved Data Extract in Data Integration New Idle Time Setting for Agents During Automated Maintenance Window (AMW) Downtime   Planning: This section contains information related to Planning. New Video   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. EPM Cloud Planning - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Planning - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Financial Consolidation and Close - April 2021 Cloud Updates

Financial Consolidation and Close - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Topics in EPM Cloud Operations Guide EPM Automate Updates REST API to Send Email REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Import Valid Intersections REST API to Export Valid Intersections REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API Updates to the Clone Environment Feature New Web Ad Hoc Experience in EPM Cloud Ability to Display Colored Circle Icons on Horizontal Tab Labels in Navigation Flows Enhanced Business Rules Dialog in Smart View (Mac and Browser) Task Manager Improved Data Extract in Data Integration New Idle Time Setting for Agents During Automated Maintenance Window (AMW) Downtime   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. New Videos New Consolidation Dimension Members Change to Default Translation Sequence Performance Substitution Variables   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Financial Consolidation and Close Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1    

Financial Consolidation and Close - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Narrative Reporting - April 2021 Cloud Updates

Oracle Narrative Reporting - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Topics in EPM Cloud Operations Guide EPM Automate Updates REST API to Send Email REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Import Valid Intersections REST API to Export Valid Intersections REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API Updates to the Clone Environment Feature New Web Ad Hoc Experience in EPM Cloud Ability to Display Colored Circle Icons on Horizontal Tab Labels in Navigation Flows Enhanced Business Rules Dialog in Smart View (Mac and Browser) Task Manager Improved Data Extract in Data Integration New Idle Time Setting for Agents During Automated Maintenance Window (AMW) Downtime   Narrative Reporting There are no new features in this update except for the applicable features listed in the EPM Cloud Common section. Disclosure Management customers should refer to an important Statement of Direction update. Please refer to Oracle Cloud Enterprise Performance Management (EPM) Narrative Reporting - Disclosure Management Statement of Direction (Doc ID 2762013.1)   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Performance Reporting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Oracle Narrative Reporting - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

EPM Cloud

Account Reconciliation - April 2021 Cloud Updates

Account Reconciliation - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Topics in EPM Cloud Operations Guide EPM Automate Updates REST API to Send Email REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Import Valid Intersections REST API to Export Valid Intersections REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API Updates to the Clone Environment Feature New Web Ad Hoc Experience in EPM Cloud Ability to Display Colored Circle Icons on Horizontal Tab Labels in Navigation Flows Enhanced Business Rules Dialog in Smart View (Mac and Browser) Task Manager Improved Data Extract in Data Integration New Idle Time Setting for Agents During Automated Maintenance Window (AMW) Downtime   Account Reconciliation: New Videos Ability to Purge Matched Transactions in Transaction Matching Account Reconciliation User Interface Translated into Additional Languages Skipping the Next Account Reconciliation System Maintenance Run in a Streamlined System Setting Transaction ID Added to Transaction Matching Filterable Fields Improved Selection of Report Generation Parameters for Organizational Units Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API   Defects Fixed Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1)   ============================================================================================= Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Account Reconciliation Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

Account Reconciliation - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Oracle Enterprise Data Management Cloud (EDMCS) - April 2021 Updates

Enterprise Data Management Cloud (EDMCS) - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 2, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, April 16, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Topics in EPM Cloud Operations Guide EPM Automate Updates REST API to Send Email REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Import Valid Intersections REST API to Export Valid Intersections REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Updating of Reconciliation Attributes Through Loading a File in Reconciliation Compliance Now Available in EPM Automate and REST API Updates to the Clone Environment Feature New Web Ad Hoc Experience in EPM Cloud Ability to Display Colored Circle Icons on Horizontal Tab Labels in Navigation Flows Enhanced Business Rules Dialog in Smart View (Mac and Browser) Task Manager Improved Data Extract in Data Integration New Idle Time Setting for Agents During Automated Maintenance Window (AMW) Downtime   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). Updated Videos Access Current Date/Time and Calculate Date Offset in Expressions Appearance Option to Display Business Process Name Arithmetic Methods for Integer and Float Data Types in Expressions Create Unbound Dimensions for Custom Data Sets Custom Validations Report Derived Values and Property Transformations for List Data Type Properties Disable Existing Subscriptions for Viewpoint Download Subscriptions Report to File Enrich Request Items During Approval Filter Archived Dimensions and Viewpoints Global Connections to Oracle Enterprise Resource Planning Cloud and Oracle Enterprise Performance Management Cloud Inspect Request Items and Delete Individual Request Actions Match Nodes Across Viewpoints Using Alternate Name Original Request and Subscription Links in Request Inspector Participant Permission and Granular Data Access by Action and Property Recall Requests Awaiting Approval Reconnect Parents, Header/Footer, and Zip File Options in Dimension Extracts Reference Node Data Type Properties in Expressions Request Title Included in Transaction History REST API to Dimension Import, Export, and Export Mappings by Name REST API to Download Transaction History REST API to Upload, List, and Delete Files in the Staging Area Set Archived View Back to Active Status Subscription Indicator on Viewpoints Suffix for Node Type Qualifiers Tools Cluster on Home Page Request Object in Expressions for Validations, Policies, and Subscriptions   Defects Fixed: Software issues addressed each month will be posted to Enterprise Performance Management Cloud Release Highlights (Doc ID 2055579.1) ============================================================================================ Refer to the following links and documents for further information: Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. Oracle Enterprise Data Management Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1  

Enterprise Data Management Cloud (EDMCS) - April 2021 Enterprise Performance Management (EPM) Cloud Common - April 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Oracle Digital Assistant (ODA) for Enterprise Performance Management (EPM)

Oracle Digital Assistant for Enterprise Performance Management Thank you to Mike Casey, EPM Product Management, for the presentation on this topic You can also watch the on-demand video here. The Oracle Digital Assistant (ODA) is a platform that enables creating and deploying digital assistants, which are AI-driven interfaces that help users accomplish a variety of tasks in natural language conversations. It is an independent Oracle product, a Platform-as-a-service (PaaS) offering. Several Oracle SaaS products have delivered pre-built digital assistant skills to work with the ODA platform. The Oracle Digital Assistant for Enterprise Performance Management (EPM) is designed as a family of conversational skills for Oracle Enterprise Performance Management business processes that are built for use with ODA platform. To use the EPM Digital Assistant, you need to have an Oracle Digital Assistant subscription as well as one or more of the following Enterprise Performance Management business processes that have digital assistant skills currently available: (see Release Plan section below for more details) Account Reconciliation Financial Consolidation and Close   Oracle Digital Assistant (formerly known as "Chatbot") Review the key points from the presentation; including the release plan. Conversational interaction with EPM Automatic speech recognition and natural language processing Typically available on multiple channels Web UI, mobile, slack, etc. First release for EPM will be web channel  only Extend “skills” to tailor to customer specific requirements Insights Release Plan: First Release, available February 2021 Financial Consolidation and Close AND Account Reconciliation Web Channel Only Subsequent Releases Planning Teams, SMS Requires Oracle Digital Assistant (ODA)  Cloud Service or ODA Platform subscription EPM Digital Assistant Skills provided at no charge   How to Enable Digital Assistant in Your Environment   Use Case: Oracle Digital Assistant for Account Reconciliation (New in 21.02) Use Case: Oracle Digital Assistant for Consolidation (New in 21.02) ========================================================================================================= References: Presentation - provided by Mike Casey, EPM Product Management Recorded webcast can be accessed here Oracle Digital Assistant (ODA) Oracle Digital Assistant - Getting Started Getting Started with the Digital Assistant for Oracle Cloud Enterprise Performance Management February 2021 Update -  New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation

Oracle Digital Assistant for Enterprise Performance Management Thank you to Mike Casey, EPM Product Management, for the presentation on this topic You can also watch the on-demand video here. The Oracle...

BI On Premise

Advisor Webcast: OBIA 12c: BIApps 11.1.1.10.3 Updates and Applying Patch Bundle 1

Register for the following Advisor Webcast! OBIA 12c: BIApps 11.1.1.10.3 Updates and applying Patch Bundle 1 Schedule Tuesday , April 06, 2021 08:00 AM (US Pacific Time) Tuesday , April 06, 2021 11:00 AM (US Eastern Time) Tuesday , April 06, 2021 05:00 PM (Central European Time) Tuesday , April 06, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast is recommended for (technical users, functional users, system administrators, Database Administrators, etc.) Who use or work on OBIA/BIApps. Topics Include: OBIA 12c: BIApps 11.1.1.10.3 Uptake and Updates BIApps 11.1.1.10.3 PB1 Patch Summary PBx Release Cadence PB1 MOS KM Reference Notes OBIA Patching Steps and Details Q&A   ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: OBIA 12c: BIApps 11.1.1.10.3 Updates and applying Patch Bundle 1 on April 6, 2021 (Doc ID 2755085.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! OBIA 12c: BIApps 11.1.1.10.3 Updates and applying Patch Bundle 1 Schedule Tuesday , April 06, 2021 08:00 AM (US Pacific Time)Tuesday , April 06, 2021 11:00 AM...

EPM On Premise

Oracle Hyperion Calculation Manager 11.1.2.4.015 is Available

The following Patch Set Update (PSU) has been released for Hyperion Calculation Manager 11.1.2.4, and available for download from the My Oracle Support > Patches & Updates section: Oracle Hyperion Calculation Manager PSU 11.1.2.4.015 Patch 32535657   Patch Type: This is a patch set update (PSU).  This patch replaces files in the existing installation and does not require a full installation. Supported Paths to This Patch: You can apply this patch to the following releases: 11.1.2.4.000 11.1.2.4.001 (20569991) 11.1.2.4.002 (20830325) 11.1.2.4.003 (21284466) 11.1.2.4.004 (21453167) 11.1.2.4.005 (22549387) 11.1.2.4.006 (22806363) 11.1.2.4.007 (23596012) 11.1.2.4.008 (25362429) 11.1.2.4.009 (25775528) 11.1.2.4.010 (25926429) 11.1.2.4.012 (27534345) 11.1.2.4.013 (27780138) 11.1.2.4.014 (28557058) All users should clear cached files from their browsers.   Prerequisites: Required Patches - Hyperion Planning 11.1.2.4.002(20937926) or higher Required User Rights - The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights: Windows - Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: “Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.” UNIX/Linux:- Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products. OPatches are not intended to be applied using a root user.   Defect Fixed in this Release: 32494859 - The Enable flash button in Calculation Manager should not be shown   Readme File: Refer to the Readme files for information pertaining to the above requirements. The Readme file should also be consulted prior proceeding with the PSU implementation for important information that also includes supported paths, list of defects fixed, additional support information, prerequisites, required rights, details for applying patch and troubleshooting FAQ's. It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file. The Readme file is available from the Patches & Updates download screen.   To locate the latest Patch Sets and Patch Set Updates for the EPM products visit the My Oracle Support (MOS) Knowledge Article: Available Patch Sets and Patch Set Updates for Oracle Hyperion Enterprise Performance Management Products (Doc ID 1400559.1)      

The following Patch Set Update (PSU) has been released for Hyperion Calculation Manager 11.1.2.4, and available for download from the My Oracle Support > Patches & Updates section: Oracle Hyperion...

BI Cloud

Explore New Features in Oracle Analytics Server Release 5.9

Oracle Analytics Server (OAS) Release 5.9 provides you with capabilities to extend your machine learning practice with confidence.  With the introduction of Oracle machine learning and use of Oracle Database analytic functions, you can increase your analytic power all in a no-code interface.  Content developers now have additional controls to help ensure that their shared analyses provide a great user experience.  You can also impress your users with the ability to create custom background images that highlight your data in new and creative ways. What’s New in Release OAS 5.9   Capabilities for this release include most features from Oracle Analytics Cloud (OAC) 5.6, 5.7, 5.8, and 5.9. You can also find additional capabilities for this release in the Oracle Analytics Cloud 5.9 Release Blog. Oracle Machine Learning Registration and usage of Oracle machine learning models | Docs You can now leverage the power of Oracle Database or Autonomous Data Warehouse (ADW) to run existing machine learning models on your data stored in the database or Oracle Analytics Server.  Just register the machine learning model in OAC and you can run that model on data stored in OAC Datasets or on data in your database. From the data flow, choose the data you want to use and select Apply Model.  Next, chose a registered machine learning model.  Save the data as a new data set for the Oracle Database connection to view the model results. To find out more about registering and using Oracle machine learning models, watch this video.   Additional model training output for clusters | Docs The ability to quickly determine clusters within your data is a base feature included in business intelligence tools today.  Now you have the power to access additional model output for clusters to see cluster size, distance from center, and centers.  The data arrangement then enables you to visualize the results and gain a better understanding of it.  You can also use a network chart to see how the decision tree plots your results.       Advanced Analytics with Database Analytics Customers that leverage Oracle Database or Autonomous Data Warehouse (ADW) can now take advantage of the new Database Analytics node available in data flows.  These database functions provide you with many types of analytic operations that make it easy to perform complex computations, all in a no-code environment.   Support for database analytics un-pivoting in data flows | Docs It’s necessary for you to manipulate your data in order to format the results in a way that’s useful for you.  You can now transpose data that’s stored in the Oracle Database or Autonomous Data Warehouse (ADW) with the unpivot function in the Database Analytics node of data flows.   To find out more about un-pivoting columns into rows, watch this video. There’s now additional support for sampling your data when you just need to use a portion of your data sets for model training or dashboard development on a smaller data size.   You can perform dynamic clustering or anomaly detection to quickly partition data sets based on defined attributes.             Data Visualizations and Design Custom background images and map layer creation tool | Docs Data can be represented in many different ways through visualizations.  You can now enable your users to power up their data with custom background images.  If your business uses data that’s related to any type of image or drawing, simply import the image, use the drawing tools to segment areas in the image, and assign data elements to the image segments drawn to create a powerful visualization.  These visualizations are interactive and cross filter other visuals on your dashboard. To find out more about custom map backgrounds, watch this video.   Heat-map layers with custom image maps | Docs Map layers provide you with another compelling way to visualize data.  With support for the new heat-map layer, you can import an image and assign your data points to the map by latitude and longitude coordinates.  To find out more about using heatmaps to visualize detailed latitude and longitude points on custom image maps, watch this video.   Improved map performance Content developers can now set zoom controls on map visualizations.  Depending on the geographical map, you may or may not want to enable zoom for your users. If you set zoom interactions to off, users won’t be able to use wheel, scroll and double-click map zooms.  For large result sets, users will receive a data truncation warning.    Visualization use-as-filter configuration New single click filter capabilities are now available in the filter properties pane.  You can now select the filter icon on a chart or grid in data visualizations to quickly begin selecting attributes and measures to filter other visuals on the page. Single header bar With the newly combined header for Oracle Analytics Server, you now have more space for data viewing and content creation density.   Waterfall visualization for building bridge reports Additional functionality is available in the Waterfall visualization with the new Detail field in the Grammar panel.   This field utilizes attributes for showing positive and negative variations between values in the category details. You’ll also see additional capabilities in the properties pane for setting Detail field colors. To find out more about waterfall chart enhancements, watch this video.   Spark chart on performance tiles | Docs Performance tiles are a highly used visualization type for key performance metrics.  You can include spark charts in your performance tiles to quickly show trends that make up that value with an area, bar, or line chart and include the high and low marks in the data.  You can use a simple mouse hover to access the tooltip information. To find out more about spark charts on performance tiles, watch this video.   Top and bottom N filters for attributes | Docs Users commonly want to search for the top 10 or bottom number of values from a list of attributes.  With the new filter options, you can determine what to filter without needing to ask a content developer to create it.  Once you select the filter, you can choose the number (n) of rows for either top or bottom, set the measure to use, and quickly filter your data sets on the fly.  To find out more about creating top (n) filters from attributes, watch this video.   Custom calculation copy/duplicate and canvas bar enhancements Flexibility in content creation is key for you to be efficient.  You can now right click a calculation to access the Duplicate Calculation option for making small changes to your calculations. The Canvas tab improvements provide more viewing space for your canvas labels. Canvas layout in OAS 5.5 Canvas layout in OAS 5.9 To find out more about custom calculations and canvas bar enhancements, watch this video. Content developer controls Control the column-width in pivot tables by dragging your column or row edge to the preferred size for the best visual fit depending on your data. Set the transparency background for image/color to best control the necessary data reading.  To find out more about content developer controls, watch this video.   Set a data action to a Publisher report | Docs Data actions are a very powerful and commonly used feature for directing users to an object for further information.  Content developers can now include Publisher reports from the Catalog for user redirection. To find out more about navigating to Publisher reports from data actions, watch this video.   Other data visualization features There are a number of additional features and user interface changes to improve the experience including: List box filter visualization Filter options in properties pane Layout container and visual spacing enhancements Harmonized legend properties across visualization Improved density and visibility Duplicate canvas near original Content paging rows setting   Data and System Settings Simplified data set editor The new page editor provides you with a single interface for managing data sets.  Properties include incremental data refreshes, caching rules, and flexible column management.  The newly densified page enables you to see more content and provides you with inline editing capabilities such as removing columns to quickly design your data scheme. To find out more about reducing clicks in the data set editor, watch this video.   Regular expressions in data preparation | Docs When you clean and prepare your data, a common occurrence is the need to replace some portion or pattern in your text with something different.  Within Data Preparation, when select the attributes Option you will now see the Replace function, providing the ability to use regular expressions to replace text with new values. Here are some examples of different ways to search your data: Literal matches — Matches the exact text for partial or entire values. Re-inserted matched text — Allows the insert of text before and after regex matches. Back references — Allows the replacement text to reuse parts of the text matched by the regular expression. Character classes or sets — Used for matching only one out of several characters.                  To find out more about regular expressions, watch this video.   Enhanced Oracle Enterprise Performance Management Cloud (EPM) data modeling | Docs Oracle EPM Cloud connectivity can now be created directly in self-service. To find out more about using the EPM data modeling connector, watch this video.   Improved live data sets When you set the data access value to live mode, cache is neither populated nor used when additional queries are issued.  This enables a call back to the database every time a call is made.  Depending on your scenario, you can set the value to cache or live to give you the control you need.   Propagate permissions to object associated artifacts When you save report objects, you will receive a prompt if you don’t have access to the related artifacts.  This ensures that data security is aligned between your reports and data structures.   To find out more about propagating permissions to associated artifacts, watch this video.   Configurable local time zone | Docs You can set a defined time zone in System Settings to enable your specific date calculations. To find out more about configuring custom time zones, watch this video.   Resources What's Notable and Different in Oracle Analytics Server Tech Blogs Oracle Analytics Community Hub Oracle Analytics Cloud and Server Public Roadmap Submit product ideas at the Oracle Analytics Idea Lab

Oracle Analytics Server (OAS) Release 5.9 provides you with capabilities to extend your machine learning practice with confidence.  With the introduction of Oracle machine learning and use of Oracle...

EPM Cloud

Vanity URL Support in Enterprise Performance Management (EPM) Cloud

Vanity URL Support in EPM Cloud Thanks to Daniel Edwin, EPM Infrastructure Team, for the presentation on this topic. Support for Vanity URLs You can use custom URLs to access EPM Cloud environments from a web browser and Smart View. You use a third party link shortener, for example, T.ly, Bitly, Rebrandly, TinyUrl, is.gd and so on, or an open source solution, for example, YOURLS, to configure custom URLs for each environment. For detailed information on creating vanity URLs, see the documentation from the third party link shortener of your choice. Vanity URLs work for Smart View version 20.200 and higher only. Vanity URL is currently not supported for EPM Automate, EPM Agent, and cross-environment connections (EPM Connect). Vanity URLs help you easily remember and enter URLs of EPM Cloud environments into a web browser.   Vanity URL Examples: Below are examples of Vanity URL configurations using third party vanity URL provider “ReBrandly” for the following business processes in Classic and OCI flavors of EPM Cloud: Planning and Budgeting Cloud Narrative Reporting Cloud Profitability and Cost Management Cloud   Vanity URL Support for EPM Cloud - Classic – Planning and Budgeting – Web Interface   Vanity URL Support for EPM Cloud - OCI  – Profitability and Cost Management- Web Interface   Vanity URL Support for EPM Cloud - Classic – Planning and Budgeting – Smart View   Vanity URL Support for EPM Cloud – Classic – Narrative Reporting  – Smart View     Vanity URL Configuration for EPM Cloud - OCI  – Profitability and Cost Management – Smart View ================================================================================== References: Presentation - provided by Daniel Edwin, EPM Infrastructure Team Using Vanity URLs to Redirect to EPM Cloud Smart View version 20.200  

Vanity URL Support in EPM Cloud Thanks to Daniel Edwin, EPM Infrastructure Team, for the presentation on this topic. Support for Vanity URLs You can use custom URLs to access EPM Cloud environments from...

EPM On Premise

Advisor Webcast: Financial Reporting Print Service 11.1.2.1

Register for the following Advisor Webcast! Financial Reporting Print Service 11.1.2.1 Schedule Wednesday, March 24, 2021 08:00 AM (US Pacific Time) Wednesday, March 24, 2021 11:00 AM (US Eastern Time) Wednesday, March 24, 2021 04:00 PM (Central European Time) Wednesday, March 24, 2021 08:30 PM (India Standard Time) The details of this Advisor Webcast are found below! You can also visit the Oracle Product Support Advisor Webcasts series page to register for upcoming webcasts and view the replays of any that you may have missed! Description: This one-hour advisor webcast is recommended for (technical users, functional users, system administrators, Database Administrators, etc.) covering topics 11.1.2.1 FR print service architecture, Installation / configuration, performance tuning and trouble shooting. Topics Include: Financial Reporting 11.1.2.1 print services architecture Installation and configuration Performance tuning Troubleshooting Questions and Answers   ============================================================================================ For Additional Information and Registration Details: ADVISOR WEBCAST: EPM - Financial Reporting Print Service 11.1.2.1 on March 24, 2021 (Doc ID 2744545.1) To view scheduled & archived recordings of previous webcasts: Business Analytics Advisor Webcasts visit Doc ID 1456233.1 Oracle Product Support Advisor Webcasts - search for your webcast and register    

Register for the following Advisor Webcast! Financial Reporting Print Service 11.1.2.1 Schedule Wednesday, March 24, 2021 08:00 AM (US Pacific Time) Wednesday, March 24, 2021 11:00 AM (US Eastern Time)Wed...

Monthly Index

Business Analytics Monthly Index - February 2021

Welcome to the Monthly Index for February 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence and Hyperion EPM from the past month.   General Summary Business Analytics Monthly Index - January 2021   Business Intelligence (BI) Summary No posts this month   Business Intelligence (BI) Cloud Summary Explore New Capabilities in Oracle Analytics Cloud Release 5.9     Enterprise Performance Management (EPM) Summary EPM Patch Set Updates - January 2021 Oracle Essbase Customers On 11.1.2.4.041 or 11.1.2.4.042 for IBM AIX on POWER Systems (64-bit) are Requested to Upgrade to Oracle Essbase 11.1.2.4.043   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - March 2021 Updates Account Reconciliation - March 2021 Cloud Updates Narrative Reporting - March 2021 Cloud Updates Financial Consolidation and Close - March 2021 Cloud Updates Oracle Planning - March 2021 Cloud Updates Profitability and Cost Management - March 2021 Cloud Updates Tax Reporting - March 2021 Cloud Updates Next Generation Reporting Comes to the Enterprise Performance Management (EPM) Cloud Platform New Video Tutorials for Reports in Cloud EPM (Enterprise Performance Management) Application Design for EPM Planning Part I: App Deployment, Dimensions, and Forms Dynamic Tabs in Enterprise Performance Management (EPM) Cloud   Essbase On Premise No posts this month   Essbase Cloud Oracle Essbase 21.1 is now available on OCI Marketplace   Advisor Webcasts Advisor Webcast: EPM - What's New in Financial Consolidation and Close Cloud (FCCS) 21.02 Advisor Webcast: Oracle Business Analytics SMTP Setup in Oracle Analytics Cloud (OAC) Using Oracle Cloud Infrastructure (OCI) Email Advisor Webcast: Oracle Analytics Cloud (OAC) Snapshots and Backups

Welcome to the Monthly Index for February 2021 This blog provides quick links to recent Proactive Support Blog postings for Oracle Business Intelligence and Hyperion EPM from the past month.   General...