Unable to get passwords from Vault

Completed database cleanup for previous session.

Error: Unable to execute statement <
Begin
ad_jar.get_jripasswords(:l_storepass, :l_keypass);
End;
> len = 63

AD Administration error:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 101
ORA-06512: at "APPS.AD_JAR", line 17
ORA-06512: at line 3


AD Administration error:

Unable to get passwords from Vault


You should check the file
/u02/applgstR12/apps/apps_st/appl/admin/FMSGST/log/adadmin.log

for errors.


Solution:

Run adgrants.sql

sqlplus sys "/as sysdba" @adgrants.sql APPS