ORA-00904: "UTILS_PKG"."GET_OFFER_DESC": invalid identifier
Execution of package UTILS_PKG results in below error:
ORA-00904: "UTILS_PKG"."GET_OFFER_DESC": invalid identifier
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.
Or
Solution 2:
Dependent Package/procedure is not Valid.
select * from dba_dependencies where NAME='UTILS_PKG';
Or
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