value Set Filtering – How to Hide End-Dated Lookup Values While Still Displaying Historical Records?

Summary:

Hello everyone,

I am currently working on a value set configuration in Oracle Fusion HCM and would like to seek guidance on handling historical lookup values.
Requirement:

1. End-dated (obsolete) lookup values should not appear in the dropdown for new records
2. However, these values should still remain visible in existing (historical) records

What I have tried:

1. Using date-based filtering in the value set » This successfully hides end-dated values from the dropdown. However, historical values are no longer displayed in existing records.
   
   LOOKUP_TYPE = 'xxxxx'
   AND ENABLED_FLAG = 'Y'
   AND (END_DATE_ACTIVE IS NULL OR TRUNC(END_DATE_ACTIVE) >= TRUNC(SYSDATE))