Introduction

 

Data Loader is a tool to load data into Oracle forms from front end. It is used by thousands of users worldwide to load data into Oracle E-Business Suite.

 

Although it is specially built to load data into Oracle ERP Applications forms, it can be used to load data in any type of Windows application form whether it is SAP or HTML or any other application. It provides easy to use spreadsheet interface to build data load. Forms Data Loader fills data by simulating keystrokes as though type by a user.

 

Building Load is quite easy, you can learn building data loads by just spending few minutes.

 

We also provide a series of demos which demonstrates how the loads are developed and how FDL works.

 

Forms Data Loader consists of two tools

 

Forms Data Loader

(Used to load data into Oracle Java Applet forms or any Windows application form)

 

HTML Forms Data Loader

(Used to load data into Oracle Web Based forms also known as Oracle OAF forms or Oracle Self Service forms)

 

To load data into Oracle EBS Java Applet Forms (also known as Oracle Core Forms or Oracle Traditional Forms) use Forms Data Loader. To load data into Oracle Web Based forms (also known as Oracle Self Service forms) use HTML Forms Data Loader.

 

 

Forms Data Loader loads the data using the following methods (for Oracle Java Applet Forms)

 

•  Macro Loading

•  Forms Record and Playback Feature

 

Macro Loading

 

Forms Data Loader fills data in Forms by simulating keystrokes as though type by a user. It provides a spreadsheet interface where you can enter the data and keystrokes to send to the forms. Building Load is quite easy, you can learn building data loads by just spending few minutes. We provide a series of demos which demonstrates how the loads are developed and how FDL works. Although it is specially focused to load data into Oracle ERP Applications, it can be used to load data in virtually any type of application form whether it is SAP or HTML or any other application More...

 

 

To Learn more about loading the data using macros click here

 

Forms Record and Playback Feature

Using this feature Forms Data Loader can be used to load data accurately and several times faster than Macro Loading. It is more reliable, the load will stop whenever an error comes, It is because Oracle Forms will execute the load. You use Forms Data Loader just for developing the load.

Using this method you can load the data in Oracle Apps by performing the following Steps.

 

Step 1

Run the Oracle Application Forms in record mode and enter 2 or more records in whichever form you want to load the data.

 

Step 2

Open the recorded file in Forms Data Loader and add records by entering directly or by importing from a CSV file or Excel any other delimited file

 

Step 3

Then Play the file saved in Step 2 by running Oracle Application Forms in Playback Mode.

This method is accurate and handles all errors and nearly 10 times faster than macro loading.

 

To Learn more about Forms Record and Playback Feature click here

 

Please see the other sections of this help which demonstrates how to use Forms Data Loader.

 

Comparison Between  Macro Loading and Forms Record and Playback Methods

 

Macro Load	Forms Record & Playback Method
Templates can be build easily	Templates build with one time setup required
Errors are not handled	In-built Error Handling
Not Reliable	Reliable
Load Doesn't Stop on Error	Load Stops on Error
Load is asynchronous to application speed	Load is Synchronous to Application Speed
Slow	Nearly 25 times Faster than Macro Load
Can be used for any application window running in Windows	Can be used only for Oracle Applications Forms