ORA-40556
unsupported chaining of two JSON_TABLE expressions
Cause
The output of one JSON_TABLE expression was provided as direct input to a second JSON_TABLE expression (possibly from a view definition). Such chaining should be avoided for performance reasons.
Action
First, try to combine multiple JSON_TABLE expressions into one using the JSON_TABLE NESTED PATH clause. If this is not possible, then apply a JSON or JSON_SERIALIZE operator to the input of the second JSON_TABLE to break the chain.