Vertex Implementation: ORA-22922 Nonexistent LOB Value (Doc ID 2162772.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.2.4.2 and later
Information in this document applies to any platform.

Symptoms

On RMB 2.2.4.2 version, FW 2.2.0 BI - Billing

Billing is not getting completed due to the following error. As per User, it is reproducible.

Below are the environment details gathered:
1) Version of Java - jdk1.6.0_45
2) JDBC driver version - ojdbc6-11.2.0.3
3) Database Engine and its version - 11.2.0.4.0
4) RMB & FW version - 2.2.4.2 32365 & V2.2.0 16 11116 000
5) No recent upgrades/changes in the environment for Oracle or 3rd party components
6) AWR Report, Installed_Fixes log & Threadpool logs are available for a review
 
ERROR
-----------------------
09:29:31,823 [CobolThread 16] ERROR (org.hibernate.util.JDBCExceptionReporter) ORA-22922: nonexistent LOB value
09:29:31,823 [CobolThread 16] ERROR (org.hibernate.event.def.AbstractFlushingEventListener) Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [com.splwg.domain.outboundMessage.outboundMessage.OutboundMessage__#OutboundMessage_Id(369456650533)]
  at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
  at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
  at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2420)
  at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2302)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the billing batch and it fails with above error message

BUSINESS IMPACT
-----------------------
This is affecting their operations and needs a fix.

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