Oracle Error PLS-00714: supertypes’s AUTHID is DEFINER but supertype and subtype are not in same schema

Oracle Error Message

PLS-00714: supertypes’s AUTHID is DEFINER but supertype and subtype are not in same schema

Reason for the Error

The supertype’s AUTHID is DEFINER, but the supertype and subtype are defined in different schemas. SQL statements executed in dynamically dispatched methods can potentially pick up different values from database tables in the two schemas.

Solution

Create the subtype in the same schema as the supertype.