My Oracle Support Banner

The Index Should Return To 0 Once The Max Value Is Reached In CCB (Doc ID 1325150.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

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


**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:
CCB/CC&B - Oracle Utilities Customer Care and Billing
OUAF/FW - Oracle Utilities Framework

When attempting to add a new characteristic on a Case,
the following error occurs.

The Web Server did not respond correctly

while the log file shows the error:
(web.common.XMLToPageBodyMapper) Could not parse XML document into PageBody
java.lang.NumberFormatException: For input string: " "

After further investigation, it was determined the sequence of the characteristics already added to the case has reached 999,and the application generated a 4 digits sequence number for the new characteristic to be added.
Since the SEQ_NUM column on the CI_CASE_CHAR table allows a maximum 3 digits number, the error message was raised.

The issue can be reproduced at will with the following steps:
1. Add new characteristics on a Case until the SEQ_NUM reaches the value of 999
2. Add a new characteristics
3. The reported error should occur.

The index should return to 0 once the max value is reached.
Kindly make sure that the index returning to zero does not affect the Primary key generation of the CI_CASE_CHAR table.


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.