A day in the life of an Oracle Applications Consultant

DataLoad - a tool to facilitate system data migration

This post discusses the DataLoad Software - a tool that will assist you in application data migration.

In the early days of my present occupation, namely Oracle ERP Consultant, I was introduced to the DataLoad utility. I can’t remember who introduced me to the tool but I owe them a big thankyou. I have subsequently used it on every single implementation I have been involved in for the past 3 years and am sure I will continue to make use of it in the future. I was able to learn DataLoad incredibly quickly as it is very easy to use. In a former life I was a BaaN consultant, I only wish I had been introduced to this product then as DataLoad can work on any application that accepts inputs from a keyboard or mouse. DataLoad comes in two versions, namely Classic and Professional. Up until now I’ve managed to get by using the Classic version which is free but on my most recent implementation we had some fairly heavy duty data loads to perform and so decided to buy Professional. The differences between the two version are outlined on the DataLoad site. According to the DataLoad site: -

“DataLoad loads data into any application running in Windows, and contains extra functionality for loading data and setup into Oracle Applications.

DataLoad loads data through the forms. This means the data is indistinguishable from that entered by users. To load data using DataLoad you setup DataLoad to load into the forms and the forms load the data into your system. This non-technical approach means the load can be built and run by non-technical users, and by not having to write conventional interfaces into the database a huge amount of time and money can be saved”.

Essentially there are two types of data that one needs to think about when it comes to Enterprise Applications - master data and transactional data. Examples of Master Data are Customer or Supplier information whilst transactional data might consist of sales or purchase invoices. In the instance of Oracle Applications a further data type (which is essentially master data) can be outlined, namely Application Object Library (AOL) or Setup Data such as profile options and flexfield definitions.

Loading data of any type into your application from DataLoad Classic is a three step process: -

1. Obtain your data in Electronic Format (e.g text file, excel file)

2. Copy or Import the data into a DataLoad template.

3. Load the data in to your application from the DataLoad template.

The key to success is designing your DataLoad template in ways that ensures a smooth load of your data. The DataLoad template will be used to load your data by simulating the keystrokes and mouse clicks that you would normally use to capture the data manually. An example of what a DataLoad template looks like is as follows: -

DataLoad Template Example (for loading the Accounting Calendar)

An example of a DataLoad Template for loading the Accounting Calendar

For Oracle Applications users, Pre-Built Spreadsheets or templates can be downloaded from the DataLoad web site for each module - the obvious benefit here is you will save time by not having to build your own templates. The pre-built templates can also be edited and I find it best to start out with a pre-built template and modify it, rather than building a template from scratch.

Obviously DataLoad is not the only way to migrate or load data into your applications. Each alternative means of data migration should be carefully considered and the pros and cons established (the Accenture presentation mentioned below provides a good comparison of the alternatives). Where necessary a cost benefit analysis may need to be prepared.

Related Presentations

The following presentations will provide you with further information on DataLoad: -

Data Migration in Oracle E-Business Suite (679KB) by Trond Steensnaes of Accenture at an OAUG Forum Meeting in Paris.

Posted by Richard Byrom on 07/09 at 03:12 PM
  1. I’m trying using dataload with 11.5.10, but it doesn’t work.
    Can anybody suggest how to configure Oracle Applications 11.5.10 in order to record and playback forms playback files?

    Thanks a lot

    Posted by .(JavaScript must be enabled to view this email address)  on  01/21  at  11:11 PM
  2. You should check out the Oracle Forms Playback Setup Page on the Dataload site which has a section entitled Additional Steps for Oracle Applications 11.5.9 and 11.5.10

    Posted by Richard Byrom  on  03/31  at  05:02 PM
  3. You know who is the command into Dataload Tool for ‘check flag’ in Oracle applications 11 i?

    very thanks

    Posted by .(JavaScript must be enabled to view this email address)  on  06/23  at  12:11 AM
  4. I think the command you are talking about his how to tick a check box, if that is the case you should tab to the check box in question and then use the space bar to activate it.

    Posted by Richard Byrom  on  06/23  at  07:51 PM
  5. Hi All,
    We are working on Oracle Record and Playback Functionality.  We have already done all the required setup.
    If anybody works on these issues and share there knowledge with us that will be the great helps to us.

    Thanks & Regards
    Pankaj Rode

    Posted by Pankaj  on  08/11  at  04:59 PM

Add Comment Information Here

Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.


Notify me of follow-up comments?

Submit the word you see below: