Unable to make changes to the Object with the newly created Workspace after the upgrade (Doc ID 2497349.1)

APPLIES TO:

Siebel Tools - Version 18.12 and later
Information in this document applies to any platform.
SYMPTOMS

Unable to make changes to the Object with the newly created Workspace after the upgrade


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login into the tools
2. Create a Workspace dev_sadmin_deu_test
3. In the Action BC > try to inactivate a MVL
4. Getting following error"The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)"

CAUSE
In the SQL which is causing this Issue STATUS_CD is empty

UPDATE siebel.S_WORKSPACE SET
  DB_LAST_UPD = current timestamp,
  LAST_UPD = ?,
  LAST_UPD_BY = ?,
  MODIFICATION_NUM = ?,
  LATEST_VER = ?,
  OBJ_LOCKED_BY = ?,
  OBJ_LOCKED_DATE = ?,
  OBJ_LOCKED_FLG = ?
  WHERE
  ROW_ID = ? AND LATEST_VER = ? AND STATUS_CD = ? AND MODIFICATION_NUM = ?


SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 1: 2019-01-17 10:34:36.000000

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 2: 0-1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 3: 1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 4: 1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 5: 0-1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 6: 2019-01-17 10:34:36.000000

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 7: Y

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 8: 5-PFVTF1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 9: 0

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 10:

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 11: 0

SQLParseAndExecute Execute 5 000000025c401710:0 2019-01-17 10:34:36 0s

SQLParseAndExecute Execute 5 000000025c401710:0 2019-01-17 10:34:36 DML statement affected 0 rows

EVIDENCE OF CAUSE
---------------
UPDATE siebel.S_WORKSPACE SET
  DB_LAST_UPD = current timestamp,
  LAST_UPD = ?,
  LAST_UPD_BY = ?,
  MODIFICATION_NUM = ?,
  LATEST_VER = ?,
  OBJ_LOCKED_BY = ?,
  OBJ_LOCKED_DATE = ?,
  OBJ_LOCKED_FLG = ?
 WHERE
  ROW_ID = ? AND LATEST_VER = ? AND STATUS_CD = ? AND MODIFICATION_NUM = ?


SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 1: 2019-01-17 10:34:36.000000

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 2: 0-1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 3: 1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 4: 1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 5: 0-1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 6: 2019-01-17 10:34:36.000000

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 7: Y

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 8: 5-PFVTF1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 9: 0

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 10:

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 11: 0

SQLParseAndExecute Execute 5 000000025c401710:0 2019-01-17 10:34:36 0s

SQLParseAndExecute Execute 5 000000025c401710:0 2019-01-17 10:34:36 DML statement affected 0 rows



SOLUTION
When two languages are installed then both the Languages Seed Data needed to by installed. For ex: if ENU and DEU is installed and DEU is the base language. Both the ENU and DEU seed data has been installed as we need all the LOV's values related to both the Languges

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