This content has been marked as final. Show 3 replies
If your requirement is that if an employee adds a record in EIT, certain fields like grade, department, location etc should get auto populated then you can achieve this as below:
Lets take a simple case where you want to default the department( organization_id), then while SIT definition for the respective segment select dafault type as SQL Statement and default value as
select organization_id from PER_ALL_ASSIGNMENTS_F PAAF where 1 = 1 and PAAF.PERSON_ID = FND_GLOBAL.EMPLOYEE_ID and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
What I am trying to do is select the organization_id for the loged in person which you can derive easily using FND_GLOBAL.EMPLOYEE_ID.
Hope this helps.