We are facing lock contention and Application Hang when we try to search vacation rules or to search workflow using below navigation
WorkFlow Administrator --- Home --- status monitor -- search user and keep the page open
Same Time Same or other user try to navigate the same page. It hangs and i can see that there is lock in FND_USER_PREFERENCES tables.
The problem is that the patch is available for 11.5 not for EBS 12.1
When i search the user notification why the update query on FND_USER_PREFERENCES start as it is not required.
My Env Details -
DB -- 220.127.116.11
EBS -- 12.1.3
OS - Oracle Linux 6
Please assist on this.
Thanks and Regards,