Error SBL-DAT-00523 occurs when a script updates the current record through a second BC instance (Doc ID 1127053.1)

Last updated on JUNE 30, 2023

Applies to:

Symptoms

Scenario

A script was created on a business component event handler for updating the current record. The script needs to  update fields that have not been activated in the current BC instance. However, as the current instance exists in UI context, the programmer decided to update the current record through a new instance of the BC:

1. Get current record ID.
2. Save the current record.
3. Instantiate new BO.
4. Get a new instance of the current BC through the new BO.
5. In the new BC instance, query for the ID from step 1.
6. Update the returned record in the new BC instance as desired.
7. Save the record in the new BC instance.

Issue

A user accesses this BC through the UI and triggers the script. After that, the user modifies the record through the UI and tries to save it. However, this causes an error message:

"The selected record has been modified by another user since it was retrieved. Please continue. (SBL-DAT-00523)"

The script took care to save the current record before updating it through the second BC instance, so why is there an update conflict?

Cause

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