Oracle Error Message
ORA-23501: refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
Reason for the Error
Instantiation of a refresh template is not supported for database compatibility 8.0 or less.
Solution
Be sure the database compatibility is 8.1 or above.