ORA-00904: "DBMS_OBFUSCATION_TOOLKIT"."MD5" failing PPM upgrade

Document ID : KB000124905
Last Modified Date : 17/01/2019
Show Technical Document Details
Question:
During upgrade for PPM, an error is thrown:
 
1/15/19 4:21 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 11, column 20:
1/15/19 4:21 PM (ExecTask) PL/SQL: ORA-00904: "DBMS_OBFUSCATION_TOOLKIT"."MD5": invalid identifier
1/15/19 4:21 PM (ExecTask) ORA-06550: line 11, column 6:
1/15/19 4:21 PM (ExecTask) PL/SQL: SQL Statement ignored
1/15/19 4:21 PM (ExecTask)

How to proceed forward with this to resolution?
Answer:
dbms_obfuscation_toolkit.md5 is an Oracle toolkit generating encryption.
 
We suggest to check with the DBA team to ensure there is access to this toolkit and that the PPM database user can run it.