Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.013 (27780138)
Readme
Defects Fixed in Patch 11.1.2.4.012 (27534345)
Defects Fixed in Patch 11.1.2.4.010 (25926429)
Defects Fixed in Patch 11.1.2.4.009 (25775528)
Defects Fixed in Patch 11.1.2.4.008 (25362429)
Defects Fixed in Patch 11.1.2.4.007 (23596012)
Defects Fixed in Patch 11.1.2.4.006 (22806363)
Defects Fixed in Patch 11.1.2.4.005 (22549387)
Defects Fixed in Patch 11.1.2.4.004 (21453167)
Defects Fixed in Patch 11.1.2.4.003 (21284466)
Defects Fixed in 11.1.2.4.002 (20830325)
Defects Fixed in 11.1.2.4.001 (20569991)
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: 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.
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.4.000
11.1.2.4.001 (20569991)
11.1.2.4.002 (20830325)
11.1.2.4.003 (21284466)
11.1.2.4.004 (21453167)
11.1.2.4.005 (22549387)
11.1.2.4.006 (22806363)
11.1.2.4.007 (23596012)
11.1.2.4.008 (25362429)
11.1.2.4.009 (25775528)
11.1.2.4.010 (25926429)
11.1.2.4.012 (27534345)
All users should clear cached files from their browsers.
Hyperion Planning 11.1.2.4.002(20937926) or higher
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 supports the same platforms as release 11.1.2.4.000.
This patch supports the same languages as release 11.1.2.4.000.
Defect Fixed |
|
26242858 |
Validation of Financial Management rules may be slower than the previous version |
26281384 |
Using a rule with a RTP dimension type variable, when the name of the dimension is different than the type, the variable prompt may show: "No dimensions are available from which to select member(s)." |
27754365 |
In a rule set containing rules with RTP variables, the rule set may not save the default values entered for these RTP variables. |
27789898 |
When using RUNJAVA com.hyperion.calcmgr.common.cdf.MDXDataCopy in a rule, the log file may be appended each time the rule is launched. |
Defect Number |
Defect Fixed |
27510205 |
In an ASO rule with multiple formula lines, the rule may give an error when the rule launches. |
27540445 |
The custom defined function @CalcMgrMDXExport was modified to add additional parameters, but the registration of the CDF may fail due to the addition of the new parameters. |
27540472 |
A rule that uses the nested range functions with cross dimension syntax may not open, or may take a long time to open. |
27540490 |
Validating Scripts may not work, and may require you to restart Calculation Manager. |
Defect Number |
Defect Fixed |
25247546 |
If you use a non-level 0 attribute member in a rule, the rule may not validate from the rule designer. |
25751618 |
Short cut rules may not show the application/cube of the application/cube in which they are located, instead they may show the application/cube of the original rule. |
25996141 |
The CalcManager.log file may not show the start and end time for the launch of an Essbase rule from within Calculation Manager. |
25996325 |
Using the Command Line Launcher for Essbase Rules in Calculation Manager the CalcManager.log file may not show the start and end time for the launch of the rule. |
26023711 |
In an ASO cube, creating a Custom Calc rule with more than one formula line may not validate. |
Defect Number |
Defect Fixed |
25752296 |
When deploying a Rule Set that contains rule sets, it may return an error. |
Defect Fixed |
|
24558681 |
Using a Cross Dimension Essbase Runtime Substitution Variable (RTSV) in a rule may not validate. |
Defect Number |
Defect Fixed |
23575845 |
Moving rules up or down in a ruleset, may not move the variable data with the rule. |
23614211 |
In the Variable Designer, after saving a variable, the variable highlighted in the top pane, may not be the variable shown in the Properties pane. |
Defect Number |
Defect Fixed |
22165267 |
In a Financial Management EPMA enabled application, using Lifecycle Management (LCM) to export/import Calculation Manager artifacts, LCM may not export/import the check for Deployed. |
22754730 |
After renaming a rule that is part of a ruleset, deployment to Planning may not show the revised rule name within the Ruleset. |
22754828 |
Deploying an Essbase rule from Calculation Manager may incorrectly add UFT-8 to the locale header for a non-Unicode application. |
23054859 |
In a Financial Management rule, the Write to file function may not work. |
23071337 |
Updating Financial Management rules from 11.1.2.2 to 11.1.2.4, then importing to Calculation Manager, may cause the rules to give errors when opened. |
23179133 |
Right clicks in the blank space of the rule designer, may prevent Calculation Manager from working. |
23204371 |
Using /* */ to comment lines in a rule for Financial Management may produce errors on deployment. |
23211308 |
Database properties Statistics tab in Calculation Manager may not show all of the lines under the Run-time statistics. |
23535482 |
The Function, "@ALIAS(alias,tablename)", may not validate in Calculation Manager when you specify the second parameter - the alias table name. You must apply Essbase 11.1.2.4.010 (Patch 23184458) in order to use table name in the function. |
23543370 |
In an ASO rule, using a Run-time prompt with a function, for example: @Level0Descendants({Accts}), when the rule is launched in Planning, the variable may not prompt for input. |
Defect Number |
Defect Fixed |
22122103 |
When accessing Financial Management application preferences, the screen freezes. |
22143852 |
The Financial Management Calculation Manager application Preferences menu does not work. |
22279817 |
Function @ISACCTTYPE may not validate in Calculation Manager if you use "LAST" for the argument as in @ISACCTYPE(LAST). |
22468689 |
Function @ROUND may not validate in Calculation manager if you specify three parameters. |
22538686 |
Lines in script beginning with "//" may be color coded green. |
22553555 |
When making changes to a shared component within a rule, save may not keep the changes. |
Defect Number |
Defect Fixed |
21517268 |
When you launch a rule from within Calculation Manager, there is not a log file to show the rule name and runtime prompt values that were used by the rule. |
21910925 |
In Calculation Manager, launching two Essbase rules from two different databases are not running parallel. |
21967630 |
Using Lifecycle Management to import a business rule may fail to migrate the deployable flag. |
Defect Number |
Defect Fixed |
21124257 |
In IE11 check "Display intranet sites in Compatibility View" and Calculation Manager may not display the rule designer. |
21308171 |
Highlight several rules, CTRL + drag to another application's plan type is moving the rules when it should create shortcuts. |
21312362 |
If you configured active-passive Essbase cluster for Essbase failover, the Essbase node in Calculation Manager may not expand. |
21314411 |
Essbase functions @FORMATDATE and @TODAYEX may not validate in Calculation Manager if you use "Long Format", or "Short Format" as the first parameter. |
21342792 |
In Desktop Mode, using Calculation Manager's Database Properties, Start/Stop Application may not work. |
Defect Number |
Defect Fixed |
20861729 |
Using IE11, in Planning, the member formula editor may not load. |
20871222 |
Using IE11 with the language set to Chinese, in System View the deployed rules may show as not deployed. |
20886465 |
If you deploy a rule with multi-byte characters in the script, the deployed rule may show the multi-byte characters as unreadable text. |
21226576 |
In a rule, the use of the Custom Defined Functions - @CalcMgrMDXExport, @CalcMgrSubstring, @CalcMgrIndexOf, @CalcMgrLastIndexOf, or @CalcMgrGetCurrentDate, may not function correctly. |
Defect Number |
Defect Fixed |
20611321 |
In an Essbase rule that is in script mode, if the rule contains a runtime prompt variable, the rule may not validate. |
20688936 |
Unable to validate and launch business rules against ASO cubes in Planning applications. |
20762922 |
Calculation Manager may not work with Windows 7 and IE 11 |
20782979 |
In a Ruleset that contains more than 25 runtime prompt variables, you may get error: "Target Unreachable, identifier 'row' resolved to null" when entering a variable value. |
20801753 |
Re-Deploying an Essbase rule, may overwrite the user's security that was applied using the MaxL grant execute statement. |
Defect Number |
Issue |
17670292 |
In a script rule, when you are creating a new object by using Actions on the toolbar menu, a message stating the new object is created and opened for editing may continue to show after you click OK. Continue to click OK until the message is no longer shown, and the new object will open. To work around this, create the new object from the System View, and the message will no longer be shown after you click OK for the first time. |
17851179 |
When you right-click an object to access menus in Calculation Manager, the menus may not be displayed, and Internet Explorer menus may be displayed instead. For example when you are using the debug feature, you must click to the right of the breakpoint to access the right-click menus. To work around this, if the browsers right-click menu is shown instead of Calculation Managers, try clicking to the right of the item, and Calculation Managers menu should display. |
17922118 |
When you drag an object into the Script Editor, the text may be pasted at the beginning instead of the current cursor position in the script. To work around this, copy the text from the first line, and paste it into the required position. |
18003547 |
When you set the browser language for Internet Explorer 9 or 10 to Arabic (ar-ae), which is a bidirectional language, the expand icons, which display as pluses (that is, +) may not be displayed in the System View of Calculation Manager, and it may be difficult to expand the nodes in the System View. |
18050764 |
For performance and memory optimization, Oracle recommends that you do not open more than 10 tabs within Calculation Manager. If you open more than 10 tabs, errors may be generated. |
18086809 |
When the browser language is set to Arabic (ar-ae), any functions with members are displayed as ("FUNCTION("MEMBER@ For example: ("IDESCENDANT("Q1@ should be displayed as @IDESCENDANT("Q1"). |
18779427 |
In Internet Explorer 10, using the new object icon may not display the new object. To work around this, click on the System View, and the new object will display. |
18958860 |
When you save a rule that is in script with a different name using Save As, the saved as rule may not display, or may not display correctly. To work around this, click on the System View tab, and if the saved as rule is shown, close the rule and reopen it. |
19466572 |
If you edit a script component, add a member range component after the script component, and then drag the script component into the member range component, the changes to the script may not be saved. |
20828529 |
Using IE11 on Windows 2008 R2 to access Calculation Manager may not work. Workaround: Use Firefox E31 ESR, or IE 11 on Windows 7 or Windows 8.1 |
21418137 |
In Calculation Manager, using Analyze, Debug, Analyze Script, or a custom-defined function in a rule, may give an error. Workaround: Stop and restart the application. |
23064941 |
In a Financial Management EPMA enabled application script, validating a script may show the Validation Status window without updates or completed status. Workaround: Include the script in a rule and validation will complete. |
This section includes important information about applying this patch for Oracle Hyperion Calculation Manager.
To apply this patch:
1. Check whether any of these products: Oracle Hyperion Calculation Manager, Oracle Hyperion Planning, Oracle Hyperion Financial Data Quality Management ERP Integrations Adapter for Oracle Applications (ERP Integrator), Oracle Essbase Administration Services (Administration Services), and Oracle Essbase are installed and their services are running. If so, stop the following services: CALC Manager - Web Application, Hyperion Planning - Web Application, ERP Integrator - Web Application, the Administration Services - Web Application, and Oracle Essbase.
2. Download and unzip the downloaded patch file, 27780138.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
NOTE: 27780138.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 all servers that have the products mentioned in step #1 installed, 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/27780138 -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/27780138 -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. On the server where Oracle Hyperion Calculation Manager is installed, delete the cached files in the following directories:
<Middleware_Home>/user_projects/domains/<DOMAIN_NAME>/servers/<CalcMgr0>/tmp
<Middleware_Home>/user_projects/domains/<DOMAIN_NAME>/servers/<CalcMgr0>/cache
6. Start the services you stopped in Step #1.
7. All users should now clear cached files from their browsers
To roll back a patch:
1. Check whether any of these products: Oracle Hyperion Calculation Manager, Oracle Hyperion Planning, Oracle Hyperion Financial Data Quality Management ERP Integrations Adapter for Oracle Applications (ERP Integrator), Oracle Essbase Administration Services (Administration Services), and Oracle Essbase are installed and their services are running. If so, stop the following services: CALC Manager - Web Application, Hyperion Planning - Web Application, ERP Integrator - Web Application, the Administration Services - Web Application, and Oracle Essbase.
2. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
3. On all servers that have the products mentioned in step #1 installed, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch
4. To roll back the patch, enter the following command on one line:
Windows:
opatch.bat rollback -id 27780138 -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 27780138 -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. On the server where Oracle Hyperion Calculation Manager is installed, delete the cached files in the following directories:
<Middleware_Home>/user_projects/domains/<DOMAIN_NAME>/servers/<CalcMgr0>/tmp
<Middleware_Home>/user_projects/domains/<DOMAIN_NAME>/servers/<CalcMgr0>/cache
6. Start the services you stopped in Step 1.
7. All users should now clear cached files from their browsers
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 © 2018, Oracle and / or its affiliates. All rights reserved. http://www.oracle.com