My Oracle Support Banner

CCB V2.2.0 Business Entity Does Not Validate Required Datetime/Date Fields In Custom Table (Doc ID 744950.1)

Last updated on JUNE 09, 2010

Applies to:

Oracle Utilities Customer Care and Billing - Version: and later   [Release: 2.2 and later ]
Information in this document applies to any platform.


Business Entity does not validate required datetime or date fields in custom table that results to a database error.

10:31:24,617 [main] ERROR (org.hibernate.util.JDBCExceptionReporter) ORA-01400: cannot insert NULL into ("V22ADM"."CM_LPSS_DATA"."CM_LAST_UPDT_DTTM")

10:31:24,632 [main] ERROR (org.hibernate.util.JDBCExceptionReporter) ORA-01400: cannot insert NULL into ("V22ADM"."CM_LPSS_DATA"."CM_LAST_UPDT_DTTM")

10:31:24,632 [main] ERROR (org.hibernate.event.def.AbstractFlushingEventListener) Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(
at org.hibernate.exception.JDBCExceptionHelper.convert(
at org.hibernate.jdbc.AbstractBatcher.executeBatch(
at org.hibernate.engine.ActionQueue.executeActions(
at org.hibernate.engine.ActionQueue.executeActions(
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(
at org.hibernate.impl.SessionImpl.flush(


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.