Oracle Hyperion Calculation Manager

Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.013 (27780138)

Readme

About This Patch. 1

Patch Type. 2

Supported Paths to This Patch. 2

Prerequisites. 2

Required Patches. 2

Required User Rights. 2

Supported Platforms. 3

Supported Languages. 3

Defects Fixed in This Patch. 3

Defects Fixed in Patch 11.1.2.4.012 (27534345). 3

Defects Fixed in Patch 11.1.2.4.010 (25926429). 4

Defects Fixed in Patch 11.1.2.4.009 (25775528). 4

Defects Fixed in Patch 11.1.2.4.008 (25362429). 4

Defects Fixed in Patch 11.1.2.4.007 (23596012). 5

Defects Fixed in Patch 11.1.2.4.006 (22806363). 5

Defects Fixed in Patch 11.1.2.4.005 (22549387). 6

Defects Fixed in Patch 11.1.2.4.004 (21453167). 6

Defects Fixed in Patch 11.1.2.4.003 (21284466). 6

Defects Fixed in 11.1.2.4.002 (20830325). 7

Defects Fixed in 11.1.2.4.001 (20569991). 7

Known Issues in This Patch. 8

Applying This Patch. 9

Rolling Back This Patch. 10

Troubleshooting FAQs. 11

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

Why do I get the OUI-67078 warning message when applying OPatch?. 11

How can I find out which releases and patches of EPM System products are installed in a deployment?. 11

I applied the patch successfully but I don’t see the changes from the patch in the product. What should I do?. 11

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 require a full installation.

Supported Paths to This Patch

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)

 

Prerequisites

All users should clear cached files from their browsers.

Required Patches

Hyperion Planning 11.1.2.4.002(20937926) or higher

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

This patch supports the same platforms as release 11.1.2.4.000.

Supported Languages

This patch supports the same languages as release 11.1.2.4.000.

Defects Fixed in This Patch

 

Defect Number

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. 

 

Defects Fixed in Patch 11.1.2.4.012 (27534345)

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.

 

Defects Fixed in Patch 11.1.2.4.010 (25926429)

 

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.

 

Defects Fixed in Patch 11.1.2.4.009 (25775528)

 

 

Defect Number

Defect Fixed

• 25752296

When deploying a Rule Set that contains rule sets, it may return an error. 

 

Defects Fixed in Patch 11.1.2.4.008 (25362429)

 

 

Defect Number

Defect Fixed

• 24558681

Using a Cross Dimension Essbase Runtime Substitution Variable (RTSV) in a rule may not validate. 

 

Defects Fixed in Patch 11.1.2.4.007 (23596012)

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.

 

 

Defects Fixed in Patch 11.1.2.4.006 (22806363)

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.

 

Defects Fixed in Patch 11.1.2.4.005 (22549387)

 

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.

 

Defects Fixed in Patch 11.1.2.4.004 (21453167)

 

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.

 

Defects Fixed in Patch 11.1.2.4.003 (21284466)

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.

 

Defects Fixed in 11.1.2.4.002 (20830325)

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.

 

Defects Fixed in 11.1.2.4.001 (20569991)

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.

 

Known Issues in This Patch

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 browser’s right-click menu is shown instead of Calculation Manager’s, try clicking to the right of the item, and Calculation Manager’s 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.

Applying This Patch

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

 

Rolling Back This Patch

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

 

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_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