Issue
Custom verification functions of an oracle profile do not exist error in the Application even it exists in the Database.
Cause
Even though the function exists in the database, the public user role doesn't have permission to execute that function. So, it cannot be accessed from the Application level.
Resolution
Grant Execute permission for that specific function(s) to the PUBLIC role.
- PUBLIC is a default database role that all users are a member of.
- GRANT EXECUTE on [PROC_NAME] to PUBLIC. The result is that every user of the database and any new user(s) that are added will automatically be given permissions to execute this procedure.
For Example: -
GRANT EXECUTE on CML_OFFICE_SENSITIVE_DATA TO PUBLIC;