Batch Insert Mode for Insert API

The Batch Insert Mode in Bulk Data Loader (BDL) for Insert (API) configurations enables separate insertion of Header and detail (DTL) records. This feature resolves dependency issues between staged objects during the data load process. The Insert menu consist of these options:
  • Header & Details
  • Header only
  • Details Only
Note:  The Insert menu is displayed only if the Action Type field on the Main tab is set to Insert (API).

Header & Details

The Header & Details option inserts both Header and Detail (DTL) records in a single operation. Before insertion, the system validates dependencies between objects. When there are no dependencies, the system inserts Header and detail records, and the status is set to completed.

Note:  If there are any dependencies, an alert message is displayed. The user must use these options:
  • Header only
  • Details only

Header Only

The Header Only option inserts Header and Description data for selected objects. These statuses are updated:
  • Header Completed: The value in this field is set to Completed if the header records are successfully inserted.
  • Partially Uploaded: The value in this field is set to Partially Uploaded when some header records fail validation, the users download the error data, correct the failed header rows, and reinsert the records. After successful header insertion, Details Only inserts the detail line records for the uploaded headers.

Details Only

The Details only option is used after the Header is uploaded completely. These statuses are updated:
  • All Details Successful: The value in this field is set to Completed if the object load is fully completed.
  • Partial Detail Uploaded:The value in this field is set to Partially Uploaded if some detail lines fail validation due to invalid data, users must download and fix error data and reinsert using a BDL update configuration.
Note: 
  • The upload is completed only after the Header and Detail records are inserted without errors.
  • You can use the Download Error Data option to identify, review, correct failed records in the Reports tab that allows users to download the error-stage records whenever the script execution status is Partially Uploaded.
  • If the Status field displays an error, all records are failed due to validation issues.