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


Article ID: 124905


Updated On:


CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise


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?


Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment


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;