Oracle Hyperion Strategic Finance

Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.002

Readme

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

About This Patch. 1

Patch Type. 1

Supported Paths to This Patch. 2

Prerequisites. 2

Strategic Finance Client 2

Conversion Utility. 2

Required User Rights. 2

Supported Platforms. 2

Supported Languages. 3

Contents of this Patch. 3

Defects Fixed in This Patch. 3

Defects Fixed in Patch 11.1.2.4.001 (20458658). 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

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 the existing installation and does not perform a full installation.

This is a cumulative patch that includes the following patches:

11.1.2.4.000

11.1.2.4.001

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

11.1.2.4.001

[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

Strategic Finance Client

To use the Strategic Finance client, the following must be installed:

·         Microsoft Excel (2007, 2010 or 2013)

·         The most recent version of Oracle Hyperion Smart View

Conversion Utility

If you are upgrading to Strategic Finance Release 11.1.2.2 or later from any previous release, you must run a conversion utility to convert your Strategic Finance entity files to 11.1.2.2. Patches containing this utility are available for all supported prior releases. This conversion will convert entities, archives, translation files, etc. For additional information, see the Enterprise Performance Management System Release 11.1.2.2 Installation and Configuration Guide.

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

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 this document contributes to mongo, the list should be identical to the readmes for all other products that are included in Mongo.

If being released on more than one specific platform, put the platforms in a bulleted list (with no introductory text). This way of listing supported platforms is required for consistency in the Defects Fixed Finder.] For example:

Information about system requirements and supported platforms for EPM system products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix.   This matrix is posted on the Oracle Fusion Middleware Supported System Configuration page on Oracle Technology Network (OTN):

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Note: Unless otherwise stated in this readme, platform support in HSF 11.1.2.4.002 follows that which is stated in the 11.1.2.4.000 version of Oracle Enterprise Performance Management System Certification Matrix.

Additional Microsoft Platform Support

Microsoft Windows 8

Microsoft Office 2013 (32-bit and 64-bit)

Supported Languages

This release of Strategic Finance is provided only in English in correlation with the English version  of the 11.1.2.4.000 Smart View release.

Information about supported languages for EPM System products is available in a spreadsheet format on the Translation Support tab in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN:

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

Contents of this Patch

Unzip this patch to any temporary local directory you wish on the host to be patched. The <PATCH FILE NAME>.zip will create the following:

Patch\

  hsf_11.1.2.4.002.3057_win32.zip

  hsf_11.1.2.4.002.3057_amd64.zip

  HSFClient.exe

  HSFClient-x64.exe

  readme.html

 

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.

Defects Fixed in This Patch

 

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

[Include:

[Do Not Include:

[Note: These are guidelines. Teams can make the final decisions.]

[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

• 20446807

In the Last Historical Period and Base Period dropdowns of the Time Periods dialog the time period names are being shown instead of the time period ID's.

• 20586561

Standard reports are showing the time period ID instead of the time period name.

• 20588662

Standard reports are prompting to Unprotect the sheet.

• 20630467

All the fields in the Currency Translator dialog are blank when there are a large number of dimensions in an entity. 

• 20670609

The default entity field on the common tab of the mapping dialogs is too short to display an entity with a long name.

• 20865923

There has been performance degradation when opening reports or opening an entity that has reports open.

• 21211065

Attempting to run an ACM on dimensional accounts fails and loses the connection to the provider.

• 21645729

Adding an @Dim to a formula causes an error.

 

Defects Fixed in Patch 11.1.2.4.001 (20458658)

[NOTE to writers: FOR CUMULAtive patches only. List earlier patch DEFECTS FIXED and create sub-headings for each previous patch, where YYYYYYYY refers to an earlier patch.  DELETE THIS SECTION IF NOT CUMULATIVE.  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).]

Defect Number

Defect Fixed

• 20395341

The check in of certain specific entities fails.

 

Known Issues in This Patch

 [Include the following:

[Note: These are guidelines. Teams can make the final decisions.]

Defect Number

Issue

• 16232392

The password feature for local entity files has been deprecated.  This feature is not available on Smart View.

 

[NOTE TO WRITERS: If the patch is cumulative, check with your product team about whether to include any known issues from the earlier patches.]

Applying This Patch

This section includes important information about applying this patch for Oracle Hyperion Strategic Finance.

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

Important Note

Follow these steps when applying this patch:

1.    Uninstall Strategic Finance Client (if present).

2.    Install Strategic Finance Client 11.1.2.4.002 by running HSFClient.exe or HSFClient-x64.exe depending on if the 32-bit or 64-bit version of Office is being used.

3.    Apply OPatch for Strategic Finance 11.1.2.4.002.

Default Locations

<EPM_ORACLE_HOME> is C:\Oracle\Middleware\EPMSystem11R1

<MIDDLEWARE_HOME> is C:\Oracle\Middleware

 

Pre-Patch Notes

Before applying this patch, please close all Strategic Finance applications that may be running and stop all Strategic Finance services on the host being patched.

If both the Strategic Finance Client and Server are installed on the same box, when uninstalling Strategic Finance Client, do not select the Delete Common Components option box.

Applying the Patch

Skip this set of steps if the Strategic Finance server components are not installed on the host being patched.

The following steps for patching are the same for both 32-bit and 64-bit server installs.

1.    Copy the server patch file to the <EPM_ORACLE_HOME>/OPatch directory.

Patch file name:

32-bit OS: hsf_11.1.2.4.002.3057_win32.zip

64-bit OS: hsf_11.1.2.4.002.3057_amd64.zip

2.    Unzip the patch file to the <EPM_ORACLE_HOME>/OPatch directory.

NOTE: Unzipping the patch file will automatically create a subdirectory of the same name.

3.    From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

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

32-bit OS:

opatch.bat apply <EPM_ORACLE_HOME>\OPatch\hsf_11.1.2.4.002.3057_win32 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_35

64-bit OS:

opatch.bat apply <EPM_ORACLE_HOME>\OPatch\hsf_11.1.2.4.002.3057_amd64 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_35

Post-Patch Notes

Start all Strategic Finance services.

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

Rolling Back This Patch

To roll back a patch:

Default Locations:

<EPM_ORACLE_HOME> is C:\Oracle\Middleware\EPMSystem11R1

<MIDDLEWARE_HOME> is C:\Oracle\Middleware

 

Pre-Rollback Notes

Before rolling back this patch, please close all Strategic Finance applications that may be running and stop all Strategic Finance services on the host being rolled back.

Strategic Finance Server Components

Skip this set of steps if the Strategic Finance server is not installed or was not patched on the host.

The following steps for rolling back are the same for both 32-bit and 64-bit server installs.

1.    -        From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

2.    -        From the command line window, enter the following command on one line:

opatch.bat rollback –id 20868598 –oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_35

Strategic Finance Client

Skip this set of steps if the Strategic Finance client is not installed or was not patched on the host.

1.    -        Uninstall Oracle Hyperion Strategic Finance Client.

2.    -        Copy and run the pre-patched, original Strategic Finance client installer from the Strategic Finance server. The client installer can be found in the <EPM_ORACLE_HOME>/common/epmstatic/wspace/hsf/Client directory.

Post-Rollback Notes

Start all Strategic Finance services.

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, 11.1.2.2, and 11.1.2.3/11.1.2.4. change the jdk160_xx directory as follows:

11.1.2.3/11.1.2.4: JDK160_35

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

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