SupplierNegotiations
Oversees key negotiation details (for example, objectives, timelines, participants) for supplier sourcing events or auctions.
Columns
| Name | Type | Description |
| AuctionHeaderId [KEY] | Long | Unique identifier for the auction header, linking the negotiation data to a specific auction event. |
| AllowAlternateLinesFlag | Bool | Flag indicating whether suppliers can create alternate response lines for each negotiation line. If true, alternate lines are allowed; if false, they are not. |
| AllowSuppliersToNegotiateRetainageFlag | Bool | Flag indicating whether suppliers can enter retainage attributes during the negotiation. If true, they are allowed; if false, they are not. |
| NegotiationTitle | String | Title or description of the purpose of the negotiation, summarizing what the negotiation is about. |
| Negotiation | String | Unique identifier for the negotiation, used to track and reference the specific negotiation instance. |
| NegotiationStatus | String | Current status of the negotiation (for example, 'Open', 'Closed', 'Pending'). |
| AmendmentDescription | String | Description of changes made to the negotiation when it is amended, providing context for the updates. |
| Synopsis | String | A summary of the negotiation, providing a brief overview of the negotiation details. |
| NegotiationTypeId | Long | Unique identifier for the type of negotiation, helping categorize the negotiation (for example, Auction, RFQ, RFI). |
| NegotiationType | String | The type of negotiation, which could include Auction, RFQ, or RFI. |
| NegotiationStyleId | Long | Unique identifier for the style of the negotiation, allowing categorization by the format or process used. |
| NegotiationStyle | String | Name of the negotiation style, which can indicate the process or method used (for example, sealed bid, open bidding). |
| LargeNegotiationFlag | Bool | Flag indicating whether the negotiation is considered large in scope, often affecting the negotiation process or criteria. |
| TwoStageEvaluationFlag | Bool | Flag indicating whether two-stage evaluation is enabled for the negotiation. If true, two-stage evaluation is used; if false, it is not. |
| BuyerId | Long | Unique identifier for the buyer, the person who created or is managing the negotiation. |
| Buyer | String | The name of the person who created the negotiation, typically the buyer or procurement manager. |
| ProcurementBUId | Long | Unique identifier for the procurement business unit associated with the negotiation, helping track the ownership of the negotiation. |
| ProcurementBU | String | Name of the procurement business unit that owns the negotiation, helping to link the negotiation to the relevant department. |
| Outcome | String | Display name of the purchasing document created at the end of the negotiation process, indicating the final result of the negotiation. |
| ApprovalAmount | Decimal | Amount used in the approval process for the negotiation, which could be the negotiation amount or the agreement amount. |
| NoteToNegotiationApprovers | String | Notes for the approvers when submitting the negotiation document for approval. |
| SourceAgreement | String | The agreement being renegotiated or referenced in the current negotiation process. |
| POStyleId | Long | Unique identifier for the purchasing document style associated with the negotiation. |
| POStyle | String | Name or description of the purchasing document style used for the negotiation. |
| PODoctypeCode | String | Code identifying the document type of the purchasing document related to the negotiation. |
| PODoctype | String | Description of the purchasing document type associated with the negotiation. |
| TechnicalStageUnlockedBy | String | The person or role that unlocked the technical stage in the negotiation. |
| TechnicalStageUnlockedDate | Datetime | The date and time when the technical stage was unlocked in the negotiation process. |
| TechnicalStageUnsealedBy | String | The person or role that unsealed the technical stage in the negotiation. |
| TechnicalStageUnsealedDate | Datetime | The date and time when the technical stage was unsealed, marking a shift in the negotiation process. |
| CommercialStageUnlockedBy | String | The person or role that unlocked the commercial stage in the negotiation. |
| CommercialStageUnlockedDate | Datetime | The date and time when the commercial stage was unlocked, marking the transition to this phase in the negotiation. |
| CommercialStageUnsealedBy | String | The person or role that unsealed the commercial stage in the negotiation. |
| CommercialStageUnsealedDate | Datetime | The date and time when the commercial stage was unsealed, allowing the transition to a new phase in the negotiation. |
| PreviewImmediatelyFlag | Bool | Flag indicating whether suppliers can view the negotiation immediately after publication but before they can respond. If true, suppliers can view the negotiation; if false, they cannot. |
| PreviewDate | Datetime | The date when suppliers are allowed to view the negotiation but are not yet allowed to respond. |
| CloseDate | Datetime | The date when the negotiation closes, ceasing to accept replies from suppliers. |
| DaysAfterOpenDate | Decimal | The number of days after the open date when the negotiation will close, defining the duration of the negotiation period. |
| StaggeredClosingFlag | Bool | Flag indicating whether staggered closing is enabled for the negotiation, allowing different lines to close at different times. |
| StaggeredClosingInterval | Decimal | The time interval between two negotiation lines when staggered closing is enabled, defining the difference in closing times. |
| FirstLineCloseDate | Datetime | The date when the first line of the negotiation closes when staggered closing is enabled. |
| AutoExtendFlag | Bool | Flag indicating whether the negotiation will automatically extend if certain conditions are met, such as the submission of new responses. |
| AutoExtendMinimumTriggerRank | Decimal | The minimum rank of response that can trigger an automatic extension of the negotiation. |
| AutoExtendAllLinesFlag | Bool | Flag indicating whether all lines should be extended automatically in case of an extension, or just the lines with winning responses. |
| AutoExtensionsNumber | Decimal | The number of times the negotiation can be extended automatically, based on predefined conditions. |
| AutoExtendTriggerPeriod | Decimal | The time period before the close date that allows responses to trigger an extension. |
| AutoExtendFromCloseDateFlag | Bool | Flag indicating whether the extension period is counted from the original close date or from the start of the negotiation extension. |
| AutoExtendDuration | Decimal | The duration of the extension applied when the negotiation is extended automatically. |
| OpenImmediatelyFlag | Bool | Flag indicating whether suppliers can respond immediately after the negotiation is published. If true, they can respond immediately; if false, they cannot. |
| OpenDate | Datetime | The date when the negotiation begins accepting replies from suppliers. |
| AwardByDate | Datetime | The date when the negotiation is expected to award the contract based on the responses received. |
| ResponseVisibilityCode | String | Code indicating when the supplier can view details from competing responses, with options like Open, Sealed, or Blind. |
| ResponseVisibility | String | Specifies when the supplier can view details from competing responses, providing visibility into how transparent the negotiation process is. |
| OverallRankingMethodCode | String | Code identifying the method used to calculate overall rankings for supplier responses, such as 'Response amount only' or 'Composite scoring'. |
| OverallRankingMethod | String | Method used to calculate the overall ranking for supplier responses, such as using response amounts or composite scoring. |
| NegotiationLayoutName | String | Layout used by Oracle Business Intelligence Publisher to generate the negotiation PDF document. |
| ResponseLayoutName | String | Layout used by Oracle Business Intelligence Publisher to generate the negotiation response PDF document. |
| ContractTermsLayout | String | Layout used by Oracle Business Intelligence Publisher to generate the contract terms PDF document for the negotiation. |
| EnableTeamScoringFlag | Bool | Flag indicating whether team scoring is enabled for evaluating negotiation requirements, allowing multiple evaluators to score the responses. |
| EnableRequirementWeightsFlag | Bool | Flag indicating whether weights are applied to requirements when calculating the total score in the negotiation. |
| EnableSectionWeightsFlag | Bool | Flag indicating whether section weights are applied when calculating the total score for the negotiation. |
| DisplayRequirementScoresFlag | Bool | Flag indicating whether the supplier can view the requirement scoring criteria during the negotiation process. |
| DefaultMaximumRequirementScore | Decimal | Default maximum score for each requirement in the negotiation, representing the highest possible score a supplier can achieve for a requirement. |
| RequisitioningBUId | Long | Unique identifier for the requisition business unit, linking the negotiation to the relevant requisition unit. |
| RequisitioningBU | String | Name of the requisition business unit that sets default values for negotiation lines. |
| PriceTiersCode | String | Code identifying the type of price tier applied in the negotiation, such as 'None', 'Price Break', or 'Quantity'. |
| PriceTiers | String | Type of price tier applied in the negotiation, with options such as 'None', 'Price Break', or 'Quantity'. |
| RankIndicatorCode | String | Code identifying how supplier replies are ranked during the negotiation, such as 'Best', '1,2,3', or 'No'. |
| RankIndicator | String | Indicator used to rank supplier replies during the negotiation, with options such as 'Best', '1,2,3', or 'No'. |
| RankingMethodCode | String | Code identifying the method used to rank supplier replies, such as 'Price' or 'Multiattribute'. |
| RankingMethod | String | Method used to rank supplier replies in the negotiation, such as 'Price' or 'Multiattribute'. |
| DisplayScoresToSuppliersFlag | Bool | Flag indicating whether suppliers can view the line attribute scoring criteria during the negotiation. |
| RestrictToInvitedSuppliersFlag | Bool | Flag indicating whether only invited suppliers can participate in the negotiation, restricting access to others. |
| RestrictToInvitedSuppliersDisplayFlag | Bool | Flag indicating whether suppliers can see if the negotiation is restricted to invited suppliers. |
| ViewNotesAndAttachmentsFlag | Bool | Flag indicating whether suppliers can view contract terms, notes, and attachments submitted by other suppliers. |
| ViewNotesAndAttachmentsDisplayFlag | Bool | Flag indicating whether suppliers can see if they are allowed to view contract terms, notes, and attachments from other suppliers. |
| RespondOnAllLinesFlag | Bool | Flag indicating whether suppliers can respond to all lines in the negotiation, or if they can respond selectively. |
| RespondOnAllLinesDisplayFlag | Bool | Flag indicating whether suppliers can view whether they are required to respond to all lines in the negotiation. |
| DisplayBestPriceBlindFlag | Bool | Flag indicating whether the best price is displayed to suppliers during a blind negotiation. |
| RequireFullQuantityFlag | Bool | Flag indicating whether the response must match the full quantity requested in the negotiation. |
| RequireFullQuantityDisplayFlag | Bool | Flag indicating whether suppliers can see if the negotiation requires responses to match the full quantity requested. |
| EnforcePreviousRoundPriceAsStartPriceFlag | Bool | Flag indicating whether the previous round’s price is used as the start price for the current round. |
| AllowMultipleResponsesFlag | Bool | Flag indicating whether suppliers can submit more than one response during each negotiation round. |
| AllowMultipleResponsesDisplayFlag | Bool | Flag indicating whether suppliers can see if they are allowed to submit multiple responses. |
| AllowResponseRevisionFlag | Bool | Flag indicating whether suppliers can revise their active replies during each negotiation round. |
| AllowResponseRevisionDisplayFlag | Bool | Flag indicating whether suppliers can see if they are allowed to revise their responses. |
| RevisedResponseLinePriceRuleCode | String | Code specifying how revised responses must modify their price, such as 'No Restriction' or 'Lower Than Previous Price'. |
| RevisedResponseLinePriceRule | String | Describes the rule for modifying revised responses' prices, including options like 'No Restriction' or 'Lower Than Previous Price'. |
| ResponseRevisionDecrementTypeCode | String | Code identifying the type of minimum price reduction in revised responses, either 'Amount' or 'Percentage'. |
| ResponseRevisionDecrementType | String | Displays the type of minimum price reduction in revised responses, either as an 'Amount' or 'Percentage'. |
| ResponseRevisionDecrementValue | Decimal | The minimum amount or percentage by which the price must be reduced in each revised response. |
| AgreementStartDate | Date | Date when the purchase agreement becomes effective, often used in renegotiations. |
| AgreementEndDate | Date | Date when the purchase agreement expires, specifying the end of the agreement. |
| PaymentTermsId | Long | Unique identifier for the payment terms applied by the supplier based on invoice due date and discount date. |
| PaymentTerms | String | Name of the payment terms the supplier applies, indicating when and how the payment for the invoice should be made. |
| CarrierId | Long | Unique identifier for the transportation company responsible for moving goods from one location to another. |
| Carrier | String | The name of the transportation company responsible for delivering the goods. |
| ModeOfTransportCode | String | Code identifying the mode of transportation used to move the goods, such as 'Land', 'Sea', or 'Air'. |
| ModeOfTransport | String | Mode of transport used to ship the goods, providing details about the transportation method. |
| ServiceLevelCode | String | Code identifying the priority of the shipping service, used to determine the speed of delivery. |
| ServiceLevel | String | Describes the service level, indicating the priority of shipping to ensure timely delivery. |
| ShippingMethod | String | Method used for shipping, combining the carrier, transport mode, and service level for complete logistics information. |
| AgreementAmount | Decimal | Total amount for the purchase agreement, typically used as a baseline for renegotiation. |
| MinimumReleaseAmount | Decimal | The minimum amount for any purchase order line that the application can release for the purchase agreement line. |
| FreightTermsCode | String | Code identifying the freight terms used in the negotiation, indicating whether the buyer or supplier pays for shipping. |
| FreightTerms | String | The freight terms used in the negotiation, specifying who bears the shipping costs. |
| FOBCode | String | Code identifying the point where the ownership of goods and risk of loss transfers from the supplier to the buyer. |
| FOB | String | Point of delivery where the ownership of goods and the cost of loss or damage transfer from the supplier to the buyer. |
| BuyerManagedTransportationFlag | Bool | Flag indicating whether the buying company is responsible for managing the transportation of goods. |
| CurrencyCode | String | Code identifying the currency used in the negotiation for pricing. |
| Currency | String | Name of the currency used in the negotiation. |
| AllowOtherResponseCurrencyFlag | Bool | Flag indicating whether suppliers can submit responses in a currency other than the negotiation's currency. |
| PricePrecision | Decimal | Number of decimal places the application displays for pricing attributes in supplier responses. |
| ConversionRateTypeCode | String | Code identifying the type of currency conversion rate used for converting responses to the negotiation currency. |
| ConversionRateType | String | Describes the type of currency conversion rate used in the negotiation process. |
| ConversionRateDate | Date | The date when the conversion rate was applied to convert the response currency to the negotiation currency. |
| DisplayRatesToSuppliersFlag | Bool | Flag indicating whether suppliers can view the currency exchange rates used in the negotiation. |
| ScoringStatusCode | String | Code representing the scoring status of the negotiation, showing whether it is in progress or completed. |
| ScoringStatus | String | Describes the current status of scoring for the negotiation, indicating whether it's still being calculated or has been finalized. |
| TechnicalStageScoringStatusCode | String | Code representing the scoring status for the technical stage of the negotiation. |
| TechnicalStageScoringStatus | String | Describes the status of scoring in the technical stage of the negotiation. |
| CommercialStageScoringStatusCode | String | Code representing the scoring status for the commercial stage of the negotiation. |
| CommercialStageScoringStatus | String | Describes the status of scoring in the commercial stage of the negotiation. |
| ContractSource | String | Source of the contract, specifying where the contract originated from, such as a prior agreement or new negotiation. |
| ContractTermsTemplateId | Decimal | Unique identifier for the contract terms template applied to the negotiation. |
| ContractTermsTemplate | String | Template used for the contract terms in the negotiation, helping to standardize agreement terms. |
| CreatedBy | String | The name or identifier of the user who created the negotiation record. |
| CreationDate | Datetime | The date and time when the negotiation record was created. |
| LastUpdateDate | Datetime | The date and time when the negotiation record was last updated. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the negotiation record. |
| CoverPageText | String | Text displayed on the cover page of the negotiation document. |
| GeneralIntroductionText | String | Text that provides a general introduction or overview of the negotiation. |
| TermsInstructionText | String | Text that explains how to negotiate terms within the context of the negotiation. |
| RequirementInstructionText | String | Text that describes how to respond to each requirement in the negotiation. |
| LinesInstructionText | String | Text that provides specific instructions for the negotiation line items. |
| PrebidFlag | Bool | Flag indicating whether pre-bid is enabled in the negotiation, allowing suppliers to review the terms before submitting bids. |
| LineDecrementFlag | Bool | Flag indicating whether line-level price decrement is enabled in the negotiation, allowing suppliers to lower their prices in subsequent rounds. |
| AiDataDurationInMonths | Long | Duration, in months, for which AI data is used to influence the negotiation. |
| PersonId | Long | Unique identifier for the person managing or overseeing the negotiation process. |
| NegotiationSupplierLayoutName | String | The layout name used to generate supplier-facing documents for the negotiation in the negotiation supplier layout. |
| NegotiationBuyerLayoutName | String | The layout name used to generate buyer-facing documents for the negotiation in the negotiation buyer layout. |
| TimeRemaining | String | Text indicating the remaining time in the negotiation process, usually counting down until closing. |
| BuyerCompanyName | String | The name of the company representing the buyer in the negotiation. |
| LoggedInPerson | String | Name of the person currently logged into the system, associated with managing the negotiation. |
| Finder | String | Search or query reference used for filtering or locating specific negotiation records. |
| EffectiveDate | Date | Query parameter used to fetch resources based on their effective date, typically indicating when the negotiation or contract becomes valid. |