Oracle Error Message
ORA-12015: cannot create a fast refresh materialized view from a complex query
Reason for the Error
Neither ROWIDs and nor primary key constraints are supported for complex queries.
Solution
Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view.