Hi,

we are on HFM 11.1.2.4.204 and if we want to apply the 11.1.2.4.206 ,after applying the patch,do we need to execute the  sql command in step 6 of read me  to upgrade the schema against the Financial Management database and run the Oracle_Create_ImportApp_package.pck and Oracle_Create_InsightDetails.pck.

The read me shows to upgrade from .203 to .204, but here are we are moving from .204 to .206.

READ ME for

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

1. On the HFM Application Server and HFM Web Server, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.
2. To apply the patch, enter the following command on one line:

Windows:

• opatch.bat

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.

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

1. 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:
2. 1.    Select Navigate, then Administer, and then Consolidation Administration.
3. From Admin Tasks, click Configure DSN.
4. Select any data source that has Oracle database as database type, and then click on Edit.
5. Enter the database connection information, including the database server network address as Host.
6. Click Test Connection. If successful, click on Save.
7. All users should now clear cached files from their browsers.

Thanks,

vj