Do's and Don'ts for Data Loader

Here are some guidelines which can be followed while creating Macro Load sheets in Data Loader.

Macro Loading

While using Data Loader to load data into the Oracle EBS Suite or any other application via the Macro Loading feature, there are some guidelines you should follow. Adhering to these makes creating Data Loader templates easy and fast.

Do's

Before recording a macro template, decide on the sample record values you'll enter while recording.
Open the form you want to record before clicking "Start Recording".
Place the cursor in the first field of the target form before clicking "Start Recording".
Check the "Record Mouse Clicks" checkbox if you want to capture mouse clicks too, as shown below.
Before clicking Load, make sure the target form is open and the cursor is in the first field before clicking "Start Loading".

Don'ts

Do not paste data into form fields while recording — always type the data while recording.
Don't use the mouse to navigate between fields if you didn't check "Record Mouse Clicks".
Don't use the mouse to select values from dropdown lists if you didn't check "Record Mouse Clicks".

For troubleshooting loads, see the Data Loader FAQ.

Back to Data Loader Articles