Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement gives a column-list for which there is no matching unique or primary key constraint in the referenced table. See the solution below.
Error solution: Find the correct column names using the ALL_CONS_COLUMNS catalog view
Database version: Oracle 11g Release 2 (11.2)