Hyperion On-Premise update June 2018 from Kscope18

•11.1.2.3

–S1 defect fixing only until March 2018

•11.1.2.4

–Defect Fixing, 3rd party certification updates, enhancements thru Dec 2020

•11.2

–Scheduled for early 2019

–Uplift to Fusion Middle Ware 12g release

–Repository Simplification released early 2018

•Remove of Foundation services with a content migration for FR/Workspace to RDBMS repository

–Defect Fixing, 3rd party certification updates, enhancements thru Dec 2030

HFM 11.1.2.4.207 Patch released June 12, 2018

https://blogs.oracle.com/proactivesupportepm/psu_hfm_11124207

New Features in this Release

New Statistics Option in HFM Insights

HFM Insights now includes a Statistics section that displays detailed data statistics based on a selected Scenario and Year combination.  You can choose when to manually update the statistics.

To update statistics:

1.            Select Navigate, then Administer, and then Consolidation Administration.

2.            Select System, and then Insights.

3.            From the Statistics section, click the Data tab.

4.            Click the Member Selector, select a Scenario and Year, and click OK.

5.            Click the Execute button to run the process and return statistics on the selected Scenario and Year combination.

Note:

When you click the Execute button and update statistics, the button is disabled for a certain period of time while the process runs. The task runs in the background, and you can navigate to other parts of the application while it is running. When it is done, the button is re-enabled and the table is refreshed with the updated statistics. You can also click Refresh to see the updated values.

If there are no records in a particular table, the system does not display any statistics for that table.

Data tab

·         Data (DCE and DCN total record count per Scenario/Year combination)

·         Invalid records (invalid member ID), DCE and DCN only, Total count only (not per entity)

·         Near Zero Value Records for all periods

·         Near Zero Value Calculated Records for all periods

·         PFlow History (per Scenario/Year)

·         Input Data (if any period in the year is Input or Line Item Details)

Table Count tab

The Table Count tab displays record counts of the following Oracle Hyperion Financial Management system tables and the times they were last executed.

·         Task Audit

·         Data Audit

·         System Messages (Error Log table)

·         Rules Profile data

Hyperion Modules Optimizing Performance by Changing the Heap Size

Depending on your environment, you might need to change the heap size for your Java web application server. 

For example, if you see “OutOfMemory” errors in WebLogic, increase the heap size. 

If you need to reduce the memory requirement of the WebLogic Server, decrease the heap size.

By default, if you deploy Java web applications to a single managed server, EPM System Configurator sets the default heap size for the single managed server based on the machine's memory:

• 12 GB or more on machine, sets heap size at 8 GB
• 6 GB or more, up to but not including 12 GB, sets heap size at 4 GB
• Under 6 GB on a 32-bit machine, sets heap size at 750 MB
• Under 6 GB on a 64-bit machine, sets heap size at 1.536 MB

Hyperion 11.1.2.4 and Virtual Machine error - Insufficent memory for the Java Runtime Environment

Recently we had a snafu where 2 of my Hyperion services, APS and EPM Web, were not starting....i ran the validate.bat command from the Foundation server and came across this exciting log file.

hs_err_pid3444.log in the folder below (E is where my Hyperion is installed)
E:\Oracle\Middleware\user_projects\epm-fnd\config\validation\11.1.2.0

Log file content was saying that Native memory allocation failed to allocate.

# There is insufficient memory for the Java Runtime Environment to continue.
# Native memory allocation (malloc) failed to allocate 1122576 bytes for Chunk::new
# Possible reasons:
#   The system is out of physical RAM or swap space
#   In 32 bit mode, the process size limit was hit
# Possible solutions:
#   Reduce memory load on the system
#   Increase physical memory or swap space
#   Check if swap backing store is full
#   Use 64 bit Java on a 64 bit OS
#   Decrease Java heap size (-Xmx/-Xms)
#   Decrease number of Java threads
#   Decrease Java thread stack sizes (-Xss)
#   Set larger code cache with -XX:ReservedCodeCacheSize=
# This output file may be truncated or incomplete.
#
#  Out of Memory Error (allocation.cpp:317), pid=3444, tid=7848
#
# JRE version: 6.0_35-b52
# Java VM: Java HotSpot(TM) 64-Bit Server VM (20.10-b01 mixed mode windows-amd64 compressed oops)


So i reduced the Java Heap Size for Min/Max for some of the services.  And restarted all the services and everything worked. 

I thought i would share this nice tip that i discovered.

Hyperion Planning Simplified UI Login screen displays when Workspace times out

Some of my user's session timed out due to the inactivity and user's are seeing the Simplified Planning user interface login screen instead of the Workspace login screen.

This is happening because the session in Planning product getting invalidated even before the Workspace session gets timed out.

=================================================

To implement the solution, please execute the following steps (Please ensure you take a backup of the mod_wl_ohs.conf file)

1. Go into the OHS file

2. Navigate to \Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\

 Edit the following file:
\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\mod_wl_ohs.conf

3. Add (or edit, if already present) the following parameters:

WLIOTimeoutSecs 1800
WLSocketTimeoutSecs 1800
to the sections for Planning and Workspace. Each section begins with an XML tag, for example:

Add the new "WLIOTimeoutSecs 1800" and "WLSocketTimeoutSecs 1800" properties as new lines within the tags, for example:

  SetHandler weblogic-handler
  WeblogicCluster planserver01:8300
  WLIOTimeoutSecs 1800
  WLSocketTimeoutSecs 1800


4. Restart the Oracle HTTP Server and the Workspace web application services after the modifications are complete.

5. Retest the issue Migrate the solution as appropriate to other environments.

Oracle Hyperion Technical Matrix for compatibility

Here is the Oracle link to the Excel file.

http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html