SBL-DBC-00111, SBL-EAI-04451 And ORA-00957: duplicate column name Due To Wrong SQL When Updating Action Record Through REST (Doc ID 3071692.1)

Last updated on FEBRUARY 11, 2025

Applies to:

Siebel CRM - Version 24.8 and later
Information in this document applies to any platform.

Symptoms

A wrong SQL is generated intermittently when updating an action record through REST Interface :

INSERT INTO SIEBEL.S_EVT_MKTG (
  ACTIVE_FLG,
  ROW_ID,
  PAR_ROW_ID,
  MODIFICATION_NUM,
  CREATED_BY,
  LAST_UPD_BY,
  CREATED,
  LAST_UPD,
  DB_LAST_UPD,
  DB_LAST_UPD_SRC,
  CONFLICT_ID,
  PAR_ROW_ID)
VALUES (:1, :2, :3, :4, :5, :6, :7, :8, current_date, :9, :10, :11)

INSERT INTO SIEBEL.S_EVT_ACT_CAL (
  REPT_EVERYDAY_CD,
  PRI_ALARM_ID,
  REPT_DAYON_CD,
  REPT_END_CD,
  ROW_ID,
  PAR_ROW_ID,
  MODIFICATION_NUM,
  CREATED_BY,
  LAST_UPD_BY,
  CREATED,
  LAST_UPD,
  DB_LAST_UPD,
  DB_LAST_UPD_SRC,
  CONFLICT_ID,
  PAR_ROW_ID)
VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, current_date, :12, :13, :14)

This SQL then leads to the below error:

The issue occurs in 10% of the time, and is intermittent.

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

1. Invoke Custom REST API BS from POSTMAN.

2. The error occurs.