SQL Error Encountered When Deleting SA/SP Record
Last updated on JUNE 01, 2018
Applies to:Oracle Utilities Customer Care and Billing - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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
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
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