Notifications for Approval going to POSITION but not to the person attached on that Position

How do we Debug the Issue when Notifications for Approval is going to POSITION but not to the person attached on that Position

1) Below are the list of Approval Notification which has to be fired to the Person attached to that position

Recipient Role: "POS:24656"

Query for Reference:

SELECT   *
  FROM   apps.wf_notifications
 WHERE   RECIPIENT_ROLE = 'POS:24656' AND status = 'OPEN'



2) Extract the details of the Employee Attached to the Position to which approval Notification should be fired
i.e. User Name of Employee

Query for Reference:

SELECT   fu.user_name
  FROM   apps.fnd_user fu, per_people_x per, per_assignments_x paaf
 WHERE       per.person_id = fu.employee_id
         AND per.person_id = paaf.person_id
         AND paaf.assignment_status_type_id IN (1, 2)
         AND paaf.assignment_type = 'E'
         AND paaf.primary_flag = 'Y'
         AND paaf.position_id = 24656

3) Now we need to check if the role (Position) is assigned to each of the Workflow local tables which is used to send  notification based on the Position attached. The following query would help you to trace the same

a) Status Should be ACTIVE

SELECT   *
  FROM   apps.wf_local_roles
 WHERE   name = 'F29483';

b) Check if the Role is Active and  Attached as per the Position of the Employee e.g: POS:24656
SELECT   *
  FROM   apps.wf_local_user_roles
 WHERE       user_name LIKE '%29483%'
         AND role_name LIKE 'POS%'
         AND user_orig_system = 'PER'

c) Check if the Role is Active and  Attached as per the Position of the Employee e.g: POS:24656
SELECT   *
  FROM   apps.wf_user_roles
 WHERE       user_name LIKE '%29483%'
         AND role_name LIKE 'POS%'
         AND user_orig_system = 'PER'

d) Check if the Role is Active and  Attached as per the Position of the Employee e.g: POS:24656
SELECT   *
  FROM   apps.wf_user_role_assignments
 WHERE   user_name LIKE '%29483%' AND role_name LIKE 'POS%'

4) Run the below seeded Program's if any of the above query doesn't show the roles assigned

a) Request Name: Synchronize WF LOCAL tables
Parameters:
Orig System: "POS"
Raise Errors: "Yes"

b) Request Name: Workflow Directory Services User/Role Validation

Parameters:

User Name: <Desired User Name>

Fix Dangling Users: "Yes"

Add/Missing User/Role Assignment: "Yes"

Update WHO Columns in WF Tables: "Yes"