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 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

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

Steps

  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

Cause

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
Symptoms
Cause
Solution
References


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