Oracle Integration Cloud SFTP Guide

Introduction

In modern enterprise integrations, secure file transfer remains a critical requirement—even in cloud-first architectures. Oracle Integration Cloud SFTP plays a vital role in enabling organizations to exchange files securely between external systems, on-premise applications, and Oracle Fusion Cloud applications.

From payroll file transfers in HCM to supplier invoice imports in ERP, SFTP-based integrations are still widely used due to their reliability, simplicity, and security. In this article, we will explore Oracle Integration Cloud (OIC Gen 3) SFTP capabilities from a real implementation perspective, including architecture, setup, and troubleshooting.

What is Oracle Integration Cloud SFTP?

Oracle Integration Cloud SFTP is a feature within OIC that allows integrations to:

• Connect to external SFTP servers

• Read, write, list, and delete files

• Automate file-based integrations

• Securely transfer data using SSH encryption

OIC provides a prebuilt SFTP Adapter, which simplifies file operations without writing low-level code.

Key Capabilities

• Upload files to external systems (Outbound)

• Download files from external systems (Inbound)

• Poll directories for new files

• Perform file operations (read, write, move, delete)

• Handle large files using streaming

Real-World Integration Use Cases

1. Payroll File Transfer (HCM → Bank)

In a payroll project:

• Oracle Fusion HCM generates a payroll output file

• OIC picks the file and sends it to the bank’s SFTP server

• Bank processes salary payments

Consultant Tip: Always implement file naming conventions like:

2. Supplier Invoice Import (Vendor → ERP)

• Vendors upload invoice files to SFTP

• OIC polls the directory

• Files are transformed and sent to Oracle ERP via REST/HDL

3. Data Migration from Legacy Systems

• Legacy systems drop CSV/XML files on SFTP

• OIC processes them and loads data into Fusion (HCM/ERP/SCM)

Architecture / Technical Flow

Typical OIC SFTP Integration Flow:

Flow Explanation

1. External system places file on SFTP

2. OIC Scheduled Integration polls SFTP directory

3. File is read and parsed

4. Data is transformed using mapper

5. Data is sent to target system (REST/SOAP/DB)

Prerequisites

Before working with Oracle Integration Cloud SFTP:

Environment Requirements

• OIC Gen 3 instance

• Access to SFTP server (host, port, credentials)

• SSH key (optional but recommended)

• Firewall access enabled

Required Information

Step-by-Step Build Process in OIC Gen 3

Step 1 – Create SFTP Connection

Navigate to:

OIC Console → Integrations → Connections → Create

• Select Adapter: SFTP Adapter

Configure Connection

👉 Upload SSH Key if using key-based authentication

Click Test Connection → Ensure success

Step 2 – Create Integration

Navigate to:

Integrations → Create → Scheduled Orchestration

• Name: SFTP_FILE_PROCESSING

• Pattern: Scheduled

Step 3 – Add SFTP Trigger (Inbound File Read)

• Drag SFTP Adapter

• Configure:

Important Options

• Enable File Polling

• Set Polling Frequency (e.g., every 5 minutes)

• Enable Archive After Read

Step 4 – Define File Schema

• Upload sample file (CSV/XML)

• Define structure

Example CSV:

Step 5 – Add Transformation

• Use mapper to transform file data

• Map source fields to target payload

Step 6 – Send Data to Target System

Example:

• ERP REST API

• HCM HDL Load

• Database Adapter

Step 7 – Optional: Write File to Another SFTP

• Use SFTP Adapter (Invoke)

• Operation: Write File

• Directory: /processed

Step 8 – Activate Integration

• Save → Activate

• Schedule integration

Testing the Technical Component

Test Scenario

• Upload a file to SFTP:

Expected Behavior

• OIC picks file automatically

• Data is processed and sent to target

• File moves to archive folder

Validation Checks

• Check OIC Tracking → Instances

• Verify:

Common Errors and Troubleshooting

1. Connection Failed

Cause:

• Wrong host/port

• Firewall issue

Solution:

• Verify connectivity using tools like WinSCP

2. Authentication Error

Cause:

• Incorrect password or SSH key

Solution:

• Re-upload key

• Validate key format (OpenSSH)

3. File Not Picked

Cause:

• Incorrect directory path

• Wrong file pattern

Solution:

• Check exact folder structure

• Use wildcard properly

4. Large File Processing Failure

Cause:

• Memory limitations

Solution:

• Enable streaming

• Split files

5. File Lock Issues

Cause:

• File still being written by source system

Solution:

• Use file readiness check

• Add delay mechanism

Best Practices for Oracle Integration Cloud SFTP

1. Use SSH Key Authentication

• More secure than password

• Avoid storing credentials

2. Implement File Naming Standards

Example:

3. Always Archive Files

• Avoid duplicate processing

• Maintain audit trail

4. Enable Fault Handling

• Use Scope + Fault Handler

• Log errors into DB or send alerts

5. Use Staging for Large Files

• Avoid direct memory load

• Improves performance

6. Secure Sensitive Data

• Encrypt files if required

• Mask PII data

7. Monitor Integrations

• Use OIC dashboard

• Set up alerts for failures

Summary

Oracle Integration Cloud SFTP is a powerful and essential capability for handling file-based integrations in enterprise environments. Even in API-driven architectures, SFTP remains critical for batch processing, legacy system integration, and secure file exchange.

From real-world implementations, success depends on:

• Proper connection setup

• Robust file handling logic

• Error handling and monitoring

• Following best practices like archiving and naming standards

For any Oracle consultant, mastering SFTP integrations in OIC Gen 3 is a must-have skill, especially for projects involving HCM payroll, ERP data loads, and vendor integrations.

For more details, refer to Oracle official documentation: https://docs.oracle.com/en/cloud/saas/index.html

FAQs

1. Can OIC handle large files using SFTP?

Yes, OIC supports large file processing using streaming and staged file handling. However, it is recommended to split very large files for better performance.

2. What is the difference between SFTP and FTP in OIC?

SFTP uses SSH encryption and is secure, whereas FTP is not encrypted. OIC primarily uses SFTP for secure integrations.

3. Can OIC trigger integration when a file arrives in SFTP?

Yes, using Scheduled Orchestration with file polling, OIC can automatically detect and process new files.