My Oracle Support Banner

Delete Fails On Business Component With Errors (ORA-01723) (ORA-06550) (SBL-DAT-00236) (ORA-00932) (SBL-DBC-00111) (Doc ID 1538399.1)

Last updated on APRIL 29, 2021

Applies to:

Siebel CRM - Version 8.1.1 [21112] to [23016] [Release V8]
Information in this document applies to any platform.


When trying to delete a record, the following error occurs:

Steps to Reproduce

The issue can be reproduced with the following steps, using the Account Business Component as an example:

1. Configure auditing on a "Note" Business Component (or a field based on a column named TEXT that is of Type LONG) such as the following:

Account Note
Account Private Note

2. Go to the Accounts tab.
3. Select an Account record.
4. Define a child Note for the selected Account.
5. Delete the parent Account record.
6. Requery for the Account record.

Result: Error message is displayed and the Account record still exists:  the Account is not deleted.




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

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