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

Job Req DFF - For Replacement showing duplicates in Valueset

Summary:

On The Job Req we have an option to select that it is a replacement for an employee.

Here is my Value Set:

From Clause “PER_ALL_PEOPLE_F PAPF,PER_PERSON_NAMES_F PPNF”

Value Column Name “PAPF.PERSON_NUMBER||' - '||PPNF.DISPLAY_NAME”

Where “1 = 1

AND TRUNC(SYSDATE)BETWEEN PAPF.EFFECTIVE_START_DATE AND

PAPF.EFFECTIVE_END_DATE

AND PPNF.PERSON_ID=PAPF.PERSON_ID”

Oreder by clause “1”

But it shows multiple options for each employee - is there a way to remove duplicates or add the assignment number to it?


Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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