Oracle Error ORA-30344: number of child cols different from number of parent level cols

Oracle Error Message

ORA-30344: number of child cols different from number of parent level cols

Reason for the Error

The number of child columns specified in a JOIN KEY clause is not the same as the number of columns in the specified parent level.

Solution

Check the child columns and the columns in the definition of the referenced parent level and correct the discrepency.