SSIS Components for Oracle Fusion Cloud Financials

Build 26.0.9770

SupplierRegistrationQuestionnaireResponsesQuestionnaireResponseSectionsQuestionnaireResponses

Returns the nested question responses captured within questionnaire response sections during supplier registration.

Columns

Name Type SupportedFinders Description
SupplierRegistrationQuestionnaireResponsesQuestnaireRespHeaderId [KEY] Long Value that uniquely identifies the questionnaire response.
SupplierRegistrationQuestionnaireResponsesSupplierRegistrationKey [KEY] String Value that uniquely identifies the questionnaire response using the registration key.
QuestionnaireResponseSectionsQuestnaireRespSectionId [KEY] Long Value that uniquely identifies the questionnaire response section.
QuestnaireResponseId [KEY] Long Value that uniquely identifies a questionnaire question response.
QuestnaireRespHeaderId Long PrimaryKey Value that uniquely Identifies the response to questionnaire.
QuestnaireRespSectionId Long Value that uniquely identifies the section of questionnaire.
QuestnaireQuestionId Long Value that uniquely identifies Questionnaire question from the questionnaires table.
ParentQuestnaireQuestId Long Value that uniquely identifies Questionnaire question from the questionnaires table.
DisplayNumber String Indicates the order in which the questions are displayed.
QuestionId Long Identifier of the questionnaire question.
QuestionName String Name of the questionnaire question.
QuestionTypeCode String Code to specify the question type.
QuestionType String Specifies whether the question is a multiple choice question with single selection, a multiple choice question with multiple selections, or a text entry box question without predefined acceptable responses.
ResponseTypeCode String Code to indicate the response type for questions of text entry box type.
ResponseType String Indicates the response type for questions of text entry box type, such as text, number or date.
QuestionText String Text of the question to be displayed to responders of a questionnaire.
QuestionHint String Hint to the question.
DisplayPreferredRespFlag Bool Indicates whether there is a preferred response.
PreferredResponseText String Value of the preferred response in Text format.
PreferredResponseDate Date Value of the preferred response in Date format.
PreferredResponseDatetime Datetime Value of the preferred response in Date and Time format.
PreferredResponseNumber Decimal Value of the preferred response in Number format.
AttachmentAllowedCode String Code for whether the response attachment is allowed.
AttachmentAllowed String Indicates whether response attachments are required, optional, or not allowed.
ResponseRequiredFlag Bool Indicates whether the response is required for the question.
AllowRespCommentFlag Bool Indicates whether comments are allowed for the question response.
ResponseComments String Comments entered by supplier or internal respondent for response to a question.
QuestionDisplayedFlag Bool Indicates if the questions were shown to the responders at the time of response submission.
BranchLevel Int Indicates the level at which question is appearing in the questionnaire.
ParentAccResponseId Long Indicates the ID for the acceptable response that the branching question belongs to.
QuestionPlainText String Text of the question to be displayed to responders of a questionnaire.
SupplierAttributeCode String Code to uniquely identify the supplier attribute that the question is mapped to.
SupplierAttributeFlag Bool Indicates whether the question is mapped to an attribute from the supplier profile.
RegReadOnlyFlag Bool Indicate if the question mapped to this supplier attribute appears as read-only on the supplier registration questionnaire.
CategoryCode String Code for identifying the categorization of the supplier attribute.
Category String Indicates the categorization of the supplier attribute that the question is mapped to.
Finder String A named finder reference used to filter or locate specific supplier registration questionnaire responses when querying.
SupplierRegistrationKey String FindByRegKey, PrimaryKey The unique key that identifies the supplier registration, supplied as input to the finder.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770