Wednesday, January 14, 2009

The Function Is Not Available Under The Responsibility

Cause

This issue is caused by launching the menu item before the Compile Security has completed.

When a function is added to a menu , a concurrent program 'Compile Security' is submitted which
loads the data in Fnd_Compiled_Menu_Functions table.

Whenever a function is accessed, security code checks Fnd_Compiled_Menu_Functions table to
determine whether that function is accessible under the given security context or not. So if this
function is accessed before the 'Compile Security' program is finished, the function cache gets
loaded with stale data and the reported error message is thrown.

So after modifying the 2 menu definitions associated with 'System Administrator' and 'Application
Developer' make sure that 2 concurrent requests submitted for the above 2 modifications completed
normally and then try to access the functions.

Further once this error occurs, it will be cached which means that even after the menu item has
been flagged as available, it the error will be returned from the cache.

Solution

-- To implement the solution, please execute the following steps::
1) Manually run the 'Compile Security' concurrent program with parameter "YES"
2) Shut down Middle Tier (Apache)
3) Restart Middle tier
4) Test the menu item