Oracle Hyperion Financial Management
Readme
Insights Dashboard for Key Metrics/KPIs
Printing Entity Detail Reports
Application Elements Download Log Option
Working with
Journals in Smart View
Viewing Data Grids, Forms, and Process Control as Charts
Why do I get the following patch conflict error message
when running OPatch?
Why do I get the OUI-67078 warning message when applying
OPatch?
How can I find out which releases and patches of EPM System
products are installed in a deployment?
This Readme file describes the defects fixed in this patch and the requirements and instructions for applying this patch.
Caution: 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.
This is a patch set update (PSU). This patch is a full installation.
You can apply this patch to:
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.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
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.
The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights:
Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: “Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.”
Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products. OPatches are not intended to be applied using a root user.
This patch can be applied to all platforms supported in Release 11.1.2.4.000.
This patch can be applied to all languages supported in Release 11.1.2.4.000.
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
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:
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.
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.
This release includes support for Solaris on Exalytics only.
A Printable Page option has been added to Entity Detail reports, and is also available when you view Source and Destination transactions.
After you create an application, you can now modify it to increase the number of years used in the application if needed.
When you load or extract Application Elements, you now have the option to download the load or extract log file.
Financial Management application tabs now include the same right-mouse click options as EPM Workspace, including Close, Close All, and Close Others.
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.
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.
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.
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.
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.
|
Defect Number |
Issue |
|
27001117 |
Fix
an error preventing execution of Oracle_Create_InsightDetails.pck |
|
26967637 |
"Ok"
and "Cancel" buttons disappear from member selector UI in data form
or data grid |
|
26941613 |
Fix
a rare occurrence where XfmDatasource process stop
responding |
|
26911241 |
Error
occurred while running journal report through taskflow |
|
26882854 |
Import
application fails when using filters and a large amount of scenarios |
|
26864635 |
Data
from newly added metadata member not showing on second server |
|
26820854 |
Loading
erroneous rule corrupts the application |
|
26801869 |
On
some environment, users can still log into the application even when “Disable
Connections” is set in “System Manage” screen |
|
26774106 |
Error
opening some web forms in 11.1.2.4 that could be opened in 11.1.2.1 |
|
26637206 |
Non-admin users unable to
select parent.{[Base]} and parent.{[Children]} in IC reports
|
|
26608332 |
Fix
non-standard SSL port configuration |
|
26566491 |
Add
a log entry for the actual periods consolidation run on |
|
26485104 |
Cannot
load drill regions to HFM from FDMEE |
|
26445336 |
Errors
in CC_LOCK_ENTITIES table when running consolidation |
|
26435453 |
Deployment from EPMA aborts when using OTD
|
|
26363340 |
Performance improvement for web form when suppressing invalid,
nodata, or zero data on columns
|
|
26333468 |
Period
offset function erroneously suppresses rows with data
|
|
26275046 |
Create
table #cc_locks_datacubes while table already
exists |
|
26265166 |
Add
task audit entry for Intercompany matching report |
|
26187486 |
Member
description with ' changes to '' in data extract to database |
|
26182813 |
Non-admin
user could not generate intersection validation report |
|
26130985 |
Increase
number of cluster displayed in Preference > Preferred Cluster menu |
|
26028743 |
Multi-period
POVs not working for consolidation using java API |
|
25997497 |
When
loading metadata, add log entry to show metadata difference even when the
difference is ignored due to account type |
|
25910949 |
Display
all security class when viewing journal entry in non-editable mode |
|
25817492 |
Fix
a potential XfmDatasource crash when using getInvalidMembersInList API |
|
25769184 |
Fix
filter in journal reports UI when multiple entities are chosen |
|
25725829 |
Reports
running in HFM TaskFlow scheduler not overriding
POV as per taskflow definition |
|
25639977 |
Performance
improvement for retrieving data audit |
|
25492176 |
SmartView not
auto-reconnecting after HFM user session timeout |
|
25220432 |
Linux:
action buttons occasionally disappear in web form UI |
|
25135219 |
Creating
journal through SmartView throws error: 80070057 |
|
25104970 |
IC
Transaction match by account fails when entries tied to deleted metadata
member exist |
|
24412735 |
In
SmartView, HsGetValue
function is not giving informative metadata error |
|
24333493 |
Unable
to retrieve journal details for specific journals |
|
23742820 |
Web
form is not retaining the members using @cur in linked form |
|
23220065 |
Users
with Application Administrator and Financial Management Admin roles can now
access to rule profiler summary |
|
23196096 |
Add
validation to thousand and decimal separator characters in application
preference setting |
|
23144613 |
Error occurs while running security report within
assign access control when user or group names contain special characters
|
|
23127131 |
Correct
the filter items in Documents UI related to Intercompany Transaction module |
|
23024252 |
Clear
data may incorrectly clear valid data in inactive entities |
|
22974917 |
"Social"
menu item incorrectly appears in the right click menu |
|
22868823 |
Wrong
number displayed in web form when using small input length |
|
22561594 |
EPMHFM-66076
error when importing HFM LCM artifacts |
|
22472862 |
Calculate
and Force Calculate are reversed in SmartView |
|
22471956 |
Excel
filename are not correct when downloading journal report |
|
21973820 |
Unable
to open a web grid or web form with an apostrophe in its name from a task
list |
|
21696559 |
Unable
to create or open a financial report when HFM contains more than 7 memberlists in Scenario dimension |
|
21285305 |
Cannot
change the length of input field for cell text in data forms |
|
21247130 |
Filter similar to {regional.[base]}
does not work in Manage Journal UI
|
|
19427694 |
Non-admin
users cannot open Line Item Detail when lineitemdetailsingleperiod
is false |
|
19327899 |
Dataform does not display
member in designer if member name contains "<" |
|
19264201 |
Add
Manage Taskflows and Run Taskflows
roles to access Consolidation Administration menu |
|
Issue |
|
|
27076232 |
HFM needs to be
restarted when one of RAC node goes offline during consolidation. |
|
27037334 |
Data load with “process
control management data” option checked will cause all OK data to become OKSC
status even when the load failed. |
|
27033226 |
Unable to use
mouse wheel to scroll web form horizontally. |
|
27009772 |
LCM does not
import accented characters in HFM folder description. |
|
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. |
|
26811357 |
In SmartView, Hsgettext function
shows NULL instead of actual data when used in high frequency. |
|
26724631 |
In web form,
unable to copy document link that does not fit the background using IE11. |
|
26666300 |
EPMHFM-7443 error
when accessing process control and web form. |
|
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. |
|
26572009 |
HFM database
links/linked servers drop down menu is empty. |
|
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 |
|
25204479 |
Unable
to delete years in a target application via hfmcopyapplication_x64. |
|
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. |
|
23664657 |
Import
application does not include sequences. |
|
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]}. |
|
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. |
|
Defect Number |
Issue |
|
24794995 |
IC
reporting stops working when number of temporary folders exceed 32000 |
|
20236377 |
Autojournals script for JSK does not tie out. |
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 |
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, and HFMWeb.
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 and HFM Web Server, 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.
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.
If the patch that you apply conflicts with a previously applied patch, you may receive the following error message when running OPatch:
Patch(es) <PreviousPatch#> conflict with the patch currently being installed (<NewPatch#>).
If you continue, patch(es) <PreviousPatch#> will be rolled back and the new patch (<NewPatch#>) will be installed.
If a merge of the new patch (<NewPatch#>) and the conflicting patch(es) (<PreviousPatch#>) is required, contact Oracle Support Services and request a Merged patch.
This error is returned when one patch attempts to update a previously patched file. When this conflict happens, you can either (1) roll back the previous patch and apply the new patch (this action might be appropriate if the previous patch was not critical) or (2) request a “merged patch” consisting of the new patch and the patch that it conflicts with. To request a merged patch, contact your Oracle Support representative.
This warning means that the patch being applied is a superset of a patch already on the deployment and the existing patch will be rolled back. The following snippet shows the context of this warning.
The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 12345678 is a superset of the patch(es) [77777777] in OH C:\Hyperion
-----------------------------------------------------------------------------------
OPatch Session completed with warnings.
In EPM System Release 11.x, you can use the lsinventory command to OPatch to find the release and patches that are installed in an Oracle Home. For example, enter the following command on one line:
Windows:
opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35
UNIX/Linux:
./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_35 –invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
When patching an .EAR file for an application, you may need to delete the cached files in the following folders in order to see the changes provided with the patch:
<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME>/tmp/
<MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME>/cache
Copyright © 2017, Oracle and / or its affiliates. All rights reserved. http://www.oracle.com