Help required in create_project API-CSDN博客

I am getting following error

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

This error comes when the key player person is not assigned a job in HRMS. But the person is assigned with one job too, still it is giving this error. My program is working fine on other instances, we just moved the custom program on new instance, and it seems there is some setup issue for that person. We are not able to know the required setup. Becasue the error says that person should have job assigned to it. There must be more setup issues.

I need such document reference which can tell the reasons for this error, and also does somebody help in in finding the location of this error message in pa_project_pub.create_api. I tried to debug that api, But I am not able to find it out. Is there any method by which we can easily find the origin place of this error?

Any kind of help is appreciated.

you may run the following query to see if the person has active assignment

select effective_start_date,
effective_end_date,
assignment_status_type_id,
organization_id,
job_id,
primary_flag,
assignment_type,
period_of_service_id
from per_all_assignments_f
where person_id in (select person_id from per_all_people_f where full_name=:X_FULL_NAME)

primary_flag should be "Y". The current system date should be within the active dates of assignment

Check the organization_id and job_id are populated. The person shoudl have a job.

The fnd user record should be associated to the person. check the following query

select * form. fnd_user where employee_id in (select person_id from per_all_people_f where full_name=:X_FULL_NAME)

replace the :X_FULL_NAME with the person's full name