Need to Access Department ID in one of the DFF of PER_ASG_DF

Summary

Need to Access Department ID in one of the DFF of PER_ASG_DF

Content

All,

 

I have requirement where I will need to use Department Id from employee's assignment in one of the segments of Assignment Attributes DFF (PER_ASG_DF). I have had a look at multiple threads for the same but have not seen a proper answer to it.  I followed the below the steps:

1. Created a table type value which has the below condition

hou.ORGANIZATION_ID = :{PARAMETER.OrganizationId}

2. I then tried to enable one segment for Assignment Attributes DFF but while I tried to assign that value set to the segment I received the below error