My Oracle Support Banner

Transformation Data For New Added Tables Is Missing in Production Lifecycle (Doc ID 2611746.1)

Last updated on DECEMBER 12, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version and later
Information in this document applies to any platform.


On Oracle Health Sciences Data Management Workbench (DMW) version,

In the Production lifecycle of per study amendment, two new Source and Target Tables were added recently.
The Table mapping was updated to the study change and it is working well in both DEV and QC lifecycle.
After the Transformation was promoted to Production lifecycle, data of the two new sources are not transformed to the target tables.

It would be expected that the data from the new source tables to be transformed and loaded into the target table.

The issue can be reproduced with the following steps:
1. Create a Data Model with a table having four source tables.
2. Define mapping type as Union and map the four source tables to the target table.
3. Install and execute the Transformation in Dev/QC/Production lifecycle.
4. Verify that the data from all source tables is being loaded.




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.