DMW Transformation UI Shows Filter Value for the Deleted Codelist Value (Doc ID 2761982.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

The issue can be reproduced with the following steps from DMW:

1. Create a new Therapeutic Area (optional).
2. Create a new codelist with 4 values.
3. Check in the codelist.
4. Create a new study.
5. Create a source and Target Data Model under the new study.
6. Map the created codelist to target Data Model.
7. Create a transformation of type unpivot.
8. Map the column filter value for codelist in column mapping in the transformation for four columns.
9. Install the models and transformation.
10. Promote all and install all in production lifecycle.
11. Go to the newly created Codelist, check out and delete any code mapped to the transformation.
12. Check in.
13. Go to study, checkout transformation.
14. Go to clinical Data Model tab and under target Data Model, modify the column which is mapped to the codelist and up-version the codelist.
15. Go to the transformation and see the column mapping if the filter value exists for the deleted codelist value.

Cause

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