Tasks in the Release 11.2.15 Target Environment

Note:

For Oracle database and SQL Server: Configure Financial Close Management and Tax Provision to a new schema in the target environment (for example, fcm_new).
For Oracle database: Create a new database schema in the target database server (for example, fcm_target).
1. For Oracle database: Export schema from source environment and import it into the target environment. Using the schema Remap command, import the schema from source to target (note that this is the newly created schema (fcm_target) that you created in step 2 above).
2. For SQL Server: Restore the FCM schema that you exported from the source environment (11.2.12+). See Restoring the Financial Close Management Schema for more information.
1. For Oracle database: Use the remapped schema to run the Financial Close Management and Tax Provision configuration tasks.
2. For SQL Server: Use the restored schema to run the Financial Close Management and Tax Provision configuration tasks.

Have your database administrator perform these tasks in the Release 11.2.15 target environment:

For Oracle Database: Import the source database you exported from Release 11.2.12+ (fcm_source) to be used with the Release 11.2.15 environment. Use Oracle Data Pump with the REMAP command to import to a different schema (for example, fcm_target).
```
impdp <user>/<password>@<SID> DIRECTORY=data_pump_dir dumpfile=<DatabaseDumpFile.dmp> logfile=import.log REMAP_SCHEMA=<user>:<user1>
```
For example:
```
impdp <fcm_source>/<password>@<SID> DIRECTORY=data_pump_dir dumpfile=<fcm_source.dmp> logfile=import.log REMAP_SCHEMA=<fcm_source>:<fcm_target>
```
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 REMAP_SCHEMA=<user>:<user1>
```
For Oracle Database and SQL Server:
1. Stop Oracle Enterprise Performance Management System services.
2. Run EPM System Configurator again and select the Configure Database and Deploy to Application Server tasks for Oracle Hyperion Financial Close Management. If you are using Oracle Hyperion Tax Governance, also select the Configure Database and Deploy to Application Server tasks for Tax Management.
  During database configuration, enter details for the Release 11.2.15 database that you just imported (for example, fcm_target) to be used with Release 11.2.15, and when prompted, select Reuse the existing database. (You are prompted for each product you are configuring.)
  
  Note:
  For SQL Server: During database configuration, enter details for the Release 11.2.15 database that you just restored (for example, fcm_target) to be used with Release 11.2.15, and when prompted, select Reuse the existing database. (You are prompted for each product you are configuring.)
  
  On the Deploy to Application Server page, select FinancialClose, AccountReconciliation, and SDM. If you are using Tax Governance, select TaxOperation and TSS. If you are using Tax Provision, select TaxProvisioning.
3. Import WebLogic users from the Release 11.2.12+ environment to the Release 11.2.15 environment.
4. Restart all EPM System servers and run Oracle Hyperion Enterprise Performance Management System Diagnostics.