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

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.1.0 and later   [Release: 2.1 and later ]
Information in this document applies to any platform.

Goal

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

ERROR
-----------------------
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.

STEPS
-----------------------
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.

EXPECTED BEHAVIOR
---------------------------
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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users were confused and the processing delayed.

Solution

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