Oracle Error ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier

Oracle Error Message

ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier

Reason for the Error

A value constituting the PRIMARY KEY-based object identifier is NULL.

Solution

Ensure the expressions in MAKE_REF system function or attributes in the WITH OBJECT OID clause of an object view do not evaluate to NULL.