Users Unable To Mark Not Null Column As Not Used In Transformation
(Doc ID 2802006.1)
Last updated on FEBRUARY 21, 2023
Applies to:Oracle Health Sciences Data Management Workbench - Version 188.8.131.52 and later
Information in this document applies to any platform.
On Oracle Data Management WorkBench 184.108.40.206 version, Users are not able to mark not null column as Not used in Transformation.
Transformation Execution was failing with Error "ORA-01400: cannot insert NULL into ("SCHEMA"."TNAME"."COL"). One of the Column was defined as NOT NULL but the Transformation was not populating any value to it. Users wanted to get rid of the column .System did not allow to update the Column name as COL_NOT_USED and to set the NOT_USED attribute for the column in Transformation.
Is this an expected Behavior?
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