PQH Role's Notification Preference has been changed to QUERY instead of MAILHTML (12.0.6)

Problem Description :
---------------------------------------------------
We have defined Few Roles in Application, in which we have defined users.
We observed that PQH Roles's notification has been changed to Query in wf_local_roles table.
Manager could not get notification. 

 Solution : 

--------------------------------------------------

1) Check for the patch: 8399271:R12.PER.A. Apply the patch 8399271.

2) Have check Notification preference for PQH role with below query.

SELECT DISTINCT NOTIFICATION_PREFERENCE FROM WF_LOCAL_ROLES WHERE
ORIG_SYSTEM ='PQH_ROLE';

3) after that we have execute update statement to set as MAILHTML.

update apps.wf_local_roles
set notification_preference = 'MAILHTML'
where name like 'PQH_ROLE%';

4) After that execute below command.

exec FND_PREFERENCE.put('PQH_ROLE', 'WF', 'MAILTYPE', 'MAILHTML');

5) than we have run request 'Synchronize WF LOCAL tables'

we found that Notification preference not change to 'QUERY' as expected.


6) Check the File version:

 File version is as below after applying the patch.
 $Header: pqhwfsy.odf 120.0.12000000.2 2008/10/16 15:07:08 brsinha noship $

Error Message 3205 : USER_NAME is not a valid role or user name.

Email address should be define in FND_USER and PER_PEOPLE_F tables for the User who is not getting workflow.
 
1) Check for Table : FND_USER
    End_date should be null for the user who is not getting Workflow.

2) Check For Table:  WF_LOCAL_ROLES
    Expiration_date should be null for the user who is not getting Workflow.

3) Run Request : Workflow Directory Services User/Role Validation.
   Schedule request periodically as per below parameter.