Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

EBC wrong fully querying for external table name instead of external table alias

edited Mar 20, 2019 3:23AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 6 commentsAnswered

Hi all,

According to bookshelf we have created/configure an EBC at IP 18.12. Unfortunately we have spotted that Siebel queries at external table name and not at alias.

BCLog DBCLogError 1 000009cd5c904b4e:0 2019-03-19 09:41:50 OCIStmtExecute: SELECT DISTINCT

      T1.X_MMC_0000001_0007,

      T1.X_MMC_0000001_0002,

      T1.X_MMC_0000001_0009,

      T1.X_MMC_0000001_0011,

      T1.X_MMC_0000001_0010,

      T1.X_MMC_0000001_0008,

      T1.X_MMC_0000001_0012,

      T1.X_MMC_0000001_0006,

      T1.X_MMC_0000001_0005,

      T1.X_MMC_0000001_0004,

      T1.X_MMC_0000001_0001,

      T1.X_MMC_0000001_0003,

      :1

   FROM

       SIEBEL.EX_MMC_0000001 T1

   WHERE

      (T1.X_MMC_0000001_0001 = :2)

ObjMgrLog Error 1 000009cd5c904b4e:0 2019-03-19 09:41:50 (oracon.cpp (4821)) SBL-DBC-00105: An error has occurred executing a Sql statement.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center