Delete Existing Account Receiving SQL Error In CIPCACCR (Doc ID 2210552.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.1.0 to 2.5.0.2.0 [Release 2.5]
Information in this document applies to any platform.

Symptoms

On Customer Care and Billing : 2.5.0.1.0/2.5.0.2.0 version, CI - Customer Information

When attempting to delete an existing account, popup window displays showing SQL error in CIPCACCR

When attempting to delete an existing account, a popup window is displayed stating that an SQL error has occurred in CIPCACCR (SQL error 000099997).

ERROR
-----------------------
SQL error code 000099997

E05202 - 491492-29323-1 2016-11-28 15:58:07,228 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (api.program.Displayer_Impl) SQL error in CIPCACCR
E05202 - 491492-29323-1 2016-11-28 15:58:07,228 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (api.program.Displayer_Impl) 2016-11-28 User : E05202
E05202 - 491492-29323-1 2016-11-28 15:58:07,228 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (api.program.Displayer_Impl)
E05202 - 491492-29323-1 2016-11-28 15:58:07,229 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (api.program.Displayer_Impl) Error: S_CHKRI04
E05202 - 491492-29323-1 2016-11-28 15:58:07,229 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (api.program.Displayer_Impl) 000099997


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Delete an account
2. Failed with error SQL error code 000099997

Cause

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