Encountered ORA-22922: Nonexistent LOB Value On Batches After DB Upgrade From To

(Doc ID 2194741.1)

Last updated on OCTOBER 31, 2016

Applies to:

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


On : CCB 2.3.1 version, IP - Installation Upgrade Proc

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

Some CM batches (CM-MCONI) 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.




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