Resolving "PLS-00201: identifier 'DBMS_SYSTEM.XXXX' must be declared" Error

Here is a failure sample. SQL> set serveroutput onSQL> alter package APPS.FND_TRACE compile body;Warning: Package Body altered with compilation errors.SQL> show errorsErrors for PACKAGE BODY APPS.FND_TRACE:LINE/COL ERROR-------- -----------------------------------------------------------------235/6 PL/SQL: Statement ignored235/6 PLS-00201: identifier 'DBMS_SYSTEM.SET_EV' must be declared.. By default, DBMS_SYSTEM package is accessible only from SYS schema. Also there is no public synonym created for this package. So, the solution...

Read More