Oracle Hyperion Strategic Finance

Release 11.1.2.3.500 Patch Set Update (PSU): 11.1.2.3.507

Readme

 [NOTE TO WRITERS: Go to the File or Document properties and change the “title.” The correct entry for “Author” and “Company” are provided in the template.]

About This Patch. 2

Patch Type. 2

Supported Paths to This Patch. 2

Prerequisites. 3

Required Patches. 3

Strategic Finance Client 3

Conversion Utility. 3

Required User Rights. 3

Supported Platforms. 3

Supported Languages. 4

Contents of this Patch. 4

Defects Fixed in This Patch. 4

Defects Fixed in Patch 11.1.2.3.506 (20807807). 4

Defects Fixed in Patch 11.1.2.3.505 (20417772). 5

Defects Fixed in Patch 11.1.2.3.504 (19689889). 6

Defects Fixed in Patch 11.1.2.3.503 (19564734). 7

Defects Fixed in Patch 11.1.2.3.502 (18831805). 7

Defects Fixed in Patch 11.1.2.3.501 (18400594). 8

Defects Fixed in Patch 11.1.2.3.500 (17898859). 10

Defects Fixed in Patch 11.1.2.3.100 (16942313). 11

Known Issues in This Patch. 14

Known Issues in Release 11.1.2.3.500. 15

Known Issues in Release 11.1.2.3.100. 16

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?. 19

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

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

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.3.000 PSE 16957075

11.1.2.3.100

11.1.2.3.100 PSE 17933055

11.1.2.3.500

11.1.2.3.501

11.1.2.3.502

11.1.2.3.503

11.1.2.3.504

11.2.3.3.504 PSE 20207130

11.1.2.3.505

11.1.2.3.506

[NOTE TO WRITERS:  Add a sentence stating whether the patch Requires a full installation or a partial replacement. if it’s a partial replacement, The boilerplate for this statement is: “This patch replaces files in the existing installation and does not require a full installation.”]

[note to writers:  State whether this is a cumulative or standalone Patch. If it’s cumulative, list the previous Patch IDs (XXXXXXXX) that are included. To find previous patch IDs, either Ask your team or look for the patch id in uninstall section of previous Readme. If Standalone, state that this patch does not include previous patches.] 

Supported Paths to This Patch

You can apply this patch to the following releases:

11.1.2.3.000

11.1.2.3.000 PSE 16957075

11.1.2.3.100

11.1.2.3.100 PSE 17933055

11.1.2.3.500

11.1.2.3.501

11.1.2.3.502

11.1.2.3.503

11.1.2.3.504

11.2.3.3.504 PSE 20207130

11.1.2.3.505

11.1.2.3.506

[NOTE TO WRITERS:  list the base Release(s) from which you can apply this patch and Include any prerequisite patches. TO refer to service fixes or service packs using the old nomenclature, use the fully qualified service fix/service pack version number along with the patch id, for example, 11.1.2.0.07 (12345678).]

Prerequisites

Required Patches

Strategic Finance Client

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

·         Microsoft Excel (2007, 2010 or 2013)

·         The most recent version of Oracle Hyperion Smart View

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 containing this utility are available for all supported prior releases. This conversion will convert entities, archives, translation files, etc. For additional information, see the Enterprise Performance Management System Release 11.1.2.2 Installation and Configuration Guide.

Required User Rights

[NOTE TO WRITERS: Delete the windows and unix sections as appropriate based on what platforms the patch is for.]

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

Supported Platforms

[NOTE TO WRITERS: State whether this patch IS being released on all platforms OR list the supported platforms.

If being released on all platforms, say “Applies to all supported platforms.”

If being released on one specific platform, list that platform (with no introductory text).

IF this document contributes to mongo, the list should be identical to the readmes for all other products that are included in Mongo.

If being released on more than one specific platform, put the platforms in a bulleted list (with no introductory text). This way of listing supported platforms is required for consistency in the Defects Fixed Finder.] For example:

Information about system requirements and supported platforms for EPM system products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix.   This matrix is posted on the Oracle Fusion Middleware Supported System Configuration page on Oracle Technology Network (OTN):

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Note: Unless otherwise stated in this readme, platform support in HSF 11.1.2.3.507 follows that which is stated in the 11.1.2.3.500 version of Oracle Enterprise Performance Management System Certification Matrix.

Additional Microsoft Platform Support

Microsoft Windows 8

Microsoft Office 2013 (32-bit and 64-bit)

Supported Languages

[NOTE TO WRITERS:  State whether this patch IS being released on all languages OR list the supported languages. If ENGLISH ONLY, State "This patch supports English only."]

This release of Strategic Finance is provided only in English in correlation with the English only 11.1.2.3.000 Smart View 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.3.507.2595_win32.zip

  hsf_11.1.2.3.507.2595_amd64.zip

  HSFClient.exe

  HSFClient-x64.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 indicates the file name.

Defects Fixed in This Patch

[NOTE TO WRITERS: present this list in a table format.]

 [NOTE TO WRITERS: do not copy descriptions from bug db. they need to be rewritten to be meaningful from the customer point of view.]

[Include:

[Do Not Include:

[Note: These are guidelines. Teams can make the final decisions.]

[The text in the first column of the table must start with a bullet in order for the import into the Defects Fixed Finder tool to work correctly. Like so:]

Defect Number

Defect Fixed

• 18441906

An entered an input value in Smart View is displayed in millions.

• 20996211

Changes to the thousands separator on the accounts tab are not maintained when the view is refreshed or the entity is checked in and checked back out.

• 21194682

Running an ACM on an account that has dimensions assigned generates an error and does not complete successfully.

• 21194713

The consolidation structure names are not sorted alphabetically.

• 21329309

Adding an @Dim to a formula causes an error.

• 21621960

Data linked from other entities does is not  updated when the scenario is changed.

 

 

Defects Fixed in Patch 11.1.2.3.506 (20807807)

 

Defect Number

Defect Fixed

• 20128212

After checking out an entity that was saved as an xls(x) file the reports do not display the correct values.

• 20463059

Data input freezes when the language is changed in Smart View.

• 20511622

When using the Audit Trail on an account that has special characters in the name an error can be generated.

• 20652301

The accounts tab can display values incorrectly when the locale is not the same across the entire platform.

• 20652375

After applying the 11.1.2.3.505 patch the standard reports can fail to be displayed.

• 20652420

A defined print area is not saved when the entity is checked in.

• 20652479

The Audit trail does not analyse accounts with dimensions.

• 20652543

After applying the 11.1.2.3.505 patch entities are not listed alphabetically.

• 20701908

Reports can open with an error related to merged cells and then the Display Options and Report Format menu items cannot be accessed.

• 20763648

The deletion of a row on a report fails.

• 20819302

Copying a column and then assigning an alias to it removes all other cell attributes.

• 20821518

Dimensions do not expand properly on reports.

• 20891318

An ACM created in the Oracle Hyperion Strategic Finance client will not open in Smart View.

• 20891329

Attempting to check out an ACM that is currently locked by another user will cause an Unknown Exception error.

• 20983693

Some of the Page Setup options are not being saved with the entity.

 

Defects Fixed in Patch 11.1.2.3.505 (20417772)

Defect Number

Defect Fixed

• 18205158

After changing to a new account group on the Accounts tab and refreshing the form the dataview does not switch to the account group's default dataview.

• 18260894

When accounts are added to an account group in Smart View, if there is an account currently selected the newly added accounts are not placed relative to the selected account. 

• 19439523

Access control on scenarios does not restrict the user's ability to access scenarios in Smart View.

• 19621414

In Smart View in the Account Forecast dialog the option to annualize the input is not available for related accounts of balance sheet accounts.

• 19706596

On freestyle reports names assigned in the Excel Name Manager are not saved with the entity.

• 19726612

Account rows cannot be inserted on a standard report.

• 19831610

Audit trail will not drill back to inputs on accounts that use the sum of prior periods.

• 20054224

When a new scenario is created based on a scenario that has debt schedules the new scenario is created without copying the debt schedules the old scenario contained.

• 20122396

When on a free style report the copy and paste icons on the ribbon bar do not work.

• 20137454

In some cases when a trailing period is added to the time structure it will be added in the wrong year.

• 20205565

Some converted entities will not open in Smart View.

• 20245494

On the free style reports when changing a single cell attribute of a range of selected cells all the other cell attributes are removed.

• 20321587

In the Oracle Hyperion Strategic Finance client when clicking on the ok button in the User Defined Accounts dialog the program closes.

• 20424885

When subaccounts of ratio accounts are created the ability to have input in history and forecast periods is disabled.

• 20454473

Formulas in freestyle reports do not display correctly when Oracle Hyperion Strategic Finance is upgraded from previous versions.

• 20463014

When switching between locales in the Oracle Hyperion Strategic Finance Administration application the reports and scenarios tabs under access control will display two entries for  <default>.  It will be displayed in language of both the current and prior locale.

• 20463054

Adding deal periods failed when the time period name did not match the internal name for the time period.

• 20463059

Data input can stop working when there are differences in the decimal place formatting between Smart View and the operating system of the machine.

• 20480088

In the currency translator dialog the accounts list will be empty if there are too many dimensions in the accounts.

Defects Fixed in Patch 11.1.2.3.504 (19689889)

Defect Number

Defect Fixed

• 17872192

Implement the Print Account Information feature for Strategic Finance in Smart View.

• 19613535

Data copy/pasted into text cells on reports is not saved to the entity when it is checked in.

• 19622164

After unprotecting a standard report, editing the report and hitting return the report becomes protected again.

• 19768800

When a new scenario is created that is a copy of an account scenario the debt schedules attached to the scenario being copied from do not get copied.

 

Defects Fixed in Patch 11.1.2.3.503 (19564734)

Defect Number

Defect Fixed

• 19452859

Copy/Paste of cell text does not work on reports.

• 19459742

Goal Seek does not show forecast periods in a year when the last history period is a sub period in the year.  When the last history period is a sub period of the last year in the entity the Goal Seek does not open.

• 19484543

The Time>Settings dialog does not allow selection of time periods that have a modified time period label.

• 19508833

The Audit Trail dialog does not display numbers using the localized numeric separators.

 

Defects Fixed in Patch 11.1.2.3.502 (18831805)

Defect Number

Defect Fixed

• 18252270

On the accounts view, some forecast periods are showing a value of 0.00 when the correct value is "None".

• 18787755

When the machine local is in Japanese the following steps can case an error to occur.   Change the time detail of an entity using the Oracle Hyperion Strategic Finance client.  Save the changed entity.  Open the saved entity in Smart View and attempt to use the Sensitivity Analysis dialog.

• 18790795

The access control setting for renaming accounts does not work in Smart View if the group the setting is applied to is a permission group.

• 18793317

Opening a new freestyle report or attempting to copy a current freestyle report causes Smart View to stop working.

• 18842446

Selecting a time period in the Time > Time Period > Actuals dialog will fail if the time period's name has been changed.

• 18969061

In Smart View the Links dialog does not open properly if a linked account has dimensions.

• 18977984

After applying the Oracle Hyperion Strategic Finance 11.1.2.3.501 patch consolidations will fail because the consolidation cannot find one of the data files needed for the consolidation.

• 19015027

When selecting Reports > Properties for a report that has special characters in the name can cause an XML load error which does not allow the properties to be displayed.

• 19073271

On input rows of the Account View tab in Smart View some of the values displayed can be incorrect.

• 19128529

On a free style report data from an aliased entity will show an N/A until the audit trail is used on the cell.

• 19219309

After hiding a report in Smart View attempting to check in the entity will generate an error message.  The entity will check in but when reopened the report will not be hidden.

• 19222837

Batch imports from ASO cubes fail.

• 19236315

When the regional settings are localized to a locale that uses a comma as the decimal seperator the numbers on the Account View do not display correctly. 

 

NOTE: This fix requires Oracle Hyperion Smart View (11.1.2.5.215).  As of the initial release of Hyperion Strategic Finance 11.1.2.3.502 the required version of Smart View has not been released.

• 19365659

With Excel 2013, when an invalid numeric value is input on the accounts tab no warning dialog is displayed.

• 19431298

Using a # override in the account input dialog can cause the associated number to be saved with an incorrect value.

 

Defects Fixed in Patch 11.1.2.3.501 (18400594)

Defect Number

Defect Fixed

• 17819725

Unable to enter data on accounts in Smart View.

• 17819795

Errors when checking in larger reports in Smart View.

• 18096619

Microsoft Active Directory user accounts are failing to connect to Smart View.

• 18146740

When a deal period is added to the entity it does not appear on the standard reports.

• 18168703

The Hyperion Strategic Finance web app can close unexpectedly when a Microsoft Active Directory user logs in.

• 18170644

The report list does not appear in the users' access records in the Hyperion Strategic Finance Administrator.

• 18178791

Tivoli Directory user accounts are failing to connect to Smart View.

• 18182623

Copy local file to server in Smart View does not work for large files.

• 18193064

The Hyperion Strategic Finance Smart View provider unexpectedly closes when using a Microsoft Active Directory user account to connect.

• 18193989

Adding a scenario with a blank name throws an error in Smart View.

• 18197455

The formula box is greyed out and cannot be edited for user defined accounts when the account is using "Calculate by Formula in All Periods".

• 18230515

The forecast method "input As…" is incorrect for the selected forecast method.

• 18238335

Historical inputs are greyed out and do not allow # overrides when the account has the "use in history" and "allow overrides" options have been selected.

• 18252814

When a freestyle report is referencing an aliased entity and the time reference is changed in the aliased entity the audit trail does not reflect the updated time period.

• 18260660

When a deal period is added to a month the value of the month does not calculate correctly.

• 18260673

When changing the input type of the @input function in freeform formulas the input type is not updating correctly.

• 18262285

Freestyle reports cannot be deleted from the target entities using Entity Change Management.

• 18267442

Renumbering subaccounts that include subtotals can cause subaccounts to be deleted.

• 18282650

When running Smart View and the Hyperion Strategic Finance client concurrently closing out of one can cause the other application to disconnect from the Hyperion Strategic Finance database.

• 18303196

Deleting reports from target entities using Entity Change Management does not delete the reports.

• 18306354

Attempting to open an archived entity using the alias manager fails, throwing an "XML Load Error".

• 18307581

When a user defined account has its Aggregate Period Value changed to None, if the user defined accounts dialog is closed and the model is calculated upon returning to the user defined accounts dialog the Aggregate Period value is no longer set to "none".

• 18354249

Adjusting the time structure on an entity using Entity Change Management causes the account data to shift to a different time period.

• 18370582

The Strategic Finance client disconnects from the Hyperion Strategic Finance server when a different instance of an application connected to the Hyperion Strategic Finance Server is closed.

• 18381588

Attempting to check out an entity with the selected dataview having an "&" in the dataview name prevents an entity from Being checked out in Smart View.

• 18382206

Scenario level access control settings are not being honored in Smart View.

• 18382849

When setting up the export of batches during a consolidation the drop down for the batch name is empty.

• 18389998

Attempting to close the report list dialog box will throw an error when the current dataview has an "&" in the dataview name.

• 18392001

Using Entity Change Management to copy a report to a target entity can fail to copy the report even though the ECM reports that it completed successfully.

• 18433483

When multiple users are using the same Hyperion Strategic Finance server users can have their session disconnected from the server while the user is still active.

• 18440631

When a user is in Smart View, the Hyperion Strategic Finance client and the Hyperion Strategic Finance admin. App the user can become disconnected from the server in an application while the app is still active.

• 18453792

Checking in a large entity or switching to a large report has performance issues.

• 18459831

Formatting changes to reports are not being save when an entity is checked in and then checked back out.

• 18467963

Some large entities fail to open in Smart View.

• 18497636

Hyperion Strategic Finance for Smart View fails to submit or save data in Russian.

• 18597289

Currency translation is causing changes in the value of the common stock account.

• 18614599

Formulas manually constructed on the freestyle reports no longer work after upgrading.

• 18621948

Clicking on a cell in a protected freestyle report opens the Unprotect sheet dialog.

• 18645452

Inserting a sheet will cause an error to be thrown by the server.

 

Defects Fixed in Patch 11.1.2.3.500 (17898859)

Defect Number

Defect Fixed

• 17871359

Strategic Finance can throw an error when opening the worksheet tab for some entities.

• 17903959

Adding a scenario causes Smart View to refresh all open reports.

• 17945963

Some entities from versions of Hyperion Strategic Finance prior to 11.1.1.00 had problems with the handling of the Actual scenario upon conversion to version 11.1.1.00 and beyond. 

• 17950515

Using the audit trail on a cell in a freestyle report fails if the cell has a reference to a time period from an aliased entity that does not exist in the current entity.

• 17982150

The import / export interface from Hyperion Strategic Finance to Hyperion Financial Management failed when the number of custom dimensions was not four.

• 18045013

An error occurs when clicking on Depreciation Scheduler dialog when there are no current depreciation schedules.

• 18083449

On standard reports inserted account rows do not appear in the correct location on the report.

• 18124672

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

• 18131111

After refreshing a report there is flashing as the active sheet changes.

• 18132161

If an accounts value is changed from the Input dialog, arrived at from the audit trail, if the calculation is called after the value is changed an error occurs.

 

Defects Fixed in Patch 11.1.2.3.100 (16942313)

• 14588197

Unable to change scenarios on reports.

• 16384421

Exporting a single entity to HFM is taking over 30 minutes.

• 16460181

Issues with using references to archive points of entities in alias manager for free style reports.

• 16523558

ECM is not pushing correct metadata changes.

• 16667491

Mapping to Essbase errors after a large number of account.

• 16740421

Using the Scenario Manager via SV to rename a scenario causes loss of forecasting methods.

• 16755785

Cannot change multiple account names using submit data.

• 16755803

'Apply to' functionality of the forecast methods dialog is not being applied to selected accounts.

• 16756794

Dimensional hierarchy is being rearranged when adding detail to an existing structure.

• 16761591

In the account groups dialog find accounts does not work on groups with a name starting with a space.

• 16797542

Freestyle report functionality not working in Excel 2010.

• 16802416

Refreshing reports returns: PASTESPECIAL METHOD OF RANGE CLASS FAILED

• 16835337

The funds flow out of balance warning is appearing in goal seek in Smart View even though the preference to suppress the warning is selected.

• 16857839

Error when opening a local file in Smart View when it is already open

• 16948716

Cancelling out of closing a report closes all sheets except the report.

• 16948798

Opening an entity with three reports displays an error.

• 16949016

Unable to check in an entity after adding reports in Smart View.

• 16975124

'SELECT METHOD OF RANGE CLASS FAILED' error when checking out entity which has updated links.

• 16984254

Account forecast description disappears when switching between reports and the account view.

• 16985208

When entering data into an account with a dimension an error occurs.

• 16985951

HSF client throws an error when trying to save a file as a .alt file.

• 16986762

Select method of range class failed while copying selected range error thrown when copying a range.

• 17025354

Checking out an entity which has frozen panes on reports causes method of range class failed.

• 17038121

Error being thrown when closing checked out entity.

• 17038572

User cannot scroll through time periods after changing time detail in the time dialog.

• 17069727

After a Save or Save As of an entity, following it with a Check-in fails.

• 17073324

Select method of Range class failed while copying selected range error when opening an entity saved with multiple reports open

• 17076354

Check in dialog appears when attempting to delete a sheet after adding a sheet.

• 17082401

Unhandled exception error occurs when cell in input dialog is cleared and then enter key is hit

• 17082426

Receive a warning message about form contains unsaved data after opening reports and then refreshing all reports in Smart View.

• 17164710

Assign cell attributes does not update reports when assigning attributes.

• 17165183

Changing alias is clearing the account map.

• 17318910

Cannot check in an HSF entity when the crystal ball extension is enabled.

• 17318961

Excel hangs when checking in entity with crystal ball enabled

• 17334722

Running an ECM can throw an unhandled exception.

• 17336891

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

• 17349950

Excel hangs when attempting to open a built in HSF worksheet.

• 17383960

Currency translation issues during consolidation

• 17383981

ACM does not push inputs of accounts forecast as Constant in all periods correctly

• 17409535

 When the alias is broken, build button in cell attributes throws exception.

• 17424056

Audit trail does not work from a free style report.

• 17424148

Currency translation can result in N/A

• 17424178

Data is not appearing on freestyle reports

• 17424237

Clicking on label dropdown in Alias manager can throw an exception.

• 17432822

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

• 17467158

Smart View cannot submit data and calculate for Japanese language.

• 17468849

Large files get out of memory errors when opening in Smart View.

• 17517603

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

• 17543548

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

• 17548726

When an ECM has an entity group as the target the ECM fails

• 17548843

Unable to set a time range in a dataview

• 17614360

Unchecking Expand accounts can cause an 'Invalid cell type' error

• 17615870

Account input dialog allows editing of actuals when it should not.

• 17616265

On reports the currency and growth rate columns display n/a when they should not.

• 17616362

Combined scenario losing members on account tab.

• 17616529

Changing a setting in the currency translator and checking in the entity does not change the consolidation status of the entity

• 17622661

The historical average on the status bar is not functional

• 17623250

When an alias is broken the assign cell attributes dialog throws an exception.

• 17627347

The build time formula displays period labels and user labels incorrectly

• 17627901

In the goal seek dialog, on the time series tab, after undoing a goal seek the prior values are not being restored correctly.

• 17635924

Pasting a worksheet link is not working

• 17635947

The user defined accounts dialog throws an error on dimensional accounts.

• 17635956

Copy/Paste worksheet links is enabled/disabled inappropriately on the accounts tab and the worksheet tab.

• 17636089

When selecting 'work offline' from the right click menu of a database that menu selection does not work.

• 17636378

Cell comments entered on the account view do not appear on reports.

• 17636398

Submit causes the entity to calculate

• 17640564

Cells that should be read only are allowing inputs

• 17641128

Hidden rows are not saved after checking in the entity and reopening it.

• 17648149

Consolidation structures allow columns to be sorted.

• 17655551

Receive an empty response from the provider when defining a new dataview.

• 17663571

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

• 17720671

Smart View allows adding debt schedules to the actual scenario.

• 17730210

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

• 17740204

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

• 17740422

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

• 17751301

Changing report properties on a custom report locks cells.

• 17753020

Assigned cell attributes disappear after inserting rows.

• 17753045

ECM fails when pushing report changes.

• 17777516

Adding specific accounts to reports can throw an exception.

 

 

Known Issues in This Patch

 [Include the following:

[Note: These are guidelines. Teams can make the final decisions.]

Defect Number

Issue

• 20562802

Running a currency translation with a currency exchange rate set to zero can cause Oracle Hyperion Strategic Finance to show an error message.

• 20808292

Smart View fails to connect in a distributed environment.

Workaround:

1. On the HSF Web App host, specify the network address of the HSF server

(because it defaults to localhost)  in [HKLM\SOFTWARE\Hyperion

Solutions\HSFWebServices\network address].

 

2. Copy HSFGatewayJNI.dll from HSF Server host ...hsf\bin and ...hsf\bin-64

to same locations on HSF Web App host.  

 

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.

When running the client installer on Windows 7 and Windows 8 machines it is necessary to either run the installer using the "Run as administrator" option or set the User Account Control setting to "Never Notify" prior to running the installer.  Note: when changing the User Account Control setting is it necessary to reboot the machine for the changed setting to take effect.

When logging onto Hyperion Strategic Finance from Crystal Ball by using the More Tools/Strategic Finance option the Strategic Finance log on page fails to receive focus.

[NOTE TO WRITERS: If the patch is cumulative, check with your product team about whether to include any known issues from the earlier patches.]

Known Issues in Release 11.1.2.3.500

 

• 17960373

Installing the Hyperion Strategic Finance client fails when run without using the 'Run as Administrator' option.

• 17976619

HSFClient-x64.exe cannot be downloaded from workspace

• 18014359

HSFWebServices validation fails if the IIS 'Enable 32-Bit Application' property of IIS @ DefaultAppPool for .NET webservices is not set to true

• 18019643

Problems in testing Crystal Ball with Hyperion Strategic Finance functionality

• 18021385

The Strategic Finance ribbon does not display well in the Japanese Office 2013

• 18025364

When logging into Hyperion Strategic Finance from Crystal Ball sometimes the HSF log on panel does not receive focus.

• 18049197

In Windows 7 or 8 when using Office 2013, when opening entities with reports flickering will sometimes be seen.

• 18112615

Hyperion Strategic Finance will not start after rolling back the patch due to a serialization change in the users.adm file.

• 18167434

Hyperion Financial Management integration is not available on a 64-bit OS

 

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.

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.

Hyperion Financial Management integration is not available on a 64-bit OS, 64bit client tier running Smart View, Hyperion Strategic Finance, and Hyperion Financial Management clients work around:

   1. Install HFM ADM driver and configure DCOM.

   The ADM driver allows for a connection to the EPM registry, and got us past

   the “class not registered” error when clicking on the connect button.

 

   2. Copy windows registry contents from

   [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HFM] to

   [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\HFM], and from

   [HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial    

   Management\JavaInterop] to [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Hyperion

   Solutions\Hyperion Financial Management\JavaInterop].

 

   3. Install 32bit Java 6 and change

   [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Hyperion Solutions\Hyperion

   Financial Management\JavaInterop\JvmPath] to point to the 32bit jvm.dll.

When running the client installer on Windows 7 and Windows 8 machines it is necessary to either run the installer using the "Run as administrator" option or set the User Account Control setting to "Never Notify" prior to running the installer.  Note: when changing the User Account Control setting is it necessary to reboot the machine for the changed setting to take effect.

The Wbocx.ocx can be registered manually by running the following from a command prompt that has been opened with the "Run as administrator" option.

On 32-bit machines: %WINDIR%\system32\regsvr32 %WINDIR%\system32\wbocx.ocx

On 64-bit machines: %WINDIR%\SysWOW64\regsvr32 %WINDIR%\SysWOW64\wbocx.ocx

For PS3 500 the 64-bit client installer will be delivered with the HSF Opatch.  The EPM Static Content folder will be patched with both the 32-bit and 64-bit MSI and the user will be able to pick it up from that location.

For Oracle Hyperion Strategic Finance in the Smart View private connections it is necessary to put "HSFServer" in the server field instead of the actual HSF server's name.

For Oracle Hyperion Strategic Finance to import from or export to an HFM application it is necessary for the HFM application to have four custom dimensions.

When using Extended Analytics the connection string cannot contain any quotes.

 

Known Issues in Release 11.1.2.3.100

For Oracle Hyperion Strategic Finance in the Smart View private connections it is necessary to put "HSFServer" in the server field instead of the actual HSF server's name.

For Oracle Hyperion Strategic Finance to import from or export to an HFM application it is necessary for the HFM application to have four custom dimensions.

[NOTE TO WRITERS: If the patch is cumulative, check with your product team about whether to include any known issues from the earlier patches.]

Applying This Patch

This section includes important information about applying this patch for Oracle Hyperion Strategic Finance.

 [NOTE TO WRITERS:  Make sure that instructions for applying the PATCH indicate specifically which components are being patched and which machines in a distributed installation should be patched. for example, “on the machine hosting the shared services web application, …”]

[NOTE TO WRITERS:  For web applications, make sure you provide instructions for all supported application servers.]

Important Note

Follow these steps when applying this patch:

1.    Uninstall Strategic Finance Client (if present).

2.    Install Strategic Finance Client 11.1.2.3.507 by running HSFClient.exe or HSFClient-x64.exe depending on if the 32-bit or 64-bit version of Office is being used.

3.    Apply OPatch for Strategic Finance 11.1.2.3.507.

Default Locations

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

<MIDDLEWARE_HOME> is C:\Oracle\Middleware

 

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.

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

64-bit OS: hsf_11.1.2.3.507.2595_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.3.507.2595_win32 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_35

64-bit OS:

opatch.bat apply <EPM_ORACLE_HOME>\OPatch\hsf_11.1.2.3.507.2595_amd64 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_35

Post-Patch Notes

Start all Strategic Finance services.

Rolling Back This Patch

To roll back a 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 21213553 –oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>\jdk160_35

Strategic Finance Client

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

1.    -        Uninstall Oracle Hyperion Strategic Finance Client.

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

[NOTE TO WRITERS: very important! the jdk version in the apply command is different for 11.1.2.0, 11.1.2.1, 11.1.2.2, and 11.1.2.3/11.1.2.4. change the jdk160_xx directory as follows:

11.1.2.3/11.1.2.4: JDK160_35

11.1.2.2: jdk160_29

11.1.2.1: jdk160_21

11.1.2.0: jdk160_11

The example here is for 11.1.2.2.

Windows:

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

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