Error File Spreadsheet Format of Bulk Update Import Process
When the Bulk Update Import process is Completed with Errors, an Error file is generated as a Microsoft Excel spreadsheet (.xls).
Use any of the following methods to download the error file:
- Download the error file from the Import Data History Details window.
For more details, see Viewing Bulk Update Import Data History Details.
- Download the error file from the email notification you receive when the import process is Completed with Errors.
The error file contains the following worksheets / tabs:
- Instructions worksheet
The Instructions worksheet is generated automatically. Depending on the type of business processes included in the spreadsheet, the Instructions worksheet describes how to use the spreadsheet to resolve errors identified in BP records and line item data.
- Main Form worksheet
The Main Form worksheet is generated automatically as the second worksheet in the spreadsheet. It is recommended to not rename or reorder this worksheet. It contains a list of erroneous records identified in the Main Form.
- Column A of the Main Form describes the error identified for each erroneous record.
Note: All line items associated with the erroneous record in the Main Form will not be validated. Therefore, the error file may not show all errors related to the line items for the erroneous record.
- The following columns/data elements are also read-only: Record Status, Creator, Creation Date, Currency ID, Due Date, Status in WF, BP, Formula Data Elements.
- Data elements that are set to auto-populate from the sum of all line items data elements from the Integration Validation Form.
- The line item tab order is identical to the order in the selected records.
- Custom date formats are honored in the spreadsheet.
- The name of the worksheet is translated according to the user's language preference.
- Column A of the Main Form describes the error identified for each erroneous record.
- Worksheet for each line item tab
Line item tabs with erroneous records are color-coded orange. Each Line Item tab worksheet contains:
- The line item records and the data elements of each tab are listed in the same order as displayed in the user interface.
- Column A in the relevant Line Item tab describes the error identified for each line item record.
- Each line item record is identified by read-only columns in the following order: Record ID, Line Item ID, Record number, and Line No. These columns cannot be renamed, reordered, duplicated, or removed from the file.
- The formula data elements and auto-populated data elements are read-only columns.
- Worksheet names do not support the following special characters: \ / ? * : [ or ]
Last Published Sunday, July 20, 2025