EPM Cloud Planning Clone Environment

A while back (nearly 2 years ago), I wrote about the Clone Environment feature. Oracle has continued to improve this feature and it seemed like a good time to update that original post. Note: I am detailing the process for EPM Planning. Some features may or may not be available for other EPM products.

Some things about it are still the same. It is a full migration of the application using the most recent Artifact Snapshot. You can update this snapshot by running the EPM Automate command runDailyMaintenance. The target environment is still recreated as part of the process. You can use other methods like copySnapshotFromInstance if you need flexibility in choosing a source snapshot.

The newer features include more choices in what gets cloned. In the early versions of Clone Environment, the only option available was Users and Predefined Roles.

Now there are multiple options available in what to migrate.

1. Select Users and Predefined Roles to clone users and their predefined role assignments.
2. Select Data Management to clone data management records. This may take a long time to process depending on how much data is in the staging tables in the source application. Also, per Oracle documentation, “Clone Data Management records only if both the source and target environments are on the same monthly update, or the target environment is one update newer than the source environment. For example, you can clone 22.01 Data Management records to another 22.01 environment or to a 22.02 environment only.”
3. Select Application Audit to clone audit records.
4. Select Job Console to clone the job records.
5. Select Stored Snapshots and Files to clone the files in the inbox and outbox, and the stored snapshots. This could take a long time depending on how many files and snapshots are in the source application.
6. Select Daily Maintenance Start Time to clone the current maintenance start time of the source application.

That’s a lot more options than when this was first introduced. When I am cloning from Prod to Test, I normally check Data Management and Daily Maintenance Start Time and leave the other options unchecked. It really depends on the purpose of the clone.

When the clone completes, some settings and configurations may need to be updated. Make sure the application is open to all users or restricted to administrators as needed.

Update any connections to other applications.

There are some other post-Clone items to consider, refer to full Oracle documentation for more information.

As always, happy EPM’ng!