Oracle Error ORA-32043: recursive WITH clause needs an initialization branch

Oracle Error Message

ORA-32043: recursive WITH clause needs an initialization branch

Reason for the Error

A WITH clause query referred to itself (recursive) but did not have a branch in a UNION ALL with no references to itself (the initialization branch or anchor member).

Solution

Rewrite the recursive WITH query to have a branch in a UNION ALL operation with no references to itself.