Oracle Hyperion Strategic Finance

Release 11.1.2.2.000 Patch Set Update (PSU): 11.1.2.2.305

Readme

 

About this Patch. 1

Patch Type. 2

Supported Paths to this Patch. 2

Prerequisites. 2

Required Microsoft Patch. 2

Required User Rights. 3

Supported Platforms. 3

Supported Languages. 4

Contents of this Patch. 4

Defects Fixed in this Patch. 4

Defects Fixed in Release 11.1.2.2.304. 4

Defects Fixed in Release 11.1.2.2.303. 6

Defects Fixed in Release 11.1.2.2.302. 8

Defects Fixed in Release 11.1.2.2.301 PSE 17355249. 9

Defects Fixed in Release 11.1.2.2.301. 9

Defects Fixed in Release 11.1.2.2.300. 13

Known Issues in this Patch. 14

Known Issues in Release 11.1.2.2.302. 15

Known Issues in Patch 11.1.2.2.301. 15

Applying this Patch. 16

Rolling Back this Patch. 17

Troubleshooting FAQs. 18

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

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

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

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

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

11.1.2.2.301

11.1.2.2.301 PSE 17355249

11.1.2.2.302

11.1.2.2.303

11.1.2.2.304

Supported Paths to this Patch

You can apply this patch to the following releases:

11.1.2.2.300

11.1.2.2.301

11.1.2.2.301 PSE 17355249

11.1.2.2.302

11.1.2.2.303

11.1.2.2.304

Prerequisites

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:

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

Strategic Finance Client

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

·         Microsoft Excel

·         Oracle Hyperion Smart View (11.1.2.5.200)

Other Required Patches

Note: If you installed the Strategic Finance Client and Smart View on the same machine, you’ll need to install Smart View first before Strategic Finance Client.

 

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

Supported Platforms

This patch can be applied to all platforms supported in release 11.1.2.2.000 of Strategic Finance.

CLIENT

·         Microsoft Windows XP Professional SP3 or later

·         Microsoft Windows Vista SP1 or later

·         Windows 7        

·         Microsoft Windows Office 2007

·         Microsoft Windows Office 2010 (only the 32-bit version is supported)

·         Microsoft Windows 2003, SP2, and R2

·         Microsoft Windows 2008 SP2 and R2

SERVER

·         Microsoft Windows 2003, SP2, and R2

·         Microsoft Windows 2008 SP2 and R2

·         Oracle database 11gR1 or later

·         SQL Server 2008 R2

·         SQL Server 2005 with SP3 or later

·         IBM DB2 9.7 FP3a or later

Supported Languages

This release of Oracle Hyperion Strategic Finance is provided only in English in correlation with the English only 11.1.2.2.300 Oracle Hyperion Strategic Finance 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

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.2.305.2357_win32.zip

  hsf_11.1.2.2.305.2357_amd64.zip

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

Defects Fixed in this Patch

Defect Number

Defect Fixed

• 18314216

Entity Change Management moves data to the next time period when the change being pushed is a change in the time structure of the entity.

Defects Fixed in Release 11.1.2.2.304

Defect Number

Defect Fixed

• 14780266

When using an aliased consolidation child entity of the parent entity, data is not being brought into the freestyle report correctly.

• 16041581

An error occurs when applying an adjustment to two input cells that are in forecast periods.

• 16601784

When using the assign cell attributes dialog attempting to apply the attributes to the entire freestyle report freezes excel.

• 16622060

Freestyle reports take a long time to update in Smart View after a calculating the model.

• 16629738

Freestyle reports with aliased links take several minutes to open.

• 16955664

Data does not populate correctly when creating a new freestyle report.

• 16977891

Even though the account's forecast method allows overrides, if an invalid value is entered there is no warning that only overrides can be entered.  The invalid data is rejected but the correct value is not restored.

• 17006021

Assign cell attributes for the freestyle reports is not working correctly.

• 17088006

Attempting to open some reports causes errors on entities that were converted up from prior versions of Hyperion Strategic Finance.

• 17414672

Using entity change management to push time period details from the base entity can fail.

• 17432500

Selecting user defined accounts in the audit trail dialog fails when Crystal Ball has been installed.

• 17549848

Some reports throw exceptions when opened manually and do not reopen when checked in then checked back out.

• 17981109

After importing data into the HSF client the values of some accounts that have #overrides are different when comparing the data in the client and Smart View.

• 18063593

The upgraded import / export interface to Hyperion Financial Management does not concatenate parent and child member names for the entity dimension causing existing maps and batches to fail.

• 18125840

Unable to assign cell attributes on large freestyle reports.

• 18131118

Reports lose formatting after changing scenarios or hiding and unhiding time periods.

• 18139177

After refreshing a report there is flashing and active sheet changes.

• 18140054

Some freestyle reports can lose assigned cell attributes after checking in an entity and checking it back out.

• 18149699

Errors can occur when checking in large reports.

• 18196441

In Crystal Ball when attempting to use the More Tools/Strategic Finance option it returns a error.

• 18202729

Attempting to use the audit trail on some cells in a freestyle report can cause an exception to be thrown.

• 18261819

Smart View shuts down unexpectedly when a different copy of Excel is closed.

• 18262615

Opening an entity while the Assign cell attributes dialog is open causes an error to be thrown.

• 18306779

When the Assign cell attributes dialog is open for an entity closing a different entity causes an error to be thrown.

• 18307098

When using the Time/Settings dialog after changing the name of a time period, attempting to add a period to date time period will cause an error to be thrown.

• 18308564

When using the Audit trail dialog after changing an input value to use a # or ## override in the Account input dialog if you then attempt to invoke the Account input dialog again without leaving the Audit trail an error can be thrown.

• 18309843

When accessing the Account input dialog from the Audit trail dialog if there are input values that contain a # or ## override the most significant digit of the input is lost when closing the Account input dialog.

 

Defects Fixed in Release 11.1.2.2.303

Defect Number

Defect Fixed

• 16322488

Unable to open entities after upgrade

• 16893846

Opening custom reports can cause an "Exception in OpenReport: Exception from HRESULT: 0x800A03EC".

• 16908240

Closing an entity in Smartview does not remove all references to the entity in excel.

• 16913533

Errors when pushes time period changes in ECM

• 16984047

After applying the PS2 301 patch changing dimensions in the dimension maintenance dialog throws an error.

• 17061416

Data cells showing 1#IND instead of N/A.

• 17074755

Cannot add or remove freeze panes from reports in Smartview

• 17243783

Interactive user group access ability is different in the HSF client and Smartview.

• 17416375

HFM import fails due to invalid metatata member

• 17470343

Assigning a non-existent HFM dimension to common crashes HSF

• 17590380

Assign cell attributes associations can disappear.

• 17595680

Pushing report changes with ECM causes errors

• 17741647

Checking out specific entities in Smartview generates an xml load error.

• 17752119

Data on reports does not update after the data is changed on the accounts tab and calculated.

• 17766893

Cannot create a dataview with a user time label as the time boundary.

• 17768512

After changing the time periods displayed in the active dataview the account description is no longer displayed in the correct cell.

• 17792983

Error when clicking the user defined account button in the audit trail.

• 17792996

Renaming the base scenario can hang excel if the crystal ball extension is enabled.

• 17793126

The Strategic Planning ribbon options remain enabled after checking in specific entities.

• 17834975

Cannot assign accounts from an aliases.

• 17835111

Exception thrown when trying to add account to a report.

• 17835285

Changing report tab properties locks the cells on the report.

• 17835374

Specific entities can generate an xml load error when opening the alias manager.

• 17835666

In a local file, when attempting to search on an account of an open file in the alias manager Excel throws message "… waiting for another application to complete OLE action."

• 17835731

When the worksheet on an entity is opened and the entity is then checked in and reopened the open worksheet option is disabled.

• 17836061

Turning off "Allow input in actuals" in access control is disabling input in forecast periods.

• 17836223

When an excel worksheet saved from SmartView is opened, opening an entity, refreshing and attempting to open a report can cause an "Empty response from provider" error.

• 17836320

Pasting a worksheet link is not working.

• 17836516

Using the apply forecast and select accounts option in free style reports can cause an Unknown exception error.

• 17836672

SmartView cannot submit data and calculate for Japanese language.

• 17836880

Error when opening a local file in SmartView when it is already open.

• 17837072

When using the audit trail from a report attempting to audit a to date time period that is synthetic does not work.

• 17837504

Excel hangs after renaming base scenario with crystal ball extension enabled.

• 17843668

Inserting rows on a report then closing the entity and releasing the lock throws an exception.

• 17853106

The accounts tab is displaying NaN instead of N/A for not a number.

• 17853171

Offline entities incorrectly indicate that they can be checked in or have their locks released when SmartView is not connected to the HSF server.

• 17860488

Data displayed in the audit trail is incorrect when the data is coming from an alias.

• 17891166

Attempting to run the audit trail dialog from a free style report where the cell references an alias to a local entity fails.

• 17896416

SmartView fails to display the "Entity changed by ECM" dialog when opening entities that have ECM changes.

• 17896914

When in the actual scenario the inputs are not editable.

• 17922344

On the accounts view in SmartView only the accounts in the current scenario should be enabled.

• 17931257

Cannot access default reports in some entities.

• 17936189

Adding a subaccount changes the cell in focus.

• 17938168

Going to the scenario tab in an HFM import map with no scenarios causes HSF to crash.

• 17945959

When migrating from 9.3.1.4 to the 11.x version of HSF non-base accounts were not migrating correctly when the non-base scenario uses actual data and has less actual time period then the base scenario.

• 17952259

Worksheet options in SmartView are not functioning correctly.

 

Defects Fixed in Release 11.1.2.2.302

Defect Number

Defect Fixed

• 16601915

In the Time/Settings dialog the Display column cannot be unchecked

• 16622700

Hitting okay to close the Dataview dialog hangs excel.

• 16623111

Reports are not inheriting formats when rows or columns are inserted

• 16635831

Connection to HSF lost in Smartview when PowerPoint is closed.

• 16698208

Changing the currency translator data does not cause the consolidation status of an entity to change.

• 16717093

In ECM copy account groups does not copy the exchange rate accounts.

• 16745770

When checking in if the entity has multiple maps to export only the first map is being exported.

• 16843445

In Smartview in an input cell entering a non-allowed character and then selecting calculate from the ribbon could freeze Excel.

• 17004381

In Smartview when in the Consolidation Structure dialog clicking on a column header will reorder the entities.

• 17263164

Report updates after calculation are slow.

• 17263173

Consolidation can use wrong scenario.

• 17312141

Error when saving local file.

• 17322753

When the ECM target is an entity group the ECM fails.

• 17341257

Data is not showing when creating a freestyle report.

• 17346917

Currency translation issues when running consolidations.

• 17355637

Unable to open entities if current account group does not exist.

• 17402615

When alias is broken, in the assign cell attributes dialog hitting the build button for a time period formula will cause an exception.

• 17403475

Using the Debt Scheduler is creating a value in the Accrued Interest account which can not be removed.

• 17423182

Can not set a time range in the Dataview dialog.

• 17424203

Selecting the label drop down in the Alias Manager dialog causes an exception.

• 17430706

Issues with using the archives when using the Alias Manager or Account Attributes dialogs.

• 17432152

Error when saving a checked out entity.

• 17443976

ACM can push wrong values when pushing to an account that is Constant in all periods.

• 17444046

You can add a subaccount with a subaccount number larger than the last required element.

• 17444209

When closing an entity the account tab is left open.

• 17451750

Can not open the HSF worksheet in selected entities.

• 17496691

Using the audit trail on a freestyle report will throw an error in certain cases.

• 17505533

Having done work in the scenario manager dialog can cause an unknown exception when attempting to check in an entity.

 

Defects Fixed in Release 11.1.2.2.301 PSE 17355249

Defect Number

Defect Fixed

• 17355236

Data not displaying on free style reports.

• 17355245

ACM is not working for the constant in all periods forecast method.

• 17363312

Currency translation issue during consolidation.

Defects Fixed in Release 11.1.2.2.301

Defect Number

Defect Fixed

·   14588197

Sometimes unable to change scenario in a report.

·   14588218

Hidden rows do not persist.

·   14698490

Report display options are not correctly honoring the Show Subaccounts flag.

·   14745222

Formats in free-style reports sometimes disappear after calculation.

·   14745412

Refresh will sometimes refresh to the wrong scenario.

·   14807338

When a step is a step constructed in the formula, the audit trail is getting the data from the step correct.

·   15928867

Adding a new scenario causes the active worksheet to change.

·   15949017

Common size variable cannot be changed in Reports Properties.

·   15960812

Fill values in Excel causes an exception.

·   15966704

Cell comments do not appear in reports.

·   15974371

Adding a new Strategic Finance worksheet and deleting an old one causes Excel errors.

·   15974489

Pasting from the worksheet did not work if reports are also open.

·   15979184

Submit button disappears after changing free-form formula.

·   15981376

Account Input form is not handling inputs that are not numbers correctly.

·   16000286

An unhandled exception occurs when attempting to open a report while in edit mode in Excel.

·   16000517

Scenario Manager does not default to the selected scenario.

·   16000681

Unhandled exception occurs in Scenario Manager when un-checking accounts.

·   16000786

When the list of selected accounts is updated, the changes are not handled correctly, and prior selections may get lost.

·   16000817

POV bar sometimes disappears after calculation.

·   16045946

On reports in Smart View, there is no way to freeze panes (i.e., anchor the window to the left and top of where the freeze
happens). 

·   16166591

If the base and/or actual scenario have been renamed, accounts in a different scenario that depend on the base/actual scenario for their forecast method are getting incorrect data.

·   16171214

Under heavy load, the Strategic Finance Server may temporarily deadlock, resulting in an inability to log in.

·   16187264

When attempting to write ADBControl, Invalid User errors may occur.

·   16205265

Inserting a dimensionalized account into a report causes an error.

·   16210507

Report takes a long time to open if the formatting results in a used range of all columns or rows.

·   16277752

The Account Input Form is not handling the "constant in all periods" inputs.

·   16346192

Taking an entity offline will not persist the open reports.

·   16500783

When editing accounts with a forecast method calling for a single forecast period value, using the # and ## override operators does not correctly set the dirty flags for changed data, causing the file to not calculate completely.

·   16514093

In free-style reports, changing the alias sets the mapped account to 'none'.

·   16516384

ABDUserID schema has encryption, which should be removed.

·   16522191

In Formula dialog, the formula and formula description are not xml encoded, producing an error when certain characters are used.

·   16536382

Report sizes are too large after conversion.

·   16545163

Formulas for user-defined accounts are not saved.

·   16570800

When the label of the time period is different than the period ID, the Audit trail will not open.

·   16570834

Adding a new group may cause Excel to freeze.

·   16571144

Forecast description disappears when sheet is changed.

·   16609133

File size doubles after conversion.

·   16617651

Account Input Dialog is going to the first time period when opened, not the time period in the Audit Trail.

·   16667461

Essbase/Planning batches do not run due to an unnecessary check for a missing file.

·   16679247

On Windows Vista and later versions of the operating system, the Strategic Finance Client may close when trying to save an entity as a template file.

·   16682660

Copying a value by using Excel's drag/fill operation causes an error.

·   16704418

Add and Delete worksheet ribbon options are sometimes incorrectly disabled.

·   16724478

Overrides are producing incorrect answers when calculated.

·   16739945

In Planning maps, the Entity selection is not stored correctly when using an alias table while editing.

·   16755681

Account groups that started with a blank space are not being read correctly.

·   16756966

In order to log into the Server from the Strategic Finance Client, a user must be assigned the Administrator role when provisioned.

·   16768630

Gridlines on reports do not persist.

·   16796744

The Account Input Dialog is not handling the 1.Q#NAN representation of Not a Number, also problem with overrides.

·   14594266 

While using a Unified Connection, you must enter credentials twice.

·   14685664 

Clearing an override does not always flag the model for calculation.

·   15867092 

Refreshing a standard report sometimes results in screen flickering.

·   15868171 

Refresh and calculation times are slow.

·   15935939 

Strategic Finance servers and databases do not always enumerate in the Smart View panel.

·   15941429 

Both Historical and Forecast input values are blue in color.

·   15972218 

Sometimes changing the account group and view would cause Excel to close unexpectedly.

·   16022377 

Column width sometimes changes when the data view is changed.

·   16041556 

New scenarios sometimes have an incomplete list of available accounts.

·   16041773 

Changing the formula for an account does not always flag the model for calculation.

·   16058856 

@DIMEXACT function does not work in Smart View.

·   16062501 

Scenarios do not always display properly in standard reports.

·   16173259 

Renaming a scenario sometimes causes Strategic Finance Client to close unexpectedly.

·   16217848 

Freeze frames feature is not saved properly on check in.

·   16218631 

Display option for number of reports to open is not always honored.

·   16231442 

Selecting an account group in a report sometimes causes an error.

·   16245049 

In the Strategic Finance Client, creating a server-based Essbase export map as a copy of a local map may fail and then cause the Client to close unexpectedly.

·   16269383 

In the Strategic Finance Smart View Client, scrolling around the Accounts view is noticeably slow when the view contains a large number of cells.

·   16279516 

Inserting a dimensionalized account into a standard report may cause an error.

·   16279525 

Large reports are not opening properly.

·   16279609 

Account names sometimes appear in the wrong place when changing account groups.

·   16346186 

Sometimes saving a model after opening the worksheet causes Excel to freeze.

·   16384427 

Exports of large data sets to HFM using maps and batches take up to 30 minutes to run.

·   16411060 

When changing data views, cursor may move to upper left of sheet.

·   16500936 

The Strategic Finance Smart View Client may leak noticeable amounts of memory during file operations.

·   16516342 

In the Strategic Finance Client, the user-defined account dialog does not work properly when the list of covenant accounts is selected in the dialog.

·   16516424 

Removing accounts from a scenario sometimes removes the wrong account from the scenario.

·   16574360 

Essbase/Planning import maps produce errors when run if they contain too many entries.

·   16574389 

The dimension editor in the Strategic Finance Client does not display the dimensions correctly when there is more than one user-defined dimension.

·   16601163 

Column widths on reports could be misread by Excel in some situations.

·   16682590 

Submit data sometimes causes the model to calculate.

·   16687963 

"Apply-to" functionality for account forecasts does not always work.

·   16757113 

Creating a new data view sometimes causes Excel to freeze.

 

Defects Fixed in Release 11.1.2.2.300

Defect Number

Defect Description

• 12774808 

If you have an account in your model with an empty name, trying to change the Forecast Method for any account to “Actual Value” will cause an “Out of Memory” error.

• 12993041

In Strategic Finance for Smart View, you cannot adjust the column width.

• 13424664 

Strategic Finance server service does not log enough information to determine success or failure of service start.

• 13510743 

Strategic Finance server service does not log service start to a file.

• 13520602 

You could not delete an entity from the Offline directory.

• 13520626 

The entities displayed in connection manager tree need to be sorted in alphabetical order instead of entity creation time.

• 13587883 

User could only select an item in the analyze trail by double clicking the highlighted item.  The item can now be selected by either double clicking or using the enter key.

• 13917069 

Certain entities would not open due to the absence of xml encoding

• 13936011 

Certain reports would not open due to Smart View trimming report names

• 14049331

Some files that used values from the Actual scenario in other scenarios could never be completely calculated and thus could not be checked in.

• 14128040

When selecting new accounts in the scenario manager the previously selected accounts were not maintained in all cases.  Now selecting new accounts will not accidently unselect prior selected accounts.

• 14128823

Unable to run Essbase batch import and export using the 64-bit Strategic Finance Server version.

• 14219604

The Currency Translator may not translate Common Stock correctly in certain cases where the level of detail in a year varies in the entity being translated.

• 14222998 

The Strategic Finance Entity Web services API for Extended Analytics export is not working correctly.

• 14249890 

Smart View was incorrectly labelling "N/A" as "NaN"

• 14292687

You cannot enter a numeric value via Strategic Finance for Smart View.

• 14332417

Dimension Maintenance option is disabled in both local entity and non-local entity modes.

 

Known Issues in this Patch

The following issue is the noteworthy known issue of this patch.

For Oracle Hyperion Strategic Finance to work correctly it is necessary for the  Hyperion Strategic Finance Java Web App, the Hyperion Strategic Finance  .NET Web Services and the Hyperion Strategic Finance Server to be deployed on the same machine.

Attempting to enumerate the Hyperion Strategic Finance databases in Smart View will fail if there is more than one HSF web app configured and running.

If an entity is from a version of Oracle Hyperion Strategic Finance prior to version 11.1.2.1, before opening the entity in Smart View it is necessary to make sure the entity has been updated.  This can be done by opening the entity in the Oracle Hyperion Strategic Finance client or by using the Edit/Convert menu option from the entities tab of the Oracle Hyperion Strategic Finance Administrator.

It is critical that you back up your Strategic Finance data prior to applying this patch.  In the event this patch is rolled back, you'll need to then restore that saved version of your Strategic Finance data.

For Crystal Ball to successfully launch Hyperion Strategic Finance it may be necessary to register the HSF.exe program first.  It can be registered by running the command:

%EPM_ORACLE_HOME%\products\hsf\bin\HSF /regserver

 

Defect Number

Defect Description

• 16583736

HSF Client installer does not overwrite the HSF Extension.  To work around this issue uninstall the client before running the installer.

• 18308754

While on a report when a time period is added at the end of  the model the report gets updated with the new time period but the formatting is incorrect.                  

 

Known Issues in Release 11.1.2.2.302

The following issue is the noteworthy known issue of this patch.

When running HSF the Crystal Ball extension needs to be disabled due to compatibility issues between HSF and Crystal Ball.

Known Issues in Patch 11.1.2.2.301

The following issues are the noteworthy known issues of this patch.

Defect Number

Defect Description

• 15930276

Uninstalling previous versions of Strategic Finance Client may remove the registry setting for EPM_ORACLE_INSTANCE, without which the Strategic Finance Server cannot start up properly.  Customers may need to manually add this registry key back to the Windows registry by creating a string named EPM_ORACLE_INSTANCE in the key HKEY_LOCAL_MACHINE\Software\Oracle\HSF and defining the instance there, which defaults to C:\Oracle\Middleware\user_projects\epmsystem1.

• 15931616

You must register the wbocx.ocx. If the wbocx.ocx is registered and the directory with the skin info is not there, the following message is generated:
“Cannot load product color scheme Hyperion\Hyperion.uis.  This program will run with Windows default colors.”

• 16601784

When you select an entire sheet and assign cell attributes, Excel may freeze.

• 16601879

Selecting Hide Group from the filter list in the Account view may cause Excel to freeze.

• 16624250

You cannot assign cell attributes with similar characteristics to multiple column and multiple rows in the Smart View client.

• 16709561

When working with the SUPERVIAS demo file, performance issues may occur when working with months and a large number of time periods.

• 16727235

In Office 2007, reports display as cascading after submitting a data and run calculation. 

• 16763719

When taking offline 100 entities, the Back button is not visible in the Take Offline dialog.

• 16774655

When working with the SUPERVIAS demo file, when you assign dimensions to a user-defined account, you may receive an error.

• 16796760

When closing the Audit Trial Dialog, a window behind the Excel window pops up.

• 16821645

At times, it is possible to enter values in greyed-out data cells.

• 16837738

When deleting an added worksheet, Excel issues sometimes occur.

 

 

Applying this Patch

This section includes important information about applying this patch for <Product Name>.

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.

Important Note

Follow these steps when applying this patch:

1.    Uninstall Strategic Finance Client (if present).

2.    Install Strategic Finance Client 11.1.2.2.305 by running HSFClient.exe.

3.    Apply Opatch for Strategic Finance 11.1.2.2.305.

Default Locations

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

<MIDDLEWARE_HOME> is C:\Oracle\Middleware

 

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.2.305.2357_win32.zip

64-bit OS: hsf_11.1.2.2.305.2357_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.2.305.2357_win32 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_29

64-bit OS:

opatch.bat apply <EPM_ORACLE_HOME>\OPatch\hsf_11.1.2.2.305.2357_amd64 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_29

Post-Patch Notes

Start all Strategic Finance services.

Rolling Back this Patch

This section includes important information about rolling back this 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 18355715 –oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_29

Strategic Finance Client

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

3.  Uninstall Oracle Hyperion Strategic Finance Client.

4.  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:

opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

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