Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

In a custom defined DFF, how to populate dynamic values specific to Qualifications page

edited Jun 14, 2021 9:28AM in Supplier Qualification Management 1 comment

Content

When we navigate to 'Manage Qualifications' page, under edit additional information
We have to define one DFF field
1) Here, we need the value from the response tab, that should get multiplied with 2080

The issue we are facing is dynamic values are getting populated instead of the value pertaining to specific supplier.

For better understanding, please go through the attached document.

We are trying to achieve this using below sql query in the value set.
But it's not working. (More than one value is getting populated. Please refer to the attachment provided.)

select
(pqrv.RESPONSE_VALUE_NUM*2080) abc
FROM
FUSION.POQ_QUESTIONS pq

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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