You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!