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.
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 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
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
Excelany 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
