Timeout issue when associating projects to program
Hi All -
I would like to ask for help regarding the timeout issue we are encountering when we associate a project to an existing program. Upon clicking Add Project button, the project look up is shown and after a while, an error is encountered: "Validation Query Timed Out".
We already increased the AUTO_COMPLETE_QUERY_TIMEOUT setting from 30 to 60. It was working for a while, but now the timeout issue is re-occurring.
Re: Timeout issue when associating projects to program
Please check if the user that you are using, the one that is getting this error, has the "View all Projects" access grant.
Run the below query for two different users, one who has the "View all Projects" access grant , and the other who does not have this access grant. select pm_utils.Has_Override_Access_Grant() from dual;