Incorrect Variable Order when adding a New Column in Existing Table (Doc ID 2898169.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.1.1.2, when adding a new variable or a new column in an existing table, the variable order for the newly added item is incorrectly updated.

The issue can be reproduced by executing the following steps:

    1. Create a MDD file that will be used for creating an input Data Model. In this file enter the definition of a table TAB1 with two columns COL1 and COL2.
    2. From DMW UI, create a new test study.
    3. Select the newly created study.
    4. Go to "Study Configuration".
    5. From Data Model section, create a new input Clinical Data Model "SRC1" using the MDD file created at step 1.
    6. Check the newly created table TAB1 under SRC1 Data Model:
        Table TAB1 with two columns COL1 and COL2 is created: COL1 with Order Id 1 and COL2 with Order Id 2.
    7. Edit the table TAB1, by adding a new column named COL3.
    8. Save the changes.

        The newly added column (COL1) is appended in the table as the last column.
         Order ID for this newly appended column is 5 instead of 3

Changes

Cause

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