ORA-00904: "UTILS_PKG"."GET_OFFER_DESC": invalid identifier

Execution of package UTILS_PKG results in below error:

ERROR at line 12:
ORA-00904: "UTILS_PKG"."GET_OFFER_DESC": invalid identifier

Solution 1: Check the status of the package in DBA_OBJECTS

select * from dba_objects where object_name='UTILS_PKG';

Check within the code of UTILS_PKG. This issue can come when there is no function or procedure defined within the package UTILS_PKG.


Solution 2: Dependent Package/procedure is not Valid.

select * from dba_dependencies where NAME='UTILS_PKG';


Solution 3: There is a mismatch in Timestamp of object creation with their dependent objects.
In this case you can try running utlrp.sql

sqlplus / as sysdba
SQL> @?/rdbms/admin/utlrp.sql