Oracle Hyperion Enterprise Performance Management Workspace

[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.3.000 Patch Set Update (PSU): 11.1.2.3.700

Readme

About this Patch. 1

Patch Type. 1

Supported Paths to this Patch. 2

Prerequisites. 2

Other Required Patches. 2

Required User Rights. 3

Supported Platforms. 3

Supported Languages. 4

Defects Fixed in this Patch. 4

Known Issues in this Patch. 4

Applying this Patch. 4

Rolling Back this Patch. 5

Troubleshooting FAQs. 6

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

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

About this Patch

See https://stbeehive.oracle.com/teamcollab/wiki/TPS3.700:Readme+Common+Text for updates to this common text!

Apply this patch to use Internet Explorer release 11 in standards mode. After you apply this patch, you can no longer use Internet Explorer Enterprise Mode. You must apply the 11.1.2.3.700 PSUs for all EPM System products in your deployment. For details, see the "Prerequisites" section.

This Readme file describes the defects fixed in this patch and the requirements and instructions for applying this patch.

Caution: Oracle urges you 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 service interruptions, loss of data, or both.

Patch Type

This is a patch set update (PSU). This PSU replaces files in the existing installation and does not require a full installation.

This is a standalone patch and it does not include previous patches.

[NOTE TO WRITERS:  Add a sentence stating whether the patch Requires a full installation or a partial replacement. if it’s a partial replacement, The boilerplate for this statement is: “This patch replaces files in the existing installation and does not require a full installation.”]

[note to writers:  State whether this is a cumulative or standalone Patch. If it’s cumulative, list the previous Patch IDs (XXXXXXXX) that are included. To find previous patch IDs, either Ask your team or look for the patch id in uninstall section of previous Readme. If Standalone, state that this patch does not include previous patches.] 

Supported Paths to this Patch

You can apply this patch to the following releases:

11.1.2.3.5xx 

 [NOTE TO WRITERS:  list the base Release(s) from which you can apply this patch and Include any prerequisite patches. TO refer to service fixes or service packs using the old nomenclature, use the fully qualified service fix/service pack version number along with the patch id, for example, 11.1.2.0.07 (12345678).]

Prerequisites

Other Required Patches

1.    Ensure this product's 11.1.2.3.500 / 17529887 patch is installed first.

2.    Install WebLogic Server Patch 17437110 for Release 10.3.6 to use Simplified Chinese and Traditional Chinese language settings when using Internet Explorer 10 and Internet Explorer 11 on Windows 8 and Windows 8.1. For instructions on applying the patch, see Oracle Smart Update: Applying Patches to Oracle WebLogic Server.

3.    Apply these required EPM System release 11.1.2.3.700 PSUs first:

o    Apply Oracle Hyperion Shared Services 11.1.2.3.700 PSU - 20675028. Apply the patch to all computers in the deployment.

4.    For the rest of the products, apply the product patch on the computer where the product is deployed. Use the table below to find EPM product 11.1.2.3.700 PSU patch numbers. If the product is not listed, then it does not have a 11.1.2.3.700 PSU, and no action is needed.

Note: For Oracle Hyperion Calculation Manager, apply the patch on all computers where Oracle Hyperion Planning, or Oracle Hyperion Financial Data Quality Management Enterprise Edition, or Oracle Essbase is deployed.

Note: Apply the EPM Workspace patch on all computers where Foundation Services or Oracle Hyperion Reporting and Analysis Framework is deployed.

Note: If you are using IBM WebSphere Application Server, you must redeploy the EPM System web applications after applying EPM System release 11.1.2.3.700 PSUs.

Product Name

11.1.2.3.700 PSU Patch Number

Oracle Data Relationship Management

21107706

Oracle Financial Reporting

20838970

Oracle Hyperion Calculation Manager

21292109

Oracle Hyperion Disclosure Management

20619384

Oracle Hyperion Financial Close Management

20768349

Oracle Hyperion Financial Data Quality Management Enterprise Edition

20779592

Oracle Hyperion Financial Management

20955781

Oracle Hyperion Performance Management Architect

20929569

Oracle Hyperion Planning

20643564

Oracle Hyperion Profitability and Cost Management

20915688

Oracle Hyperion Reporting and Analysis Framework

20768325

Oracle Hyperion Tax Provision

21219363

Oracle Hyperion Web Analysis

20880421

 

Required User Rights

[NOTE TO WRITERS: Delete the windows and unix sections as appropriate based on what platforms the patch is for.]

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

[NOTE TO WRITERS: State whether this patch IS being released on all platforms OR list the supported platforms.

If being released on all platforms, say “Applies to all supported platforms.”

If being released on one specific platform, list that platform (with no introductory text).

If being released on more than one specific platform, put the platforms in a bulleted list (with no introductory text). For example:

·         Applies to all supported platforms

This way of listing supported platforms is required for consistency in the Defects Fixed Finder.]

Supported Languages

This patch can be applied to all languages supported in release 11.1.2.3.000 of Oracle Enterprise Performance Management System. For the Oracle Enterprise Performance Management System Supported Platform Matrix, go to: http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html .

[NOTE TO WRITERS:  State whether this patch IS being released on all languages OR list the supported languages. If ENGLISH ONLY, State "This patch supports English only."]

Defects Fixed in this Patch

[NOTE TO WRITERS: present this list in a table format.

[NOTE TO WRITERS: do not copy descriptions from bug db. they need to be rewritten to be meaningful from the customer point of view.]

[NOTE TO WRITERS: Verify that the Defects Fixed list in the Readme includes: (1) All customer-reported defects regardless of severity; (2) All Sev 1, 2, and 3 defects whether customer reported or not; (3) Sev 4 at discretion of team.

NOTE: For Sev 3, non-customer-reported defects: The objective is to let customers know what areas of the product were touched in the patch, so they know what areas to test. Use your discretion for Sev 3 defects that are clearly internal and would not be in an area that customers would need to test.

Security vulnerabilities are not typically included. The guideline is: If a security bug is reported by a customer and if the issue is fixed across the EPM suite, then we can include that bug in the readme. Otherwise - if the problem is fixed in one product but still exists in other products - we can’t include them in the readme.]

The text in the first column of the table must start with a bullet in order for the import into the Defects Fixed Finder tool to work correctly. Like so:

 

Defect Number

Defect Fixed

21330061

IE 11 requires Enterprise mode

20829572

Unable to navigate Workspace, access other apps if user reuses same IE session

19881118

Closing "}" bracket cannot be typed in Entity field for ICP

18080943

Workspace SmartView Provider should not change unsupported locale to English

20975143

Exploring gives error when scrolling in IE 11

Known Issues in this Patch

[NOTE TO WRITERS: This section is required.  If the patch doesn’t have any known issues, INCLUDE THIS SENTENCE.] 

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

Enterprise Mode is not supported for this release. Customers who enabled Enterprise Mode must disable it before applying this patch.

[NOTE TO WRITERS: Per Legal: This sentence must be included IF THERE ARE KNOWN ISSUES.]

Applying this Patch

The section includes important information about applying this patch for Oracle Hyperion Enterprise Performance Management System Workspace.

[NOTE TO WRITERS:  Make sure that instructions for applying the PATCH indicate specifically which components are being patched and which machines in a distributed installation should be patched. for example, “on the machine hosting the shared services web application, …”]

[NOTE TO WRITERS:  For web applications, make sure you provide instructions for all supported application servers.]

To apply this patch:

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

2.    If any previous versions of this patch have been applied, roll them back using the instructions in "Rolling Back this Patch".

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

4.    NOTE: Determine the ORACLE_HOME and MIDDLEWARE_HOME for your installation prior to continuing the next step. By default, MIDDLEWARE_HOME is C:\Oracle\Middleware\ on windows and "$HOME/Oracle/Middleware/" on UNIX. EPM_ORACLE_HOME is <MIDDLEWARE_HOME>\EPMSystem11R1 on Windows and <MIDDLEWARE_HOME>/EPMSystem11R1 on UNIX.

5.    On EPM Workspace machine, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

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

Windows:

opatch.bat apply <EPM_ORACLE_HOME>\OPatch\20612400 -oh <EPM_ORACLE_HOME>

-jre <MIDDLEWARE_HOME>\jdk160_35

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/20612400 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>/jdk160_35 -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.

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

8.    Restart Oracle Hyperion EPM services and servlets.

9.    All users should now clear cached files from their browsers.

Rolling Back this Patch

To roll back a patch:

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

NOTE: Determine the EPM_ORACLE_HOME and MIDDLEWARE_HOME for your installation prior to continuing the next step. By default, MIDDLEWARE_HOME is C:\Oracle\Middleware\ on windows and "$HOME/Oracle/Middleware/" on UNIX. EPM_ORACLE_HOME is <MIDDLEWARE_HOME>\EPMSystem11R1 on Windows and <MIDDLEWARE_HOME>/EPMSystem11R1 on UNIX.

2.    On EPM Workspace machine, 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 20612400 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_35

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 20612400 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>/jdk160_35 -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.    For WebSphere deployments, you must use EPM System Configurator to redeploy the Web application.

5.    For WebLogic deployments, remove the directory which holds the cached JSPs. This directory is called "jsp_servlet" and is under the WebLogic DOMAIN_HOME/precompiled/workspace directory.

6.    Restart Oracle Hyperion EPM services and servlets.

7.    All users should now clear cached files from their browsers.

 

[NOTE TO WRITERS: IF THIS PATCH INCLUDES CHANGES TO A JAVASCRIPT FILE, YOU NEED TO INCLUDE THE STEP ABOVE AS A FINAL STEP. IF IT DOESN’T, DELETE THIS STEP.]

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:

[NOTE TO WRITERS: very important! the jdk version in the apply command is different for 11.1.2.0, 11.1.2.1, and 11.1.2.2. change the jdk160_xx directory as follows:

11.1.2.2: jdk160_29

11.1.2.1: jdk160_21

11.1.2.0: jdk160_11

The example here is for 11.1.2.2.

Windows:

opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>\jdk160_35

UNIX/Linux:

./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35 –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