Using a Copy to SFTP Job Type

Use the Copy to SFTP job type to copy a file to a location on a Secure FTP server (the target). Using this job type , 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 the IP allowlist is enabled for the SFTP server, you must add the outbound IP address of the OCI region that hosts the Oracle Fusion 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 job type supports SFTP server running on port 22 only.

Note:

As a prerequisite to using the Copy to SFTP job type, you need to define the SFTP server connection using EPM Connections. For more information, see Connecting Environments in Cloud EPM in Administering Planning.

Copy to SFTP job type parameters include:

Note:

For parameters that are common to all job types, see Pipeline Process Description.

Table 12-8 Copy to SFTP Job Type Parameters and Descriptions

Copy to SFTP Job Type Parameters Description
SFTP Connection

Specify the connection of the SFTP server where the file is to be copied and the file name.

For example, sftp//myserver.

This is the Connection name that is created in Connection.

Source File Folder

Specify the name and location of the file you want to copy from the Cloud EPM environment.

The source directory can be: Inbox (inbox folder in Data Integration), openbatch, openbatchml and the EPMInbox (Planning inbox folder).

For example,

inbox/File_new.txt

Source File Name

Specify the name of the source file name (with path) to be copied to the SFTP Server.

Target File Name

Specify the name of the target file name (with path) to which to copy to the SFTP Server.

For example,

inbox/File_new2.txt

Here are sample job type parameters for a Copy to SFTP job type:

Image shows parameters for a Copy to SFTP job type.