Search notes:

ORA-04067: … not executed, … does not exist

Create a package without package body:

create or replace package tq84_ora_04067_pkg
   authid definer
as
   function f return number;
end tq84_ora_04067_pkg;
/

Create a view that uses the function in the package. The view compiles because the function tq84_ora_04067_view.f is declared even though the package body does not exist:

create or replace view tq84_ora_04067_view as
select
   tq84_ora_04067_pkg.f
from
   dual;

However, when the view is used, it will report the missing package body:

select * from tq84_ora_04067_view;
-- ORA-04067: not executed, package body "RENE.TQ84_ORA_0406._PKG" does not exist
-- ORA-06508: PL/SQL: could not find program unit being called: "RENE.TQ84_ORA_04067_PKG"
-- ORA-06512: at line 1

ORA-04067: … not executed, … does not exist

See also