Cause
An attempt was made to use more than 255 levels of nested subqueries.
Action
Merge some of the subqueries into their containing queries, until there are less than 255 levels of nesting.
Oracle 26ai
ORA-01778
Error Message
maximum subquery nesting level exceeded