OCI-25555
complex predicate not allowed in operand of OR or IN when outer join operator (+) is present
Cause
When an outer join operator (+) is used in a predicate of either OR or IN, the outer join operator (+) is not allowed to include a complex predicate in OR or IN. For example, a predicate that contains a subquery is complex.
Action
Use ANSI outer join syntax instead.