JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierNegotiationResponses

Retrieves supplier-submitted responses to sourcing negotiations (for example, RFI, RFQ), offering visibility into proposed terms and pricing.

Columns

Name Type Description
ResponseNumber [KEY] Long Unique identifier for the response within the supplier negotiation process, used to reference and track specific responses.
AuctionHeaderId Long Unique identifier for the auction header, linking the response to a specific auction event in the negotiation process.
NegotiationTitle String The title of the negotiation, providing a summary or label for the negotiation process that the response is part of.
Negotiation String Detailed name or description of the negotiation, offering further context for the specific negotiation process.
CloseDate Datetime The date and time when the negotiation is scheduled to close, marking the deadline for submitting responses.
AwardCompleteDate Datetime The date and time when the award process for the negotiation is completed, finalizing the decision based on responses.
PurchasingDocument String The document associated with the purchasing process, often representing the contract or order that is being negotiated.
ResponseStatus String The current status of the response, indicating whether it is active, withdrawn, under review, or in another state.
OverallRank String The overall ranking of the supplier’s response in the negotiation, showing how the response compares to others.
OverallRankComposite String Composite ranking of the response, combining various evaluation metrics into a single overall ranking.
ShortlistStatus String The status of the supplier in relation to being shortlisted, indicating whether the supplier has been selected for further consideration.
ResponseAmount String The total amount stated in the supplier’s response, often representing the price or offer submitted by the supplier.
TotalAgreementAmount Long The total amount of the agreement or contract, representing the full financial commitment of the negotiation.
TotalAwardAmount Long The total award amount, indicating the final financial figure awarded based on the negotiation response.
SavingsInAmount Decimal The amount of savings generated as a result of the negotiation response, showing cost reductions compared to prior estimates.
SavingsInPercent String Percentage of savings achieved based on the negotiation response, representing the cost savings relative to the baseline amount.
AwardStatus String The current status of the award process, indicating whether the award has been completed, pending, or canceled.
RequirementScore Decimal The score assigned based on how well the supplier’s response meets the required criteria for the negotiation.
CompositeScore String The composite score combining multiple evaluation factors, providing an overall measure of the response’s performance.
OverriddenScore Decimal The score that has been manually adjusted or overridden by the evaluator, reflecting changes made to the initial score.
ScoringStatus String The current status of the scoring process, indicating whether scoring has been completed, is in progress, or is pending.
ScoreOverriddenFlag Bool Flag indicating whether the score has been overridden. If true, the score was manually adjusted; if false, it remains as initially calculated.
ScoreOverriddenBy String The name of the person who overrode the score, providing accountability for score changes.
ScoreOverridePersonId Long Unique identifier for the person who performed the score override, linking the adjustment to a specific individual.
ScoreOverrideReason String Explanation for why the score was overridden, offering context for the decision to change the original score.
ScoreOverriddenDate Datetime The date and time when the score was overridden, providing a timestamp for when the change was made.
ResponseType String Type of response submitted by the supplier, indicating whether it is a bid, offer, or another form of response.
ResponseTypeCode String Code that categorizes the response type, providing a standardized identifier for the type of response.
MethodOfResponse String Method by which the supplier submitted their response, such as electronically, via email, or in person.
MethodOfResponseCode String Code representing the method of response, used for standardized tracking of how responses are submitted.
DisqualificationReason String Reason why the supplier’s response was disqualified, providing transparency on the decision to reject the response.
EvaluationStage String Stage of the evaluation process that the response is currently in, such as initial review, scoring, or final selection.
PrebidFlag Bool Flag indicating whether the response was submitted prior to the official start of the bidding process. If true, it is a prebid response.
Buyer String The name of the buyer or procurement officer responsible for the negotiation, providing clarity on the individual overseeing the process.
PreviousResponseNumber Long The response number for the supplier’s previous submission, allowing comparison between responses across different rounds.
OriginalResponseNumber Long The original response number assigned to the first submission from the supplier, used to track initial responses.
NegotiationCurrency String The currency used in the negotiation, indicating the financial system for all amounts related to the negotiation.
NegotiationCurrencyCode String Code representing the currency used in the negotiation, following standard currency codes such as USD or EUR.
NoteToBuyer String Additional notes provided to the buyer, often used for clarification or extra information relevant to the response.
PriceDecrement Decimal The amount by which the supplier has reduced their price in subsequent rounds of the negotiation, showing price adjustments.
ResponseCurrency String Currency in which the supplier has provided their response, which may differ from the negotiation currency.
ResponseCurrencyCode String Code representing the currency used by the supplier in their response, such as USD or EUR.
ResponseCurrencyPricePrecision Decimal Precision used for pricing in the response currency, specifying the number of decimal places for price calculations.
CurrencyConversionRate Decimal The rate used to convert between the response currency and the negotiation currency, helping to reconcile different currencies.
ResponseValidUntilDate Datetime The date until which the supplier’s response remains valid, marking the expiry of the offer or bid.
Supplier String The name of the supplier submitting the response, identifying the company or entity involved in the negotiation.
SupplierId Long Unique identifier for the supplier, used to track and reference the supplier across various negotiation processes.
SupplierContact String The contact person at the supplier’s organization, providing a point of communication for the negotiation.
SupplierContactId Long Unique identifier for the supplier contact, linking the individual to their role in the negotiation.
SupplierSite String The specific supplier site associated with the response, identifying the location or branch handling the negotiation.
SupplierSiteId Long Unique identifier for the supplier site, linking the location to the supplier and their response.
SurrogateResponseEnteredById Long Unique identifier for the person who entered the surrogate response, used for tracking who submitted the response on behalf of the supplier.
SurrogateResponseEnteredBy String The name of the person who entered the surrogate response, providing clarity on the individual responsible.
SurrogateResponseFlag Bool Flag indicating whether the response is a surrogate response entered on behalf of the supplier. If true, it was entered by someone other than the supplier.
SurrogateResponseCreationDate Datetime The date and time when the surrogate response was created, marking when the surrogate submission occurred.
SurrogateResponseReceivedOn Datetime The date and time when the surrogate response was received, helping to track the timing of the submission.
ReferenceNumber String A reference number associated with the response, used for tracking and external referencing of the submission.
ProxyBidFlag Bool Flag indicating whether the response is a proxy bid, where a third party is acting on behalf of the supplier.
PartialResponseFlag Bool Flag indicating whether the response is partial, meaning it does not cover the full scope or requirements of the negotiation.
CreatedBy String The name of the individual who created the negotiation response record, providing accountability for the data entry.
CreationDate Datetime The date and time when the response record was created, providing a timestamp for when the response was initially entered.
TwoStageEvaluationFlag Bool Flag indicating whether the response is part of a two-stage evaluation process. If true, the evaluation will be conducted in two distinct stages.
TechnicalShortlistFlag Bool Flag indicating whether the response is part of the technical shortlist, indicating that the supplier meets the technical requirements.
ShortlistFlag Bool Flag indicating whether the supplier has been shortlisted for further consideration based on their response.
ShortlistStatusUpdatedBy String The name of the person who last updated the shortlist status, providing accountability for changes to the shortlist.
ShortlistStatusUpdatedById Long Unique identifier for the person who last updated the shortlist status, linking the update to a specific individual.
Finder String Search or query reference related to the SupplierNegotiationResponses, used for filtering or looking up specific response records in the negotiation process.

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