JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierQualificationQuestionsacceptableResponses

Lists potential valid answers or response choices for a qualification question, ensuring standardized input options.

Columns

Name Type Description
SupplierQualificationQuestionsQuestionId [KEY] Long Unique identifier for the question that this acceptable response applies to. This ID links the acceptable response to a specific question.
AcceptableResponseId [KEY] Long Unique identifier for the acceptable response. This ID is used to reference and track the response within the system.
QuestionId Long Unique identifier for the question to which the acceptable response applies. This links the response to a specific question.
DisplaySequence Int Defines the order in which the acceptable responses should appear to the responder on the questionnaire for the specific question.
ResponseText String The text that represents a manually entered acceptable response value. This text is displayed as an option to the responder.
AttachmentAllowedCode String Abbreviation that identifies whether the responder is allowed to attach any documents to their responses. Valid values include 'ALLOWED', 'NOT_ALLOWED', or 'OPTIONAL'. This is defined in the lookup type 'POQ_QUESTION_RESPONSE_ATTACH'.
AttachmentAllowed String Indicates whether the responder is allowed to attach documents with their responses. Possible values include 'Allowed', 'Not Allowed', or 'Optional'. These values are defined in the lookup type 'POQ_QUESTION_RESPONSE_ATTACH'.
PreferredResponseFlag Bool Indicates whether the response is the preferred response for this question when evaluating responses. If true, this is the preferred response; if false, it is not. Default value is false.
CategoryId Long Unique identifier for the category to which this acceptable response belongs. This ID links the response to a specific category.
Category String Category of the acceptable response. This provides context for the type of response and helps in organizing and grouping responses.
ParentCategoryId Long Unique identifier for the parent category. This ID links the response category to a higher-level category, forming a category hierarchy.
PurchasingCategoryFlag Bool Indicates whether the response belongs to a purchasing category. If true, the response is associated with a purchasing category; if false, it is not.
AttributeId Long Unique identifier for the attribute linked to the acceptable response. This ID refers to a specific attribute associated with the response.
AttributeCode String Abbreviation that identifies the attribute associated with the acceptable response. This code provides further details about the nature of the response.
AttributeValueCode String Abbreviation identifying the specific value code for the attribute. This code is used to track the specific value for the attribute associated with the response.
OriginalAcceptableResponseId Long Unique identifier for the original acceptable response associated with a question revision. This ID links the original response to any subsequent revisions of the question.
Score Int Score automatically assigned to the response if the user selects the corresponding acceptable response. This score is used to evaluate the response during the scoring process.
CriticalResponseFlag Bool Indicates whether this response is critical for evaluation. If true, the response is critical for evaluation; if false, it is not. The default value is false.
ExcludeScoringFlag Bool Indicates whether the response is excluded from scoring. If true, the response is not scored; if false, the response is included in the scoring. The default value is false.
Finder String Search keyword or term used to locate the acceptable response in the system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434