JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierQualificationQuestionResponses

Collects the actual answers suppliers provide to qualification questions, forming a record for subsequent review.

Columns

Name Type Description
QuestionId Long Unique identifier for the question. This ID is used to link the response to the specific question. It can be found in the question setup or configuration section of the system.
Question String Text or identifier of the question that the supplier or internal responder answers. This is defined by the user during the creation of the qualification process.
SupplierId Long Unique identifier for the supplier who is providing the response. It helps link the response to a specific supplier in the system.
Supplier String The name of the supplier providing the response. This is the company's name associated with the SupplierId.
SupplierSiteId Long Unique identifier for the supplier site where the supplier is based. It can be found in the supplier site management section.
SupplierSite String Name of the supplier site associated with the supplier. This helps to link the response to the specific location of the supplier.
ResponseDate Datetime The date when the response to the question is submitted. This is tracked for record-keeping and follow-up purposes.
InternalResponderId Long Unique identifier for the internal responder who is responsible for answering the question. It can be found in the internal responder or team management section.
InternalResponder String Name of the internal responder assigned to provide answers to the question. This is typically a representative from the buying organization.
SupplierContactId Long Unique identifier for the supplier contact responsible for submitting the response. This ID can be found in the contact management section.
SupplierContact String Name of the supplier contact who submitted the response. This person is the key point of communication for the supplier.
QuestionText String The actual text of the question as asked during the qualification process. This is used to reference the full question being answered.
QuestionRevision Int The revision number of the question. This helps track changes or updates to the question over time.
ResponderComments String Additional comments or notes provided by the responder when submitting the response. This allows for clarification or explanation of the provided answers.
AcceptanceNote String Any notes entered by the responder during the acceptance of the qualification response. This can include additional instructions or confirmations.
ResponseRepositoryId [KEY] Long Unique identifier for the repository where the responses are stored. This ID helps track the storage location of the response data.
ResponseStatusCode String Code representing the status of the response. Common values include 'Accepted', 'Pending', or 'Rejected'. Refer to the lookup type PON_RESPONSE_STATUS for accepted values.
ResponseStatus String Human-readable status of the response, indicating its current state in the process. Common values include 'Accepted', 'Pending', or 'Rejected'. This is linked to the ResponseStatusCode.
FirstSubmissionDate Datetime The date when the first submission of the response was made. This is useful for tracking the initial response date.
ResponseArchiveDate Datetime The date when the response was archived. This is used for record-keeping and audit purposes.
AcceptanceDate Datetime The date when the response was formally accepted by the responsible party. This tracks when the qualification process considers the response final.
AcceptedById Long Unique identifier for the person who accepted the qualification response. This ID links to the individual who authorized the response acceptance.
AcceptedBy String Name of the person who accepted the response. This is typically an internal representative from the purchasing or qualification team.
DataSourceTypeCode String Code representing the source type of the response data. Accepted values include 'System', 'Manual', and 'File Import'. This can be found in the data source configuration section.
DataSourceType String Human-readable type of the data source for the response. Values like 'System', 'Manual', and 'File Import' are used to categorize the source of the response.
DataSourceId Long Unique identifier for the source from which the response was received. This could link to a database, file, or manual entry system.
ResponderTypeCode String Code that represents the type of responder. Accepted values include 'Supplier', 'Internal', 'Admin'. Refer to the lookup type PON_RESPONDER_TYPE for full list.
ResponderType String Human-readable type of responder, which indicates whether the response was submitted by a supplier, internal responder, or admin.
OriginalQuestionId Long Original identifier for the question if it was modified or revised. This links the current question response to the original version.
SurrogateResponseFlag Bool Indicates whether the response was provided by a surrogate (someone other than the intended responder). Accepted values are 'true' or 'false'.
SurrogateEntryDate Datetime Date when the surrogate entered the response on behalf of the intended responder.
SurrogateEnteredById Long Unique identifier for the person who entered the surrogate response. This ID links to the individual responsible for submitting the surrogate response.
SurrogateEnteredBy String Name of the person who entered the surrogate response. This is typically an internal user or team member.
ProcurementBU String Name of the procurement business unit that the supplier site belongs to. This links the response to the relevant business unit.
ProcurementBUId Long Unique identifier for the procurement business unit associated with the supplier site.
AggregateResponseFlag Bool Indicates whether the response is an aggregate of multiple submissions. Accepted values are 'true' or 'false'. Default is 'false'.
Finder String Search term or keyword used to locate the supplier qualification question response record. This is used to filter and search within the responses.

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