ORA-30401: JOIN KEY columns must be non-null

Cause: The dimension statement failed because the column(s) in the JOIN KEY clause permitted NULL values. The JOIN KEY columns are related to the columns of the dimension's skip levels in one or both of the following ways:

1. A skip level is defined over one or more of the JOIN KEY columns.

2. The attribute clauses of a skip level determine one or more of the JOIN KEY columns.

Action: Modify the JOIN KEY columns so that they do not allow NULL values

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/