How to Load Data using Forms Data Loader


Using Forms Data Loader you can load Data Using Macro Load or through Oracle Forms Record and Playback feature.


Macro Load


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

To Learn How to Load data using Macro Load Click Here


Data Loader: Macro Load Example, Loading Invoices in Oracle E-Business



HTML Data Loader for loading data into Oracle Web Forms also known as Self Service applications or OAF.


HTML Forms Data Loader is a useful tool to automate loading of data into Oracle E-Business Suite 11i / R12.x  Self Service Forms or any HTML forms.    

Unlike Macro Loading feature of Data Loader in which user has no control, loading data through this tool is 100% reliable and accurate.


dataloader record


A user can have complete control of the load. After the load finishes HDL will show which rows were loaded successfully and which rows got errors by marking it with Green and Red colors. It will even show how many rows were processed and the remaining rows still to be processed loading is finished or cancelled.


One can load thousand of rows through Front End HTML Forms without any user interaction

Using HTML forms data loader is very easy. Preparing loads involves just 3 steps as shown below


Step 1. Record

Step 2. Populate the spreadsheet with your data from CSV or Excel

Step 3. Playback (Load)


To develop a load you have to just open the HTML form in a built-in Browser and then click Start Recording button and then HDL will automatically capture the items in which you enter data or click. After you finished entering data and completes the navigation. Click the Stop Recording button.


Then HDL will show the items in spreadsheet,  Now just copy and paste the data from Excel or Import the data from your CSV or delimited file in the spreadsheet and click Start Loading and that’s it! HTML Forms Data Loader will start playback and fills forms automatically.


To learn step by step on how to load the data using HDL please click How to load data using HTML Forms Data Loader and also don’t forget to watch demo
videos at Data Loader Videos


HTML Data Loader works with Microsoft Internet Explorer, Mozilla Firefox and Google Chrome.




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. This is applicable for Oracle Java Plugin forms also known as Oracle core forms.


To Learn How to Load data using Forms Record and Playback Feature Click Here


Comparison Between Macro Load and Forms Record & Playback Methods

Macro Load Forms Record & Playback Method
Easy to build One time setup required in application server
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




Contact Us


© Interface Computers  All Rights Reserved