ORA-63105
Single-row unnested sub-object returned more than one row.
Cause
More than one row is being returned for the specified sub-object, which is not allowed.
Action
Change the data to ensure that only one row is returned for the specified sub-object. Alternatively, change the view definition to make this sub-object an array.