My Oracle Support Banner

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

Last updated on MAY 31, 2024

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

**Examples provided in this article do not represent real life personal/confidential information. Please use proper values to your businees.**
**Disclaimer:** This KM article may include the following abbreviations:

CCB/CC&B - Oracle Utilities Customer Care and Billing
OUAF/FW - Oracle Utilities Framework

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.