Unable To Change Objects In Siebel Tools Using Workspace_SBL-DAT-00523 (Doc ID 2345990.1)

Not able to modify any object in any worksapre, siebel is returning error

APPLIES TO:

Siebel Tools - Version 17.3 [IP2017] and later
Information in this document applies to any platform.
SYMPTOMS
On : 17.3 [IP2017] version, Configuration - Dev Env

When attempting to make any change to objects in siebel tools using workspace,
the following error occurs.

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. login siebel tools,
2. open workspace
3. locate object (business component, applet, etc)
4. change any object property

CAUSE

UPDATE SIEBEL.S_WORKSPACE SET
  DB_LAST_UPD_SRC = :1,
  DB_LAST_UPD = current_date,
  LAST_UPD = :2,
  LAST_UPD_BY = :3,
  MODIFICATION_NUM = :4,
  LATEST_VER = :5,
  OBJ_LOCKED_BY = :6,
  OBJ_LOCKED_DATE = :7,
  OBJ_LOCKED_FLG = :8,
  STATUS_CD = :9
  WHERE
  ROW_ID = :10 AND LATEST_VER = :11 AND STATUS_CD = :12 AND MODIFICATION_NUM = :13

SQLParseAndExecute Bind Vars 4 000000025a4c0f28:0 2018-01-03 13:15:28 12:
SQLParseAndExecute Bind Vars 4 000000025a4c0f28:0 2018-01-03 13:15:28 13: 0

In this case, in the criteria, its searching on STATUS_CD with an empty string.


SOLUTION
There are many reasons on why the error "SBL-DAT-00523" is occurred but in this case issue is solved after changing the multi_lingual_flg value for LOVs to N, including the following:

VER_DEPLOYMENT_STATUS
WORKSPACE_CONTEXT_INFO
WS_MERGE_STATUS

Source:
https://support.oracle.com/ > Doc ID 2345990.1