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: 2.2.0.0 and later   [Release: 2.2 and later ]
Information in this document applies to any platform.

Symptoms


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(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.splwg.base.support.context.FrameworkSession.flush(FrameworkSession.java:1068)


Cause

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