How can I use LOCATION_ID in a DFF to fetch value from Common Lookups
Hello folks,
I have created a common lookups, and created a table type value set. I have used FROM clause and WHERE clause as follows:
Now, when I am selecting this same value set in the DFF, and selecting Derivation Value as LOCATION_ID, it gives an error message, "The derivation value LOCATION_ID is not valid. (FND-2626). In application 800 and descriptive flexfield PER_POSITIONS_DFF, the derivation value for global segment IP_TSA_SCHEDULING_TITLE must refer to an enabled flexfield parameter with the same data type as the segment's column".
How can I resolve this issue?