Materialized View
The developer (vndtst) is trying to create a Materialized View owned by an application schema.
The Materialized View is selecting from a tables in a remote database using a public database link. The user being used in the db link has "select any table" privilege granted to it directlt on the remote database.
The developer has "create any Materialized view" and "create Materialized View" privileges granted directly and create any table granted through a role.
The developer is able to create the MV in his own schema but not in the Application Schema. I looked up documentation and don't seem to be missing any privileges.