Forms Data Loader Advantages

• Loads data directly into front end forms thus no direct connection to the database is required.

• Requires no special technical knowledge, can be used by non-technical end users as data is loaded in forms.

• Saves lots of time. Prepare load once and replicate the load as many times as you want.

• Completely transparent to the application. Application behaves as data is entered by a user.

• Accurate. All validations define in the application forms are performed.

• Useful for developers who have to feed data into forms repeatedly while testing applications.

• Useful for loading legacy data into applications where data cannot be loaded directly into tables easily.
• Comes with a new separate tool to load data in HTML Forms from CSV or Delimited or Excel files

Features
Compatible with Oracle Applications 10.7, Oracle Apps 11,Oracle Apps 11i & Oracle Apps 12i

• Loads data through Macros or Forms Record and Playback Mode
• Import data from Comma Separated Values Files (CSV), TAB Delimited Files or any other char delimited files.
• Copy paste the data from Excel or any spreadsheet.
• Sort the data in ascending and descending order on any field
• Load hundreds of rows into target applications in very short time
• Comes with built-in sample spreadsheets templates to learn how to build loads
• Completely transparent to the target application. i.e. target application will behave as the data
  is entered by a user.
• Unlimited support for registered users.
• Supports Data verification while data is entered into forms. So no more errors while loading.
• Data is entered through Oracle Applications Forms, so all the validations are performed
   

Download The Free Trial Version Now

Forms Data Loader loads the data using the following methods

• Simulating Keystrokes (Macro Loading)

• Forms Record and Playback Feature

• To load Data into HTML Forms please use our new tool HTML Forms Data Loader

Simulating Key Strokes (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

Now build loads instantly using Macro Recording feature

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 or 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

HTML Forms Data Loader.

HTML Forms Data Loader (HDL) is a separate tool, which comes with Forms Data Loader, to load data from CSV / Delimited / Databases into an HTML Form. It is a supplement to Forms Data Loader Tool which uses Macros to enter data in Forms. Since, HTML forms usually does not provide any Alt Keys (Hot Keys) it is quite difficult to load data into HTML forms using Forms Data Loader through Macros and Forms Record and Playback is impossible in HTML form. We used to get lot of mails from users expressing difficulty in loading data using Macros and they wanted a easy solution to load data in HTML forms. HTML Forms Data Loader is an answer to all these requests

For More Information about HTML Forms Data Loader Please Click Here