My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On Oracle Data Management WorkBench 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

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