Ever have issues where EPM Automate failed due to an expired password? This blog will walk through how to create a password that never expires for a system user which then can be used in EPM Automate. Therefore, eliminating password expiration issues during EPM Automate.

Begin by accessing the EPBCS or PBCS environment.

Access the “Navigator” and under “Tools”, click on “Migration”.

Download the “Artifact Snapshot” by clicking on “Snapshots” tab and select “Artifact Snapshot”. Click on “Actions” and then click on “Download”. A zip file will be downloaded to the computer.

Unzip the downloaded “Artifact Snapshot” zip file. Click on HSS-Shared ServicesresourceExternal Directory folder.

Open the Users.csv file and add a system user at the end of the file, in the same format as the existing users (First Name, Last Name, Email, User Login). The system user does not have to be real users with real email addresses.

Go to the Roles folder.

Open the planning Service Administrator.csv file and add user to the end of the file, in the same format as the existing users (First Name, Last Name, Email, User Login). This should be the same as added in the Users.csv file.

Zip the snapshot and use EPM Automate commands to import the snapshot using the credentials of an Identity Domain Administrator.

Example of the EPM Automate Import script:

  • call epmautomate login
  • call epmautomate uploadfile Artifact Snapshot.zip
  • call epmautomate importsnapshot “Artifact Snapshot” userPassword=Password1 resetPassword=false
  • call epmautomate logout

When calling the epmautomate import snapshot, indicate the userPassword for the system admin and set “false” for the resetPassword parameter. After automation is completed for the import snapshot, the system admin password will never expire, and the password can also be encrypted via EPM automate.

Blog post by Jenny Wang of Key Performance Ideas.

Recent Posts

Successful Reconciliation Compliance with Oracle Cloud

Would you like to learn how Key Performance Ideas can help you utilize Oracle’s Account Reconciliation Compliance Module that saves time, rework, and improves accuracy?  How about seeing the same time savings and accuracy every month?  Would you like to have real-time...

read more