OCI-42619
Cannot create JSON Relational Duality View 'string': The WHERE clause does not satisfy referential constraint.
Cause
The columns specified in the WHERE clause that join two tables violate referential integrity.
Action
Modify the struct of the tables or the DDL such that the WHERE clause joins the tables using the primary key (or unique key if the table is not the root table) of the parent table and the foreign key of the child table, or such that the WHERE clause joins the tables using the foreign key of the parent table and the primary key or unique key of the child table.