Automatically populate a DFF based on Supplier Creation Date

Hi Oracle Team,

We have created two DFF under Supplier Profile - Additional Information.

DFF 1: That has 3 options.

• High: Every year
• Medium: Every 3 years
• Low: Every 5 years

DFF 2: That has date format option with values added to select the date.

The user needs to reduce one step when creating a new supplier, instead of selecting the DFF 2, user want to have this DFF being populated automatically based on the following rule:

Rule 1

• If creation date is today data (3-5-2024)
• If DFF1 is High
• Then DFF2 should automatically select a date from one year (3-5-2025)

Rule 2

• If creation date is today data (3-5-2024)