X

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

Recent Posts

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...

EPM Cloud

Profitability and Cost Management - March 2021 Cloud Updates

Profitability and Cost Management - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 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, March 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, March 19, 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 Enabling the Redwood Experience and Uploading Image Files for Custom Logos and Watermarks Ability to Hide the Business Process Name in Browser Tabs and on the Global Header New Clone Snapshot Feature Using Direct URLs to Integrate Connected Environments Changes to Reserved Group Names in Access Control REST APIs to View and Update Connections Support for Cell-Level Security Smart View Now Supports Vanity URLs New Option for Greater Row Dimension Flexibility in Flex Forms Smart View Support for Saving Ad Hoc Grids in Standard Mode New Custom Functions in Calculation Manager Approval Process Validation Enhancement in Financial Consolidation and Close Align Prefix and Suffix Symbols in Reports Cell Number Formatting Auto-Complete for Manual Entry of Reports Member Names and Functions in the Formula Bar Bursting of Report Output to Excel Suppress Missing Reports in a Book Dynamic Custom Y-Axis Minimum and Maximum in Reports Charts Direct Data Load Using the EPM Integration Agent Review  IMPORTANT Actions and Considerations   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 - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

Essbase Cloud

Oracle Essbase 21.1 is now available on OCI Marketplace

Oracle Essbase 21.1 is now available on OCI Marketplace We are excited to announce the General Availability of Essbase 21c on the Oracle Cloud Infrastructure Marketplace. This follows the release of Essbase 21c on-premises in December of 2020. Following are some of the new features and enhancements to the latest listing on Marketplace over the 19c releases: Shadow Cubes using REST API’s Outline Enhancements Verify Outline Resize columns Select Member properties to display Display additional member info in the Name column Web UI Enhancements Execute Calc scripts and Report scripts during design Load multiple data files in a single data load job Use Outline member selector while defining partitions Cube Designer Enhancements Block Storage Optimization Utility (For details refer documentation) For more details, review the 21.1.0.0.1 release notes. You can also review the Differences Between Essbase Deployment Options in order to decide on the right deployment option that suits your need. For customers that are moving from on-premise 11g to OCI review the Differences Between Essbase 11g and Essbase 21c. Note for customers that are running Essbase 19c on OCI, deployed using the 19c Marketplace listings. Kindly review the published Oracle Support Document 2754635.1 for details on support and error correction policies for Essbase 19c running on OCI. It is recommended that customers move to the latest 21c listing to be current on support.        

Oracle Essbase 21.1 is now available on OCI Marketplace We are excited to announce the General Availability of Essbase 21c on the Oracle Cloud Infrastructure Marketplace. This follows the release of...

EPM Cloud

Tax Reporting - March 2021 Cloud Updates

Tax Reporting - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 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, March 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, March 19, 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 Enabling the Redwood Experience and Uploading Image Files for Custom Logos and Watermarks Ability to Hide the Business Process Name in Browser Tabs and on the Global Header New Clone Snapshot Feature Using Direct URLs to Integrate Connected Environments Changes to Reserved Group Names in Access Control REST APIs to View and Update Connections Support for Cell-Level Security Smart View Now Supports Vanity URLs New Option for Greater Row Dimension Flexibility in Flex Forms Smart View Support for Saving Ad Hoc Grids in Standard Mode New Custom Functions in Calculation Manager Approval Process Validation Enhancement in Financial Consolidation and Close Align Prefix and Suffix Symbols in Reports Cell Number Formatting Auto-Complete for Manual Entry of Reports Member Names and Functions in the Formula Bar Bursting of Report Output to Excel Suppress Missing Reports in a Book Dynamic Custom Y-Axis Minimum and Maximum in Reports Charts Direct Data Load Using the EPM Integration Agent Review  IMPORTANT Actions and Considerations   Tax Reporting: This section contains information related to Tax Reporting. Acquisition, Rate Change, and Effective Tax Rate (ETR) Calculation   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 - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Oracle Planning - March 2021 Cloud Updates

Planning - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 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, March 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, March 19, 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 Enabling the Redwood Experience and Uploading Image Files for Custom Logos and Watermarks Ability to Hide the Business Process Name in Browser Tabs and on the Global Header New Clone Snapshot Feature Using Direct URLs to Integrate Connected Environments Changes to Reserved Group Names in Access Control REST APIs to View and Update Connections Support for Cell-Level Security Smart View Now Supports Vanity URLs New Option for Greater Row Dimension Flexibility in Flex Forms Smart View Support for Saving Ad Hoc Grids in Standard Mode New Custom Functions in Calculation Manager Approval Process Validation Enhancement in Financial Consolidation and Close Align Prefix and Suffix Symbols in Reports Cell Number Formatting Auto-Complete for Manual Entry of Reports Member Names and Functions in the Formula Bar Bursting of Report Output to Excel Suppress Missing Reports in a Book Dynamic Custom Y-Axis Minimum and Maximum in Reports Charts Direct Data Load Using the EPM Integration Agent Review  IMPORTANT Actions and Considerations   Planning: This section contains information related to Planning. New Videos REST API to Import Cell-Level Security REST API to Export Cell-Level Security REST API to Export Valid Intersections REST API to Import Valid Intersections Disallow Deletion of User Variables Used in Forms Planning Modules Valid Intersections Updated for Quarterly Planning Migration of Account Forecast to Oracle JET in Strategic Modeling Run Clear Cube Jobs Using Groovy Rules   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 - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Financial Consolidation and Close - March 2021 Cloud Updates

Financial Consolidation and Close - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 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, March 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, March 19, 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 Enabling the Redwood Experience and Uploading Image Files for Custom Logos and Watermarks Ability to Hide the Business Process Name in Browser Tabs and on the Global Header New Clone Snapshot Feature Using Direct URLs to Integrate Connected Environments Changes to Reserved Group Names in Access Control REST APIs to View and Update Connections Support for Cell-Level Security Smart View Now Supports Vanity URLs New Option for Greater Row Dimension Flexibility in Flex Forms Smart View Support for Saving Ad Hoc Grids in Standard Mode New Custom Functions in Calculation Manager Approval Process Validation Enhancement in Financial Consolidation and Close Align Prefix and Suffix Symbols in Reports Cell Number Formatting Auto-Complete for Manual Entry of Reports Member Names and Functions in the Formula Bar Bursting of Report Output to Excel Suppress Missing Reports in a Book Dynamic Custom Y-Axis Minimum and Maximum in Reports Charts Direct Data Load Using the EPM Integration Agent Review  IMPORTANT Actions and Considerations   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. Additional Consolidation Features in Standard Edition Data Load Files with Closing Balance Input Entries 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 - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Narrative Reporting - March 2021 Cloud Updates

Oracle Narrative Reporting - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 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, March 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, March 19, 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 Enabling the Redwood Experience and Uploading Image Files for Custom Logos and Watermarks Ability to Hide the Business Process Name in Browser Tabs and on the Global Header New Clone Snapshot Feature Using Direct URLs to Integrate Connected Environments Changes to Reserved Group Names in Access Control REST APIs to View and Update Connections Support for Cell-Level Security Smart View Now Supports Vanity URLs New Option for Greater Row Dimension Flexibility in Flex Forms Smart View Support for Saving Ad Hoc Grids in Standard Mode New Custom Functions in Calculation Manager Approval Process Validation Enhancement in Financial Consolidation and Close Align Prefix and Suffix Symbols in Reports Cell Number Formatting Auto-Complete for Manual Entry of Reports Member Names and Functions in the Formula Bar Bursting of Report Output to Excel Suppress Missing Reports in a Book Dynamic Custom Y-Axis Minimum and Maximum in Reports Charts Direct Data Load Using the EPM Integration Agent Review  IMPORTANT Actions and Considerations   Narrative Reporting New Doclet Versioning Optimization Support for Member Selection Functions to Copy Notes in the Notes Manager 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 - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

EPM Cloud

Account Reconciliation - March 2021 Cloud Updates

Account Reconciliation - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 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, March 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, March 19, 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 Enabling the Redwood Experience and Uploading Image Files for Custom Logos and Watermarks Ability to Hide the Business Process Name in Browser Tabs and on the Global Header New Clone Snapshot Feature Using Direct URLs to Integrate Connected Environments Changes to Reserved Group Names in Access Control REST APIs to View and Update Connections Support for Cell-Level Security Smart View Now Supports Vanity URLs New Option for Greater Row Dimension Flexibility in Flex Forms Smart View Support for Saving Ad Hoc Grids in Standard Mode New Custom Functions in Calculation Manager Approval Process Validation Enhancement in Financial Consolidation and Close Align Prefix and Suffix Symbols in Reports Cell Number Formatting Auto-Complete for Manual Entry of Reports Member Names and Functions in the Formula Bar Bursting of Report Output to Excel Suppress Missing Reports in a Book Dynamic Custom Y-Axis Minimum and Maximum in Reports Charts Direct Data Load Using the EPM Integration Agent Review  IMPORTANT Actions and Considerations Account Reconciliation: All Supported Transactions for All Match Processes Are Now Displayed 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 - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

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

Enterprise Data Management Cloud (EDMCS) - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 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, March 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, March 19, 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 Enabling the Redwood Experience and Uploading Image Files for Custom Logos and Watermarks Ability to Hide the Business Process Name in Browser Tabs and on the Global Header New Clone Snapshot Feature Using Direct URLs to Integrate Connected Environments Changes to Reserved Group Names in Access Control REST APIs to View and Update Connections Support for Cell-Level Security Smart View Now Supports Vanity URLs New Option for Greater Row Dimension Flexibility in Flex Forms Smart View Support for Saving Ad Hoc Grids in Standard Mode New Custom Functions in Calculation Manager Approval Process Validation Enhancement in Financial Consolidation and Close Align Prefix and Suffix Symbols in Reports Cell Number Formatting Auto-Complete for Manual Entry of Reports Member Names and Functions in the Formula Bar Bursting of Report Output to Excel Suppress Missing Reports in a Book Dynamic Custom Y-Axis Minimum and Maximum in Reports Charts Direct Data Load Using the EPM Integration Agent   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). New Video 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) - March 2021 Enterprise Performance Management (EPM) Cloud Common - March 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Dynamic Tabs in Enterprise Performance Management (EPM) Cloud

Dynamic Tabs in EPM Cloud Thank you to Shankar Viswanathan and Murali Kuppala, part of the EPM Cloud Platform Product Management team, for the presentation on this topic. You can also watch the recorded webinar. Key Benefits of Dynamic Tabs is that it provides a better user experience. Reduces number of clicks Enables multi-tabbing and persistence of tabs across cards. Avoids popups where not needed Enables on the fly context driven navigation flow Provides end user control in tabbing Moves EPM tabs to bottom of page Distanced from browser tabs at top More headroom for form and dashboard names above grid Provides an excel workbook like tab experience   Dynamic Tabs & Redwood Experience Dynamic tabs are only available with ‘Redwood’ Theme ‘Redwood’ theme automatically  defaults with Dynamic tabs in  21.02 From 21.03 ‘Redwood’ becomes  an ‘Experience’ option outside of  themes Other themes will continue to  work as they did in 21.01 without  dynamic tabs. Reduces change in behavior on existing users   SKUs and Business Process Influenced Cloud EPM Business Processes* supported Planning (Strategic Modeling in Q2 CY21) Financial Consolidation and Close Account Reconciliation Profitability and Cost Management Tax Reporting Available in all EPM SKUs Current EPM Standard Cloud Service EPM Enterprise Cloud Service Legacy - PBCS, EPBCS, FCCS, TRCS, ARCS, PCMCS * Extend of adoption may vary across business processes   Areas Impacted Open artifacts directly from their listing page view in ‘Default’ navigation flows Task List (Planning) Data Dashboard Infolets Other impacted list views Recent, Favorites, Tasks (Planning only) Valid Intersection, Data Exchange, Access Control Out of the Box Planning Modules navigation Open tabs on the fly while working within ‘custom’ navigation flow Action menu targets open in new on the fly tabs that can be closed Right click action menus: End user: Drill through, target dashboards, forms, adhoc Admin: Form edit, member in outline   How It Works Dynamic tabs are auto enabled when ‘Redwood’ theme is selected. When Redwood Theme is enabled all horizontal tabs open at the bottom of the screen No change in vertical tabs Dynamic Tabs are persisted until session is active – until user logs out Filtered view across cards is persisted for last set of open tabs Opened dynamic tab can be closed individually All dynamic tabs within a card view can be closed together Create up to 25 dynamic tabs within a card Warning for unsaved data when you move to another tab Opening artifacts from ‘Recent’ list opens them where last opened – list view or custom navigation view Redwood and Dynamic Tabs in connected multi-pods Theme of Primary (Source) pod drives behavior When artifacts from other connected pods are accessed, they will render based on primary pod theme   Examples: Refer to the presentation for specific examples and screenshots on Dynamic tabs in Artifacts pages, data forms, dashboards and much more! Check it out! ================================================================================ References: Presentation  provided by Shankar Viswanathan and Murali Kuppala, part of the EPM Cloud Platform Product Management team Customer Connect recorded webinar    

Dynamic Tabs in EPM Cloud Thank you to Shankar Viswanathan and Murali Kuppala, part of the EPM Cloud Platform Product Management team, for the presentation on this topic. You can also watch the recorded...

BI Cloud

Advisor Webcast: Oracle Analytics Cloud (OAC) Snapshots and Backups

Register for the following Advisor Webcast! Oracle Analytics Cloud Snapshots and Backups Schedule Tuesday , March 09, 2021 08:00 AM (US Pacific Time) Tuesday , March 09, 2021 11:00 AM (US Eastern Time) Tuesday , March 09, 2021 05:00 PM (Central European Time) Tuesday , March 09, 2021 09:30 PM (India Standard Time) Register for upcoming webcasts and view the replays of any that you may have missed on the Oracle Product Support Advisor Webcasts series page. Description: This one-hour advisor webcast is recommended for technical users, system administrators, Database Administrators, etc. This one-hour advisor webcast will cover the overview of the snapshots and backups in Oracle Analytics cloud, usage of Data migration utility, End-To-End flow, and troubleshooting use cases.   Topics Include: Snapshot overview Back ups Overview Migrate Metadata FAQ's on Snapshots/back ups Question & Answers ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: Oracle Business Analytics - Oracle Analytics Cloud Snapshots and Backups on March 9, 2021 (Doc ID 2738102.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 Snapshots and Backups Schedule Tuesday , March 09, 2021 08:00 AM (US Pacific Time) Tuesday , March 09, 2021 11:00 AM (US Eastern Time)Tue...

BI Cloud

Explore New Capabilities in Oracle Analytics Cloud Release 5.9

Oracle Analytics Cloud (OAC) Release 5.9 introduces new capabilities that empower users to deepen their analytic skills with confidence. OAC has exposed powerful capabilities of the Oracle Database to users in a no-code machine learning environment. Now, users have full access to machine learning outputs to help them understand what attributes influenced each predicted value, all in a no-code environment. OAC has also added two new powerful Database Analytic functions: Text Analytics and Frequent Itemset. These no-code functions empower users to gain insights to their data that they wouldn’t otherwise find so easily. What’s New in Release 5.9   Oracle Machine Learning and Database Analytics Support for Database Analytics Text Tokenization in Data Flows | Docs We’re collecting more data today than ever before. Text Analytics offers automated processing of your data to render back insights that enable you to analyze like never before.  OAC offers the most simplistic, no-code user interface to quickly gain these insights. These capabilities enable you to extract words from unstructured data, count them, visualize the results, and then join the token analysis with your original data so you can drill into any level of detail.  Watch a video on using Text Tokenization Support for Database Analytics Frequent Itemset in Data Flows | Docs What kind of business decisions could you make if you knew more about how buying behaviors occurred? By using the Frequent Itemset function, you can understand which items are frequently bought together. A common use of the Frequent Itemset is to run a Market Basket analysis, where you can identify which combination of products are mostly commonly purchased together. This information can help you maximize the layout of a store floorplan or understand what coupons should be distributed to promote products based on purchase behaviors. Watch a video using Frequent Itemset Oracle Machine Learning (OML):  Model Explain-ability | Docs Does it ever feel like you’re working in a black box when running machine learning models?  How easy is it for you to understand what influenced the prediction outcome? You can register and execute Oracle Machine Learning models from OAC. Additional outputs are now available, providing transparency to how the predicted values were computed. For each record in your predicted output, you can show the top five attributes and values for each predicted outcome. These outputs are aggregated into a data set, providing visualization and interaction of model output. Watch a video using OML integration Data Visualizations and Design Map Layers from a Web Map Service (WMS) Protocol and XYZ Tile Layers | Docs Whether you need to analyze data over a population map or overlay bicycle and bus routes to optimize coverage of an area, you have more options to get the insights you need. With the new map layer options, you can leverage maps hosted on a web server as a dynamic background using the Web Map Service (WMS) protocol and XYZ tile layers. This enables you to take advantage of integrating maps containing information you might not have in your enterprise and easily present it spatially with your data. Watch a video on leveraging Web Map Services (WMS) for a map background Watch a video on how to implement XYZ layers as a map background   Sorting enhancements | Docs Sorting controls enable you to bring appropriate focus to your data attributes and measures.  You can sort by multiple columns, both in pivot tables and visualizations. You can sort from the Grammar Panel, through the context menu, or from the header of a pivot table. Remove or reset all sorting with the Clear Sorts option. Sort order is determined based on the order of selections, first to last. Improved Browser Content Density | Docs OAC is regularly improved for content density, to help maximize the screen space and provide flexibility to determine your focus areas. The Data Panel selections are moved to the top horizontal position. and the search box is transformed to a permanent accessed object, providing quicker access to attributes and measures in your data. The Data Panel, which was previously minimized to a left bar, is now fully hidden -- providing extra space for your analysis. Use a small icon, to the right and centered in the panel (see red outlined area in image for location) for quick accessibility to expand and collapse the panels. Improved Progress Bar Behavior | Docs Query progress indicators have changed from a per visual horizontal progress bar to a single canvas progress circle that tracks the query execution progress for all visualizations on the canvas. Pass Filters Between the Filter Bar and Visualizations | Docs Developing reports or performing an analysis is an iterative process of creating visualizations and duplicating and modifying content. You need the flexibility to quickly modify content without having to remove and re-add steps. The new drag-and-drop filter capabilities let you assign the scope of the filter to be at the canvas or visualization level with a single drag and drop of the filter.  Visualizations filter properties have new options for displaying the filter bar, using the visualization as a filter to other visualizations on your canvas, and an option to show the filter toggle icon on the visualization header. Increased Limits for Data Export and Query Results Analytic applications are typically used for high-level insights and aggregated information, but you still need to both query and export large amounts of data. Export and query limits have been increased as follows: The number of rows returned when you query data for visualizations, analyses, and dashboards has increased to 2 million rows (2-12 OCPUs) and 4 million rows (16 - 52 OCPUs). Limits Querying Data (Data Visualization Projects, Classic Analyses and Dashboards) The number of data rows that you can export from analyses and dashboards (Classic) has increased for unformatted reports (CSV, Excel, XML, and Tab Delimited): limit increased to 2 million rows (2-12 OCPUs) and 4 million rows (16 - 52 OCPUs).  Formatted reports (PDF, Excel, PowerPoint, HTML): Limit increased to 200,000 rows (2-12 OCPUs) and 400,000 rows (16 - 52 OCPUs).  Limits Exporting Data (Classic Analyses and Dashboards. Printing and Exporting Improvements | Docs Interactive dashboards provide point-and-click capabilities to quickly access important data. You might need to capture specific information from a dashboard or email a presentation to a colleague. The WYSIWYG exporting improvements provide you with beautifully exported views of your self-service content. Data and System Settings Data Actions Support Multi-Selection | Docs Data Actions provide a unique way to take selections within your data and pass them to other objects such as other analytic reports, web pages, and publication reports. Recent enhancements to Data Actions include the configuration for multiple selections, providing control over the user experience to ensure that the appropriate number of parameters are passed.  When the Multiple Selection setting is set to Off and a user has multiple attributes selected, your Data Action won’t be listed as an option in the context menu. Additional improvements include the resetting of all filters each time Data Actions are executed to avoid the passing of duplicate or incorrect filters.  Data Preparation Enhancements | Docs Cleaning and preparing data for analysis can be challenging without the right tools. The newly added Repair_us_zip_codes recommendation provides a single-click option to add leading zeros to zip code data that might get truncated during import. From the Prepare tab of your project, you can easily apply the recommendation to your zip code column and ensure all codes are valid for any geospatial analysis. A common behavior when importing data is the addition of white spaces in your categorical data. The new Trim function allows you to quickly remove all extra white spaces from any attribute column by selecting the Options bar for an attribute and choosing Trim. Impersonation Support for Hive Connections Using Kerberos | Docs When creating a connection to Hive, you can use a Kerberos authentication type and impersonation details. These new impersonation capabilities allow you to configure authentication using Kerberos and to leverage impersonation to designate a user’s credentials on behalf of a connection. Select the “Use the active user’s credentials” option to ensure that any database security that is configured, is honored. Day by Day Information Included in Snapshots | Docs Taking snapshots is a useful way to capture known good states of your environment. You might take snapshots prior to an upgrade or configuration change, or for migrating content between two environments. When using the custom option, you now can include or exclude your Day by Day snapshots. Content in the snapshot includes: For you, feed, bring backs, comments, and shared cards. System Settings Enhancements | Docs OAC Administrators can now specify whether users can override database features using request variables.   Brushing allows for a single selection in a visualization to be executed across many visualizations on a canvas. Administrators can control the default value for all users based on whether the data source is a Data Set or a Subject Area. Database Analytics is a node in the Data Flow that enables users to execute complex functions on data stored in Oracle Autonomous Data Warehouse or ADW.   System administrators can control if the Database Analytics node is displayed. What’s Fixed For a list of defects fixed in Oracle Analytics Cloud, see Doc ID 2744280.1. Resources What’s New in Oracle Analytics Cloud 5.9 OAC 5.9 Select Feature Playlist Oracle Analytics Blog OAC Tech Talks OAC Public Roadmap Submit product ideas at the Oracle Analytics Idea Lab

Oracle Analytics Cloud (OAC) Release 5.9 introduces new capabilities that empower users to deepen their analytic skills with confidence. OAC has exposed powerful capabilities of the Oracle Database to...

EPM Cloud

Application Design for EPM Planning Part I: App Deployment, Dimensions, and Forms

Application Design for EPM Planning Part I: App Deployment, Dimensions, and Forms Thank you to Manish Daga, Oracle EPM Product Development, for the presentation on this topic. You can also watch the recorded webinar. Getting the Planning application design right is important for meeting the Planning/Reporting requirements of the end users and scalability/performance requirements of the application. The presentation covers the following topics: Key requirement and design considerations Application deployment strategy Process and best practices for designing dimensions Best practices for designing forms   Application Design Separate data entry requirements from exporting ASO for reporting and Hybrid BSO for data entry and calculations Determine dimensions used in data entry vs. reporting Understand the level of detail Actual level of detail could be more granular than Forecast and Plan Understand all data sources both in and out of Planning Separate functionality into different cubes/applications where appropriate Align customer requirements to planning modules Leverage out of box functionality   Application Deployment Strategy   Dimensionality - Key Aspect of Planning Application Design   Dimension Best Practices Top 10 Best Practices for Dimensions Dimension order should follow modified hour glass Large block size has huge impact on performance. Optimal block size is between 8  KB to 500 KB. Reduce number of dense dimensions (max 3). Level 1 and above  should be label only or dynamic calc for dense dimensions. Text, Smart List, Date, and Stored Percentage type accounts should be set to Never  for consolidation.Aggregating these values, unless the accounts are explicitly excluded in any “agg” script will create nonsensical useless data on disc and make the application blow up. All GEN2 members should be set to “Ignore”. No security for root member anyway. Long/flat dimension will lead to an issue with performance of aggregation. Add  intermediate parents if there are more than 200 members under a parent member. Enabling dimension members for multiple cubes will create dynamic X-Ref’s and lead to  performance issues. Use “HSP_NOLINK” UDA and avoid creating dynamic X-Ref’s. Use  datamaps/smart push for moving data between cubes For simple calculations (e.g. Account C = Account A – Account B) leverage outline math  instead of writing member formula Single children parent members lead to implied shares or duplicate blocks & data on disk if parent member is made Never Share. Avoid single child parent members. Aggregate large dimensions in ASO instead of BSO whenever possible Store Historical data beyond 2 years in ASO instead of BSO   Forms Best Practices Top 10 Best Practices for Forms Dense dimensions on rows and columns, Sparse dimensions on page and POV Control the number of dimensions on a row. Having multiple dimensions on row will  negatively impact performance Turn on suppress missing blocks when sparse dimensions are on rows Reduce number of Business Rules set to run on save Use the outline to add member formula versus formula columns in the Form Ensure the Business Rules and Smart Pushes update unique data to reduce unnecessary contention Control the total number of rows ~ 100 rows or less Use member functions instead of picking individual members to reduce maintenance Leverage dynamic user variables, sub vars and valid combinations instead of creating too many forms Organize forms into folders   Other Sessions Include the following topics: Part II: Calculation Manager Rules & Hybrid BSO Part III: ASO, Datamaps & Smart Push Part IV: App Types & Migration from legacy SKUs =============================================================================== References: Presentation - by Manish Daga, Oracle EPM Product Development Customer Connect - Watch the recorded webinar.      

Application Design for EPM Planning Part I: App Deployment, Dimensions, and Forms Thank you to Manish Daga, Oracle EPM Product Development, for the presentation on this topic. You can also watch the reco...

EPM On Premise

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

Attention to Essbase customers that have upgraded to Oracle Essbase 11.1.2.4.041 or 11.1.2.4.042 for IBM AIX on POWER Systems (64-bit)! Oracle Essbase 11.1.2.4.041 and 11.1.2.4.042 Patchset Update for IBM AIX on POWER Systems (64-bit) contained incorrect binaries and have been removed from My Oracle Support. Customers that have upgraded to Oracle Essbase 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 as this is a superset of these Patchset Update releases. These PSU downloads are available from the  My Oracle Support > Patches & Updates section. 32253058 - HYPERION ESSBASE SERVER 11.1.2.4.043 32253069 - HYPERION ESSBASE RTC 11.1.2.4.043 32253063 - HYPERION ESSBASE CLIENT 11.1.2.4.043 32253060 - HYPERION ESSBASE CLIENT MSI 11.1.2.4.043 32253052 - HYPERION ANALYTIC PROVIDER SERVICES 11.1.2.4.043 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. Refer to the following for more information: Defect 32441013 - Oracle Essbase 11.1.2.4.041 and 11.1.2.4.042 Patchset Update for IBM AIX on POWER Systems (64-bit) contained incorrect binaries and have been removed from My Oracle Support. Customers that have upgraded to Oracle Essbase 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 as this is a superset of these Patchset Update releases. Essbase: Incorrect Binaries/Version Contained in Oracle Essbase 11.1.2.4.041 and 11.1.2.4.042 Patchset Update for IBM AIX on POWER Systems (64-bit) (Doc ID 2751882.1) Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase 11.1.x (Doc ID 1396084.1)

Attention to Essbase customers that have upgraded to Oracle Essbase 11.1.2.4.041 or 11.1.2.4.042 for IBM AIX on POWER Systems (64-bit)! Oracle Essbase 11.1.2.4.041 and 11.1.2.4.042 Patchset Update for...

EPM Cloud

New Video Tutorials for Reports in Cloud EPM (Enterprise Performance Management)

We are pleased to announce the availability of the following 4 new video tutorials for Reports in Cloud EPM: Reporting in the new Cloud EPM Platform Design reports using the new Reporting Solution in the Cloud EPM Platform. You can design reports with images, textboxes, charts, and grids. Insert formulas to calculate grid values and text functions to dynamically retrieve report and grid metadata. Apply robust reporting features such as zooming into levels, conditional formatting, and so on. Creating Reports in Cloud EPM See how to create reports in the new Cloud EPM Platform. You can start by creating a folder in the Library, create a report, define the data source, and select members. You can preview the report while you design it, format it, make changes to grid properties, and save the report. Adding Report Objects in Cloud EPM See how add text boxes and images to reports in Cloud EPM. You start with a report that already has a grid in it. You add a text box and then format the text. You add images to the report header, and you insert text functions into the report header to display specified information about the report. Creating Charts in Cloud EPM Learn how to create charts in Cloud EPM. You add charts and then set them up to visualize report data. You can base your chart off of an existing or new hidden grid. Then you can select the data to include in the chart. You can select the type of chart such as a pie chart or stacked bar chart, and select how the legend is displayed. For more information.... Click the links to view the YouTube Playlists for Planning, Financial Consolidation and Close, and Tax Reporting. The video tutorials are available on the Planning, Financial Consolidation and Close, and Tax Reporting Help Centers.

We are pleased to announce the availability of the following 4 new video tutorials for Reports in Cloud EPM: Reporting in the new Cloud EPM Platform Design reports using the new Reporting Solution in...

EPM Cloud

Next Generation Reporting Comes to the Enterprise Performance Management (EPM) Cloud Platform

Next Generation Reporting Comes to the EPM Cloud Platform Thank you to Dave Roberts, Shankar Viswanathan and Al Marciante, part of the EPM Cloud Product Management team, for their presentation! In the presentation, you will learn about the new next-generation reporting capabilities in the EPM Cloud Platform. The new  "Reports" will soon be embedded in the EPM Cloud Platform business processes and applications (Planning, Financial Consolidation and Close, Tax Reporting, and Free Form) alongside, and eventually replacing, Financial Reporting. Migration of existing Financial Reporting content is also covered. EPM Cloud Narrative Reporting – Management Reporting Embedded Reporting: Reporting in EPM Cloud Managed by the EPM Cloud Platform Reports and 3rd party documents are stored in the EPM Cloud repository and are accessible  from the Reports card Access control is managed in the Reports Card No workspace access to Reports EPM Cloud “Power User” role allows report design. “User” role is for report viewing.  Migration between environments via the EPM Cloud Lifecycle Management Data Source is automatically created based on application cubes that are available No manual Data Source creation/maintenance is necessary Can only utilize cubes on the same EPM Cloud instance Change cube for reporting in the Grid designer properties panel. Management Reporting vs. Reports Why should you be using Reports instead of FR? Feature Details - refer to the presentation for more information on the following features: User-friendly, robust report development Enhanced Charting Data Source Features Reports Features - including Prompts for Member Selection, Conditional Formatting and Suppression, Zoom on Parent, Drill to Content, Butterfly Reports, Grouping, Intelligent Narrative Generation, Analytics for Conditional Text Improved Design Paradigms Books Bursting User Preferences Application Settings Reports Components in the EPM Platform Reports Card (Library Card for Tax Reporting): Reports – create and view reports, books and batches. Access permissions, report artifact  and folder maintenance. Documents – access and maintain 3rd party documents used and generated with Books and  Bursting. For example, MS Word and PDF documents inserted in Books and CSV files used in  a bursting definition, along with PDF files generated by a bursting definition. Application Settings: Report Settings - Manage Fonts User Preferences: Reports Preferences – Preview POV, designer unit of measurement   Migrating Financial Reports to Reports FR report migration to Reports You can migrate FR Reports to the new Reports either in-place (on the same instance) or by  importing exported FR report definitions (DES or ZIP) With in-place migration, the migration is handled directly from the FR repository, where you can  either choose to migrate all reports or individual reports. When importing FR report definition, you select the file-system file to import. With both options, you select the destination folder in the EPM cloud platform repository to migrate content to. Note: Migration from Narrative Reporting reports to embedded reports is currently not supported due  to architecture differences. However, we are investigating the feasibility of providing a utility to achieve  this. When you migrate a report from Financial Reporting  to Reports, the system will convert as many elements  of the original report into the Reports equivalent as  possible. However, there are differences between the two  products, and not all elements exist in both products. When opening a report that has been migrated, the  system will display any errors that occurred during the  migration process. These errors will not prevent the report from being  migrated; however, you will have to resolve them in  order for your report to display properly. Object overlap, missing fonts, ”member not found”,  dimension renames Doc: Appendix B - Migrating Financial Reporting Reports to Management Reporting In-Place Migration File Import Migration What’s Coming?   ============================================================================================ References: Presentation - Dave Roberts, Shankar Viswanathan and Al Marciante, part of the EPM Cloud Product Management team Next Generation Reporting comes to the EPM Cloud Platform on Cloud Customer Connect - Watch the recorded webinar and demo Doc: Appendix B - Migrating Financial Reporting Reports to Management Reporting To learn how to take advantage of enhanced Reporting features to create highly formatted, integrated,  and interactive multi-source EPM and ERP cloud reports and books, please refer to the following  Customer Connect sessions: Build Awesome Reports with EPM Cloud Narrative Reporting Narrative Reporting Update and Deep Dive  

Next Generation Reporting Comes to the EPM Cloud Platform Thank you to Dave Roberts, Shankar Viswanathan and Al Marciante, part of the EPM Cloud Product Management team, for their presentation! In the...

Monthly Index

Business Analytics Monthly Index - January 2021

Welcome to the Monthly Index for January 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 - December 2020 Oracle Smart View for Office 20.200 is Available   Business Intelligence (BI) Summary Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.4.201216 is Available Oracle Business Intelligence (OBI) Bundle Patch 12.2.1.3.201216 is Available Oracle Business Intelligence Enterprise Edition Suite (OBIEE) Bundle Patch 11.1.1.9.210119 is Available Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.201216 is Available   Business Intelligence (BI) Cloud Summary No posts this month     Enterprise Performance Management (EPM) Summary EPM Patch Set Updates - December 2020 Oracle Hyperion Financial Reporting 11.1.2.4.903 is Available Enterprise Performance Management (EPM) 11.2.4 is Available   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - February 2021 Updates Account Reconciliation - February 2021 Cloud Updates Narrative Reporting - February 2021 Cloud Updates Financial Consolidation and Close - February 2021 Cloud Updates Oracle Planning - February 2021 Cloud Updates Profitability and Cost Management - February 2021 Cloud Updates Tax Reporting - February 2021 Cloud Updates   Essbase On Premise No posts this month   Essbase Cloud No posts this month   Advisor Webcasts Advisor Webcast: Deploy Oracle Analytics Cloud (OAC) With a Private Endpoint Advisor Webcast: Connecting Oracle Analytics Cloud (OAC) To Public/Private Autonomous Data Warehouse (ADW - DV and RPD)

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

BI Cloud

Advisor Webcast: Oracle Business Analytics SMTP Setup in Oracle Analytics Cloud (OAC) Using Oracle Cloud Infrastructure (OCI) Email

Register for the following Advisor Webcast! Oracle Business Analytics SMTP Setup in OAC using OCI Email Schedule Wednesday, February 17, 2021 08:00 AM (US Pacific Time) Wednesday, February 17, 2021 11:00 AM (US Eastern Time) Wednesday, February 17, 2021 05:00 PM (Central European Time) Wednesday, February 17, 2021 09:30 PM (India Standard Time) Register for upcoming webcasts and view the replays of any that you may have missed on the Oracle Product Support Advisor Webcasts series page. Description: This one-hour advisor webcast which will cover introduction to SMTP server in OCI Gen 2, End to End setup and configuration of OCI SMTP mail server in OCI console and DV console, Usage of SMTP Server in OAC and Troubleshooting issues related to Mail server configuration.   Topics Include: Introduction to SMTP Server Configure Approved Senders and policies for the OCI user Setup of OCI Mail server in OCI console Setup of SMTP Server in Data visualization console Usage of SMTP Server Troubleshooting ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: Oracle Business Analytics SMTP Setup in OAC using OCI Email on February 17, 2021 (Doc ID 2738492.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 Business Analytics SMTP Setup in OAC using OCI Email Schedule Wednesday, February 17, 2021 08:00 AM (US Pacific Time)Wednesday, February 17, 2021 11:00...

EPM Cloud

Advisor Webcast: EPM - What's New in Financial Consolidation and Close Cloud (FCCS) 21.02

Register for the following Advisor Webcast! EPM - What's New in FCCS 21.02 Schedule Tuesday , February 16, 2021 08:00 AM (US Pacific Time) Tuesday , February 16, 2021 11:00 AM (US Eastern Time) Tuesday , February 16, 2021 05:00 PM (Central European Time) Tuesday , February 16, 2021 09:30 PM (India Standard Time) Register for upcoming webcasts and view the replays of any that you may have missed on the Oracle Product Support Advisor Webcasts series page. Description: TThis 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 20.12 Product Feature Review from FCCS 21.01 What's New in FCCS 21.02 Questions & Answers ============================================================================================ For Additional Information and Registration Details: ADVISOR WEBCAST: EPM - What's New in FCCS 21.02 on February 16, 2021 (Doc ID 2741860.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! EPM - What's New in FCCS 21.02 Schedule Tuesday , February 16, 2021 08:00 AM (US Pacific Time) Tuesday , February 16, 2021 11:00 AM (US Eastern Time)Tuesday ,...

EPM Cloud

Tax Reporting - February 2021 Cloud Updates

Tax Reporting - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 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, February 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, February 19, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials New Topics in EPM Cloud Operations Guide New Next-Generation Reporting Capabilities New Terminology for Management Reporting New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation Dynamic Tabs in Redwood Experience New Clone Snapshot Feature REST API Support for Oracle Infrastructure Gen 2 Environments New Indentation Option for Standard Mode Ad Hoc Grids in Smart View Improved Member Selection for Insert Attributes and Mass Allocation in Smart View (Mac and Browser) Simplified Authentication Cache Rebuild Algorithm New Source Connections Option in Data Integration New Notification Settings for Oracle ERP BI Publisher in Data Integration Application Details Support for JDBC Drivers Type 3 and Type 4 Compliant in the EPM Integration Agent Enhanced Custom Attribute Panel in Task Manager Review  IMPORTANT Actions and Considerations   Tax Reporting: This section contains information related to Tax Reporting. Updated Standard Reports Available   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 - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Profitability and Cost Management - February 2021 Cloud Updates

Profitability and Cost Management - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 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, February 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, February 19, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials New Topics in EPM Cloud Operations Guide New Next-Generation Reporting Capabilities New Terminology for Management Reporting New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation Dynamic Tabs in Redwood Experience New Clone Snapshot Feature REST API Support for Oracle Infrastructure Gen 2 Environments New Indentation Option for Standard Mode Ad Hoc Grids in Smart View Improved Member Selection for Insert Attributes and Mass Allocation in Smart View (Mac and Browser) Simplified Authentication Cache Rebuild Algorithm New Source Connections Option in Data Integration New Notification Settings for Oracle ERP BI Publisher in Data Integration Application Details Support for JDBC Drivers Type 3 and Type 4 Compliant in the EPM Integration Agent Enhanced Custom Attribute Panel in Task Manager Review  IMPORTANT Actions and Considerations   Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There are no new features for Profitability and Cost Management other than the Clone Snapshot feature (see that topic under EPM Cloud Common).   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 - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Oracle Planning - February 2021 Cloud Updates

Planning - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 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, February 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, February 19, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials New Topics in EPM Cloud Operations Guide New Next-Generation Reporting Capabilities New Terminology for Management Reporting New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation Dynamic Tabs in Redwood Experience New Clone Snapshot Feature REST API Support for Oracle Infrastructure Gen 2 Environments New Indentation Option for Standard Mode Ad Hoc Grids in Smart View Improved Member Selection for Insert Attributes and Mass Allocation in Smart View (Mac and Browser) Simplified Authentication Cache Rebuild Algorithm New Source Connections Option in Data Integration New Notification Settings for Oracle ERP BI Publisher in Data Integration Application Details Support for JDBC Drivers Type 3 and Type 4 Compliant in the EPM Integration Agent Enhanced Custom Attribute Panel in Task Manager Review  IMPORTANT Actions and Considerations   Planning: This section contains information related to Planning. New Videos EPM Planning Financials Support for Budget Revisions and Integration with Budgetary Control EPM Planning Projects and Project Management Integration Whitepaper is Now Available   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 - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Financial Consolidation and Close - February 2021 Cloud Updates

Financial Consolidation and Close - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 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, February 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, February 19, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials New Topics in EPM Cloud Operations Guide New Next-Generation Reporting Capabilities New Terminology for Management Reporting New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation Dynamic Tabs in Redwood Experience New Clone Snapshot Feature REST API Support for Oracle Infrastructure Gen 2 Environments New Indentation Option for Standard Mode Ad Hoc Grids in Smart View Improved Member Selection for Insert Attributes and Mass Allocation in Smart View (Mac and Browser) Simplified Authentication Cache Rebuild Algorithm New Source Connections Option in Data Integration New Notification Settings for Oracle ERP BI Publisher in Data Integration Application Details Support for JDBC Drivers Type 3 and Type 4 Compliant in the EPM Integration Agent Enhanced Custom Attribute Panel in Task Manager Review  IMPORTANT Actions and Considerations   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. New Video Referential Integrity Enhancements Refresh Database Performance Improvements 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 - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Narrative Reporting - February 2021 Cloud Updates

Oracle Narrative Reporting - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 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, February 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, February 19, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials New Topics in EPM Cloud Operations Guide New Next-Generation Reporting Capabilities New Terminology for Management Reporting New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation Dynamic Tabs in Redwood Experience New Clone Snapshot Feature REST API Support for Oracle Infrastructure Gen 2 Environments New Indentation Option for Standard Mode Ad Hoc Grids in Smart View Improved Member Selection for Insert Attributes and Mass Allocation in Smart View (Mac and Browser) Simplified Authentication Cache Rebuild Algorithm New Source Connections Option in Data Integration New Notification Settings for Oracle ERP BI Publisher in Data Integration Application Details Support for JDBC Drivers Type 3 and Type 4 Compliant in the EPM Integration Agent Enhanced Custom Attribute Panel in Task Manager Review  IMPORTANT Actions and Considerations   Narrative Reporting New Chart Property to Exclude Plotting Zero Data Values Disclosure Management Taxonomy Designer Support for Base Taxonomy Import for Templates 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 - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during...

EPM Cloud

Account Reconciliation - February 2021 Cloud Updates

Account Reconciliation - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 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, February 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, February 19, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials New Topics in EPM Cloud Operations Guide New Next-Generation Reporting Capabilities New Terminology for Management Reporting New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation Dynamic Tabs in Redwood Experience New Clone Snapshot Feature REST API Support for Oracle Infrastructure Gen 2 Environments New Indentation Option for Standard Mode Ad Hoc Grids in Smart View Improved Member Selection for Insert Attributes and Mass Allocation in Smart View (Mac and Browser) Simplified Authentication Cache Rebuild Algorithm New Source Connections Option in Data Integration New Notification Settings for Oracle ERP BI Publisher in Data Integration Application Details Support for JDBC Drivers Type 3 and Type 4 Compliant in the EPM Integration Agent Enhanced Custom Attribute Panel in Task Manager Review  IMPORTANT Actions and Considerations Account Reconciliation: Improvements to Date Tolerance in Transaction Matching Ability to Run Data Management Data Load Rules in Parallel New Variable Explanations (VEX) Argument Added to Import Pre-Mapped Transactions Command in EPM Automate and REST API Tabs Added to Custom Attribute Dialog to Improve Usability   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 - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

EPM Cloud

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

Enterprise Data Management Cloud (EDMCS) - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 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, February 5, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, February 19, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Tutorials New Topics in EPM Cloud Operations Guide New Next-Generation Reporting Capabilities New Terminology for Management Reporting New EPM Digital Assistant for Financial Consolidation and Close and Account Reconciliation Dynamic Tabs in Redwood Experience New Clone Snapshot Feature REST API Support for Oracle Infrastructure Gen 2 Environments New Indentation Option for Standard Mode Ad Hoc Grids in Smart View Improved Member Selection for Insert Attributes and Mass Allocation in Smart View (Mac and Browser) Simplified Authentication Cache Rebuild Algorithm New Source Connections Option in Data Integration New Notification Settings for Oracle ERP BI Publisher in Data Integration Application Details Support for JDBC Drivers Type 3 and Type 4 Compliant in the EPM Integration Agent Enhanced Custom Attribute Panel in Task Manager   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). New Videos   Important Actions and Considerations: Click here for a list of Important Actions and Considerations.   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) - February 2021 Enterprise Performance Management (EPM) Cloud Common - February 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly...

EPM On Premise

Enterprise Performance Management (EPM) 11.2.4 is Available

Enterprise Performance Management (EPM) System On-Premise Release 11.2.4 is available! Before installing this release, it is critical that you review the 11.2.4 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. What's New with EPM 11.2.4? EPM System New Features Release 11.2.4 includes accessibility improvements and the ability to apply an update directly from Release 11.2.2 or 11.2.3. For Oracle Hyperion Planning, you can now upgrade Oracle Hyperion Public Sector Planning and Budgeting applications from Release 11.1.2.4 to Release 11.2.4 using Oracle Hyperion Enterprise Performance Management System Lifecycle Management. Note: You can’t upgrade Public Sector Planning and Budgeting applications with Decision Packages or Budget Requests enabled. Planning New Features A new Planning utility called SetDBNEssbasePassword enables you to set database and Oracle Essbase passwords for a list of applications you provide. You must provide application names as a comma-separated list enclosed in quotation marks and without spaces. Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements and details. ============================================================================================= References: 11.2.4 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.4 is available! Before installing this release, it is critical that you review the 11.2.4 readme in its entirety. The readme...

BI Cloud

Advisor Webcast: Connecting Oracle Analytics Cloud (OAC) To Public/Private Autonomous Data Warehouse (ADW - DV and RPD)

Register for the following Advisor Webcast! Connecting OAC To Public/Private ADW (DV & RPD) Schedule Thursday , February 11, 2021 08:00 AM (US Pacific Time) Thursday , February 11, 2021 11:00 AM (US Eastern Time) Thursday , February 11, 2021 05:00 PM (Central European Time) Thursday , February 11, 2021 09:30 PM (India Standard Time) Register for upcoming webcasts and view the replays of any that you may have missed on the Oracle Product Support Advisor Webcasts series page. Description: This one-hour advisor webcast is recommended for Oracle Analytics Cloud (OAC) technical users, system administrators who setup connections to ADW (Public & Private) Database from OAC (DV & RPD).   Topics Include: Download ADW Wallet (region & Instance) Create Connections to Public ADW from DV & RPD Setup RDG on OCI Compute Node to be able to Create Connections to Private ADW from DV & RDP ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: Connecting OAC To Public/Private ADW (DV & RPD) on Feb. 11, 2021 (Doc ID 2736440.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! Connecting OAC To Public/Private ADW (DV & RPD) Schedule Thursday , February 11, 2021 08:00 AM (US Pacific Time)Thursday , February 11, 2021 11:00 AM (US...

BI Cloud

Advisor Webcast: Deploy Oracle Analytics Cloud (OAC) With a Private Endpoint

Register for the following Advisor Webcast! Deploy Oracle Analytics Cloud with a Private Endpoint Schedule Thursday , February 04, 2021 08:00 AM (US Pacific Time) Thursday , February 04, 2021 11:00 AM (US Eastern Time) Thursday , February 04, 2021 05:00 PM (Central European Time) Thursday , February 04, 2021 09:30 PM (India Standard Time)   Register for upcoming webcasts and view the replays of any that you may have missed on the Oracle Product Support Advisor Webcasts series page. Description: This one-hour advisor webcast is recommended for Oracle Analytics Cloud Administrators, OAC Analysts, OAC Consumers. If you want only hosts within your virtual cloud network (VCN) or your on-premise network to have access to Oracle Analytics Cloud, you can deploy your Oracle Analytics Cloud instance with a private endpoint. When you set up an Oracle Analytics Cloud instance you have the option to restrict access through a private endpoint. Private access means that traffic doesn't go over the internet. Private access can be from hosts within your virtual cloud network (VCN) or your on-premise network.   Topics Include: About Private Endpoints Prerequisites for a Private Endpoint Typical Workflow to Deploy Oracle Analytics Cloud with a Private Endpoint Create Oracle Analytics Cloud with a Private Endpoint Change a Private Endpoint using the Console Connect to Your On-premise Network using FastConnect or VPN Connect ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: BI - Deploy Oracle Analytics Cloud with a Private Endpoint on February 4, 2021 (Doc ID 2738401.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! Deploy Oracle Analytics Cloud with a Private Endpoint Schedule Thursday , February 04, 2021 08:00 AM (US Pacific Time)Thursday , February 04, 2021 11:00 AM (US...

BI On Premise

Oracle Analytics Server (OAS) Bundle Patch 5.5.0.0.201216 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.201216 Patch 32294034 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.201216, 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" =============================================================================== 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) 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.201216 Patch 32294034 Prior to proceeding with this OAS...

BI On Premise

Oracle Business Intelligence Enterprise Edition Suite (OBIEE) Bundle Patch 11.1.1.9.210119 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.210119 Patch 32310890 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.210119 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.210119 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 32310890 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.201020, the component patches listed in the table below in BOLD are new.   OBIEE Bundle Patch 11.1.1.9.201020 under the top-level Patch 32310890 consists of the following component patches: 24346370 - BIADFCOMPS Bundle Patch 11.1.1.9.160808    Oracle Business Intelligence ADF Components (BIADFCOMPS) 32296320 - BIFNDN BUNDLE PATCH 11.1.1.9.201216    Oracle Business Intelligence Presentation Services (BIPS) (BIFNDN) 32293873 - BIP Bundle Patch 11.1.1.9.201216    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.210119 includes all the bug fixes released in Oracle BI EE Suite Bundle Patch 11.1.1.9.201020 and new bug fixes. For a detailed report of new bug fixes in Oracle BI EE Suite Bundle Patch 11.1.1.9.210119, 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.210119" "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)    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.201216 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.201216 Patch 32294042 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.201216 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.201216 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.201216, 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.201216" "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)  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.201216 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.201216 Patch 32294048 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.201216, 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.201216 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.201216, 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.201216" "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.201216 Bundle Patch" "Section 3.9: Export the results of Analysis" "Section 3.10: Pre requisite for Bug 30414648 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)   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 &...

EPM On Premise

Oracle Hyperion Financial Reporting 11.1.2.4.903 is Available

Hyperion Product Management have advised the release of a Patch Set Update (PSU) for Oracle Hyperion Financial Reporting 11.1.2.4.x. Hyperion Financial Reporting PSU 11.1.2.4.903 Patch 31758268 This PSU is available from the My Oracle Support > Patches & Updates section. This is a patch set update (PSU). This patch set update is a partial installation. It replaces files in the existing installation, and does not require a full installation. This patch set update is cumulative and does include fixes from previous patches.   README FILE: This Readme file describes the defects fixed in this patch and the requirements and instructions for 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 your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme.   Important Information Regarding This Patch: For defect number 27580097 - When using Batch Bursting in the Batch Scheduler, and scheduling output to Snapshot reports and PDF, the folder specified for Snapshot output, is appended to the specified PDF external folder. This is the historical behavior, before a recent change was made to separate the output folders between Snapshots and PDFs. A new MBean property was added to specify if the Snapshot path is used for PDF external ouput: "UseSnapshotSaveAsPathForExternalPDFPath = true/false", by default this is true, which will keep the previous, original behavior. Setting the property to "false" will utilize a different folder path for Snapshot and PDF output. Defects Fixed in this Patch: 30998543 - When Reports are included as a part of a book the Modified Date for that report is updated. Patch Type: This is a patch set update (PSU). This patch set update is a partial installation. It replaces files in the existing installation, and does not require a full installation. This patch set update is cumulative and does include fixes from previous patches. Supported Paths to this Patch You can apply this patch to the following releases: 11.1.2.4.900 11.1.2.4.901 11.1.2.4.902   ============================================================================================ References: Available Patch Sets and Patch Set Updates for Oracle Hyperion Reporting and Analysis, Financial Reporting and Interactive Reporting. (Doc ID 1360962.1) Enterprise Performance Management Documentation  

Hyperion Product Management have advised the release of a Patch Set Update (PSU) for Oracle Hyperion Financial Reporting 11.1.2.4.x. Hyperion Financial Reporting PSU 11.1.2.4.903Patch 31758268 This PSU...

Monthly Index

Business Analytics Monthly Index - December 2020

Welcome to the Monthly Index for December 2020 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 - November 2020   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 - November 2020 Essbase Patch Set Update 11.1.2.4.042 is Available Enterprise Performance Management (EPM) On-Premises: Current Release and Roadmap   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - January 2021 Updates Account Reconciliation - January 2021 Cloud Updates Narrative Reporting - January 2021 Cloud Updates Financial Consolidation and Close - January 2021 Cloud Updates Oracle Planning - January 2021 Cloud Updates Profitability and Cost Management - January 2021 Cloud Updates Tax Reporting - January 2021 Cloud Updates Changes to Process for Requesting an Upgrade Delay for Production Environments in EPM Cloud Oracle Guided Learning - Enterprise Performance Management (EPM) Cloud User Enablement   Essbase On Premise Oracle Essbase 21.1 is Available   Essbase Cloud No posts this month   Advisor Webcasts No posts this month.

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

BI Cloud

Oracle Smart View for Office 20.200 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 20.200 Patch 32147634   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: Support for Drill-Through to Source Vanity URL Support in Smart View New Health Check for Microsoft Office Documents Job Console Autorefresh Cell Styles Now Support Multiple Style Properties   Defects Fixed in this Release Click here for the full list   Supported Platforms: Check the readme for information on the following related topics: 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: You can upgrade to Oracle Smart View for Office Release 20.200 from 11.1.2.5.xxx.to 20.100. =============================================================================== 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 20.200 Installation and Configuration Guide - Includes Tips and Troubleshooting section  

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

EPM Cloud

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

Enterprise Data Management Cloud (EDMCS) - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 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, January 1, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Version of Oracle Smart View for Office Additional Data Formatting Options in Smart View (Mac and Browser)   Enterprise Data Management Cloud (EDMCS) This section contains information related to Oracle Enterprise Data Management Cloud (EDMCS). New Videos   Important Actions and Considerations: CHROME 86 AND CHROMIUM EDGE 86 BROWSERS - Due to recent changes in the Chrome 86 and Chromium Edge 86 browsers, you may see buttons that are not aligned on the right hand side. Oracle is aware of this behavior change in these browsers and is working to retrofit our user interface to resolve these issues. 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) - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly...

EPM Cloud

Tax Reporting - January 2021 Cloud Updates

Tax Reporting - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 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, January 1, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Version of Oracle Smart View for Office Additional Data Formatting Options in Smart View (Mac and Browser)   Tax Reporting: This section contains information related to Tax Reporting. There are no new features in this update.   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 - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Profitability and Cost Management - January 2021 Cloud Updates

Profitability and Cost Management - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 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, January 1, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Version of Oracle Smart View for Office Additional Data Formatting Options in Smart View (Mac and Browser)   Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There were no new features 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 - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Oracle Planning - January 2021 Cloud Updates

Planning - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 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, January 1, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Version of Oracle Smart View for Office Additional Data Formatting Options in Smart View (Mac and Browser)   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 - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first daily...

EPM Cloud

Financial Consolidation and Close - January 2021 Cloud Updates

Financial Consolidation and Close - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 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, January 1, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Version of Oracle Smart View for Office Additional Data Formatting Options in Smart View (Mac and Browser)   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. There are no new features in this update.   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 - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...

EPM Cloud

Narrative Reporting - January 2021 Cloud Updates

Oracle Narrative Reporting - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 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, January 1, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Version of Oracle Smart View for Office Additional Data Formatting Options in Smart View (Mac and Browser)   Narrative Reporting There are no new features in this update.   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 - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

EPM Cloud

Account Reconciliation - January 2021 Cloud Updates

Account Reconciliation - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 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, January 1, 2021. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: New Video New Version of Oracle Smart View for Office Additional Data Formatting Options in Smart View (Mac and Browser)   Account Reconciliation: There are no new features in this update.   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 - January 2021 Enterprise Performance Management (EPM) Cloud Common - January 2021   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the...

Essbase On Premise

Oracle Essbase 21.1 is Available

Oracle Essbase 21.1 is Available If you’ve been using Essbase standalone (11g) for years, and yearning for the day that you could take advantage of the latest Essbase features, but remain on your independent, standalone Linux platform, THAT DAY IS HERE! We’re excited to announce the availability of Essbase 21c. This new release has many enhancements of the Essbase features you’ve come to know and value. It also gives you all the latest features available in our Essbase 19c cloud offering, PLUS! it enables you to continue to work from your standalone, Linux platform. You can download Essbase 21c on Oracle Software Delivery Cloud. For details on platform support and certification matrix, see our documentation. For those of you looking forward to Essbase 21c for the Microsoft Windows platform or the upgraded Essbase 21c on Oracle Cloud Infrasructure Marketplace, those will follow in just a few months. Stay tuned. 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 in 21c Essbase 21.1, comes with its own installer and configuration tools. As noted, you get all the new features we’ve introduced on the cloud, as well as in 19c. Some notable new features include – a modern browser-based UI for management and administration, Cube Designer plug-in for Smart View, platform features like Connections/Datasources, new security roles, dynamic filters and more. Why 21c? With 21c, you get the choice of an independent Essbase install with the latest product features and platform support. Existing customers can easily migrate their 11g applications to 21c using the LCM migration utilities. New client utilities and REST API’s enable customers to develop custom analytic solutions.   More Details: Features Release Notes Install and configuration Differences between 11g and 21c Migration to 21c New features and overview of 21c Certification Matrix - now located in the documentation  

Oracle Essbase 21.1 is Available If you’ve been using Essbase standalone (11g) for years, and yearning for the day that you could take advantage of the latest Essbase features, but remain on your...

EPM On Premise

Essbase Patch Set Update 11.1.2.4.042 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.041 31907382 - HYPERION ESSBASE SERVER Hyperion Essbase Client 11.1.2.4.042 31907369 - HYPERION ESSBASE RTC 31907373 - HYPERION ESSBASE CLIENT 31907378 - HYPERION ESSBASE CLIENT MSI Hyperion Analytic Provider Services 11.1.2.4.042 31907392 - 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.037, Provider Services 11.1.2.4.042, and Essbase Studio 11.1.2.4.031 are supported for use with Essbase 11.1.2.4.042.  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

Changes to Process for Requesting an Upgrade Delay for Production Environments in EPM Cloud

Changes to Process for Requesting an Upgrade Delay for Production Environments The December (20.12) monthly update of the EPM Cloud introduces new functionality for customers to delay updates to an EPM Cloud production environment without the need to create a service request.  This is beneficial when you need to complete time-sensitive tasks (i.e. closing of a quarter) or are in a critical phase of your implementation project.  There are two self-service options available beginning with the 20.12 Update: A new EPM Automate command: skipUpdate A new REST API: skip updates These self-service features can also be used to remove all skip update requests that were previously made using this command so that the environment is updated to the main code line. You can also use these features to list the skip update requests currently specified for an environment. Please note that these self-service options cannot be used on environments that contain a one-off patch.  Additionally, they can only be used to skip updates for a maximum of 2 cycles, after which the environment will be returned to the main code line.  For further information on requesting production upgrade delays using EPM Automate, including how to request a delay of more than two cycles, please see Requesting Upgrade Delay for Production Environments.  For information on using the REST API to skip updates, please see the REST API for Oracle Enterprise Performance Management Cloud > Skip Updates documentation.  Please begin using these features for your production upgrade delay requests beginning with the 20.12 release.

Changes to Process for Requesting an Upgrade Delay for Production Environments The December (20.12) monthly update of the EPM Cloud introduces new functionality for customers to delay updates to an EPM...

Monthly Index

Business Analytics Monthly Index - November 2020

Welcome to the Monthly Index for November 2020 The following provides quick links to recent Proactive Support Blog postings for OBI and Hyperion from the past month.   General Summary Business Analytics Monthly Index - October 2020 Remote Diagnostic Agent (RDA) 20.4 is Available   Business Intelligence (BI) Summary My Oracle Support Communities (MOSC) For Business Intelligence Are Being Renamed   Business Intelligence (BI) Cloud Summary My Oracle Support Communities (MOSC) For Business Intelligence Are Being Renamed     Enterprise Performance Management (EPM) Summary EPM Patch Set Updates - October 2020 Hyperion Financial Close Management and Tax Governance PSU 11.1.2.4.255 Oracle Hyperion Profitability and Cost Management 11.2.3.0.001 is Available Hyperion Shared Services 11.1.2.4.101 is Available Oracle Hyperion Financial Reporting 11.1.2.4.714 is Available   Enterprise Performance Management (EPM) Cloud Summary Oracle Enterprise Data Management Cloud (EDMCS) - December 2020 Updates Account Reconciliation - December 2020 Cloud Updates Narrative Reporting - December 2020 Cloud Updates Financial Consolidation and Close - December 2020 Cloud Updates Oracle Planning - December 2020 Cloud Updates Profitability and Cost Management - December 2020 Cloud Updates Tax Reporting - December 2020 Cloud Updates Hands-on Tutorials for Oracle Enterprise Performance Management (EPM) Cloud Planning What You Need To Know Before Starting the EPM Cloud Profitability and Cost Management Implementation   Essbase On Premise No posts this month   Essbase Cloud No posts this month   Advisor Webcasts Advisor Webcast: Troubleshooting Enterprise Performance Management (EPM) Cloud Issues - Part 8 Advisor Webcast: Migrating to Oracle Analytics Cloud (OAC) on Oracle Cloud Infrastructure (Gen 2)

Welcome to the Monthly Index for November 2020 The following provides quick links to recent Proactive Support Blog postings for OBI and Hyperion from the past month.   General Summary Business Analytics...

EPM On Premise

Oracle Hyperion Financial Reporting 11.1.2.4.714 is Available

Hyperion Product Management have advised the release of a Patch Set Update (PSU) for Oracle Hyperion Financial Reporting 11.1.2.4.x. Hyperion Financial Reporting PSU 11.1.2.4.714 Patch 32040166 This PSU is available from the My Oracle Support > Patches & Updates section. This is a patch set update (PSU). This patch set update is a partial installation. It replaces files in the existing installation, and does not require a full installation.This patch set update is cumulative and does include fixes from previous patches. Review the Readme: Ensure to review the Readme file prior proceeding with this PSU implementation for important information that includes prerequisites, details for applying patch, troubleshooting FAQ's and additional support information. Important Information Regarding This Patch: Oracle Hyperion Financial Reporting Windows Studio is included with the patch installations but it is only for use with the Oracle Hyperion Financial Reporting command line utilities included with the installer.  For Report Designer features only use the Oracle Hyperion Financial Reporting Web Studio included with this patch.  Oracle no longer supports Windows Studio aside from the command line utilities. For defect number 27580097 - When using Batch Bursting in the Batch Scheduler, and scheduling output to Snapshot reports and PDF, the folder specified for Snapshot output, is appended to the specified PDF external folder. This is the historical behavior, before a recent change was made to separate the output folders between Snapshots and PDFs. A new MBean property was added to specify if the Snapshot path is used for PDF external ouput: "UseSnapshotSaveAsPathForExternalPDFPath = true/false", by default this is true, which will keep the previous, original behavior. Setting the property to "false" will utilize a different folder path for Snapshot and PDF output. Defects Fixed: Refer to the readme for the full list The Readme file is available from the Patches & Updates download screen. For more information: The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion EPM sub-space: Hyperion Patch Reviews For questions specific to Hyperion Financial Reporting ... The My Oracle Support Community "Hyperion Reporting Products" is the ideal first stop to seek & find product specific answers:  Hyperion Reporting Products    

Hyperion Product Management have advised the release of a Patch Set Update (PSU) for Oracle Hyperion Financial Reporting 11.1.2.4.x. Hyperion Financial Reporting PSU 11.1.2.4.714Patch 32040166 This PSU...

BI Cloud

Advisor Webcast: Migrating to Oracle Analytics Cloud (OAC) on Oracle Cloud Infrastructure (Gen 2)

Register for the following Advisor Webcast! Migrating to Oracle Analytics Cloud (OAC) on Oracle Cloud Infrastructure (Gen 2) Schedule Wednesday, December 09, 2020 08:00 AM (US Pacific Time) Wednesday, December 09, 2020 11:00 AM (US Eastern Time) Wednesday, December 09, 2020 05:00 PM (Central European Time) Wednesday, December 09, 2020 09:30 PM (India Standard Time) Check out the new Oracle Product Support Advisor Webcasts series page that allows you to register for upcoming webcasts and view replays based on the different product areas! Description: This one-hour advisor webcast is recommended for administrators who are migrating content from Oracle Business Intelligence Enterprise Edition to Oracle Analytics Cloud.   Topics Include: Migration Scope Migration Task Flow Migration Tools Post-Migration Tasks Questions and Answers ============================================================================================ For Additional Information and Registration Details: Advisor Webcast: Migrating to OAC on Oracle Cloud Infrastructure (Gen 2) on Dec. 9, 2020 (Doc ID 2727029.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! Migrating to Oracle Analytics Cloud (OAC) on Oracle Cloud Infrastructure (Gen 2) Schedule Wednesday, December 09, 2020 08:00 AM (US Pacific Time)Wednesday,...

EPM Cloud

Profitability and Cost Management - December 2020 Cloud Updates

Profitability and Cost Management - No New Features in December 2020 Enterprise Performance Management (EPM) Cloud Common - December 2020   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, December 4, 2020. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, December 18, 2020.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: Certification for Chrome 85-86 and Chromium Edge 85-86 Browsers New Sample Application New Version of Oracle Smart View for Office EPM Automate Updates REST API to Copy a File Between Instances REST API to Copy a File Between Instances REST API to Skip Updates Updates to Oracle Enterprise Performance Management Cloud Operations Guide New Activity Report Generation on Restarting an Environment Support for Selecting Dimension Members Based on UDAs in Form Designer New System Maintenance Process to Reset Environment in Data Management Clear All Data and Setup When Deleting an Application Support for Summary Drill with More Than 1000 Descendants in Data Integration New Proxy Authentication Support in the EPM Integration Agent New Drill Through Options When Drilling to Source from Excel In Smart View   Profitability and Cost Management: This section contains information related to Profitability and Cost Management. There were no new features 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 - No New Features in December 2020 Enterprise Performance Management (EPM) Cloud Common - December 2020   Monthly Update Schedule: Test Environments: Oracle will apply...

EPM Cloud

Tax Reporting - December 2020 Cloud Updates

Tax Reporting - December 2020 Enterprise Performance Management (EPM) Cloud Common - December 2020   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, December 4, 2020. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, December 18, 2020.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: Certification for Chrome 85-86 and Chromium Edge 85-86 Browsers New Sample Application New Version of Oracle Smart View for Office EPM Automate Updates REST API to Copy a File Between Instances REST API to Copy a File Between Instances REST API to Skip Updates Updates to Oracle Enterprise Performance Management Cloud Operations Guide New Activity Report Generation on Restarting an Environment Support for Selecting Dimension Members Based on UDAs in Form Designer New System Maintenance Process to Reset Environment in Data Management Clear All Data and Setup When Deleting an Application Support for Summary Drill with More Than 1000 Descendants in Data Integration New Proxy Authentication Support in the EPM Integration Agent New Drill Through Options When Drilling to Source from Excel In Smart View   Tax Reporting: This section contains information related to Tax Reporting. Total Special Deduction Hierarchy Supplemental Data Manager Alerts Using Groups in Supplemental Data Manager Task Actions Banner Enhancement   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 - December 2020 Enterprise Performance Management (EPM) Cloud Common - December 2020   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update during the first...

EPM Cloud

Oracle Planning - December 2020 Cloud Updates

Planning - December 2020 Enterprise Performance Management (EPM) Cloud Common - December 2020   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, December 4, 2020. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, December 18, 2020.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: Certification for Chrome 85-86 and Chromium Edge 85-86 Browsers New Sample Application New Version of Oracle Smart View for Office EPM Automate Updates REST API to Copy a File Between Instances REST API to Copy a File Between Instances REST API to Skip Updates Updates to Oracle Enterprise Performance Management Cloud Operations Guide New Activity Report Generation on Restarting an Environment Support for Selecting Dimension Members Based on UDAs in Form Designer New System Maintenance Process to Reset Environment in Data Management Clear All Data and Setup When Deleting an Application Support for Summary Drill with More Than 1000 Descendants in Data Integration New Proxy Authentication Support in the EPM Integration Agent New Drill Through Options When Drilling to Source from Excel In Smart View   Planning: This section contains information related to Planning. Detailed Reports for Auto Predict Predictions Task Lists Now Supported in Smart View (Mac and Browser)   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 Planning and Budgeting Cloud - Product Documentation Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

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

EPM Cloud

Financial Consolidation and Close - December 2020 Cloud Updates

Financial Consolidation and Close - December 2020 Enterprise Performance Management (EPM) Cloud Common - December 2020   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, December 4, 2020. Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, December 18, 2020.   Enterprise Performance Management (EPM) Cloud Common This section contains announcements related to the common EPM Cloud components: Certification for Chrome 85-86 and Chromium Edge 85-86 Browsers New Sample Application New Version of Oracle Smart View for Office EPM Automate Updates REST API to Copy a File Between Instances REST API to Copy a File Between Instances REST API to Skip Updates Updates to Oracle Enterprise Performance Management Cloud Operations Guide New Activity Report Generation on Restarting an Environment Support for Selecting Dimension Members Based on UDAs in Form Designer New System Maintenance Process to Reset Environment in Data Management Clear All Data and Setup When Deleting an Application Support for Summary Drill with More Than 1000 Descendants in Data Integration New Proxy Authentication Support in the EPM Integration Agent New Drill Through Options When Drilling to Source from Excel In Smart View   Financial Consolidation and Close: This section contains information related to Financial Consolidation and Close. New Tutorials Refresh Database Enhancement New Rules for Automatically Computing Rates Entity Dimension Consolidation Enhancements Data Load Enhancement Intercompany Report Enhancements Performance Substitution Variables Supplemental Data Manager Alerts Using Groups in Supplemental Data Manager Task Actions Banner Enhancement   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 - December 2020 Enterprise Performance Management (EPM) Cloud Common - December 2020   Monthly Update Schedule: Test Environments: Oracle will apply this monthly update...