My Oracle Support Banner

Encountered ORA-22922: Nonexistent LOB Value On Batches After DB Upgrade From To (Doc ID 2194741.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 and later
Information in this document applies to any platform.


**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
OUAF/FW - Oracle Utilities Framework
LOB - Large object
DB - Database
CM - Customer Modification
JDBC - Java Data Base Connectivity
CLOB - Character large object


On CCB v2.3.1, IP - Installation Upgrade Proc

Encountered ORA-22922: nonexistent LOB value on Batches after DB upgrade from to

Some CM batches encountered encountered ORA-22922: nonexistent LOB value after Oracle DB upgrade from to

The issue does not occur on the previous version of DB On base batches there are no issues.

ORA-22922: nonexistent LOB value

The issue can be reproduced at will with the following steps:
1. Oracle DB upgrade from to
2. Submit a batch.

The issue has the following business impact:
Due to this issue, batch does not complete.


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.