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.

How to Transfer the files from local machine to Oracle EBS server

 How to Transfer the files from local machine to Oracle EBS server

 

Download and Install Winscp software ,its an freeware you can download  from below link ,

 

https://winscp.net/eng/download.php 

 

Goto >  Winscp >  give Connection Details along with Servver details.

you can get this details  along with username and password from your  apps DBA.

 

 

now to goto exact file location , for this you should know the oracle apps file structure .

 few examples of files types with there server location

forms (.fmb)  >  $CUSTOM_TOP/forms/US

reports          >   $CUSTOM_TOP/reports

 to find out the exact custom top from putty exlained in below post or using table " applsys.FND_ENV_CONTEXT"

 

 for file transfer you need to select appropriate transfer setting ,in binary mode or text or else if you dont know  which mode to select you can use automatic default mode.

 

 

for transferring file from  local machine to server , 

in left window >goto file in local path > right click choose upload.

for transferring file from   server to local machine , 

in right  window >goto file in server path > right click choose download.

 

How to login to putty and find out custom_top path in oracle APPS

Putty is freeware , you can download it from below link

https://www.putty.org

 

 

Give username and password..

YOU need to run the command for setting environment EBSapps.env

 

Give  choice :R

 

Then type command

Ø  Cd $CUSTOM_TOP

 

 

Now give command >pwd

It will give the custom path foor your environment ..

Copy this path and paste it into winscp