Supplier Management

Get Involved. Join the Conversation.

Topic

    Marko Knezevic
    Supplier Descriptive Flexfield DFF number checkboxAnswered
    Topic posted June 13, 2019 by Marko KnezevicBronze Medal: 1,250+ Points, tagged FAQ, How-To 
    109 Views, 7 Comments
    Title:
    Supplier Descriptive Flexfield DFF number checkbox
    Summary:
    Is it possible to add Global Segment Data Type: number and Display Type: checkbox?
    Content:

    Hi,

    I need to use checkbox with my Global Segment DFF in order to enable my supplier managers to mark the supplier or unmark.

    The data type for this checkbox segment must be number because I need it for SQM to automatically create qualification based on the value of the checkbox.

    How to set my DFF Global segment as number and use checkbox? Is it possible?

    Thank you

    Version:
    19A

    Best Comment

    Piyush Singh

    Check box with number data type is not supported, using lov seems to be the only option.

    Thanks,

    Piyush

    Comment

     

    • Piyush Singh

      Hi Marko,

      Trying to understand the relationship between the check box and how do you relate it to SQM to automatically create Qualification? Can you provide more details on the use case? Example will help.

      Thanks,

      Piyush

      • Marko Knezevic

        Hi Piyush,

        In SQM, I have created a question which will read the value from DFF and automatically generate score and a QA which contains this question and will qualify the supplier with automatic outcome according to the scoring rule I add.

        The question setup => Responder Type: automatic, mapped to suppllier attribute (select Additional information and the DFF I want to use).
        In order to use automatic scoring with this question, I need the DFF to be numeric (this is the only way to user automatic scoring).

        Is there a way to set the DFF to be Display Type: checkbox and Data Type: number? I have tried to create a Global Segment DFF Data Type numeric and with an independent value set, value set values 0 and 1 but can't use Display Type: checkbox.

        The error I get:The display type of the segment is not compatible with its value set. (FND-2881)

        Thanks

        • Piyush Singh

          Hi Marko,

          Thanks for sharing the use case. The intent of a check box is to ensure you capture value as either true or false (0 or 1). Will not having DFF displayed as LOV instead of a check box help? Using LOV you can have numeric values displayed in the dropdown.

          Hope this will help you achieve your requirement.

          Thanks,

          Piyush

          • Marko Knezevic

            Piyush,

            I know I can use LOV, but the numeric display doesn't suit our need since the DFFs will be used to mark true or false.
            If I use LOV, then the value 0 or 1 is visible as the value for DFF on supplier profile but I would like to display some text or simply checked checkbox.

            The real purpose of the DFF will be to mark the if the supplier needs to be added to the Assessment initiative this year for example.

            Thanks,

            Marko

            • Piyush Singh

              Check box with number data type is not supported, using lov seems to be the only option.

              Thanks,

              Piyush

              • Marko Knezevic

                I am sorry to hear that.

                I have seen that number can't be used with checkbox, however it was confusing to see that the option to select checkbox has appeared in my case (perhaps because the value set values contains only two options?).

                Perhaps in the future we could use number DFF if it has two values 0 and 1 with checkbox.

                Thank you,
                Marko