Collection Type Attributes

Actions available for collection type attributes

If an attribute in a batch upload definition is a collection type attribute, then you can specify the following actions in the Column Usage drop-down list on that attribute.

• Add to List

  The values that are provided for the collection type attribute in the batch upload file are added to the corresponding attribute in the application during batch upload. If the value provided in the batch upload exists in the application, then the new value is ignored. If an incorrect value is provided in the batch upload, the batch upload fails for this attribute, and an error message is displayed in the Batch Upload details screen.

• Ignore

  The values that are provided for the collection type attribute in the batch upload file are ignored during batch upload. No validation of the values and no modifications are done, irrespective of the existing values in the attribute.

• Remove from List

  The values that are provided for the collection type attribute in the batch upload file are removed from the corresponding attribute in the application during batch upload. If the value provided in the batch upload does not exist in the application, then this value is ignored. If an incorrect value is provided in the batch upload, the batch upload fails for this attribute, and an error message is displayed in the Batch Upload details screen.

  You cannot remove system-assigned roles, such as default, internal user, external user, or system-assigned groups, such as default.

• Replace List

  This is the default action for a collection type attribute. The values that are provided for the collection type attribute in the batch upload file replace the existing values in the corresponding attribute in the application during batch upload. If an incorrect value is provided in the batch upload, the batch upload fails for this attribute, and an error message is displayed in the Batch Upload details screen.

  You cannot replace system-assigned roles, such as default, internal user, external user, or system-assigned groups, such as default.

  Replace List does not act on an empty value passed in the file. To remove all values, use Remove From List passing all assigned values in the file.

Collection type attributes available for batch processors

The collection type attribute is supported by the HR Batch processor for the User business object and the Organization Batch processor for the Organization business object.

The following columns in the HR Batch processor support the collection type attribute:

• Roles
• Groups
• Categories
• Application.SLM.Assigned Groups
• Application.ESP.Business Units
• Application.ESP.Module Visibility
• Application.ECM.Associated Organizations
• Application.ECM.Assigned Groups
• Application.Spend.Assigned Groups
• Application.PGM.Assigned Groups
• Application.PGM.Assigned Roles

The following columns in the Organization Batch processor support the collection type attribute:

• Assigned Organization Applications
• Sourcing Modules

Guidelines for entering comma-separated values (CSV) for the collection type attributes

You can specify the values in a collection type attribute as a comma-separated list. However, the following considerations apply when you use the CSV format during the batch upload.

• If a value in the batch upload file contains a comma, then you must enclose the value within double quotation marks. For example, to add the ABC, XYZ value, you must enter "ABC, XYZ" in the batch upload file.
• If a value in the batch upload file contains a double quotation mark, then you must enclose the value within another pair of double quotation marks. For example,
  • To add the ABC, "XYZ" value, you must enter "ABC, ""XYZ""" in the batch upload file.
  • To add the "ABC, "XYZ"" value, you must enter """ABC, "XYZ"""" in the batch upload file.