Dayalan Punniyamoorthy Blog

Monday, July 9, 2018

NEW EPM AUTOMATE UTILITY - Oracle PBC 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 environment (target) 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
You can download  the file from the PBC instance
And get that downloaded for the Windows or Linux


Make sure you run the installer as “run as administrator”. While installation you might get this message
Hit on "More info". Not sure why Windows is blocking the executables, hit Run anyway.
It will prompt to uninstall the older one and install the new one
Hit yes and proceed with the installation, after successful installation you should get the confirmation as below,
Lets us explore the new version of the utility & try the copyfilefrominstance command

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.

Usage: 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 "my data file.zip" serviceAdmin C: \mySecuredir\password.epw https://test-cloud-pln.pbcs.us1.oraclecloud.com myprodIdentityDomain "my target data file.zip"

Its early for me to run the command as the Production Pod is yet to be applied for path, let me come back again on this 

listfiles:

Lists the files in the 
  • default location,
  • Data Management folders,
  • profitinbox/ profitoutbox.
  • Also lists incremental and backup export files, and Migration snapshots. 
Usage: epmautomate listfiles (running in the Test instance)
In Test POD:
Files under DataManagement under Test Instance
and files under Outbox,reports under DataManagement 

It has listed the files from Data Management also let me run the same command against the Production instance (where the patch is yet to be applied) so you can get the difference.

In Production POD:
Running Listfiles - against the Production Instance, do note that the files against the Data Management are missing in the Prod.
However, I do have a file under Home

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.

Usage: epmautomate deletefile FILE_NAME

In Test POD:
Running against the Test Instance:
Missed the double quotes in the last command, retrying with the quotes

Ran the command to delete a file from the DataManagement under Outbox/report


In Production POD:
The same command is run in Prod (as stated earlier the patch is yet to be applied & will be applied on 21st July 2018)

Was able to delete a file which was listed by the listfiles command

But cant delete a file in Prod even though it does exist, So it confirms the patch will allow me to do all these updated operations post 21 July 2018.

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

1 comment:

  1. What if i want to copy a snapshot within the one instance with a different name. I don't see downloading file, renaming it and then uploading ..a good option just to create one more copy with differnt name.
    I tried keeping the same URL for Source and Target but it is giving error "file doesn't exist" even though file is there in listfiles..

    any suggestion. please

    ReplyDelete