Transformation Model Status Shows Invalid Status Even If Tables Are Marked As Completed And/Or Not Used
(Doc ID 2512567.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Health Sciences Data Management Workbench - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 version the Transformation Model status is showing up as Invalid
The transformation has installed successfully and even the Validation map job was successful however status of transformation shows as Invalid.
Expect when it installs successfully, it shows Status as Valid, too.
Navigate to the transformation Tab to see the status of the transformation and there are some of the invalid table maps.
(1). Primary key column in the target table must be either mapped to source column or to a constant value.
(2). Mapping Required. All Primary key columns in the target table are unmapped.
(3). Not null columns in the target table must be either mapped to source column or to a constant value.
(4). One or more column expression(s) or criteria expression is invalid
(1). A join definition is missing columns
(2). One or more column expression(s) or criteria expression is invalid
You need to promote to Production life cycle as soon as possible.
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