Get Started with Redwood for Oracle Cloud HCM Begin Now
How to derive Job DFF segment information in Assignment DFF?
Summary:
We have a Job DFF where Bonus% is stored, we have a requirement to fetch Job DFF Bonus% in one of the attribute of PER_ASG_DF (Assignment Attributes).
Example: Bonus% is a Job DFF storing 8%, we created one attribute in PER_ASG_DFF to fetch Job DFF using table value set
Below is the code snippet we are using;
[Select ATTRIBUTE_NUMBER1 from per_job_f_vl
Where job_id = :{PARAMETER.JOB_ID}
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE]
If anyone has worked on a similar requirement earlier please share your inputs. Thanks!
Tagged:
0