Oracle Error Message
ORA-30551: The index depends on a package/type body which does not exist
Reason for the Error
the functional indexes depends on a package/type body which does not exist
Solution
create the package/type body
ORA-30551: The index depends on a package/type body which does not exist
the functional indexes depends on a package/type body which does not exist
create the package/type body