Technology Stack - EBS (MOSC)

MOSC Banner

Value Set validation on std form error

edited Aug 20, 2021 10:47AM in Technology Stack - EBS (MOSC) 3 commentsAnswered
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?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center