Uses Advanced Encryption Standard (AES/CBC/PKCS5Padding(128)) to encrypt Oracle Enterprise Performance Management Cloud password, and optionally, the internet proxy server password, and stores it in a password file.

Encrypting the password 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.


See Handling Special Characters for information on encrypting passwords that contain special characters.

Applies to

Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting, Account Reconciliation, Profitability and Cost Management, Oracle Enterprise Data Management Cloud, Narrative Reporting, Oracle Sales Planning Cloud, and Oracle Strategic Workforce Planning Cloud.


epmautomate encrypt PASSWORD KEY PASSWORD_FILE [ProxyServerPassword=PROXY_PASSWORD] where:
  • PASSWORD is the password of the user. You cannot use corporate credentials with EPM Automate.

  • KEY is the private key that is to be used to encrypt the password.

  • PASSWORD_FILE is the name and location of the file that stores the encrypted password. The password file must use the .epw extension.

  • ProxyServerPassword=PROXY_PASSWORD is 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