Sample example for DataLoad - Part 1

Before, I provide sample example for DataLoad, would like to provide some background information on this Tool.

DataLoad

This is one of the very useful tool for end users/technical developers used across Oracle Ebusiness Suite for entering large number of records.Say for example, If you want to enter 1000's of records into Sales Order screen, then using the DataLoad tool will be much faster and quicker. The tool provides other functionality too. Please refer the DataLoad which provides more information. Free version of the tool is available at the site.

Here is a sample example/script with the minimum functionality for DataLoad to load data into Sales Order Screen in Oracle EBS application.

                     Source: Order Items Data in Excel Sheet

                     Destination: Oracle EBS application

Steps to prepare the DataLoader file : Order_Lines_Load.dld

1. Launch the DataLoad Tool.

2. Enter the Following :
      a) Window : Oracle Applications
      b) Command Group : EBS - R12
      c)  Notes : Load Order Line Information into Sales Order Form in Oracle EBIS

 3. Click the Data Tab, select the first column in the tab and double click.

4. In the Column Titles -> Main Load section, enter the desired column titles.

5. Click on Save & Close button.

6. Enter the Sample Data in the file.

 Note  :
        TAB indicates after entering the item number, simulate the Tab out functionlity
        *DN indicates Down arrow and simulating the script to move to the next record
        *SL(1) indicates wait for 1 second

7. Save the file with the extension : Order_Lines_Load.dld.

Thats it, your sample script is ready.
My next post on the same, will show you how to load the entire data from the Excel spreadsheet into Order_Lines_Load.dld file and Load the data into Oracle EBS application.



Please feel free to comment.