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