My Oracle Support Banner

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

Last updated on JUNE 01, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.