Updating BP Records in Excel for Bulk Update From Business Process Log Node

If you have the Allow Bulk Edit privilege, you can upload a batch of modified business process records using a Microsoft Excel file (.xlsx) from the Business Process Log grouping node.

A bulk update allows you to update and import multiple business process records that have been distinctly modified in a Microsoft Excel file (.xlsx). For a list of business processes supported by the Bulk Update menu options, see Business Processes Supported by the Bulk Update Export/Import Process.

Note:

  • Bulk Import data relies on V1 REST services. Therefore the system displays an error in the Import Error details window.
  • Bulk workflow actions follow REST V2 services.
  • Email is not generated through Bulk Update when bulk workflow actions are taken for multiple records.
  • Line items that are part of the input file are ignored if the record does not have those line items.
  • Bulk Update is not currently supported for General Spends Classification of Cost BPs with Line item of CBS Code (both workflow and non-workflow) if breakdown rows exist in the referenced Schedule of Values (SOV).
  • If provided, the BP Picker value must meet the configured query conditions. Otherwise, the system displays an Invalid value or multiple records found message.

Recommendation

To import BPs successfully, do not change the data formatting type in the exported file. For a detailed list of data elements that can and cannot be updated via Excel import, see Supported Data Elements For Bulk Update in Excel Import.

Procedure

To update business process records through Bulk Update:

  1. Modify the business process records in the Excel file.
  2. Import the data in the Excel file.
  3. View the import history information of the bulk update process.
  4. View error details of business process records, if any, associated with the bulk update process.
  5. Resolve the errors and re-import the business process records.