EPM AUTOMATE UTILITY – copyfilefrominstance, listfiles & deletefile

Oracle added a new EPM Automate utility with July-2018 update. A new version of the EPM Automate Utility is available with this update. This version includes the copyfilefrominstance command, which copies a file from a source environment to the target environment from which you run the command.

This version also includes changes to the following commands to make them consistent with other file operation commands:

listfiles: now lists snapshots and files available in an environment.

deletefile: now deletes snapshots and files from an environment.

Let’s explore the new version of the utility & try these commands.

copyfilefrominstance: Copies a file from a source environment to the environment (target) from which you run this command. Before running this command, start an EPM Automate Utility session and sign into the target environment.

Syntax:

epmautomate copyfilefrominstance SOURCE_FILE_NAME USERNAME PASSWORD_FILE URL IDENTITYDOMAIN TARGET_FILE_NAME

where:

• SOURCE_FILE__NAME is the name of the file (including extension) that you want to copy from the source environment.

• USERNAME is the user name of a Service Administrator of the source environment.

• PASSWORD_FILE is the name and location of the file containing the encrypted password of the Service Administrator of the source environment.

• URL is the URL of the source environment.

• IDENTITYDOMAIN is the identity domain of the source environment.

• TARGET_FILE_NAME is a unique name for the file (including extension) in the environment from which you run this command.

Example:

epmautomate copyfilefrominstance "abcd.zip" username "C:\users\documents\ EPMAutomate\password.epw" https://test-cloud-pln.pbcs.us1.oraclecloud.com IdentityDomain "target data file.zip"

listfiles: Lists the files in the

·       default location,

·       Data Management folders,

·       inbox/ outbox.

·       Also lists incremental and backup export files, and Migration snapshots.

Syntax:

epmautomate listfiles

deletefile: Deletes

·       a file

·       or a snapshot from the default upload location,

·       a Data Management folder,

·       or from profitinbox/profitoutbox.

To delete a file from a location other than the default upload location, you must specify the file location.

Syntax:

epmautomate deletefile "location/FILE_NAME"

Thanks for your time in reading this, meet you all in the next post!!!!

Best Regards,

SST.!