How to transfer files from Local Machine to Oracle EBS

🖥️ How to Transfer Files from Your Local Machine to Oracle EBS Server

When working with Oracle E-Business Suite (EBS), file transfers between your local machine and the server are often required—whether for deploying custom code, moving reports, or managing backups. Here’s a quick and practical guide to doing this securely using WinSCP and PuTTY.

---

✅ Step 1: Download and Install WinSCP

WinSCP is a free and powerful SFTP/SCP client for Windows.

Download WinSCP

---

⚙️ Step 2: Setup WinSCP Connection

1. Open WinSCP.
2. Enter the host/server name, username, and password provided by your Apps DBA.
3. Select the protocol (SFTP or SCP).
4. Click Login.

---

📁 Step 3: Understand Server File Locations

Here are some common Oracle EBS file locations:

File Type	Path
.fmb	$CUSTOM_TOP/forms/US
.rdf	$CUSTOM_TOP/reports

You can find your $CUSTOM_TOP using PuTTY:

cd $CUSTOM_TOP
pwd

Or query using:

SELECT * FROM applsys.FND_ENV_CONTEXT WHERE parameter = 'CUSTOM_TOP';

---

🔄 Step 4: File Upload & Download in WinSCP

• Upload to Server: From the left pane (local), right-click the file > Upload.
• Download to Local: From the right pane (server), right-click the file > Download.

---

🧑‍🔧 Step 5: Login to PuTTY and Set Environment

Download PuTTY and login with your server credentials.

Once connected, run the following:

. /u01/install/APPS/fs1/EBSapps.env

Select the instance if prompted (e.g., R for Run).

---

👀 Pro Tips

• Transfer .fmb or .rdf files in Binary mode.
• Transfer .sql or .xml in Text mode.
• Use Auto mode if unsure.

---

📌 Conclusion

Using WinSCP and PuTTY, you can easily manage file transfers between your local machine and the Oracle EBS server. This is essential for any technical consultant working on customization, patching, or deployment.