JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062