Award DFF to be read only and populated with a value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Award DFF to be read only and populated with a value

edited Feb 7, 2025 2:09PM in Project Management 1 comment

Summary:

I am trying to write a table validation value set to be used on a DFF to populate a read only field with the num defined in another value set. Can we use a bind variable to point to the award number? It is working when pointing to another DFF but having issues pointing to the award number.

Value set: Award to Num

Flex_Value

FFVV.description

Award A

123

Award B

234

Award C

456

Value set: Table Validation AwardNum_View

select substr(FFVV.description ,1,25)

from FND_FLEX_VALUES_VL FFVV

where

value_category = 'Award and Num'
AND FFVV.ENABLED_FLAG = 'Y'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!