Error-ORA-01400: Cannot Insert NULL Into ("FUSION"."HXT_TCLAYFLD_DEFNS_TL"."NAME") (Doc ID 2111489.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Fusion Time and Labor Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.10.0.0 version, Time and Labor Setup

Receiving error-ORA-01400: cannot insert NULL into ("FUSION"."HXT_TCLAYFLD_DEFNS_TL"."NAME")

There were created 20 different time card field, which customer needs to attach on the layout set.

They cannot proceed further due to error message : "You cannot add this field because limit has been reached for the time attribute data type mapped to this field.
ORA-01400: cannot insert NULL into ("FUSION"."HXT_TCLAYFLD_DEFNS_TL"."NAME")
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms