SQL Error Encountered When Deleting SA/SP Record
(Doc ID 2208398.1)
Last updated on JUNE 02, 2024
Applies to:
Oracle Utilities Customer Care and Billing - Version 2.4.0.0.0 and laterInformation 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! |
In this Document
Symptoms |
Cause |
Solution |