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 04, 2023

Applies to:

Symptoms

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.

Changes

Cause

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