SQL Error Encountered When Deleting SA/SP Record (Doc ID 2208398.1)

Last updated on NOVEMBER 30, 2016

Applies to:

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

Symptoms

An SA/SP record created in V2.3.1 cannot be deleted in V2.4. If an old SA/SP record created in V2.3.1 and converted to V2.4 is deleted in V2.4, the SA/SP User Exit returns an SQL Error. It is looking for a record in CI_CHG_LOG table which does not exist for old records because it was not populated during the upgrade.
 
ERROR
-----------------------
SQL Error code 000020100 occurred in module CIPCSAPR:XQ050 DELETE
Please contact your system administrator.
If you need support please supply the following info to system support:
Message number: 3,3

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open an SA that has an SA/SP relationship
2. From the SA maintenance page, go to SA/SP tab
3. Delete the SA/SP record
4. Save

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