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

We have a dff on assignment and we want it to default it to yes or no checking the bargaining unit

edited Sep 23, 2025 1:20PM in Human Capital Management 1 comment

Summary:

Hi Team,
We have a dff on assignment and we want it to default it to yes or no checking the bargaining unit (a seeded field),
if we have bargaining unit as 01 - Salaried then dff value should be yes other wise no

We have chosen initial default
default type - sql
derviation value - BARGAINING_UNIT_CODE
default value-
SELECT CASE
WHEN FLV.MEANING = '01 - SALARIED' THEN 'Yes'
ELSE 'No'
END
FROM FND_LOOKUP_VALUES FLV,
PER_ASSIGNMENT_SECURED_LIST_V PAAF
WHERE FLV.LOOKUP_TYPE = 'BARGAINING_UNIT_CODE'
AND FLV.LOOKUP_CODE(+) = PAAF.BARGAINING_UNIT_CODE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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