Previously, we had used CopyApp utility to copy HFM Application from one environment to another environment or from one version to another.

However while migrating HFM application from V11.1.2.4 to V11.2.7 , we used Import application wizard as suggested by Oracle.

There are 3 important steps for HFM application upgrade, migration to V11.2.7.

1) Database Link between HFM V11.1.2.4 and HFM V11.2.7

HFM schema in new version V11.2.7 must have following privileges.

CREATE DATABASE LINK

SYS.DBMS_LOB

SYS.DBMS_SQL

Create Database Link

Use following query to create database link between HFM V11.2.7 schema and HFM V11.1.2.4 schema.

CREATE DATABASE LINK DEVTONEWDEV CONNECT TO EPMXDEV1 IDENTIFIED BY PASSWORD USING HFMDEV11;

To view the database links present, execute following query.

select * from all_db_links

To view applications present in source HFM database, list out datasources using following query:

Select * from HSX_DATASOURCES@DEVTONEWDEV;

We received following error at this point:

Error:

ORA-12541: TNS:no listener
12541. 00000 - "TNS:no listener"
*Cause:    The connection request could not be completed because the listener
           is not running.
*Action:   Ensure that the supplied destination address matches one of
           the addresses used by the listener - compare the TNSNAMES.ORA entry with
           the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
           go by way of an Interchange). Start the listener on the remote machine.
Error at Line: 3 Column: 31

Our first step was to add TNS entry for source database (HFM V11.1.2.4 database) in destination database, however due to security at client, found that port 1521 was closed between source and destination databases and hence we had to get port opened through firewall request.

After creating the DB link we can run below mentioned package in the target oracle DB.

Oracle_Create_ImportApp_package.pck file

After successful execution, the new package, HFMUTIL_PKG, will show up under the HFM schema’s available packages, in SQL Developer. If you see the green dot showing on the package, right click and click Compile. If the green dot is not there, there is no need to do this step:

2) Import Application

After successful creation of the database link, login to Workspace and go to Navigate -> Administer -> Consolidation Administration, then click on Import Application. The Database link should be available and a dropdown list of the source environment’s HFM applications should be available.