Default Value in Value Set based on SQL Query not auto-populated but user has to select.

Hi All,

We are trying to set up an Initial Default on a descriptive flexfield. We are trying to achieve it based on a SQL Query.

The field to be defaulted is a Value Set with values either as Y or N and to be derived based on an attribute(attribute1) in projects table based on Project number. This is not defaulting the field as expected. It is only restricting the value as either Y or N based on the query and user has to manually select the displayed option. Ideally we would want the value as either Y or N to be present automatically and not require user to select. Appreciate any leads or guidance on this.