My Oracle Support Banner

PAXPREPR Not Able To Assign Active Employee As Project Key Member Error: The role assignment cannot complete because the selected person has no active Human Resources assignment for the current period of service. (Doc ID 2679379.1)

Last updated on MAY 14, 2024

Applies to:

Oracle Project Foundation - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

User is not able to assign active Employee as Project Key Member due to following error while adding an active employee as Project Key member:

  The role assignment cannot complete because the selected
  person has no active Human Resources assignment for the
  current period of service.


As per HRMS record, the employee is active and has active assignment. In the same way we were able to add another employee.

The following queries may be run to identify record with issue:

select asgn.assignment_id
   from per_all_assignments_f asgn,      
        per_assignment_status_types status,
        (select person_id, actual_termination_date from
per_periods_of_service
         union all
         select person_id, actual_termination_date
           from per_periods_of_placement) po
   where asgn.person_id                  = p_person_id
   and   nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)
   and   asgn.person_id                  = po.person_id
   and   po.person_id                   = p_person_id
   and   asgn.assignment_status_type_id  = status.assignment_status_type_id
   and   status.per_system_status in ('ACTIVE_ASSIGN', 'ACTIVE_CWK')
   and   asgn.assignment_type            in ('E', 'C')  
   and   rownum                          = 1;
   
   
select asgn.assignment_id
   from per_all_assignments_f asgn,
        per_assignment_status_types status,
        (select person_id, actual_termination_date
           from per_periods_of_service
         union all
         select person_id, actual_termination_date
           from per_periods_of_placement) po -- FP M CWK
   where asgn.person_id                  = p_person_id
   and   nvl(po.actual_termination_date, trunc(sysdate)) >= trunc(sysdate)
   and   asgn.person_id                  = po.person_id
   and   po.person_id                    = p_person_id
   and   asgn.assignment_status_type_id  = status.assignment_status_type_id
   and   status.per_system_status in ('ACTIVE_ASSIGN', 'ACTIVE_CWK')
   and   p_start_date between asgn.effective_start_date
                          and asgn.effective_end_date
   and   asgn.assignment_type in ('E', 'C');

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.