Questionnaire Responses
questionnaireResponses Based on 26C
Change and look up Questionnaire Responses, with questionnaire response sections. Actions include populate responses. No create.
The record key questionnaireResponsesUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.
Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.
- Operations
- GET (list)GET (one)PATCH (update)2 actions
- Record key
questionnaireResponsesUniqID- Required on create
- no create on this resource
- At a glance
- 83 fields2 finders8 children1 file/large text fields
- Extra parameters
?effectiveDate=Effective-Of:
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/questionnaireResponses?fields=AcceptanceDate,AcceptanceInstanceId,AcceptanceNote,AcceptanceProcessedStage,AcceptanceRecoveredCode&limit=25&onlyData=true
{
"items": [
{
"AcceptanceDate": "2026-01-31T09:00:00+00:00",
"AcceptanceInstanceId": 0,
"AcceptanceNote": "<string, max 1000>",
"AcceptanceProcessedStage": "<string, max 30>",
"AcceptanceRecoveredCode": "<string, max 1>"
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 83
| Attribute | Type | Use |
|---|---|---|
AcceptanceDate | date-time | Read-onlySearchable |
AcceptanceInstanceId | number | Read-onlySearchable |
AcceptanceNote | text · max 1000 | UpdatableSearchable |
AcceptanceProcessedStage | text · max 30 | Read-onlySearchable |
AcceptanceRecoveredCode | text · max 1 | Read-onlySearchable |
AcceptedBy | number | Read-onlySearchable |
AcceptedByDisplayName | text · max 240 | Read-onlySearchable |
AcceptedByName | text · max 240 | Read-onlySearchable |
CanceledBy | number | UpdatableSearchable |
CanceledByDisplayName | text · max 240 | Read-onlySearchable |
CanceledByName | text · max 240 | UpdatableSearchable |
CanceledDate | date-time | UpdatableSearchable |
CanceledReasonCode | text · max 30 | UpdatableSearchable |
CanceledReasonUserText | text · max 1000 | UpdatableSearchable |
CloseDate | date-time | Read-onlySearchable |
ClosedBy | number | Read-onlySearchable |
ClosedByDisplayName | text · max 240 | Read-onlySearchable |
ClosedByName | text · max 240 | Read-onlySearchable |
CrActionByPersonName | text · max 255 | Read-onlySearchable |
CrActionDate | date-time | Read-onlySearchable |
CrActionReason | text · max 2000 | Read-onlySearchable |
CrNumber | number | Read-onlySearchable |
CrOutcome | text · max 255 | Read-onlySearchable |
CrRequestedByPersonName | text · max 255 | Read-onlySearchable |
CrStatusCode | text · max 30 | Read-onlySearchable |
CrSubmissionDate | date-time | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
DueDate | date | Read-onlySearchable |
InitiativeId | number | Searchable |
InitiativeSuppContactId | number | Searchable |
InitiativeSupplierContactDisplayName | text · max 255 | Read-only |
InitiativeSupplierContactName | text · max 255 | Read-only |
InitiativeSurveyFlag | yes/no · max 1 | Read-onlySearchable |
InternalRespondentId | number | Searchable |
InternalResponderDisplayName | text · max 240 | Read-onlySearchable |
InternalResponderName | text · max 240 | Read-onlySearchable |
Introduction | text · max 4000 | Read-only |
LastOverdueReminderDate | date-time | Read-onlySearchable |
MergeRequestId | number | Read-onlySearchable |
NextScheduledReminderDate | date-time | Read-onlySearchable |
ProcurementBU | text · max 240 | Read-onlySearchable |
ProcurementBUId | number | Searchable |
Questionnaire | text · max 30 | Read-onlySearchable |
QuestionnaireRespHeaderId | number | Searchable |
QuestionnaireType | text · max 80 | Read-only |
QuestionnaireTypeCode | text · max 30 | Read-onlySearchable |
QuestionnaireUsage | text · max 80 | Read-onlySearchable |
QuestionnaireUsageCode | text · max 30 | Read-onlySearchable |
QuestnaireId | number | Searchable |
RecentNotificationFlag | yes/no · max 1 | Read-onlySearchable |
RecoveredByDisplayName | text · max 240 | Read-onlySearchable |
RecoveredById | number | UpdatableSearchable |
RecoveredByName | text · max 240 | Read-onlySearchable |
RecoveredDate | date-time | Read-onlySearchable |
RequestErrorReason | text · max 4000 | Read-onlySearchable |
RequestedByDisplayName | text · max 240 | Read-onlySearchable |
RequestedById | number | Read-onlySearchable |
RequestedByName | text · max 240 | Read-onlySearchable |
ResponseStatus | text · max 80 | UpdatableSearchable |
ResponseStatusCode | text · max 30 | UpdatableSearchable |
ReturnMessageContent | text | Read-only |
ReturnedBy | number | Read-onlySearchable |
ReturnedByDisplayName | text · max 240 | Read-onlySearchable |
ReturnedByName | text · max 240 | Read-onlySearchable |
ReturnedDate | date-time | Read-onlySearchable |
SubmissionDate | date-time | UpdatableSearchable |
SubmittedBy | number | UpdatableSearchable |
SubmittedByDisplayName | text · max 240 | Read-onlySearchable |
SubmittedByName | text · max 240 | UpdatableSearchable |
SupplierContactPartyDisplayName | text · max 255 | Read-only |
SupplierContactPartyId | number | Read-onlySearchable |
SupplierContactPartyName | text · max 255 | Read-only |
SupplierId | number | Read-onlySearchable |
SupplierName | text · max 360 | Read-onlySearchable |
SupplierSiteAddress | text · max 255 | Read-onlySearchable |
SupplierSiteId | number | Searchable |
SupplierSiteName | text · max 240 | Read-onlySearchable |
SurrogEnteredBy | number | Read-onlySearchable |
SurrogEntryDate | date-time | Read-onlySearchable |
SurrogResponseFlag | yes/no · max 1 | Read-onlySearchable |
SurrogateEnteredByDisplayName | text · max 240 | Read-onlySearchable |
SurrogateEnteredByName | text · max 240 | Read-onlySearchable |
Title | text · max 80 | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 2
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
FindByChecklist·Bind_LoggedInUserFindByInternalResponder·Bind_LoggedInUser
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 8
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/questionnaireResponses/{questionnaireResponsesUniqID}/child/<name>. Add them to a GET with expand.
questionnaireAttachmentsGET Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamequestionnaireResponseSectionsGET · PATCH Questionnaire Response Sections · 8 fieldsDisplaySequenceInstructionsQuestionnaireRespHeaderIdQuestionnaireRespSectionIdQuestionnaireSectionIdQuestionnaireSectionNameSectionCompletedFlagSectionGeneratedFlagquestionnaireResponseDetailsGET · PATCH Questionnaire Response Details · 45 fieldsAcceptanceNoteAllowRespCommentFlagAttachmentAllowedAttachmentAllowedCodeBranchLevelCategoryCategoryCodeDisplayNumberDisplayPreferredRespFlagDisplaySequenceFailedPozValidationFlagHasNewResponseFlagHasNewerResponseFlagHasSubmissionHistoryFlagMappedToPrereqQuestionFlagMappingIdOriginalQuestionIdParentAcceptableResponseIdParentQuestionnaireQuestIdPreferredResponseDatePreferredResponseDatetimePreferredResponseNumberPreferredResponseTextQuestionDisplayedFlagQuestionHintQuestionIdQuestionLevelQuestionLevelCodeQuestionNameQuestionPlainTextQuestionTextQuestionTypeQuestionTypeCodeQuestionnaireQuestionIdQuestionnaireRespHeaderIdQuestionnaireRespSectionIdQuestionnaireResponseIdResponseCommentsResponseRepositoryIdResponseRequiredFlagResponseTypeResponseTypeCodeSupplierAttributeCodeSupplierAttributeFlagSupplierAttributeNamebusinessClassificationsGET · POST · PATCH · DELETE Business Classifications · 24 fieldsAgencyIdBusClassCodeBusClassRequestIdCertificationNoCertifyingAgencyIdCertifyingAgencyNameConfirmedOnDisplayedFieldEnabledFlagEndDateActiveExistingClassificationFlagExpirationDateMappingIdNotesOtherCertifyingAgencyProvidedByContactIdProvidedByContactNameRowStatusStartDateStartDateActiveStatusStatusCodeSubClassificationSubClassificationCodebusinessClassificationAttachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamequestionAttachmentsGET Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamequestionnaireResponseValuesGET · PATCH Questionnaire Response Values · 18 fieldsAcceptableResponseIdAttachmentAllowedAttachmentAllowedCodeCertifyingAgencyIdDisplayNumberDisplaySequenceFromUIHasBranchingFlagIsSelectedFlagPreferredResponseFlagQuestionnaireAccResponseIdQuestionnaireRespValueIdQuestionnaireResponseIdResponseTextResponseValueDateResponseValueDatetimeResponseValueNumberResponseValueTextresponseAttachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserName
Actions 2
POST …/action/populateResponses·parametersPOST …/{questionnaireResponsesUniqID}/child/questionnaireResponseSections/{QuestionnaireRespSectionId}/action/processSection·parameters
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/questionnaireResponsesand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
FindByChecklistfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AcceptanceNote, notacceptancenote. - 64 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
onlyData=trueremoveslinks, and this resource's key only comes fromlinks. Leave it off when you need the key.- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.