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

MOSC Banner

Problem with where clause

edited Jun 8, 2016 9:02AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 3 commentsAnswered

Hi

we have created a new srf and now no entries are visible under Catalog-Categories. Looking into the logfile I can see that the search spec is different from the old srf, but I cannot find out what I need to check in Siebel Tools.

Actually the question here is around following log entry:

Problem comes from following sql statement

SELECT

      T5.CONFLICT_ID,

...

      :1

   FROM

       SIEBEL.S_CTLG T1,

       SIEBEL.S_LST_OF_VAL T2,

       SIEBEL.S_LIT T3,

       SIEBEL.S_LIT T4,

       SIEBEL.S_CTLG_CAT T5

   WHERE

      T5.THMBNL_IMAGE_ID = T3.ROW_ID AND

      T5.DSPLY_TMPL_CD = T2.VAL

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