1. Oracle Enterprise Performance Management Cloud Operations Guide
  2. Troubleshooting EPM Cloud Issues
  3. Resolving EPM Automate Issues
  4. Resolving EPMAT-1: Command Failed To Execute. The Parameter Location Is Invalid Error While Running the ImportMetadata Command

Resolving EPMAT-1: Command Failed To Execute. The Parameter Location Is Invalid Error While Running the ImportMetadata Command

EPM Automate displays this error due to a syntax error in the command you specified to run the importMetadata command.

To resolve this issue, use one of the following methods:

  • If the import CSV file name specified in the job is identical to the name of the CSV file you are using with the command, use the uploadFile command to upload the import CSV file into to the environment. Run the importMetadata command without specifying the FILE_NAME optional parameter. In this situation, the command usage should be epmAutomate importMetadata JOB_NAME.
  • If the import CSV file name specified in the job is not identical to the name of the CSV file you are using with the command or when the import CSV file name is not included in the job that is being used for the import operation, zip the import CSV file into an archive and upload it to the environment using the uploadFile command. Run the importMetadata command using the name of the archive as the value of the FILE_NAME parameter. In this situation, the command usage should be epmAutomate importMetadata JOB_NAME FILE_NAME.zip.
  • When importing metadata from multiple CSV files, zip the CSV files into one archive and use the name of the archive as the value of the FILE_NAME optional parameter: epmAutomate importMetadata JOB_NAMEimport_CSVs.ZIP.