Manage Purchasing Value Sets - Table Validation - DFF — 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

Manage Purchasing Value Sets - Table Validation - DFF

edited Jul 10, 2025 2:08PM in Purchasing

I have a validation set code with validation type 'Table'.

It allows me to get some specific data for my DFF (costCenter).

But we've got a new need from the client where we need to filter based on a DFF value that's specified in the Manage Location page ( we do the link with default location id in the requester preference in RSSP)

I added this part in my clause where, but it's not working :
From :
GL_LEDGERS l ,FND_KF_SEGMENT_INSTANCES B ,FND_KF_STR_INSTANCES_B SI ,FND_KF_SEGMENTS_B SG ,FND_VS_VALUES_VL v ,FUN_ALL_BUSINESS_UNITS_V bu

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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