[SYS] Good Design

Value Set in Oracle stores set of values, so that it can be used in elsewhere, in Descriptive Flexfield Segments, Key Flexfield Segments and even Concurrent Program Parameters.

How do we know the where-used?

Ans: Navigate to Application->Validation->Set, open the form, query the value set, click "Usages" button.