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
(Used to load data into Oracle Java Applet forms or any Windows application form)
(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 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...
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.
Run the Oracle Application Forms in record mode and enter 2 or more records in whichever form you want to load the data.
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
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.
Please see the other sections of this help which demonstrates how to use Forms Data Loader.
Forms Record & Playback Method
|Templates can be build easily||Templates build with one time setup required|
|Errors are not handled||In-built Error Handling|
|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|