ORA-42650
Cannot create JSON-relational duality view 'string': foreign key column 'string' of table 'string' should be selected to construct subobject 'string'.
Cause
The foreign key column should be selected if it is also part of the join condition.
Action
Add the foreign key column to the select list of the subobject.