Oracle Hyperion Web Analysis
Release 11.1.2.3.000 Patch Set Update (PSU): 11.1.2.3.700(20880421)
Readme
Defects Fixed in the Patch 11.1.2.3.504(19558551)
Defects Fixed in the Patch 11.1.2.3.500(17957350)
Why do I get the following patch conflict error message when running OPatch?
Why do I get the OUI-67078 warning message when applying OPatch?
How can I find out which releases and patches of EPM System products are installed in a deployment?
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.
This is a patch set update (PSU).
This patch replaces files in the existing installation, and does not require a full installation.
You can apply this patch to the following releases:
· 11.1.2.3.500
Note: Customers already on 11.2.3.504 can apply 11.1.2.3.700 on top of 11.1.2.3.504.
1. Ensure that this product's 11.1.2.3.500 patch is applied first.
2. If you are using WebLogic Application Server, apply WebLogic Application 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:
Apply Oracle Hyperion Shared Services 11.1.2.3.700 PSU - 20675028. Apply the patch to all computers in the deployment.
Apply Oracle Hyperion Enterprise Performance Management Workspace 11.1.2.3.700 PSU - 20612400. Apply to all computers with Foundation Services deployed.
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: 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 Data Quality Management Enterprise Edition |
20779592 |
Oracle Hyperion Financial Management |
20955781 |
Oracle Hyperion Performance Management Architect |
20929659 |
Oracle Hyperion Planning |
20643564 |
Oracle Hyperion Profitability and Cost Management |
20915688 |
Oracle Hyperion Tax Provision |
21219363 |
Oracle Hyperion Web Analysis |
20880421 |
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:
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.”
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.
This patch applies to all supported platforms.
This patch applies to all supported languages.
Defect Number |
Defect Fixed |
• 20880342 |
WEB ANALYSIS REPORT ERROR AT SORT TOOL: CLASS CANNOT BE CASTED TO ARRAY |
Defect Number |
Defect Fixed |
• 19558489 |
AFTER APPLYING 11.1.2.3.500, MEMBER POSITION DISPLAYED INCORRECTLY AFTER PERIOD |
• 19558536 |
AFTER APPLYING 11.1.2.3.500, SELECTIONS IN CUBE NAVIGATOR DISPLAYS ALL MEMBERS |
Defect Number |
Defect Fixed |
• 16981792 |
STUDIO UNABLE TO OPEN WA DOCUMENTS FROM WORKSPACE IF DOC NAME CONTAINS MBCS |
• 16743322 |
NAGATIVE ALMOST-ZERO VALUE SUCH AS -0.00000001 IS ROUNDED TO -0 |
• 17526730 |
CUMULATIVE FUNCTION RETURNING WRONG VALUE IN WEB ANALYSIS REPORT |
• 17567043 |
CALCULATION FUNCTION IN ANALYSIS TOOLS MANAGER OPTIONS NOT WORKING FOR POSITION |
• 17571847 |
UNABLE TO SEE CALCULATION DEFINITION IN WEB ANALYSIS REPORT |
• 17578437 |
ANALYSIS TOOLS MANAGER -> CALCULATION DISPLAYS ZERO (0) VALUE |
• 17592912 |
COMPUTATION DOES NOT DISPLAY VALUE WHEN SUPPRESS MISSING ROW IS ENABLED |
• 16698256 |
WA:WKSPC:PAGE CONTROL PANEL CRASH AFTER USING EXPORT EXCEL WIZARD |
• 16623948 |
WEB ANALYSIS REPORT LAYOUT CHANGED AFTER REMOVING MISSING MEMBERS |
• 16471824 |
CANNOT OPEN MULTIPLE WEB ANALYSIS DOCUMENTS IN WA STUDIO |
• 17838027 |
POSITION OF CALCULATION (SUBTOTAL) IS INCONSISTENT IN THE WA REPORT |
• 17453391 |
DRILL LINK FAILS IF ESSBASE ALIAS NAME CONTAINS MULTI-BYTE CHARACTERS |
This patch does not contain any known issues.
The section includes important information about applying this patch for WebAnalysis.
To apply this patch:
1. Oracle recommends making a backup of the existing installation before applying this patch.
2. Shutdown all the services and servlet instances related to Hyperion Reporting and Analysis Release 11.1.2.3.
3. 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.
4. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.
5. To apply the patch, enter the following command on one line:
Windows:
opatch.bat apply
<EPM_ORACLE_HOME>/OPatch/20880421 -oh <EPM_ORACLE_HOME>
-jdk <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/20880421 -oh <EPM_ORACLE_HOME> -jdk <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.
6. Clean up caches for RaFramework0 and WebAnalysis0 WebLogic servers. Clear the contents of the tmp directories.
Windows:
<WEBLOGIC_DOMAIN_HOME>\servers\RaFramework0\tmp
<WEBLOGIC_DOMAIN_HOME>\servers\WebAnalysis0\tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is
C:\Oracle\Middleware\user_projects\domains\EPMSystem
UNIX/Linux:
<WEBLOGIC_DOMAIN_HOME>/servers/RaFramework0/tmp
<WEBLOGIC_DOMAIN_HOME>/servers/WebAnalysis0/tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is $HOME/Oracle/Middleware/user_projects/domains/EPMSystem
7. All users should now clear cached files from their browsers.
8. Start all services and servlets.
To roll back a patch:
1. Oracle recommends making a back up of the existing installation before rolling back this patch.
2. Shut down all services and servlet instances related to Hyperion Reporting and Analysis Release 11.1.2.3.
3. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
4. To roll back the patch, enter the following command on one line:
Windows:
opatch.bat rollback -id 20880421 -oh <EPM_ORACLE_HOME> -jdk <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 20880421 -oh <EPM_ORACLE_HOME> -jdk <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.
5. Cleanup caches for RaFramework0 and WebAnalysis0 WebLogic servers. Clear the contents of temp directories:
Windows:
<WEBLOGIC_DOMAIN_HOME>\servers\RaFramework0\tmp
<WEBLOGIC_DOMAIN_HOME>\servers\WebAnalysis0\tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is
C:\Oracle\Middleware\user_projects\domains\EPMSystem
UNIX/Linux:
<WEBLOGIC_DOMAIN_HOME>/servers/RaFramework0/tmp
<WEBLOGIC_DOMAIN_HOME>/servers/WebAnalysis0/tmp
NOTE: The default for <WEBLOGIC_DOMAIN_HOME> is $HOME/Oracle
Middleware/user_projects/domains/EPMSystem
6. Start all services and servlets.
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.
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.
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_35
UNIX/Linux:
./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35 –invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
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
Copyright © 2015, Oracle and / or its affiliates. All rights reserved. http://www.oracle.com