Certificate store key and password retrieval

The default keystore password for cacerts is ‘changeit’.

When the password has been changed, it is uploaded into the fnd_vault. To retrieve it, use:

set serveroutput on
declare
storepass varchar2(30);
keypass varchar2(30);
begin
ad_jar.get_jripasswords(storepass, keypass);
dbms_output.put_line(storepass);
dbms_output.put_line(keypass);
end;

The same can be used to get the storepass/keypass for signing custom jar files in $JAVA_TOP in eBS 12.2