SupplierNegotiations
The Supplier Negotiations resource manages details about supplier capabilities and pricing negotiations for goods and services that the buyer procures. You must have the necessary roles and privileges to use this REST resource. For additional details, refer to the Job Roles and Privileges and Status Codes topics.
Columns
Name | Type | Description |
AuctionHeaderId [KEY] | Long | AuctionHeaderId of SupplierNegotiations |
AllowAlternateLinesFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to create an alternate response line for each negotiation line. If false, then do not allow. If the negotiation is of type RFI (request for information), and if lines are not enabled for the negotiation style, then the default value for AllowAlternateLinesFlag is empty. Otherwise, the default value is true. |
AllowSuppliersToNegotiateRetainageFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to enter retainage attributes. If false, then do not allow. The default value is false. |
NegotiationTitle | String | Text that describes the purpose of the negotiation. |
Negotiation | String | Negotiation of SupplierNegotiations |
NegotiationStatus | String | NegotiationStatus of SupplierNegotiations |
AmendmentDescription | String | Description of the change in the document when someone amends the negotiation. |
Synopsis | String | Text that summaries the negotiation. |
NegotiationTypeId | Long | Value that uniquely identifies the type of negotiation. |
NegotiationType | String | Type of the negotiation. Values include Auction, RFQ, or RFI. |
NegotiationStyleId | Long | Value that uniquely identifies the negotiation style. |
NegotiationStyle | String | Name of the negotiation style. |
LargeNegotiationFlag | Bool | LargeNegotiationFlag of SupplierNegotiations |
TwoStageEvaluationFlag | Bool | Contains one of the following values: true or false. If true, then the application enabled two stage evaluation for the negotiation. If false, then not enabled. The default value is false. |
BuyerId | Long | Value that uniquely identifies the person who created the negotiation. |
Buyer | String | Name of the person who created the negotiation. |
ProcurementBUId | Long | Value that uniquely identifies the procurement business unit that owns the negotiation. |
ProcurementBU | String | Name of the procurement business unit that owns the negotiation. |
Outcome | String | Display name of the purchasing document that the application creates at the end of the negotiation process. Use page Manage Document Styles in the Setup and Maintenance work area to examine and update the values that you can use for this attribute. |
ApprovalAmount | Decimal | Amount on negotiation that you can use when routing an approval. If the application creates the negotiation from an expiring agreement, then the default value is the agreement amount. If the application creates the negotiation when it processes requisition lines, then the default value is the total requisition amount. The user can update the approval amount in negotiation. |
NoteToNegotiationApprovers | String | Note for the approver when submitting the document for approval. |
SourceAgreement | String | Agreement that the negotiators are using to renegotiate the current negotiation. |
POStyleId | Long | Value that uniquely identifies the purchasing document style. |
POStyle | String | POStyle of SupplierNegotiations |
PODoctypeCode | String | Abbreviation that uniquely identifies the document type of the purchasing document. |
PODoctype | String | PODoctype of SupplierNegotiations |
TechnicalStageUnlockedBy | String | TechnicalStageUnlockedBy of SupplierNegotiations |
TechnicalStageUnlockedDate | Datetime | TechnicalStageUnlockedDate of SupplierNegotiations |
TechnicalStageUnsealedBy | String | TechnicalStageUnsealedBy of SupplierNegotiations |
TechnicalStageUnsealedDate | Datetime | TechnicalStageUnsealedDate of SupplierNegotiations |
CommercialStageUnlockedBy | String | CommercialStageUnlockedBy of SupplierNegotiations |
CommercialStageUnlockedDate | Datetime | CommercialStageUnlockedDate of SupplierNegotiations |
CommercialStageUnsealedBy | String | CommercialStageUnsealedBy of SupplierNegotiations |
CommercialStageUnsealedDate | Datetime | CommercialStageUnsealedDate of SupplierNegotiations |
PreviewImmediatelyFlag | Bool | Contains one of the following values: true or false. If true, then allow suppliers to view the negotiation immediately after the application publishes it but before the application allows suppliers to respond to the negotiation. If false, then do not allow. The default value is false. |
PreviewDate | Datetime | Date when suppliers can view the negotiation but not yet respond to the negotiation. |
CloseDate | Datetime | Date when the negotiation stops accepting replies from the supplier. |
DaysAfterOpenDate | Decimal | Number of days after the open date when the negotiation will close. |
StaggeredClosingFlag | Bool | Contains one of the following values: true or false. If true, then allow lines to use staggered close dates in the negotiation. If false, then do not allow. The default value is false. |
StaggeredClosingInterval | Decimal | Time interval between two negotiation lines in a staggered closing. |
FirstLineCloseDate | Datetime | Date when the first line of the negotiation closes when the application enables staggered closing. |
AutoExtendFlag | Bool | Contains one of the following values: true or false. If true, then allow automatic extension on the close date according to settings defined in the negotiation. If false, then do not allow. The default value is false. AutoExtendFlag applies only for auction. |
AutoExtendMinimumTriggerRank | Decimal | Lowest rank of response that can start an extension of the negotiation. |
AutoExtendAllLinesFlag | Bool | Contains one of the following values: true or false. If true, then extend all lines of the negotiation instead of extending only the lines that include a winning response. If false, then extend only the lines that include a winning response. The default value is true. |
AutoExtensionsNumber | Decimal | Number of times the application can extend the negotiation. |
AutoExtendTriggerPeriod | Decimal | Time period that occurs before the negotiation close date where the response can start an extension. |
AutoExtendFromCloseDateFlag | Bool | Contains one of the following values: true or false. If true, then extend the close date of the negotiation from the current close date. If false, then extend the receiving time from the response that starts the negotiation. The default value is true. |
AutoExtendDuration | Decimal | Number of minutes the application extends the negotiation when the negotiation meets the extension criteria. |
OpenImmediatelyFlag | Bool | Contains one of the following values: true or false. If true, then allow suppliers to respond immediately after the application publishes the negotiation. If false, then do not allow. The default value is false. |
OpenDate | Datetime | Date when the negotiation starts accepting replies from suppliers. |
AwardByDate | Datetime | Date when the application awards the negotiation. |
ResponseVisibilityCode | String | Abbreviation that specifies when the supplier can view details from competing responses. Values include Open, Sealed, or Blind. A list of accepted values is defined in the lookup type PON_BID_VISIBILITY_CODE. |
ResponseVisibility | String | Specify when the supplier can view details from competing responses. Values include Open, Sealed, or Blind. A list of accepted values is defined in the lookup type PON_BID_VISIBILITY_CODE. |
OverallRankingMethodCode | String | Abbreviation that identifies the method that the application uses to calculate the overall ranking for supplier response. Values include Response amount only or Composite scoring. A list of accepted values is defined in the lookup type ORA_PON_OVERALL_RANKING_METHOD. |
OverallRankingMethod | String | Method that the application uses to calculate the overall ranking for supplier response . Values include Response amount only or Composite scoring. A list of accepted values is defined in the lookup type ORA_PON_OVERALL_RANKING_METHOD. |
NegotiationLayoutName | String | Layout that the application uses in Oracle Business Intelligence Publisher to create the negotiation in PDF (Portable Document Format). |
ResponseLayoutName | String | Layout that the application uses in Oracle Business Intelligence Publisher to create the negotiation response in PDF (Portable Document Format). |
ContractTermsLayout | String | Layout from Oracle Business Intelligence Publisher that the application uses to create the PDF (Portable Document Format) file for the negotiation. |
EnableTeamScoringFlag | Bool | Contains one of the following values: true or false. If true, then enable team scoring for requirements. If false, then do not enable. The default value is false. |
EnableRequirementWeightsFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to include weight when calculating the requirement score. If false, then do not allow. If the negotiation style enables requirements, then the default value for EnableRequirementWeightsFlag is empty, else the default value is true. |
EnableSectionWeightsFlag | Bool | EnableSectionWeightsFlag of SupplierNegotiations |
DisplayRequirementScoresFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view the requirement scoring criteria. If false, then do not allow. The default value is false. If the negotiation style enables requirements, then DisplayRequirementScoresFlag is applied. |
DefaultMaximumRequirementScore | Decimal | Default value of the maximum score for each negotiation requirement. |
RequisitioningBUId | Long | Value that uniquely identifies the requisition business unit. |
RequisitioningBU | String | Name of the requisition business unit that the application uses to set default values for each negotiation line. |
PriceTiersCode | String | Abbreviation that identifies the price tier type that the negotiation uses. Values include None, Price Break, or Quantity. A list of accepted values is defined in the lookup type PON_PRICE_BREAK_OPTIONS. |
PriceTiers | String | Price tier type that the negotiation uses. Values include None, Price Break, or Quantity. A list of accepted values is defined in the lookup type PON_PRICE_BREAK_OPTIONS. |
RankIndicatorCode | String | Abbreviation that identifies the indicator that the application uses to rank replies from suppliers during the negotiation. Values include Best; 1,2,3; or No. No specifies to not display any indicator. A list of accepted values is defined in the lookup type PON_RANK_INDICATOR_CODE. |
RankIndicator | String | Indicator that the application uses to rank replies from suppliers during the negotiation. Values include Best; 1,2,3; or No. No specifies to not display any indicator. A list of accepted values is defined in the lookup type PON_RANK_INDICATOR_CODE. |
RankingMethodCode | String | Abbreviation that identifies the method that the application uses to rank supplier replies during the negotiation. Values include Price or Multiattribute. A list of accepted values is defined in the lookup type PON_BID_RANKING_CODE. |
RankingMethod | String | Method that the application uses to rank supplier replies during the negotiation. Values include Price or Multiattribute. A list of accepted values is defined in the lookup type PON_BID_RANKING_CODE. |
DisplayScoresToSuppliersFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view the line attribute scoring criteria. If false, then do not allow. The default value is false. If the user sets Multiattribute Scoring to Ranking Method, then DisplayScoresToSuppliersFlag is visible. |
RestrictToInvitedSuppliersFlag | Bool | Contains one of the following values: true or false. If true, then allow only invited suppliers to access the negotiation. If false, then allow any supplier to access the negotiation. The default value is false for auction; or true for RFQ (request for quotation), or RFI (request for information). |
RestrictToInvitedSuppliersDisplayFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view whether the negotiation restricts access to invited suppliers. If false, then do not allow. The default value is true. |
ViewNotesAndAttachmentsFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view contract terms, notes, and attachments that other suppliers submitted. If false, then do not allow. The default value is true. |
ViewNotesAndAttachmentsDisplayFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view whether the negotiation allows them to view contract terms, notes, and attachments that other suppliers submitted. If false, then do not allow. The default value is true. |
RespondOnAllLinesFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to respond to all lines in the negotiation. If false, then do not allow. The default value is true for an auction; or false for RFQ (request for quotation), or RFI (request for information). |
RespondOnAllLinesDisplayFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view whether the negotiation requires them to respond to all lines. If false, then do not allow. The default value is true. |
DisplayBestPriceBlindFlag | Bool | Contains one of the following values: true or false. If true, then display the best price to the supplier during a blind negotiation. If false, then do not display. The default value is false. If the response visibility is Blind, then DisplayBestPriceBlindFlag applies to auction or RFQ (request for quotation). |
RequireFullQuantityFlag | Bool | Contains one of the following values: true or false. If true, then the response must match the quantity that the negotiation requests. If false, then allow the response to include a quantity that does not meet the quantity that the negotiation requests. If the outcome is Standard Purchase Order, then the default value is true, else the default value is false. |
RequireFullQuantityDisplayFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view whether the negotiation requires the response to match the quantity that the negotiation requests. If false, then do not allow. The default value is true. |
EnforcePreviousRoundPriceAsStartPriceFlag | Bool | Contains one of the following values: true or false. If true, then use the price that the supplier submits in the previous round of negotiations as the start price for the current round. If false, then do not use this price. The default value is false. |
AllowMultipleResponsesFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to submit more than one response during each negotiation round. If false, then do not allow. The default value is true for auction and false for RFQ (request for quotation) or RFI (request for information). |
AllowMultipleResponsesDisplayFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view whether they can submit more than one response during each negotiation round. If false, then do not allow. The default value is true. |
AllowResponseRevisionFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to revise their active replies during each negotiation round. If false, then do not allow. The default value is true for auction and false for RFQ (request for quotation) or RFI (request for information). |
AllowResponseRevisionDisplayFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view whether they can revise the response during each negotiation round. If false, then do not allow. The default value is true. |
RevisedResponseLinePriceRuleCode | String | Abbreviation that specifies how the revised response must modify its price. Values include No Restriction, Lower Than Previous Price, or Lower Than Best Price. A list of accepted values is defined in the lookup type PON_REVISED_LINE_PRICE. The default value is No Restriction. |
RevisedResponseLinePriceRule | String | Specifies how the revised response must modify its price. Values include No Restriction, Lower Than Previous Price, or Lower Than Best Price. A list of accepted values is defined in the lookup type PON_REVISED_LINE_PRICE. The default value is No Restriction. |
ResponseRevisionDecrementTypeCode | String | Abbreviation that uniquely the minimum price reduction of each revised response as an amount or a percent. Values include Amount or Percentage. A list of accepted values is defined in the lookup type PON_DECREMENT_TYPE. |
ResponseRevisionDecrementType | String | Display the minimum price reduction of each revised response as an amount or a percent. Values include Amount or Percentage. A list of accepted values is defined in the lookup type PON_DECREMENT_TYPE. |
ResponseRevisionDecrementValue | Decimal | Minimum amount or percentage of reduction of the line price in each revised response. If line level price decrement is enabled in the negotiation style for an auction, then this is the default value applied to new lines. |
AgreementStartDate | Date | Date when the purchase agreement goes into effect. As an option, if the NegotiationType is RFQ (request for quotation) or Auction, and if the value of Outcome is Blanket Purchase Agreement or Contract Purchase Agreement, then you can specify a value for AgreementStartDate. If AgreementStartDate does not apply, then it is empty. |
AgreementEndDate | Date | Date when the purchase agreement expires. If you are renegotiating the agreement, then the application defaults the value for this attribute from the agreement. As an option, if the NegotiationType is RFQ (request for quotation) or Auction, and if the value of Outcome is Blanket Purchase Agreement or Contract Purchase Agreement, then you can specify a value for AgreementEndDate. If AgreementEndDate does not apply, then it is empty. |
PaymentTermsId | Long | Value that uniquely identifies the name of the payment terms that the supplier applies when making the sale according to the due date and discount date that paying the invoice requires. |
PaymentTerms | String | Name of the payment terms that the supplier applies when making the sale according to the due date and discount date that paying the invoice requires. |
CarrierId | Long | Value that uniquely identifies the name of the company that transports the item from one point to another point through land, sea, or air. |
Carrier | String | Carrier of SupplierNegotiations |
ModeOfTransportCode | String | Abbreviation that identifies the transportation mode that the application uses to transport the item. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT. |
ModeOfTransport | String | ModeOfTransport of SupplierNegotiations |
ServiceLevelCode | String | Abbreviation that identifies the priority to use when determining how quickly to ship the item. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS. |
ServiceLevel | String | ServiceLevel of SupplierNegotiations |
ShippingMethod | String | Value that indicates the method of shipping. This value is a combination of the concatenated values of carrier, mode of transport, and service level. |
AgreementAmount | Decimal | Total amount on the purchase agreement. If you are renegotiating the agreement, then the application defaults the value for this attribute from the agreement. As an option, if the NegotiationType is RFQ (request for quotation) or Auction, and if the value of Outcome is Blanket Purchase Agreement or Contract Purchase Agreement, then you can specify a value for AgreementAmount. If AgreementAmount does not apply, then it is empty. |
MinimumReleaseAmount | Decimal | Minimum amount in any purchase order line that the application can release for the purchase agreement line. |
FreightTermsCode | String | Abbreviation that identifies the name of the terms that determine whether the buyer or supplier pays freight charges for items and services. A list of accepted values is defined in the lookup type FREIGHT TYPE. |
FreightTerms | String | FreightTerms of SupplierNegotiations |
FOBCode | String | Abbreviation that identifies the point or location where the ownership of the items and services and the cost of damage or loss transfers from the supplier to the buyer. A list of accepted values is defined in the lookup type FOB. |
FOB | String | FOB of SupplierNegotiations |
BuyerManagedTransportationFlag | Bool | Contains one of the following values: true or false. If true, then the buying company is responsible for arranging transportation. If false, then buying company is not responsible for arranging transportation. The default value is false. |
CurrencyCode | String | Abbreviation that identifies the currency that the negotiation uses. |
Currency | String | Name of the negotiation currency. |
AllowOtherResponseCurrencyFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to submit a response in a currency other than the negotiation currency. If false, then do not allow. The default value is false. |
PricePrecision | Decimal | Number of decimal places that the application displays for each price attribute in the response. |
ConversionRateTypeCode | String | Abbreviation that uniquely identifies the type of conversion rate that the application uses to convert the response currency to the negotiation currency. |
ConversionRateType | String | ConversionRateType of SupplierNegotiations |
ConversionRateDate | Date | Date when the application used the conversion rate to convert each response from some other currency to the negotiation currency. |
DisplayRatesToSuppliersFlag | Bool | Contains one of the following values: true or false. If true, then allow the supplier to view the currency exchange rate that the negotiation uses. If false, then do not allow. The default value is false. |
ScoringStatusCode | String | ScoringStatusCode of SupplierNegotiations |
ScoringStatus | String | ScoringStatus of SupplierNegotiations |
TechnicalStageScoringStatusCode | String | TechnicalStageScoringStatusCode of SupplierNegotiations |
TechnicalStageScoringStatus | String | TechnicalStageScoringStatus of SupplierNegotiations |
CommercialStageScoringStatusCode | String | CommercialStageScoringStatusCode of SupplierNegotiations |
CommercialStageScoringStatus | String | CommercialStageScoringStatus of SupplierNegotiations |
ContractSource | String | ContractSource of SupplierNegotiations |
ContractTermsTemplateId | Decimal | ContractTermsTemplateId of SupplierNegotiations |
ContractTermsTemplate | String | ContractTermsTemplate of SupplierNegotiations |
CreatedBy | String | CreatedBy of SupplierNegotiations |
CreationDate | Datetime | CreationDate of SupplierNegotiations |
LastUpdateDate | Datetime | LastUpdateDate of SupplierNegotiations |
LastUpdatedBy | String | LastUpdatedBy of SupplierNegotiations |
CoverPageText | String | Text that describes the negotiation cover page. |
GeneralIntroductionText | String | Text that describes the negotiation. |
TermsInstructionText | String | Text that describes how to negotiate terms. |
RequirementInstructionText | String | Text that describes how to respond to each negotiation requirement. |
LinesInstructionText | String | Text that describes instructions for the negotiation line. |
PrebidFlag | Bool | Contains one of the following values: true or false. If true, then prebid is enabled in the negotiation. If false, then prebid is not enabled in the negotiation. If prebid is enabled in the negotiation style for an Auction or RFQ, and PreviewDate is set or PreviewImmediatelyFlag is true, and ResponseVisibility is Open or Blind, then the default value is true. Otherwise, the default value is false. |
LineDecrementFlag | Bool | LineDecrementFlag of SupplierNegotiations |
AiDataDurationInMonths | Long | AiDataDurationInMonths of SupplierNegotiations |
Finder | String | Finder of SupplierNegotiations |