Tuesday 3 May 2011

Sample example for DataLoad - Part 3

This is last part of the DataLoad example.



Here are the final steps for loading the data from the Dataloader file(Order_Lines_Load.dld) into the Oracle EBS application.

1. Before running the Dataloader file ensure the following present in the file  : Order_Lines_Load.dld

  • Ensure *LR is present for the last record in the data load file.
  • Ensure that there are no additional records like NULL in Item Number column and data being present in other columns like TAB, *DN and *SL(1)  
 2. Open Oracle Applications and Navigate to Quick Sales Order Screen and place the cursor in Ordered  Item column
     
3. Go to Data Load Tool. Click on Tools ->  Start Load
  
4. Select the Command Group : EBS - 12 and select the appropriate Oracle Applications Front end in the Window name


5. Click on ‘OK’ Button

6. Data Loading process starts and the records will start loading.

7. Wait till the confirmation of successful loading.

8. Save the window, if everything is loaded.


That's It.... 

With help of DataLoad tool, we are now able to enter hundred's of records into the Oracle applications.


Hope this was useful. Please feel free to comment.






No comments:

Post a Comment