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.
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;