Record Disappears When Edited By Two Users At The Same Time And One Changes The Sales Team - Error SBL-DAT-00494 (Doc ID 1285415.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1 [21112] and later
Information in this document applies to any platform.
""Checked for Relevance on 22-09-2015""

Symptoms

When 2 users try to edit a record at the same time, the last one to save gets error SBL-DAT-00494 or SBL-DAT-00523 depending on if the record has been updated or deleted by the first user. This is expected.

However, when user 1 and user 2 are both editing the same record, and user 1 changes the primary position in the sales team and remove the position previously set as primary, and user 2 update any other field and saves the record before user 1 has saved it, user 1 get error SBL-DAT-00494 and its changes are only partially rolled back. It happens well for the primary position change but not for the removing of the position. As a result the Primary Position ID is invalid and after a re-query the record is not longer visible (except in a view in admin mode).

Cause

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