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 is cumulative and includes defects resolved in 11.1.2.1 and subsequent patch set exceptions (pses). This patch replaces files in the existing installation, and does not require a full installation.

Supported Paths to this Patch

You can apply this patch to release 11.1.2.1.600 (patch 14464109) of Planning.

Prerequisites

EPM System Patches

Before applying this patch, install the below patch as described in the readme for that patch:

o Planning 11.1.2.1.600 (patch 14464109).

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

You can apply this patch to all platforms supported in release 11.1.2.1. Information about system requirements and supported platforms for EPM System products is available in a spreadsheet format in the Oracle Hyperion Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on the Oracle Technology Network (OTN) and listed in the Oracle Business Intelligence product area:

http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html

Supported Languages

This patch supports the languages supported in release 11.1.2.1. Information about supported languages for EPM System products is available in a spreadsheet format on the Translation Support tab in the Oracle Hyperion Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN (listed in the Oracle Business Intelligence product area):

http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html

Notes:

For this release, Arabic is not supported on Planning Web, even through customization. However, Arabic is supported within Smart View.

Defects Fixed in this Patch

Defect Number	Defect Fixed
· 12422049	Member of data type text does not display value starting with zero correctly in data form.
· 13066418	Instructions of sub-forms do not get displayed in composite form.
· 13487456	Column width property in data form is reset to default after LCM migration.
· 13624086	Web Analysis report invoked from Planning task list does not open in Web Analysis studio.
· 13997844	Formatting is not maintained in Task list instructions
· 14038551	Launching a rule attached to data form from left pane might fail if rule has hidden run time prompts.
· 14142871, 16020876, 16799835	The Page dimension shared member selections are not being retained when moving between two data forms. This causes users to have to reselect the page shared members every time they switch between data forms.
· 14277928	The current value for user variable is not shown as selected in member selector when invoked from data form.
· 14304889, 16020903	For composite forms containing global page dimensions, a warning message is not displayed if the a new member selection is made and Go is not selected prior to entering data. This is not consistent behaviour with local page dimensions, for which a warning message is displayed.
· 14467701	Unable to load data form from Essbase ASO to planning using Data Synchronization if data has negative values.
· 14548541	If a row or column in data form is defined using functions such as ISiblings, data form may not open.
· 14762712, 14779912	Changing the status of Planning unit that involves executing data validation rule on forms may result in excessive Planning user sessions.
· 14792218	Composite forms may not display correctly after applying Hyperion Planning 11.1.2.1.102 PSU.
· 14832185	Offline planning hung at 95% if any non english character is in substitution variable. To resolve this issue, perform the additional steps indicated in “Apply this Patch”.
· 15832405	Row height property of a planning form is not being retained during LCM Migration.
· 15867093, 16868937, 16485376, 16293478, 15849792, 14628876	After applying Hyperion Planning 11.1.2.1.102 or 11.1.2.1.600 PSU, changing the status of a planning unit of type free form may not work.
· 15883423	Scroll Bar is not displayed when opening composite data forms.
· 16210693	Users are duplicated in Add User access window if display full name option is enabled in application settings.
· 16469400, 16410781	When a form is opened in Ad-hoc mode in Smart View, you may be unable to search for members in the Member Selector with certain search criteria. Note: Alias based search is not supported in 11.1.2.1.000.
· 16612910	RTP of type cross dimension shows user variable names instead of member name.
· 16626930	Dimensions in rows are not in correct order if attribute is used in rows.
· 16785203, 16685515	If data forms in a composite form have same business rule attached with run on save option, when launching from Smart View, it only launches such business rule once for the first sheet.
· 16821606, 14748639	Unable to see RTP's when a ruleset is launched from SmartView via Tasklists.
· 17026275	Get intermittent error when saving a form with a business rule.

Applying this Patch

To apply this patch:

1. Stop all of the EPM services running on the Planning server where this patch is being applied, including the Planning server, RMI services, and Financial Reports.

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 the Planning server machine, from a command line, change the directory to <EPM_ORACLEHOME>/OPatch.

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

Microsoft Windows:

opatch.bat apply <EPM_ORACLE_HOME>/OPatch/16906210 -oh <EPM_ORACLE_HOME>

-jdk <MIDDLEWARE_HOME>/jdk160_21

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/16906210 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_21 -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. Delete the tmp directory for the Planning server in:

<MIDDLEWARE_HOME>/user_projects/domains/EPMSystem/servers/<server>

where <server> is the Planning server (for example, Planning0).

The full path for tmp is:

<MIDDLEWARE_HOME>/user_projects/domains/EPMSystem/servers/<server>.

5. Restart all the services on the Planning server that were stopped in Step 1, including the Planning server, RMI services, and Financial Reports services.

6. Have all users clear cached files from their browsers.

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

Resolving defect 14832185

1. Delete the existing offline connections created in your existing installation.

2. Make a back up copy of HypOfflineProvider.exe in <EPM_ORACLE_HOME>/products/OfflinePlanning/bin.

3. Rename the copy as HypOfflineProvider.exe.backup_11.1.2.1.000.

4. Copy the new HypOfflineProvider.exe file from <EPM_ORACLE_HOME>/products/Planning/bin to each Offline installation location in <EPM_ORACLE_HOME>/products/OfflinePlanning/bin.

5. Create new offline connections by taking the required forms offline.

Post Installation Steps

Steps if Planning and Financial Reporting are on Different Servers

1. If you have Financial Reporting (FR) installed on a different server from the one where Hyperion Planning is installed, perform these steps on that server:

- Stop all of the EPM services running on the server.

- Back up HspJS.jar from

<EPM_ORACLE_HOME>\common\ADM\Planning\11.1.2.0\lib folder (and from <EPM_ORACLE_HOME>\common\ADM-64\Planning\11.1.2.0\lib folder if it exists)

2. Unzip the 16906210 patch zip file and copy HspJS.jar from 16906210\files\common\ADM\Planning\11.1.2.0\lib to:

- <EPM_ORACLE_HOME>\common\ADM\Planning\11.1.2.0\lib

- <EPM_ORACLE_HOME>\common\ADM-64\Planning\11.1.2.0\lib (if it exists).

3. Restart all the EPM services on the server that were previously stopped.

Steps if Other Enterprise Performance Management Products Reside on a Server Other than the Planning Server

Perform these steps on all servers that host any EPM system products other than Planning. For example, if ERPI Integrator and Performance Management Architect are installed on different a server than the Planning server, perform the following procedure on the server hosting ERPI and EPMA.

1. Stop all running EPM services.

2. Make a backup of HspJSClient.jar file from <EPM_ORACLE_HOME>\common\planning\11.1.2.0\lib.

3. Unzip the 16906210 patch zip file and copy HspJSClient.jar from 16906210\files\common\planning\11.1.2.0\lib, and paste it in: <EPM_ORACLE_HOME>\common\planning\11.1.2.0\lib.

4. Restart all the EPM services on that server that were previously stopped.

Rolling Back this Patch

To roll back a patch:

1. Stop all of the EPM services running on the Planning server where this patch is being applied, including the Planning server, RMI services, and Financial Reports.

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 16906210 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_21

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 16906210 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME> /jdk160_21 -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. Delete the tmp directory for the Planning server in:

<EPM_ORACLE_HOME>/user_projects/domains/EPMSystem/servers/<server>

where <server> is the Planning server (for example, Planning0).

The full path for tmp folder is: <EPM_ORACLE_HOME>/user_projects/domains/EPMSystem/servers/<server>.

5. Restart all the services on the Planning server that were stopped in Step 1, including the Planning server, RMI services, and Financial Reports services.

6. Have all users clear cached files from their browsers

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_21

UNIX/Linux:

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