Value Set validation on std form error
Hello All,
I am running R12.1.3
I have a custom value set xxprk_log_contact that is used in a DFF that causing problems.
SELECT full_name, person_id
FROM per_all_people_f
WHERE EMPLOYEE_NUMBER IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND NVL(CURRENT_EMPLOYEE_FLAG,'N')='Y'
If I end date an employee I get an error something like "the flexfield segment X does not exit in the value set Y" every time I open the form with that user in the DFF.
How do I only list the current employees when entering data on the DFF, yet when a employee has been end dated, not generate the error on a record they were previously assigned?
I am running R12.1.3
I have a custom value set xxprk_log_contact that is used in a DFF that causing problems.
SELECT full_name, person_id
FROM per_all_people_f
WHERE EMPLOYEE_NUMBER IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND NVL(CURRENT_EMPLOYEE_FLAG,'N')='Y'
If I end date an employee I get an error something like "the flexfield segment X does not exit in the value set Y" every time I open the form with that user in the DFF.
How do I only list the current employees when entering data on the DFF, yet when a employee has been end dated, not generate the error on a record they were previously assigned?
Tagged:
0