EBC with a table join, outer join flag = true, but still an inner join is generated
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,