My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

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


On RMB 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-
3) Database Engine and its version -
4) RMB & FW version - 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
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(
  at org.hibernate.exception.SQLStateConverter.convert(
  at org.hibernate.exception.JDBCExceptionHelper.convert(
  at org.hibernate.persister.entity.AbstractEntityPersister.update(
  at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(

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

This is affecting their operations and needs a fix.


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.