Business Processes Supported by the Bulk Update Export/Import Process

If you have the Allow Bulk Edit permission, the toolbar of the business process (BP) you select in the Logs node displays the Bulk Update menu with the following menu items:

  • Export Data
  • Import Data
  • Import History Details

The Excel file generated by the Bulk Update export/import menu items displays the following worksheets for supported BPs listed below. For more information about each worksheet, see Microsoft Excel File Format for Bulk Update Export/Import Process.

Supported BPs SOV Type Instructions Worksheet Main Form Worksheet Line Items Worksheet Codes and Descriptions Worksheet SOV Line Items Worksheet
Company-level Simple BPs (workflow and non-workflow)   Yes

Yes

For workflow BPs, the data elements (DEs) appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action
 No No No
Shell-level Simple BPs (workflow and non-workflow)   Yes

Yes

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action
 No No No

Company-level *Line Item BPs, Generic Classification (workflow and non-workflow)

*Excludes Vendor BPs

   Yes

Yes

For Line Item BPs with cost code data in the Upper form, the worksheet also includes a Cost Code field.

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action
 Yes No No
Shell-level Line Item BPs (workflow and non-workflow)   Yes

Yes

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action
 Yes No No
Cost BPs, Line items with CBS Code, Generic Classification, (workflow and non-workflow)   Yes

Yes

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action

Yes

If the work package picker is included in the BP, the worksheet includes a Work Package field with a drop-down list of values. You can edit the line item.

If the BPO or BPO Line Item picker is included in the BP, the worksheet includes the BPO and BPO Line Item picker as read-only fields.

Yes No
Cost BPs, Line item with CBS Code, Budget Transfer Classification (workflow and non-workflow)   Yes

Yes

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action
 Yes Yes No
Cost BPs, Line item with CBS Code, Base Commit Classification (workflow and non-workflow General Spends SOV (with Individual Commit Line Items) Yes

Yes

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action

If you export the Main Form and line items, the worksheet also includes the following read-only fields by default:

  • currency picker
  • rate in project currency
  • rate in base currency
  • override rate
 Yes

Yes

Displays both active and inactive cost codes

 No
Cost BPs, Line item with CBS Code, Base Commit Classification (workflow and non-workflow) Payment Applications SOV (with Individual Commit Line Items) Yes

Yes

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action

If you export the Main Form and line items, the worksheet also includes the following read-only fields by default:

  • currency picker
  • rate in project currency
  • rate in base currency
  • override rate
 Yes

Yes

Displays both active and inactive cost codes.

 No
Cost BPs, Line item with CBS Code, Change Commit Classification (workflow and non-workflow) General Spends SOV Yes

Yes

For change commit records, the worksheet also displays a read-only Reference Commit field with values.

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action

Yes

For in-flight records that reference the same contract, the worksheet also includes a Reference field that lists all reference codes from the selected contract's SOV sheet for that record.

For multiple in-flight records that reference different contracts, the worksheet displays a Reference field that lists all reference codes from the SOV sheet of the associated contract.

Yes

Yes

The worksheet displays a list of all SOV values across all contracts.
Cost BPs, Line item with CBS Code, Change Commit Classification (workflow and non-workflow) Payment Applications SOV Yes

Yes

For change commit records, the worksheet also includes a read-only Reference Commit field with values.

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action

Yes

For in-flight records that reference the same contract, the worksheet also includes a Reference field that lists all reference codes from the selected contract's SOV sheet for that record.

For multiple in-flight records that reference different contracts, the worksheet displays a Reference field that lists all reference codes from the SOV sheet of the associated contract.

Yes

Yes

The worksheet displays a list of all SOV values across all contracts.
Cost BPs, Line item with CBS Code, General Spends Classification (workflow and non-workflow)**   Yes

Yes

Also includes a read-only Reference Commit field. If the end form is an Action form, the worksheet also includes record data from terminal status records.

For workflow BPs, the DEs appear on the Integration tab. The following fields also appear:

  • Workflow Name
  • Current Step Name
  • Workflow Action

Yes

Displays CBS codes associated with the SOV referenced in all the exported line items.

 Yes

Yes

Displays all SOV line items across multiple contracts in the following fields:

  • refid (Label of field)
  • Ref. (label of uuu_sovlinum field)
  • CBS Code
  • Commit Short Description

** Bulk Update is not 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).