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.
---------------------------------------------------
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.
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:
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 $
$Header: pqhwfsy.odf 120.0.12000000.2 2008/10/16 15:07:08 brsinha noship $
