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 laterInformation 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:
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 |