copyToSFTP

Copies a file from a location in an Oracle Fusion Cloud Enterprise Performance Management environment to a location on a Secure FTP server. Using this command, you can copy a file directly from an environment to an SFTP server without first downloading it to another server using EPM Automate or the REST API and then using an SFTP client to upload it to the SFTP server.

If IP allowlist is enabled for the SFTP server, you must add the outbound IP address of the OCI region that hosts the Cloud EPM environments to the IP allowlist of the SFTP server. See Outbound IP Addresses of Cloud EPM Data Centers and Regions in the Operations Guide for the outbound IP addresses of OCI regions.

Note:

This command supports SFTP server running on port 22 only.

Applies to

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

Required Roles

Service Administrator

Usage

epmautomate copyToSftp SFTP_SERVER_URL EPM_FILE_NAME username=USERNAME password=PASSWORD where:

SFTP_SERVER_URL is the URL of the SFTP server including the directory where the file is to be copied and the file name.
EPM_FILE_NAME is the name and location (if not from the default outbox) of the file you want to copy from the Cloud EPM environment. Do not specify the .ZIP extension if you are copying a snapshot
USERNAME is the ID of a user who has the required access rights on SFTP server.
PASSWORD is the SFTP user password.

Example

epmautomate copyToSftp
                sftp://mySFTP_Server/someDirectory/some_file.csv myFile.csv username=jDoe
                password=SftpWelcome