My Oracle Support Banner

Users Unable To Mark Not Null Column As Not Used In Transformation (Doc ID 2802006.1)

Last updated on JULY 13, 2023

Applies to:

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

Goal

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

Solution

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
Goal
Solution


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