FlexDeploy - Oracle EPM Plugin Guide

FlexDeploy Oracle EPM plugin provides the ability to export files using the migration/snapshot capability of EPM and import these files into another Oracle EPM environment.

Supported Versions

  • 23.06.60 +

  • Java 8 must be used on the endpoint

Key Features

  • Supports automated build and deploy of migration snapshots for Oracle EPM.

  • Source your migration files from an Oracle EPM environment.

Target Properties

FlexDeploy supports creation of Oracle EPM cloud instances and the following properties will be configured for each Instance. These properties are available to all operations.

For non-basic authentication methods you can reference OIC OAuth Support for additional guidance as process will be almost identical except cloud account will be type OracleEPM

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

Oracle EPM Auth Type

FDEPMACCT_AUTHTYPE

Yes

Authentication method for connecting to Oracle EPM. Additional properties may be required depending on basic authentication or OAuth.

Oracle EPM URL

FDEPMACCT_INSTANCE_URL

Yes

URL of the Oracle EPM environment. Typically, the URL of your Oracle Cloud service e.g.Ā https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com

Oracle EPM Username

FDEPMACCT_USERNAME

Yes

The username for your Oracle EPM environment.Ā  User will require Service AdministratorĀ and optionally:

  • Power User assigned to the Migration Administrator Profitability and Cost Management application role

  • Identity Domain Administrator role is required to import user and predefined roles

Other roles may be needed to perform specific export and import activities.

Oracle EPM Password

FDEPMACCT_PASSWORD

Yes

The password for your Oracle environment. Required for basic authentication and OAuthResourceOwner.

Oracle EPM Identity Base URI

FDEPMACCT_IDENTITY_BASE_URI

No

Ā 

Oracle EPM Client Id

FDEPMACCT_CLIENT_ID

No

EPMĀ Client Id when using. Required for OAuth.

Oracle EPM Client Secret

FDEPMACCT_CLIENT_SECRET

No

EPMĀ Client Secret Key. Required for OAuth.

Oracle EPM Scope

FDEPMACCT_SCOPE

No

EPMĀ Client Scope. Required for OAuth.

Oracle EPM Keystore Path

FDEPMACCT_KEYSTORE_PATH

No

Java keystore path containing the private key to use for JWT User Assertion.

Oracle EPM Keystore Passphrase

FDEPMACCT_KEYSTORE_PASS

No

Java keystore passphrase for the FSM Keystore Path property.

Oracle EPM Certificate Alias

FDEPMACCT_CERT_ALIAS

No

Private certificate alias.

Oracle EPMĀ Certificate Passphrase

FDEPMACCT_CERT_PASS

No

Passphrase for the EPM Certificate Alias property. Leave blank if no passphrase was used.

Oracle EPM Certificate Algorithm

FDEPMACCT_CERT_ALGORITHM

No

Algorithm used for the certificate. Defaults to RS256.

EPM Snapshots

The EPM plugin leverages snapshots to discover files.Ā  Oracle EPM documentation indicates how to use Migration and create an exportable snapshot.Ā  Please see the following document for more information.

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/epmss/using.html

Plugin Operations

The following macros are not currently supported in the footer:
  • style