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
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10951282/viewspace-761729/ ,如需转载,请注明出处,否则将追究法律责任。