My Oracle Support Banner

Agile Import for Update of Roles With Preference "MULTILIST DATA ACTION:APPEND DATA" Not Working (Doc ID 2851008.1)

Last updated on MARCH 09, 2022

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


Actual Behavior

If MultiList01 field had value "A1" and in the import data source file it had value "A2;A3;A4", then the value should be appended and the list value is not showing as "A1;A2;A3;A4" instead only showing "A2;A3;A4"

Expected Behavior

Agile import to append MultiList values from the source file


  1. Prepare Import Source Excel file with information like below:

    Import Source Excel File
    UserID FirstName LastName Email Roles
    user1 user temp user1@xyz.xom A2;A3;A4
  2. Log into Web Client, and go to Tools > Import
  3. Select the Import File
  4. Set Preference to below:
    Blank Data Action : Retain Data
    Multilist Data Action : Append Data
  5. Map fields, and Import
  6. Import completes without any error. 
  7. Check the roles of the user profile. See MultiList01 field is updated to A2;A3;A4
    Expected is: A1;A2;A3;A4


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.