­­­Oracle Hyperion Financial Management

Release 11.1.2.4.207 Patch Set Update (PSU): 27523845

Readme

About this Patch. 2

Patch Type. 2

Supported Paths to this Patch. 2

Prerequisites. 2

Other Required Patches. 2

Required User Rights. 3

Supported Platforms. 3

Supported Languages. 4

New Features in this Release. 4

Application Creation Wizard. 4

Insights Dashboard for Key Metrics/KPIs. 4

Support for Solaris. 4

Printing Entity Detail Reports. 4

Application Year Update. 4

Application Elements Download Log Option. 4

Application Tab Options. 4

Working with Journals in Smart View.. 4

Rules Profiling. 5

Duplicating Applications. 5

Importing Applications. 5

Viewing Data Grids, Forms, and Process Control as Charts. 5

Defects Fixed in this patch. 5

Known Issues in this Patch. 8

Windows. 8

Solaris. 10

Linux. 11

Applying this Patch. 11

Rolling Back this Patch. 12

Troubleshooting FAQs. 12

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

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

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

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

About this Patch

This Readme file describes the defects fixed in this patch and the requirements and instructions for applying this patch.

Caution: FDMEE Patch Set Exception (PSE) 25616936 is strongly recommended.

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

Supported Paths to this Patch

You can apply this patch to:

Release 11.1.2.4.000

Release 11.1.2.4.100

Release 11.1.2.4.101

Release 11.1.2.4.102

Release 11.1.2.4.103

Release 11.1.2.4.200

Release 11.1.2.4.201

Release 11.1.2.4.202

Release 11.1.2.4.203

Release 11.1.2.4.204

Release 11.1.2.4.205

Release 11.1.2.4.206

Prerequisites

Other Required Patches

Additionally, this Financial Management patch requires:

Oracle Application Development Framework patch 25113405

FMW patch 13866584

FMW patch 16810628

 

To install patch 25113405:

1.    Go to https://support.oracle.com.

1.    Select the Patches & Updates tab.

2.    In Patch Search, enter 25113405 in the Type in comma separated values text field.

3.    Make sure you are searching for a Patch Name or Number and select Search.

4.    On the next page, there should only be one item in the table. Select Download.

5.    After downloading p25113405_111171_Generic.zip, extract it to <MIDDLEWARE_HOME>/oracle_common/Opatch.

6.    There should now be a 25113405 directory in the <MIDDLEWARE_HOME>/oracle_common/Opatch directory.

7.    Follow the instructions in the patch readme for the RT only environment.

 

To install patch 13866584:

1.    Go to https://support.oracle.com.

2.    Select the Patches & Updates tab.

3.    In Patch Search, enter 13866584 in the Type in comma separated values text field.

4.    Make sure you are searching for a Patch Name or Number and select Search.

5.    On the next page, there should only be one item in the table. Select Download.

6.    After downloading p13866584_111170_Generic.zip, extract it to <MIDDLEWARE_HOME>/oracle_common/Opatch.

7.    There should now be a 13866584 directory in the <MIDDLEWARE_HOME>/oracle_common/Opatch directory.

 

To install patch 16810628:

1.    Go to https://support.us.oracle.com.

2.    Select the Patches & Updates tab.

3.    In Patch Search, enter 16810628 in the Type in comma separated values text field.

4.    Make sure you are searching for a Patch Name or Number and select Search.

5.    On the next page, there should only be one item in the table. Select Download.

6.    After downloading p16810628_111170_Generic.zip, extract it to <MIDDLEWARE_HOME>/oracle_common/Opatch.

7.    There should now be a 16810628 directory in the <MIDDLEWARE_HOME>/oracle_common/Opatch directory.

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 can be applied to all platforms supported in Release 11.1.2.4.000.

Supported Languages

This patch can be applied to all languages supported in Release 11.1.2.4.000.

New Features in this Release

New Statistics Option in HFM Insights

HFM Insights now includes a Statistics section that displays detailed data statistics based on a selected Scenario and Year combination.  You can choose when to manually update the statistics.

To update statistics:

1.            Select Navigate, then Administer, and then Consolidation Administration.

2.            Select System, and then Insights.

3.            From the Statistics section, click the Data tab.

4.            Click the Member Selector, select a Scenario and Year, and click OK.

5.            Click the Execute button to run the process and return statistics on the selected Scenario and Year combination.

Note:

When you click the Execute button and update statistics, the button is disabled for a certain period of time while the process runs. The task runs in the background, and you can navigate to other parts of the application while it is running. When it is done, the button is re-enabled and the table is refreshed with the updated statistics. You can also click Refresh to see the updated values.

If there are no records in a particular table, the system does not display any statistics for that table.

Data tab

·         Data (DCE and DCN total record count per Scenario/Year combination)

·         Invalid records (invalid member ID), DCE and DCN only, Total count only (not per entity)

·         Near Zero Value Records for all periods

·         Near Zero Value Calculated Records for all periods

·         PFlow History (per Scenario/Year)

·         Input Data (if any period in the year is Input or Line Item Details)

Table Count tab

The Table Count tab displays record counts of the following Oracle Hyperion Financial Management system tables and the times they were last executed.

·         Task Audit

·         Data Audit

·         System Messages (Error Log table)

·         Rules Profile data

New Option to Limit Number of Concurrent Consolidations Per User Action

A new parameter has been added to control the maximum number of concurrent consolidations allowed per user. The parameter is named MaxNumConcurrentConsolidationsPerAction. The default value is 8.

When user selects multiple entities in the grid to run multiple Consolidations, the Consolidation processes will run each selected entity, up to the number indicated by this setting for that user. Any consolidations performed above the configured value will be queued as Scheduled Consolidations and run according to their Scheduled Start Status. If a serial execution is preferred, set this parameter to 1.

To set the parameter:

  1. Select Navigate, then Administer, and then Consolidation Administration.
  2. From Admin Tasks, expand System, and then click Settings.
  3. From the Settings table, set a value for MaxNumConcurrentConsolidationsPerAction, then click Save.

Application Creation Wizard

You now use the Application Creation wizard to create applications. In the Application Creation wizard, you can define the application calendar, application settings, module configuration, and custom dimensions. You can also copy an existing application to create a new one, or create an application from a profile file.

Insights Dashboard for Key Metrics/KPIs

HFM Insights provides a dashboard for system administrators to monitor HFM system status. It displays data collected from system components over a period of time and enables administrators to take corrective action if necessary.

Support for Solaris

This release includes support for Solaris on Exalytics only.

Printing Entity Detail Reports

A Printable Page option has been added to Entity Detail reports, and is also available when you view Source and Destination transactions.

Application Year Update

After you create an application, you can now modify it to increase the number of years used in the application if needed.

Application Elements Download Log Option

When you load or extract Application Elements, you now have the option to download the load or extract log file.

Application Tab Options

Financial Management application tabs now include the same right-mouse click options as EPM Workspace, including Close, Close All, and Close Others.

Working with Journals in Smart View

You can open and work with journals directly in Smart View. You can view journal properties, create, edit, submit, approve, post, unpost, and delete journals. You can also create an ad hoc query from within a journal.

In addition, in Smart View, you can now access the Manage Journals module through a tasklist.

To use journals in Smart View, you must have the Oracle Smart View Release 11.1.2.5.500.

Rules Profiling

You can use rules profiling to capture in-depth information about rules execution at the major subroutine level. Rules profiles include statistics about time spent calculating, translating, and consolidating each entity during a consolidation task.

Duplicating Applications

You can duplicate of the contents of an application to create a new application. You can duplicate an application in the same environment and rename it, or register the new application in a different project and cluster.

Importing Applications

You can import an application across databases or across EPM systems. Both EPM systems should use Oracle DB or SQL Server.

For details, see the Oracle Hyperion Financial Management 11.1.2.4.200 Administrator’s Guide.

Viewing Data Grids, Forms, and Process Control as Charts

This release includes the ability to view data grids, data forms, and Process Control information as charts. You can customize the chart display, and also print charts.

Defects Fixed in this patch

Defect Number

Issue

27655740

After applying HFM 11.1.2.4.206, getting "EPMHFM-66076: server is unavailable"

27586568

HFM application import data filter copies years that are not selected

27501318

HFM journal templates not displaying after applying 11.1.2.4.206

27452863

Drill through back to FDMEE option is disabled for locked cell in HFM

27444622

User by group security report in assign access control fails with error EPMHFM-65962

27414991

Smart view users are able to login to disabled applications

27388802

Fix custom path while generating intercompany matching report through HFM Taskflow

27375723

On demand rule execution not correctly displayed in task audit

27345293

Data not showing up if it was entered using parent level input rule and later moved to base level

27322820

Translate and Force translate are reversed in Smart View adhoc grid

27300676

Remove unnecessary errors "CHsvMetadata_DOMParser::StartElement() unexpected error" during EPMA deployment

27275214 

Reinstate req_EnumChildren API

27254329

Error clearing data after applying HFM 11.1.2.4.206

27190843

Error in web form when using account that starts with “CALC1”

27164144

Cell text entry from Smart View does not preserve word wrap

27037410

Add additional logging for data load with “file contains process control management data” option selected

27037334

Data load with “file contains process control management data” option unnecessarily selected cause all data status changed to OKSC

27009772

LCM does not import accented characters in HFM folder descriptions

26934103

Data not synchronized across all HFM servers due to rare timing issue

26788238

In Smart View form, user can enter data in cells that are marked as read only by the form definition

26724631

Display document link in a new popup

26666300

EPMHFM-7443 error when accessing process control UI and web form

26572009

HFM database links/linked servers drop down is empty for import application

25487401

Degradation in consolidation performance after applying Microsoft security patch

Caution: Microsoft patch KB4074594 or KB4074736 or any rollup patch that includes one of these two patches is required this fix to function correctly.

25286267

Data copy allows user to delete the data that the user does not have write access to due to review level

24929391

User who has no access control against an account member cannot see display override setting in web form that has the account in last column

24326464

Web form shows "string("")" where the custom2 and custom1 should be shown

21635491

Timestamp in data extract log does not match application server time

21526607

Smart View prompting to login twice when switching between HFM clusters

21271851

Change logging level to avoid repetitive logging in oracle-epm-fm.log

21247272

“EPMHFM-1057: The POV selected for this function is invalid” when calculating without first submitting data

Known Issues in this Patch

Oracle Database

If you are using an Oracle database, you may experience an issue where the Financial Management failover process does not run correctly if one or more Oracle Real Application Clusters (RAC) nodes goes down.  To improve stability you can configure Financial Management by manually setting the ConnectionOptions setting in the HFM parameter table.

To enable the ConnectionOptions setting, execute the following SQL commands:

INSERT INTO XFM_PARAMETERS_DEFAULTS (NAME, TYPE, HIDDEN, DESCRIPTION) VALUES ('ConnectionOptions', '2', '1', 'Extra connection options');

INSERT INTO XFM_PARAMETERS (PARAMETERNAME, CLUSTERNAME, SERVERNAME, APPLICATIONNAME, CATEGORYNAME, CREATEDBY, UPDATEDBY, VALUE) VALUES ('ConnectionOptions', 'ALL', 'ALL', 'ALL', 'ALL', 'system', 'system', ';FM=2;ASRV=(HOST=xxxHOSTxxx:PORT=yyyPORTyyy:ServiceName=zzzServiceNamezzz)');

Replace the xxxHOSTxxx, yyyPORTyyy, zzzServiceNamezzz with the actual hostname, port, and service name to the Oracle RAC DB environment respectively. If the environment is set up with a SID, replace the ServiceName=zzz with SID=zzz.

If Oracle RAC is set up with one scan address and multiple nodes (n), the ASRVsettting  (or "AlternateServers") must include the scan address multiple (n-1) times. For example, the following ConnectionOptions setting is needed for a RAC environment with one scan address and 3 failovers:

INSERT INTO XFM_PARAMETERS (PARAMETERNAME, CLUSTERNAME, SERVERNAME, APPLICATIONNAME, CATEGORYNAME, CREATEDBY, UPDATEDBY, VALUE) VALUES ('ConnectionOptions', 'ALL', 'ALL', 'ALL', 'ALL', 'system', 'system', ';FM=2;ASRV=(HOST=10.11.12.13:PORT=1521:ServiceName=OracleRAC, HOST=10.11.12.13:PORT=1521:ServiceName=OracleRAC)');

Database Connectivity

If you experience a network outage and the outage recovers within 5 seconds, Financial Management has implemented retry logic as well as additional logging which notifies users of network connectivity problems.  Retry logic may reconnect successfully or you may experience an issue where the Financial Management process does not run correctly.  Restarting the Financial Management services may be required.

Windows

Defect Number

Issue

28041386

Load security option incorrectly displayed for EPMA application

28035961

Custom links sometimes do not work

28031470

Insight UI shows incorrect HFM application status

28021381

User with read only access to cell can launch On Demand rule

27972605

UI and extracted profile show additional characters for dimension alias

27967711

AllowOverlappingConsolidationOverride setting not working in some Web Forms and Smart View

27960992

Task Audit records are not properly displayed for “Include All” option

27940401

Member selector for value dimension does not show all members until user scroll down and up

27918116

IC reports document type is missing in Load Document UI

27853669

HFM logged less database connection number than actually used on multi server environment

27845641

“ADFC-10001: cannot instantiate class” error when editing and running journal report

27839227

Cell information displays data while data grid shows invalid intersection

27837748

Unable to use “flat file with header” option when extracting data using Task Flow

27590946

HFM application import aborts when using data filter

27567030

Extracted data file cannot be loaded again if any cell text was entered in multiple lines

27566241

After schema upgrade, “EPMHFM-65536” error when opening data extract template

27076232

HFM needs to be restarted when one of RAC node goes offline during consolidation.

27033226

Unable to use mouse wheel to scroll web form horizontally.

26946722

Clear invalid record does not clear ownership data in deleted parent/child pair.

26906463

Process management security is not enforced when running IC matching report.

26894565

Port conflict causes HFM application to be inaccessible.

26635004

Harmless error message “unhandled exception occurred in CXfmJHsxServerWrapper” when shutting down HFM.

26594015

Some task audit records are not properly displayed when using “include all” option.

26444010

HFM display in correct timestamps due to time zone for process management history.

26422285

In SmartView, unable to use zoom in all level due to indents issue in hierarchy.

26204796

Getting “invalid pointer” error wen trying to retrieve data through SmartView.

26193119

Currency description are missing after data extract to database.

25949243

Member search is not working in SmartView WDEF member selection.

25926714

Sorting and grouping is incorrect when drill down on HFM dimensions in SmartView.

25889901

Data extract takes longer in 11.1.2.4 comparing to 11.1.2.2.

25880069

SmartView incorrectly allows data input if a column has Override with String or Blank, causing an error thrown when the data was rejected by HFM.

25869969

Load data tab not opening after clearing all the data load rows

25861613

Incorrect error message “ODBC connection error when using EA”.

25784748

@cur in WDEF through SmartView disappears after adding a member and refresh

25737124

In SmartView, “unknown error” when selecting a member with “-“ in the member name in POV manager.

25724727

ICP and Journal Report in Excel format uses incorrect format for column width and amount column.

25723476

Unable to delete a row in journal.

25660919

User with view data audit role cannot extract data audit

25598534

No option to specify decimal character in data extract to flatfile

25556937

Overlapping consolidation warning message not appearing in some cases.

25537482

Traditional Chinese translation for “Consolidation Administration” is not consistent.

25536667

Cannot access journal when EnableMetadataSecurityFilter is checked.

25480494

@cur override is not working correctly in HFM web data form

25446829

Missing parent entity when zoom in to bottom in Smartview

25407116

In Smartview, submission of data does not respect the scale factor.

25378272

Column sorting in Rules Profiler does not work.

25291675

No warning message at Smartview for overplapping consolidations

25176118

LCM import application process does not use data and index tablespaces.

25169567 

Unable to unlock multiple periods in data grid or form.

25168254

Invalid member error when running ICP report with system member list as partner that the user doesn’t have access to

25163511 

Sometimes scheduled task flows do not run.

25084474 

When running journal report, running tasks has empty description in activity field.

25072792

Column suppression doesn’t work in SmartView

25070569

Incorrect calculation status for value dimension members.

25062980 

Line item detail input adding up to zero is seen as no data.

25041164

In web form, Submitting data to specific POV takes longer to process.

24903472

EPMHFM-221: invalid argument error when selecting process history with filter.

24841757

In intercompany transaction screen, users are not able to set reason codes through action>set reason code.

24836868

Running delete extract from Taskflow result in error EPMHFM-66126 even though the extract was successfully deleted.

24826923

EPMA duplicate application as deployed application fails with SQL Server

24824013 

LCM application snapshots fail unless HFM’s MSSQL user is a member of sysadmin

24811074

FDMEE may attempt to load to the wrong cluster in a multi-cluster environment.

24747566

In SmartView member and other text data in adhoc analysis results in EPMHFM-3037.

24733397

Security class extract includes 'None' entries.

24716412

Overlapping consolidations cannot be started from actions button in process control UI.

24688632

In SmartView, EPMHFM-7274: invalid session id. Your session may have expired.

24672466 

Missing a valid message when loading a memberlist with errors.

24667259

SmartView performance issue when retrieving the data.

24666664

In process control validation incorrectly passes when validation account is not zero.

24659554

Large number of "Invalid session ID" error messages in ODL log and system messages.

24657984

Unable to add a document to favourites from task list.

24654126

SmartView spreadsheet refresh is slower with Oracle database.

24580610

Grand totals for Entity Transaction, Parent Transaction and Transactions Difference is missing the Intercompany Reports.

24361427

Need to add APIs to work with system messages.

24361232

Unable to scroll in data forms using Firefox.

24339379 

Configure DSN doesn’t have option to set up Windows authentication for SQL DB.

23858337

Incorrect decimal and thousand separator characters using graphs.

23629019

Intercompany reports abort when running more than one report at the same time.

23513413

In SmartView no warning is displayed when user posts a journal without saving data first.

23510132

In WDEFs the display value for all Flow and Balance accounts is incorrect when scaling is enabled.

23498740

There is no method to enumerate users in the java API.

23483829

In SmartView, suppress column is not working.

23325600

It is not possible to choose a single dimension member when creating intercompany reports.

23320620

Intercompany reports generated in excel format are missing the columns "Partner Amount" and "Difference."

23319660

Intercompany reporting with IE11 generates error when using the alert function.

23291556

Journal reports do not honor Entity filters.

23265348

Extracting data via Taskflow does not include line item details.

23250225

Consolidations started in SmartView are not listed in running tasks.

23198687

Consolidations run from Taskflow that take longer than 2 hours are resubmitted.

23171605

Tasklists with Japanese Name and/or Description cannot be loaded.

23142568

Stopping the HFM service does not kill all of the HFM java threads on OEL.

23121161 

Unrecognizable character in extracted HFM rule file

23104733

When loading documents it is not possible to change security class without selecting the 'Override Security Class' checkbox.

23099786

Suppression for parent level member may not work when running report through FR

23078316 

Smartview indentation does not work correctly

23052997

Extracting Journals with more than one value member selected generates and OCBD error.

22927729 

Calculation manager rule deployment from EPMA does not work

22915147

Calculation status for Entity Currency is displayed incorrectly in cell information.

22891539

Cannot extract data for dynamic accounts.

22874615

In SmartView performing "Zoom In --> All Levels" on ad-hoc girds causes improper indentation for dimension members in alternate hierarchies.

22858287

In Process Control it is not possible to promote if there is no data in a period.

22826971

Intercompany reports in excel format remove leading zeros in entity names.

22824935

Wrong members are displayed in valid EPMHFM-69547: invalid grid error messages

22811912

Unable to find artifacts when searching for applications in LCM.

22810701

In SmartView it is not possible to create a private connection using HypCreateConnection.

22513213

Unable to enter the data in WDEF after opening multiple forms and then closing all but one.

22263269

It is not possible to use SSL enabled SQL Server.

22248543

Performance issues in IE11 when WDEF contains linked forms.

22235950

Cannot extract data using [ICP Entities].[Base] in the ICP POV member.

22121279

When running a clear data task from Manage Data it is not possible to navigate to any other tab until Clear Data is complete.

22104972

Metadata loads without any errors when a new security class is used that does not exist in Shared Services.

22019370

Unable to export/import artifacts with apostrophe in the label using LCM.

21946844

The CustomizationSample sample app does not support 11.1.2.4.xxx.

21935943

Unable to recover from intermittent database connectivity loss

21892878

Opening a WDEF when the user has no access to the control member generates an unknown error.

21847984

Values are truncated in SmartView with Swedish regional settings.

21840913

Issue creating journals in smart view when the Excel default language is Swedish.

21838501

When extracting member list and rules files in an EPMA application the extracted file is empty.

21835771

After apparently successful export from FDMEE the data is not actually imported.

21635491

Timestamp within HFM data extract log does not match real time-of-day nor server

21458897

Unable to open .app format metadata file through manage metadata option.

21417273

When importing documents folder names that contain dot or underscore are not imported correctly.

21270619

Unable to right click artifact to 'export for edit' or 'import after edit.'

21080495

In Smart View, when you open a data form and navigate to Journal Entity Detail, the time does not display correctly.

20981257

Error when opening consolidation rule in calculation manager when using non-english local system language.

20876914

Templates with label only do not get listed if parent or entity are in the column.

20843618

You cannot extract cell text unless you are an admin.

20371621

HsxServer does not start when using integrated user authentication for SQL server.

19949400

Searching in member lists is always based on {[hierarchy]}.

Solaris

Defect Number

Issue

22287161

Consolidation hangs if rules attempt to write to a file on an NFSv4 share.

21168732

EA extract in Essbase format results in incorrect records.

21164844

Opening a large grid is much slower compared with Linux.

21136891

Copying a large amount of data including cell text takes twice as long compared with Linux.

Linux

Defect Number

Issue

24794995

IC reporting stops working when number of temporary folders exceed 32000

20236377

Autojournals script for JSK does not tie out.

 

Linux/Solaris

When installing on Linux or Solaris, the system administrator needs to ensure adequate system resources are available to the operating system user who installs and runs the software. Resources can be controlled at the system level via /etc/sysctl.conf (Linux) or /etc/system (Solaris), and per user via the ulimit utility. Consult your operating system documentation for more information on how to set hard and soft resource limits. The following table describes limits that are known to affect HFM.

 

Resource

Recommended System Wide Limit

Recommended Process Limit

File Descriptors (open files).

 

If the value set for this parameter is too low, a file open error, memory allocation failure, connection error, or process hang may occur.

6148240

 

Linux only. (On Solaris, there is no maximum open file descriptors setting. They are allocated on demand as long as there is free RAM available.) For example:

 

cat /proc/sys/fs/file-max

 

This setting can be changed in /etc/sysctl.conf via the fs.file-max parameter

65535

 

Controlled via ulimit; for example:

 

ulimit -n

 

­­­Applying this Patch

This section includes important information about applying this patch.

To apply this patch:

1.    Ensure that all services are stopped.­­

2.    Ensure that all HFM processes are not running, including HsxServer, XFMDataSource, HFMWeb, WebLogic Admin and ADM Drivers.

3.    Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name.

4.    On the HFM Application Server, HFM Web Server, WebLogic Admin Server and any environment with ADM Drivers installed, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

5.    To apply the patch, enter the following command on one line:

Windows:

opatch.bat apply <EPM_ORACLE_HOME>/OPatch/<PATCH DIRECTORY> -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/<PATCH DIRECTORY> -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

6.    If you are applying this patch to version 11.1.2.4.000, execute the following sql command to upgrade the schema against the Financial Management database. Use appropriate sql as per your database type.

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\<DB Type>_from_11.1.2.4.000_to_11.1.2.4.100_SchemaUpgrade.sql

If you are using SQL Server, ignore the following warning:

Warning! The maximum key length is 900 bytes. The index 'PK_XFM_PARAMETERS_NEW' has maximum length of 1500 bytes. For some combination of large values, the insert/update operation will fail.

 

If you are applying this patch to version 11.1.2.4.100 or an earlier version, also execute the following sql command to upgrade the schema against the Financial Management database. Use appropriate sql as per your database type.

 

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\<DB Type>_from_11.1.2.4.100_to_11.1.2.4.102_SchemaUpgrade.sql

 

If you are applying this patch to version 11.1.2.4.102 or an earlier version, also execute the following sql command to upgrade the schema against the Financial Management database. Use appropriate sql as per your database type.

 

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\<DB Type>_from_11.1.2.4.102_to_11.1.2.4.200_SchemaUpgrade.sql

 

If you are applying this patch to version 11.1.2.4.203 or an earlier version, also execute the following sql command to upgrade the schema against the Financial Management database. Use appropriate sql as per your database type.

 

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\<DB Type>_from_11.1.2.4.203_to_11.1.2.4.204_SchemaUpgrade.sql

 

 

In addition, you must run:

 

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\Oracle_Create_ImportApp_package.pck

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\Oracle_Create_InsightDetails.pck

or

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\SQL_Server_Create_ImportApp_sprocs.sql

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\SQL_Server_Create_InsightDetails_sprocs.sql

This step is required for importing applications. See “Importing Applications” in the “New Features” section.

 

7.    If you are using the extract data to database functionality with Oracle database as the target database, you will need to reconfigure DSN. To reconfigure:

1.    Select Navigate, then Administer, and then Consolidation Administration.

2.    From Admin Tasks, click Configure DSN.

3.    Select any data source that has Oracle database as database type, and then click on Edit.

4.    Enter the database connection information, including the database server network address as Host.

5.    Click Test Connection. If successful, click on Save.

8.    All users should now clear cached files from their browsers.

Rolling Back this Patch

To roll back a patch:

1.    To roll back the patch, enter the following command on one line:

Windows:

opatch.bat rollback -id <PATCH ID> -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 <PATCH ID> -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.

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