ORA-44997
unsupported chaining of two JSON_TABLE with minimal cross product
Cause
The output of one JSON_TABLE with minimal cross product is provided as direct input to a second JSON_TABLE with minimal cross product.
Action
Do not chain them.