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

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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