Adding default value to a Shipment Lookup

Summary

Adding default value to a Shipment Lookup

Content

Getting the following error when creating a DFF at the shipment level

The default value must be a SQL SELECT statement that returns exactly one column whose data type matches that of the segment's column. (FND-2542)
In application 665, descriptive flexfield WSH_NEW_DELIVERIES, and global segment Pricing, the default value select creation_date from doo_headers_all where 1=1 and order_number = '100250' is not valid.