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

MOSC Banner

EBC with a table join, outer join flag = true, but still an inner join is generated

edited May 7, 2013 7:23AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 1 commentAnswered
Siebel Community,

I've been looking around Siebel Bookshelf and Support Web, but can't seem to find this anywhere.

I have an EBC (External Business Component) configured on an external database with two tables in it (the two tables reside in the same database/datasource).  I have a Join between the two tables on the business component and I have specified I want an Outer Join.  It's pretty simple and straightforward.

However, in the generated SQL, Siebel keeps putting INNER JOIN (highlighted below):

SELECT
      T2.ACTVTY_TS,
      T2.ACTVTY_TYP_NM,
      T2.ACTVTY_USER_ID,
      T1.MORTGEE_ADDR_LINE1,
      T1.MORTGEE_CITY_NM,

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