Creating a Recursive Join on a Business Component
If you create a recursive join, then you must make sure the Alias name of the join is different from the Table Name. If you use the same name with an inner join, then Siebel Tools displays the following error message:
Table 'T1' requires a unique correlation name.
If you use the same name with an outer join, then Siebel Tools displays the following error message:
Table 'T1' is in an outer join cycle.
An inner join is a join that contains an Outer Join Flag property that does not contain a check mark. An outer join is a join that contains an Outer Join Flag property that does contain a check mark.
To create a recursive join on a business component
Make sure the Alias name of the join is different from the Table Name.