Select an EPM product

[NOTE TO WRITERS: Go to the File or Document properties and change the “title.” The correct entry for “Author” and “Company” are provided in the template.]

Release 11.1.2.2.401 Patch Set Update (PSU): 11.1.2.2.401

Readme

About this Patch. 1

Patch Type. 1

Supported Paths to this Patch. 2

Prerequisites. 2

Required Microsoft Patch. 2

Required User Rights. 2

Supported Platforms. 2

Supported Languages. 2

Defects Fixed in this Patch. 2

Defects Fixed in Patch 11.1.2.1.400 (14558930). 3

Known Issues in this Patch. 3

Applying this Patch. 3

Rolling Back this Patch. 4

Troubleshooting FAQs. 5

Why do I get the following patch conflict error message when running OPatch?. 5

Why do I get the OUI-67078 warning message when applying OPatch?. 6

How can I find out which releases and patches of EPM System products are installed in a deployment?. 6

I applied the patch successfully but I don’t see the changes from the patch in the product. What should I do?. 6

About this Patch

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.

Patch Type

This is a patch set update (PSU). This patch replaces files in existing installation and doesn't require a full installation. This is a cumulatibe patch.

Previous Patch ID : 11.1.2.2.400

Supported Paths to this Patch

You can apply this patch to the following releases:

11.1.2.2.000

Prerequisites

Required Microsoft Patch

Microsoft has identified a security issue that could compromise Windows-based systems.  Before installing this patch, verify that the Visual C++  2005 Redistributable Package installed on the computer is current.  You may search and download the latest Visual C++  2005 Redistributable Package from:

http://www.microsoft.com/en-us/download/default.aspx

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 Platforms

·         APPLIES TO ALL SUPPORTED PLATFORMS

Supported Languages

This patch supports all languages supported by Oracle Hyperion Reporting and Analysis Framework System 11.1.2.2.000.

 

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 17227683

SQR HTML OUTPUT GENERATED VIA GENERIC JOB DOESN'T DISPLAY CORRECTLY.

• 17060373

"MANAGE JOB SCHEDULES" LISTS SCHEDULES OWNED BY OTHER USERS

• 17060341

JOB LOCALE DEFAULTS TO JAPAN WHEN BROWSER IS SET TO NON-SUPPORTED LANGUAGE.

• 17052878

FILTER IS NOT WORKING FOR JOB NOTIFICATION

• 16369474

REPLACE AN OCE IN WORKSPACE DOES NOT UPDATE THE OCE PROPERTIES

• 16365964

LCM IMPORT OF JOB PARAMETERS FAILS WITH ERROR EPMRAF-31008 WHEN IMPORT IN BULK

 

Defects Fixed in Patch 11.1.2.1.400 (14558930)

Defect Number

Defect Fixed

• 15904248

LCM export/import from 11.1.2.2 to 11.1.2.3 fails.

• 14705791

Log messages with level INCIDENT_ERROR should be excluded from log files.

• 16097467

Search Indexer causes high load of the system after LCM import of some objects.

• 13955948

"Required application module reporting HRRunDlg is not configured" error when running any financial report in workspace.

• 14260339

Some Reporting & Analysis validation checkers (like "Check if Agents are available" and "Check if RAF Services are available") should check objects only from the same EPM instance.

 

Known Issues in this Patch

This patch does not contain any known issues.

The following issues are the noteworthy known issues of the patch 400.

In the patch 400 css identities were replaced by user names in Life Cycle Management datasets. As a result, old datasets created for 11.1.2.2 will not work. To convert old datasets, please do the following:

1)  Prior to installing the 11.1.2.2.401 patch, import all datasets you need to convert.

2)  Apply the 11.1.2.2.401 patch.

3)  Export the datasets. They will now contain user names instead of css identities and will be compatible with 11.1.2.3 release.

Applying this Patch

The section includes important information about applying this patch for Oracle Hyperion Reporting and Analysis Framework.

To apply this patch:

1.    Shut down all services and servlet instances related to the Oracle Hyperion Enterprise Performance Management System 11.1.2.2.000 installation.

2.    Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name.

3.    On EPM Reporting and Analysis Framework machine, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

4.    To apply the patch, enter the following command on one line:

Windows:

opatch.bat apply <EPM_ORACLE_HOME>/OPatch/17027109 -oh <EPM_ORACLE_HOME>
-jdk <MIDDLEWARE_HOME>/jdk160_29

NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.

UNIX/Linux:

./opatch apply <EPM_ORACLE_HOME>/OPatch/17027109 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

5.    Clean up caches for RaFramework0 WebLogic server. Clear the contents of the tmp directories:

Windows:

<WEBLOGIC_DOMAIN_HOME>\servers\RaFramework0\tmp

NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is C:\Oracle\Middleware\user_projects\domains\EPMSystem

UNIX/Linux:

<WEBLOGIC_DOMAIN_HOME>/servers/RaFramework0/tmp

NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is $HOME/Oracle/Middleware/user_projects/domains/EPMSystem

 

6.    Restart Oracle Hyperion EPM services and servlets.

“For WebSphere deployments, you must use EPM System Configurator to redeploy the Web application.”

 

Rolling Back this Patch

To roll back a patch:

1.    Shut down all services and servlet instances related to the Oracle Hyperion Enterprise Performance Management System 11.1.2.2.000 installation.

2.    From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

3.    To roll back the patch, enter the following command on one line:

Windows:

opatch.bat rollback -id 17027109 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.

UNIX/Linux:

./opatch rollback -id 17027109 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME> /jdk160_29 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

4.    Clean up caches for RaFramework0 WebLogic server. Clear the contents of the tmp directories:

Windows:

<WEBLOGIC_DOMAIN_HOME>\servers\RaFramework0\tmp

 

NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is C:\Oracle\Middleware\user_projects\domains\EPMSystem

 

UNIX/Linux:

<WEBLOGIC_DOMAIN_HOME>/servers/RaFramework0/tmp

NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is $HOME/Oracle/Middleware/user_projects/domains/EPMSystem

 

5.    Restart Oracle Hyperion EPM services and servlets.

Troubleshooting FAQs

Why do I get the following patch conflict error message when running OPatch?

If the patch that you apply conflicts with a previously applied patch, you may receive the following error message when running OPatch:

Patch(es) <PreviousPatch#> conflict with the patch currently being installed (<NewPatch#>).

If you continue, patch(es) <PreviousPatch#> will be rolled back and the new patch (<NewPatch#>) will be installed.

If a merge of the new patch (<NewPatch#>) and the conflicting patch(es) (<PreviousPatch#>) is required, contact Oracle Support Services and request a Merged patch.

This error is returned when one patch attempts to update a previously patched file. When this conflict happens, you can either (1) roll back the previous patch and apply the new patch (this action might be appropriate if the previous patch was not critical) or (2) request a “merged patch” consisting of the new patch and the patch that it conflicts with. To request a merged patch, contact your Oracle Support representative. 

Why do I get the OUI-67078 warning message when applying OPatch?

This warning means that the patch being applied is a superset of a patch already on the deployment and the existing patch will be rolled back. The following snippet shows the context of this warning.

The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 12345678 is a superset of the patch(es) [77777777] in OH C:\Hyperion
-----------------------------------------------------------------------------------
OPatch Session completed with warnings.

How can I find out which releases and patches of EPM System products are installed in a deployment?

In EPM System Release 11.x, you can use the lsinventory command to OPatch to find the release and patches that are installed in an Oracle Home. For example, enter the following command on one line:

Windows:

opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

UNIX/Linux:

./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 –invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

I applied the patch successfully but I don’t see the changes from the patch in the product. What should I do?

When patching an .EAR file for an application, you may need to delete the cached files in the following folders in order to see the changes provided with the patch:

<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/tmp/

<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/cache