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

Supported Paths to This Patch

You can apply this patch to Release 11.1.2.4.00 and later.

Prerequisites

Microsoft Patch

Microsoft has identified a security issue that could compromise Windows-based systems. Before installing this patch, verify that the Visual C++ 2005 Redistributable Package installed on the computer is current. You may search and download the latest Visual C++ 2005 Redistributable Package from:

http://www.microsoft.com/en-us/download/default.aspx

IMPORTANT: Visual C++ 2005 is included and automatically installed in EPM versions 11.1.2.2 and newer. Installing this patch is only required if you are installing EPM versions earlier than 11.1.2.2.

Required User 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 release applies to all supported platforms.

Supported Languages

This patch supports all languages of the base release.

Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.220 New Features

See the Oracle Hyperion Financial Data Quality Management, Enterprise Edition Administrator's Guide. For new features relating to installation, architecture, and deployment changes in this release, see: "New Features" in the Oracle Enterprise Performance Management System Installation and Configuration Readme.

Import and Export of Mapping Scripts in Text Mapping Files

FDMEE now supports the export and import of mapping scripts in a text file. This support includes both Jython and SQL scripts. The scripts are enclosed in a <!SCRIPT> tag.

Registering Duplicate Target Application Names

FDMEE now enables you to register target applications with the same name. This may be the case where a customer has multiple service environments and the application name is the same in each environment, or the application names are identical in development and production environments. This feature enables you to add a prefix to the application name when registering the application so that it can be registered successfully in FDMEE and be identified correctly in the list of target applications.

Target applications with prefixes are not backward compatible, and cannot be migrated to an 11.1.2.4.210 or earlier release. Only a target application without a prefix name can be migrated to an earlier release.

For detailed information, see "Reusing Target Application Names Multiple Times" in the Oracle® Hyperion Financial Data Quality Management, Enterprise Edition Administrator's Guide.

Support Member Names with a Comma When Exporting to Planning

When export to Planning, you can now export a dimension member name that contains a comma (,). A new Member name may contain comma setting has been added to Target options, which enables the feature.

Support for REST APIs

REST API can be used now in FDMEE to execute various jobs that run data load rules, batches, scripts, reports, and the import and export of mapping rules.

For detailed information, see "Appendix B: FDMEE Rest APIs" in the Oracle® Hyperion Financial Data Quality Management, Enterprise Edition Administrator's Guide.

Defects Fixed in this Patch

Defect Number	Defect Fixed
• 27057886	An incorrect parameter is set in the schedules for System Maintenance Tasks.
• 27048279	Essbase sessions are not closing during the data export.
• 26934122	Support archiving for the TDATAMAPSEG table and retain the view map.
• 26791692	The data load fails because import mapping does not skip Byte Order Mark (BOM) characters.
• 26674309	Check Rule Group and Check Entity Group are enabled erroneously for a hybrid application.
• 26591196	The 11.1.2.4 210 patch does not include the required Account Reconciliation Manager (ARM) scenario: ARM_PREMAPPED_BALANCES.
• 26559544	Attribute, description, and currency rows disappear from import format mappings.
• 26496624	FDMEE is inaccessible to users during a large data load.
• 26403186	The data load process shows a failed status when the Hyperion Financial Management data load option is set to “No.” (The load status should not appear in process details because it was not enabled.)
• 26395917	The batch scheduler does not work when the process is scheduled at a later time.
• 26322934	Script registration fails due to the length of the query definition name.
• 26234429	When running a data load rule to load to Hyperion Financial Management and the consolidation process fails, the Status of the Consolidation Process step still runs even though the data load rule status is updated to a failed status.
• 26202259	Account dimension member names that use a comma cause the Check Report to fail.
• 26165643	User can click the execute option on the Custom Script page when the Execute button is disabled.
• 26146537	Unable to refresh the metadata option in FDMEE when the target is Essbase.
• 26117447	Duplicate query definitions occur in FDMEE.
• 26117429	When loading multi-period data, all entities are not included in the calc parameter
• 26081218	Error occurs when exporting data from Planning to PeopleSoft KK (Commitment Control).
• 25980368	Can't launch popup after selecting the Setup tab, then Target Application (Planning target application), and then Calculation script.
• 25977081	When setting up Batch Security, the second role permission must be assigned before the Setup tab is displayed.
• 25933495	When customer executes LOADDATA.BAT scripts, they fail with the following error message: "Failed. Some Error Occurred."
• 25905459	Generic fields show up as validation errors.
• 25876263	Source period mappings do not show for EPMA applications when Classic Planning applications are removed as target applications.
• 25812446	Data load rule for Universal Data Adapter fails when an IN parameter has a long text value.
• 25765020	Journals are not loaded to a single period.
• 25740932	Data load rule shows a running status when multiple rules in the same location execute at same time.
• 25723830	Trial Balance report in FDMEE does not sum correctly.
• 25695576	Support multi-period write-back when some periods have no data.
• 25689514	Unable to run Peoplesoft data load rules in parallel mode that have an account entity group.
• 25689152	Batch load does not use the POV period from the User settings.
• 25658753	FDMEE allows duplicate explicit data load mappings in release 11.1.2.4.210.
• 25616928	Minimize calls to the Hyperion Financial Management metadata API during the intersection validation.
• 25601193	FDMEE schedules are removed after applying the FDMEE 11.1.2.4.210 patch.
• 25565745	Cannot open a PDF file to view validation errors when the browser language is Portuguese.
• 25564740	An exported Excel (.XLS) file cannot be imported “as is” if it has not been saved in an .XLS format previously.
• 25546039	When reports using the POVPERIOD parameters are executed in offline mode, a PDF with 0 kilobytes is returned.
• 25543768	A shell script to launch the DRM adapter was not shipped in release 11.1.2.4.210.
• 25534805	In release 11.1.2.4.210, the LOADDATA.BAT command skips the Hyperion Financial Management consolidation process.
• 25533574	Source Period Mapping page for EPM does not show EPMA applications.
• 25526421	In release 11.1.2 4.210, the data load mappings for account dimensions show "equal" instead of "explicit.”
• 25525032	After applying release 11.1.2.4.210, the import format delimited tab is not working.
• 25524787	Unable to import data when the period name has leading/trailing spaces in the period mapping.
• 25507499	When exporting to Hyperion Financial Management, the following error occurs: “EPMHFM-832: The session has become invalid, a logoff is needed.”
• 25476665	DRM tabs are missing from the Application Details page after applying the 11.1.2.4.210 patch.
• 25394088	An ADF_FACES error occurs when an Oracle Real Application Clusters (RAC) URL is used in an ODI Repository URL.
• 25314660	When a customer using a universal adapter for integration with PeopleSoft added a View dimension in the import format and then saved it, the View dimension did not display.
• 25245051	The mapping validation button fails all source values for explicit mappings.
• 25204666	Check report throws a lookup error when a European amount format is used.
• 25203088	When loading metadata, FDMEE is not importing Employees with multiple jobs.
• 24299055	When adding a logic group to a location, the following error message occurs: “ora-01790 error: Expression must have the same data type as corresponding expression.”
• 22909588	ODI customizations in the FDMEE repository (db) are lost after the schema password is changed.
• 22843655	Hyperion Financial Management cell text is not protected by the data protection option in FDMEE.
• 21944586	In Location, increase the length of Integration Option (1-4) fields to 256 characters.
• 21286145	The customer is unable to create a new source accounting group, or add entries to an existing group in FDMEE.

Defects Fixed in 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.210 Patch Number 23041471

Defect Number

Defect Fixed

• 25191503

An error occurs in the validation step when mappings are missing.

• 25086656

Support the Skip Row feature for delimited files.

• 25073281

Uploading the mapping file in merge mode takes 7 hours.

· 25070982

Locking all (POV) locations, periods and categories is required; documentation shows step as optional.

• 25058979

The journal description is not loaded correctly in Hyperion Financial Management.

• 24831061

Intersection Check Report jobs fail.

• 24790410

Write-back to PeopleSoft Commitment Control fails with an ORA-00904: "GLI"."LOADID": INVALID IDENTIFIER.

• 24719210

Multi-period loads between EPM sources fail when the archive mode is set to "Move."

• 24704033

Target application properties are not created for Public Sector Planning.

• 24696709

Add a method to drill back to EBS using data synchronization.

• 24660228

The file extension is missing from an Open Source Document in the Data Load Workbench.

· 24615582

The application takes a long time to export maps to Excel resulting in a time-out error.

• 24581883

EBS write-back produces multiple lines for a multi-period load.

• 24581817

Open batch replace load tag in export mode for Essbase does not work.

• 24507793

The open batch process does not complete before another process starts in serial mode.

• 24481231

Unable to export data from FDMEE in an Oracle Managed Cloud Service to Planning in an Oracle Public Cloud.

• 24409145

Unable to save source filters in the data load rule for data synchronization.

• 24398268

After Batch script executes before batch has completed in parallel mode.

• 24346113

The name and type of the source system do not show in Chinese.

• 24334010

Cannot restrict number of batch loads.

• 23749615

(Mapping) Member Selector screen does refresh properly when dimensions are changed.

• 23741243

Multi-dimension mapping import removes [ ] (open/closed square brackets) from the dimension value.

• 23712261

A data synchronization import format error occurs when you add a second source column to the target dimension.

· 23704903

Batch jobs are deleted when "Maintain Process Tables" job is launched.

· 23608036

JDE adapter hangs the FDMEE database.

· 23601294

Data protection does not work correctly when entities have the same string in the entity name.

· 23570299

Users without access privileges are able to fix mappings.

• 23570139

Map Monitor reports do not save all changes that are made in a single session.

• 23569307

Increase length of dimension members to 80 characters when loading data.

• 23534813

Target member with trailing spaces fails during validation but loads correctly.

• 23521228

Duplicate data import and export steps occur in an open batch when Archive Mode is enabled.

• 23332225

Export mode always defaults to “Replace” regardless of the target option setting.

· 23299982

Unable to unlock periods when selecting the POV.

• 23244868

FDMEE uses a batch file and not the shell script for the Data Relationship Management (DRM)/FDMEE integration on LINUX.

· 23236688

Check report fails when a “-1” parameter is used to return the prior year.

• 23153744

When exporting mappings into Excel, the export works correctly, but no output is written to the Excel file.

• 23100637

Support Replace by Security with open batch.

• 23094407

When the Global POV is set to “yes,” users receive an ADF error when executing the data load rule.

• 23031907

In LifeCycle Management, when the import format has concatenated fields, then the sorted order of the concatenated fields is incorrect in the target environment.

• 23003251

Users can duplicate explicit data load mappings.

• 22996594

Data file generated by FDMEE custom application does not have correct order.

• 22975695

Import from EBS fails with a SQLSYNTAXERROREXCEPTION: INVALID COLUMN NAME 'SEGMENT1' error.

· 22747940

Check report shows wrong results.

· 22685686

When concatenating JDE accounts and the sub-account is null, no data is displayed for the source account.

• 22588695

Import script does not execute the last field when the field is blank.

• 22219833

Variance reports show zero regardless of the selected time period.

• 21968085

Unable to change column delimiter in import and export mapping tables.

• 21928674

Add support for Data View metadata tag (DV) in the Excel Trial Balance.

• 21910911

The Hyperion Financial Management (HFM) export file shows data for multiple periods in alphabetic order instead of period order.

• 21746465

Unable to load the date field into FDMEE.

• 21683139

Need to export string data to Planning application using FDMEE.

• 21622537

An intermittent failure to show goldfish occurs after the Import, Validate, or Export steps have been executed successfully in the Data Load Workbench.

• 21611707

In some cases "Recalculate" does not run when the data load rule is executed as scheduled.

• 20969139

When viewing validation errors in the Data Load Workbench, the full set of errors are not displayed in some cases.

• 20892186

Validation errors tab shows one dimension at a time.

· 20583965

Alternate hierarchies for local dimensions are not marked as shared.

· 20512084

In multi-dimensional mapping, square brackets are removed for special account values such as [ICP NONE] and [None].

• 19304596

Add ability to move the source system information in FDMEE using LifeCycle Management.

• 18550239

The text box for the target value in member mappings does not expand when the column width is increased.

Defects Fixed in Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.200 Patch Number 22452414

Defect Number	Defect Fixed
• 22749503	Drill through landing page does not display account description.
• 22720821	Multi-dimensional mapping does not extract complete list after installing release 11.1.2.4.000.
• 22700812	"Change sign" for accounts is not working when loading line item details.
• 22567897	In Import Format, user is not able to concatenate after installing release 11.1.2.4.000.
• 22526855	THE AIF_ARTIFACT_AUDIT table is not logging any changes for explicit multi-dimensions.
• 22511820	Errors occur running Map Monitor Reports after installing FDMEE Patch 11.1.2.4.100.
• 22509669	Script returns the error: "CLSAPPSERVERDM.FINITIALIZEMAINAPI: DATA ACCESS ERROR."
• 22480844	Process Monitor Report shows the time without an am/pm stamp.
• 22194961	Data validation for ICP locations fails to validate correctly.
• 22125161	Process Monitor Report does not generate correct report with manual entry.
• 22090089	When importing text mapping files contain errors, the subsequent errors are displayed in the Member Mappings Import Validation Errors Window, but the source values are not displayed.
• 21801585	TDATACHECK only stores data for the last data load rule executed.
• 20474346	First time imports into parent locations are empty.
• 17424353	When exporting a dimension to Excel, maps which have #SCRIPT do not have the associated scripts exported.

Defects Fixed in Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.100 Patch Number 20648390

Defect Number	Defect Fixed
• 22307336	File format for importmapping.sh is in DOS format.
• 22192354	Check rule always passes regardless of the value of the check figure.
• 22079421	Support exporting from SAP BW cube with forward slash in the cube name.
• 22076944	Replace by security options fails in scan, but works in data load.
• 21963347	FDMEE export to HFM is successful. However, consolidation fails but is shown as complete.
• 21891376	Unable to sort by location when selecting a file from the Inbox during the import.
• 21877468	Duplicate entries occur on the drill through landing page.
• 21826459	Support case insensitive member validation and intersection check for Hyperion Financial Management (HFM) application.
• 21801845	Status for load step is not properly updated in Process Details.
• 21798196	FDMEE process log only displays first 100 errors of a failed data load.
• 21784235	Issue occurs while running multiple check process at the same time.
• 21779748	Selected file is not enabled in data rule for run integration role.
• 21778221	HFM intersection validation throws an error.
• 21770151	Improve performance of HFM intersection check process.
• 21663983	“Accumulate” within a file does not work when data is duplicated from logic groups.
• 21658969	Invalid member error occurs in log when parenthesis is used in the member name.
• 21647380	For multi-period load HFM intersection consolidation is not executing in the order of periods (start and end period).
• 21636933	Mapping requires parent.child format in member mappings to be validated.
• 21614223	FDMEE MS SQL Server deadlocks.
• 21528201	Sequence of Check Entity Group does not control the order of HFM intersection consolidation.
• 21392422	Script mapping takes very long time in FDMEE.
• 21387372	Improve HFM load process when "Data Protection" is turned on.
• 21310289	Import from EBS fails with ORA-00904: "BAL"."SEGMENT1": invalid identifier" error.
• 21282569	Add option to turn Account Descriptions on and off.
• 21262877	Overriding the load method in target options for the data load rule does not work.
• 21262793	Data load mappings fail when two * wildcards are used.
• 21259021	Custom application export data file does not export standard dimensions, for example, Scenario, Value, or View.
• 20994639	Hierarchies appear in random order on the Member Selector screen.
• 20991324	Unable to load from Planning to Planning in SSL enabled environment.
• 20830323	Cannot Create Drill Through URL.
• 20800625	HFM Intersection load process does not apply correct debit/credit indicator.
• 20747662	Import from EPM source (Essbase) fails.
• 20678759	Workflow intersection validation fails for Hyperion Financial Management application.
• 20663845	User was able to delete data after POV was locked.
• 20662408	HFM Intersection load fails when using Replace by Security mode.
• 20662130	Data load rule details are cleared when selecting an import format for multi-periods.
• 20631385	A Calc script failure does not trigger FDMEE to show an export failure in the fish.
• 20624184	A non-administrator user should be allowed to see only their processes.
• 20546647	Cannot delete or rename log files in Outbox/logs when the batch is running.
• 20494478	Multiple to one mapping and multiple segment source mappings to dimensions are not saved for Oracle Interface Adapter integrations.
• 20407853	Leaf members of a spring tree do not import correctly.
• 18507555	FDM function parameters appear in the check rule.

Known Issues in This Patch

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

26760093 – A Trial Balance Report with amounts larger than 2,147,483,647 (2.1B), which is the JAVA size limit for an integer data type, does not run properly.

26722746 -- Map Monitor Audit Report should show the report header even when there are no records to display.

26629495 -- Unable to import data load mapping for all dimensions when a special character is used.

26614616 -- Newly created import formats and locations are not visible in the FDMEE user interface when the source system name and target application name are the same.

26608102 -- File import to FDMEE fails immediately when the data load file name is empty on the Source Option tab.

26433369 -- FDMEE is referencing the dimension alias instead of the dimension name, and the validation fails.

26259489 -- Source period mappings for JD Edwards do not display when using LifeCycle Management.

26202259 -- Account dimension member names that use a comma (,) cause the Check Report to fail. The workaround is to skip members that have a comma, set all other dimensions to the correct value, and only then add back the comma containing member, enclosed in double quotes.

25980163 -- Wrap button is not wrapping column text.

25883872 -- Unable to load data after patching to 11.1.2.4.210 and mapping the View dimension to a source column that can be null. The workaround is to map the View dimension to a source column that does not have null values.

25751756 -- Change Sign option should not available for user-defined, ICP and Entity values.

25701874 -- Unable to use the asterisk (*) wildcard for a target member search. The workaround when using a Hyperion Financial Management application is to type Sal without using the asterisk. The system finds Salary or Sales.

Applying This Patch

This section includes important information about applying this patch for Oracle Hyperion Financial Data Quality Management Enterprise Edition.

Prerequisite Patches

The following patches must be installed before installing this release:

· Hyperion Financial Management 11.1.2.4.200 or higher (it is recommended that you are running Hyperion Financial Management 11.1.2.4.206)

· Hyperion Planning 11.1.2.4.003 or higher (required to use the All Data Type data loads feature in FDMEE)

Data Relationship Management with FDMEE

To integrate Data Relationship Management with FDMEE (optional):

Apply Hyperion Data Relationship Management Release 11.1.2.4.340 Patch Number 23041471. Refer to the readme for patch 23012151 for install instructions.

The FDMEE application template is installed as part of the Data Relationship Management installation. You use the template to configure the Data Relationship Management metadata to enable integration with Oracle FDMEE.

FDMEE Release Instructions

To apply the FDMEE release:

1. Stop the FDMEE service.

2. Change the directory to: %EPM_ORACLE_HOME%\OPatch

(Replace the values for EPM_ORACLE_HOME for your environment). For example, specify:

c:\oracle\middleware\epmsystem11R1\opatch

Run the opatch as follows (replace the values for EPM_ORACLE_HOME, MW_HOME and EPM_ORACLE_INSTANCE for your environment):

opatch apply 25312033 -oh %EPM_ORACLE_HOME% -jre %MW_HOME%\jdk160_35

For example, for Windows enter:

opatch.bat apply C:\Oracle\Middleware\EPMSystem11R1\OPatch\25312033-oh C:\Oracle\Middleware\EPMSystem11R1 -jre C:\Oracle\Middleware\jdk160_35

For LINUX/UNIX, enter:

./opatch apply /u01/Oracle/Middleware/EPMSystem11R1/OPatch/25312033 -oh /u01/Oracle/Middleware/EPMSystem11R1 -jdk /u01/Oracle/Middleware/jdk160_35 -invPtrLoc /u01/Oracle/Middleware/EPMSystem11R1/oraInst.loc

All database schema changes and ODI Scenario changes are updated during the FDMEE Server startup. Review the FDMEE server log (for example, aif-odi-install.log) after a successful startup. Errors due to objects (tables, indexes) already existing can be ignored. This happens when you apply the patch more than once.

3. Start the FDMEE service.

4. Restart the HTTP server.

Additional Installation Instructions

1. Copy the following script files.

For Windows, copy from:

EPM_ORACLE_HOME/FinancialDataQuality/bin/executescript.bat.template

to:

EPM_INSTANCE_HOME/FinancialDataQuality/executescript.bat

For LINUX, copy from:

EPM_ORACLE_HOME/FinancialDataQuality/bin/executescript.sh.template

to:

EPM_INSTANCE_HOME/FinancialDataQuality/executescript.sh

2. For a LINUX environment, make sure the shell scripts in the following two directories have execute privileges:

cd EPM_ORACLE_HOME/FinancialDataQuality/bin/
chmod u+x *.sh

cd EPM_INSTANCE_HOME/FinancialDataQuality/
chmod u+x *.sh

3. If your deployment is a distributed environment where Hyperion Financial Management and Planning are on different servers than FDMEE, copy the following jar files:

Copy files from the Hyperion Financial Management server on EPM_ORACLE_HOME\common\hfm\11.1.2.0\lib to the same directory on the FDMEE server.

Copy files from the Planning server on the EPM_ORACLE_HOME\common\planning\11.1.2.0\lib to same directory on the FDMEE server.

Rolling Back This Patch

To roll back a patch:

1. Stop the FDMEE service.

2. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

3. 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_29

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

4. Import the ODI Scenario from:

C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00\workrep

5. 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_29

UNIX/Linux:

./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 –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