1. Installation and Configuration Guide
  2. Upgrading EPM System (from 11.2.12+ to 11.2.15) using Out of Place Procedure
  3. Importing Artifacts and Data for Release 11.2.15
  4. Importing Financial Management Applications
  5. Tasks in the Release 11.2.15 Target Environment

Tasks in the Release 11.2.15 Target Environment

  1. For Oracle Database: Import the source database you exported from Release 11.2.12+ (hfm_source) to be used with the Release 11.2.15 environment. Use Oracle Data Pump to import to a different schema (for example, hfm_target). 

    impdp <user>/<password>@<SID> DIRECTORY=data_pump_dir dumpfile=<DatabaseDumpFile.dmp> logfile=import.log SCHEMAS=<schema name to be imported>

    For example:

    impdp <hfm_source>/<password>@<SID> DIRECTORY=data_pump_dir dumpfile=<hfm_source.dmp> logfile=import.log SCHEMAS=<schema name to be imported>

    For Oracle Database 21c - Ensure that you open the pluggable database and set <CONTAINER=PDB NAME> as indicated below, prior to executing the import command: 

    ALTER PLUGGABLE DATABASE ALL OPEN;
ALTER SESSION SET CONTAINER=<PDB NAME>
    impdp <system>/<password>@<PDB SID> DIRECTORY=data_pump_dir dumpfile=<DatabaseDumpFile.dmp> logfile=import.log SCHEMAS=<schema name to be imported>
  2. Oracle Database and SQL Server: Stop Oracle Enterprise Performance Management System services.

  3. Oracle Database and SQL Server: Restart all EPM System servers and run Oracle Hyperion Enterprise Performance Management System Diagnostics.