Using Forms Data Loader you can load data using Macro Load or through the Oracle Forms Record and Playback feature.
Macro Load
Forms Data Loader fills data in forms by simulating keystrokes as though typed by a user. It provides a spreadsheet interface where you can enter the data and keystrokes to send to the forms. Building a load is quite easy — you can learn it by spending just a few minutes. We provide a series of demos which demonstrate how loads are developed and how FDL works. Although it's specially focused on loading data into Oracle ERP Applications, it can be used to load data into virtually any type of application form, whether SAP, 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 (Self Service / OAF)
HTML Forms Data Loader is a useful tool to automate loading data into Oracle E-Business Suite 11i / R12.x Self Service Forms or any HTML forms.
Unlike the Macro Loading feature of Data Loader, where the user has no control, loading data through this tool is 100% reliable and accurate.
A user has complete control of the load. After the load finishes, HDL shows which rows loaded successfully and which got errors, marking them Green and Red. It even shows how many rows were processed and how many remain, whether loading is finished or cancelled.
You can load thousands of rows through front-end HTML forms without any user interaction. Preparing loads involves just three steps:
To develop a load, open the HTML form in the built-in browser and click Start Recording. HDL automatically captures the items in which you enter data or click. After you finish entering data and complete the navigation, click Stop Recording.
HDL will then show the items in a spreadsheet. Copy and paste the data from Excel, or import from your CSV or delimited file, and click Start Loading — that's it. HTML Forms Data Loader starts playback and fills the forms automatically.
To learn step by step how to load data using HDL, please see How to load data using HTML Forms Data Loader, and don't forget to watch the 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 load data accurately and several times faster than Macro Loading. It's more reliable — the load stops whenever an error occurs, because Oracle Forms executes the load. You use Forms Data Loader just for developing the load. This applies to Oracle Java Plugin forms, also known as Oracle core forms.
To learn how to load data using Forms Record and Playback, click here.