Wednesday, January 31, 2024

Oracle Hyperion 11.2.16

EPM Patch Update 11.2.16.0 is now available on HTTPS://Edelivery.oracle.com

Release 11.2.16 includes the following new features:

• Certification of SQL Server 2022.

• Java 8 Update 391.

• WebLogic Patch Set Update 12.2.1.4.231115.

• Application Data Framework (ADF) Bundle Patch 12.2.1.4.230823.

• Oracle HTTP Server (OHS) 19c Bundle Patch 12.2.1.4.230922.

• There are no Oracle Data Integrator (ODI) Patches in Release 11.2

Friday, January 26, 2024

Oracle EPM February 2024 update and Hybrid Essbase

Per the February 2024 Oracle EPM Update, Oracle is planning to upgrade non-hybrid Essbase version environments to a hybrid Essbase version "within the next 3 months" (assuming Feb - Apr 2024).  

This will apply to Financial Consolidation and Close, FreeForm, Planning, Planning Modules, and Tax Reporting applications.

Oracle will be creating an "Essbase Outline Validation" menu option in the Application -> Overview -> Actions menu to analyze & view a list of Member Formulas that need to be fixed to be compatible with hybrid Essbase prior to the switchover.


To check whether your environment is on hybrid or non-hybrid Essbase version, look at the value of "Essbase Version Supports Hybrid Block Storage Option" in the Application -> Actions -> Activity Report ("Yes" = hybrid Essbase version; "No" = non-hybrid Essbase version)


If you are already on a Hybrid Essbase version, you don't have to take any action.

Friday, January 19, 2024

Supported path to Hyperion 11.2.15 release

Supported Path to Hyperion 11.2.15

You can move to Oracle Enterprise Performance Management System Release 11.2.15 from any of the following releases:

Table 4-1 Supported Paths to Release 11.2.15

FromUpdate toUpgrade to
Release 11.1.2.4.xxx 11.2.8.0.000
Release 11.2.0.0.000 to Release 11.2.7.0.000Release 11.2.8.0.000 
Release 11.2.8.0.000
  • Release 11.2.12.0.000

    or

  • Release 11.2.13.0.000

    or

  • Release 11.2.14.0.000
 
  • Release 11.2.12.0.000

    or

  • Release 11.2.13.0.000

    or

  • Release 11.2.14.0.000
Release 11.2.15.0.000 

https://docs.oracle.com/en/applications/enterprise-performance-management/11.2/hitju/applying_an_update_supported_paths_100xe7c373bc.html#GUID-023F9826-8F44-4628-8D13-602D8B5B3C96

Oracle VS Code extension

All the Oracle SQL enthusiasts out there. 

Oracle released a VS Code extension. check it out. I will be trying it out.

#oraclesql #sql #sqldeveloper #vscode 

https://lnkd.in/gDfAm5zM

Friday, January 12, 2024

Oracle EPM Cloud updates and What they mean ?

What Are Oracle Updates?

Oracle Cloud Apps are a widely used suite of enterprise applications. Available as SaaS (software-as-a-service), these apps streamline essential business functions, including Enterprise Resource Planning (ERP), Supply Chain Management (SCM), and Human Capital Management (HCM). Oracle works on the principle of continuous innovation, constantly unveiling new features, functionalities, bug fixes, and enhancements. 

These new updates are called Oracle releases, updates, or upgrades.  

Oracle Updates Release Cycle

Oracle Cloud follows a systematic quarterly update schedule, with each update being assigned a sequential name. 

The update for the first quarter of 2023 is referred to as 23A, the update for the second quarter as 23B, the update for the third quarter as 23C, and the Oracle release update for the fourth quarter as 23D. 

It’s important to note that these updates are staggered at different times, so various companies are in-process of upgrading at different stages. 

You may be finalizing 23B while the company next door works on 23C. 

Companies choose from three cycles of quarterly updates:

  • January/April/July/October
  • February/ May/ August/ November
  • March/ June/ September/ December

Thursday, January 11, 2024

Oracle EPM Cloud updates for 2023 !!

In 2023, the following EPM spotlight features were introduced:

EPM Cloud Platform

  • Operational Dashboards for Tasks, Alerts, Supplemental Data, and Enterprise Journals
  • Reports Support for Valid Intersections
  • Forms 2.0 and Dashboard 2.0
  • Pipeline Feature in Data Integration
  • Direct Drill From Summary Members Enabled For Agent Drill Type URLs
  • Announcing: New Guide to Create and Run an EPM Center of Excellence (CoE)

Account Reconciliation

  • Custom Dashboards for Reconciliation Compliance and Transaction Matching

Enterprise Data Management

  • Time Labeled Viewpoints
  • Time Labels
  • Policy Execution Plan
  • Private and Public Queries for Viewpoints
  • Extract Packages
  • Ownership Approvals

Enterprise Profitability and Cost Management

  • Ad Hoc Analysis Available in Rule Designing and Rule Balancing

Financial Consolidation and Close

  • Ability to Create Unbalanced Consolidation Journals
  • Application Roles for Consolidation Journals

Narrative Reporting

  • Report Reference Doclets Now Support Adding Report Text and Note Boxes as Available Content in the Report Package

Planning

  • Enabling Task Manager within Existing Planning Applications
  • Support for Calendars and Events in IPM Insights, Auto Predict, and Predictive Planning
  • Enhanced Connected Planning with Sales Planning and Strategic Workforce Planning - New Application Types in Planning

Tax Reporting

  • Enabling Pillar Two in Tax Reporting

  • Support for Configurable Dimensionality and Optimizing the Application Model for Hybrid Aggregation