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

MOSC Banner

Fields based on Joins with Outer Join = TRUE, when used in a search, get generated as INNER JOIN in

edited Jul 16, 2012 9:09PM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 1 commentAnswered
Siebel Community,

I have a custom business component with several explicit Joins, whose Outer Join Flag's are all set to TRUE.  This business component does not have one single Inner Join.  There are several fields on the Business Component, referencing these Joins.  If a field mapped to one of those Joins is used in the Business Component Search Spec, or a search is done on the applet using one of those fields in a QBE, Siebel generates the SQL with INNER JOINS - instead of LEFT OUTER JOIN.  The Outer Join flag is being ignored.  I can remove the fields from the Search

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