ORA-42601
Cannot create JSON Relational Duality View 'string': join query to construct subobject 'string' must use all columns of a foreign key of table 'string'.
Cause
Not all columns of the foreign key, which were required to uniquely identify an object, were used in the join to construct the specified subobject.
Action
Specify all the foreign key columns in the join.