One stop solution for
all your Data Loading requirements.
Forms Record and Playback Method
HTML Forms Record and Playback Method
Load Data directly into Database
Load hundred of rows into Oracle Apps
Front End Screens or any Window Application using Macros now comes
with macro recorder
Load thousand of rows into
traditional Oracle Forms using Record & Playback feature
thousand of rows into Web Based Forms through Record and Playback
feature. One of its kind tool.
Load data directly into Databases
from many popular databases and CSV / Delimited files. Supports
Watch Demos Download
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
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
Comes with a new separate
tool to load data in HTML Forms from CSV or Delimited or Excel files
Compatible with Oracle Applications 10.7, Oracle Apps
11,Oracle Apps 11i & Oracle Applications R12
- Loads data through Macros or Forms Record and
- 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
- 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
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
Why use Data Loader?
The answer is simple there is no direct way to modify data
in Oracle Apps tables as Oracle Corporation says
Oracle does provide Open Interface tables but, it is
tedious exercise to load data using Open interface tables. Our tools are
useful as they load the data from Front End Forms as though entered by a user
and thus all the validations are performed.
"Do Not Use Database
Tools to Modify Oracle Applications Data
Oracle provides powerful tools you can use to create, store, change, retrieve
and maintain information in an Oracle database. But if you use
Oracle tools like SQL*Plus to modify Oracle Applications data, you risk
destroying the integrity of your data and you lose the ability to audit
changes to your data.
Because Oracle Applications tables are interrelated, any change you make using
an Oracle Applications form can update many tables at
once. But when you modify Oracle Applications data using anything other than
Oracle Applications forms, you may change a row in one
table without making corresponding changes in related tables. If your tables get
out of synchronization with each other, you risk retrieving
erroneous information and you risk unpredictable results throughout Oracle
When you use Oracle Applications forms to modify your data, Oracle Applications
automatically checks that your changes are valid. Oracle
Applications also keeps track of who changes information. But, if you enter
information into database tables using database tools, you may
store invalid information. You also lose the ability to track who has changed
your information because SQL*Plus and other database tools
do not keep a record of changes.
Consequently, we STRONGLY RECOMMEND that you never use SQL*Plus, Oracle Data
Browser, database triggers, or any other tool to
modify Oracle Applications tables, unless we tell you to do so in our manuals. "
Download The Free Trial
Forms Data Loader loads
the data using the following methods
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
To Learn more about loading
the data using macros click here
Now build loads
instantly using Macro Recording feature
Forms Record and
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
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 or 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.
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
For More Information about HTML Forms Data
Loader Please Click Here
Some of our Esteemed Customers
* Akamai Technologies
* MC Graw Hill
* L & T Infotech
* Aviva Life Insurance
* DFW Airport
* Ingersol Rand
* Family Dollar Store
* Ameron Hawaii
* Sikorsky Global Helicopters
* Origin Energy
* Opti Solar
* LinkedIn Corp.
* Gentex Corp.
* Tupperware Brand
And many more...