Missing Responsibilities after applying Patch 9114911

Problem:

After  applying patch 9114911, when I logged into the Oracle Application from front-end I was unable to see any responsibilities over there.

Cause

The data in Workflow Directory tables is fine, as the responsibilities are available in Forms.
The problem comes from profile "FND: Disable Configurable Home Page" (FND_CONFIG_HOMEPAGE_DISABLED) that has been set to "No" during the upgrade, thus enabling the Configurable Home Page.

Solution

1- As SYSADMIN, login directly to Forms. The URL for login to Forms would be like :

http://<hostname:port#>/forms/frmservlet?form_params=+config=<name of dbc>.dbc

2- Choose "System Administrator" responsibility, then navigate to Profile / System

3- Query profile "FND: Disable Configurable Home Page", and set it to "True" at Site level

4- Query profile "Enable Configurable HomePage" and set it to "No" at Site Level

5- Bounce the web server

6- Verify the issue


Note : If error is received while login to Forms, i.e. it will not be possible to update the profiles from Forms, then the following script can be used to update the profiles from backend :

sqlplus apps/<password>
set serveroutput on

declare
 stat boolean;
begin
 stat := FND_PROFILE.SAVE('FND_CONFIG_HOMEPAGE_DISABLED', 'TRUE', 'SITE');
 IF stat THEN
    dbms_output.put_line( 'Profile FND_CONFIG_HOMEPAGE_DISABLED updated to TRUE' );
 ELSE
    dbms_output.put_line( 'Profile FND_CONFIG_HOMEPAGE_DISABLED NOT updated' );
 END IF;
stat := FND_PROFILE.SAVE('FND_CONFIG_HOMEPAGE_ENABLED', 'N', 'SITE');
 IF stat THEN
    dbms_output.put_line( 'Profile FND_CONFIG_HOMEPAGE_ENABLED updated to N' );
 ELSE
    dbms_output.put_line( 'Profile FND_CONFIG_HOMEPAGE_ENABLED NOT updated' );
 END IF;
end;
/