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

Document ID : KB000124905
Last Modified Date : 20/02/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.
 
Additional Information:
1. Customer is not required to get the OAS license to use dbms_obfuscation_toolkit.md5 toolkit unless they want database encryption. To ensure successful upgrade make sure that Clarity schema (ex:- niku) have permissions to run the above toolkit.
2. Use the following query to Validate permissions. If the query runs successfully necessary permissions are present, otherwise you need to check back with your DBA and get necessary permissions on Clarity schema.

select SUBSTR(dbms_obfuscation_toolkit.md5(input => UTL_RAW.cast_to_raw(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'))),-32,32) FROM dual;