Uses Advanced Encryption Standard (
AES/CBC/PKCS5Padding(128)) to encrypt Oracle Enterprise Performance Management Cloud password (or the OAuth2.0 refresh token and client ID for accessing OCI (Gen 2) environments), and optionally, the internet proxy server password used for signing in to Oracle Fusion Cloud Enterprise Performance Management environments, and stores it in a password file.
Encrypting the secrets allows Service Administrators to share their encrypted password file with developers who write EPM Automate scripts so that they can execute the scripts. This precludes the need to share the Service Administrator password or create a generic, shared EPM Cloud account specifically for running scripts.
Encrypting password is a one-time process.
Note:See Handling Special Characters for information on encrypting passwords that contain special characters.
Applies toPlanning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Account Reconciliation, Profitability and Cost Management, Enterprise Profitability and Cost Management, Oracle Enterprise Data Management Cloud, Narrative Reporting, Oracle Sales Planning Cloud, and Oracle Strategic Workforce Planning Cloud.
Required RolesService Administrator, Power User, User, Viewer
epmautomate encrypt PASSWORD|REFRESH_TOKEN KEY PASSWORD_FILE [ClientID=CLIENT_ID] [ProxyServerPassword=PROXY_PASSWORD]where:
PASSWORDis the password or the OAuth refresh token that you want to encrypt. You cannot use corporate credentials with EPM Automate.
KEYis the private key that is to be used to encrypt the password.
PASSWORD_FILEis the name and location of the file that stores the encrypted password or refresh token. The password file must use the
ClientID, optionally, is the client identifier that is created during OAuth 2.0 setup. This value must be specified while encrypting an OAuth 2.0 refresh token. Do not specify this value while encrypting a password.
ProxyServerPasswordis the password to authenticate the user with the HTTP proxy server. Required only if authentication at proxy server is enabled for your network.
Encrypt only EPM Cloud password:
epmautomate encrypt P@ssword1 myKey C:\mySecuredir\password.epw
Encrypt EPM Cloud and internet proxy server passwords:
epmautomate encrypt E@xample1 myKey C:\mySecuredir\password.epw ProxyServerPassword=Proxy_Pwd1