Using Forms Data Loader you can load Data Using Macro Load or through Oracle Forms Record and Playback feature.
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
To Learn How to Load data using Macro Load Click Here
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.
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.
HTML Data Loader works with Microsoft Internet Explorer, Mozilla Firefox and Google Chrome.
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.
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|
|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|