ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Help required in create_project API

Help required in create_project API

原创 Linux操作系统 作者:dragon_88 时间:2013-05-22 11:26:46 0 删除 编辑
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

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

下一篇: EBS 常用变量
请登录后发表评论 登录
全部评论

注册时间:2011-03-10

  • 博文量
    137
  • 访问量
    171945