Tableau Connector for Oracle Fusion Cloud Financials

Build 26.0.9770

SellerNegotiations

Returns procurement negotiations from the perspective of the participating seller.

Columns

Name Type SupportedFinders Description
AuctionStatusCode String Code for the current status of the auction.
SellerAuctionHeaderId [KEY] Long PrimaryKey Value that uniquely identifies the seller negotiation.
NegotiationStatus String Status of the negotiation. A list of accepted values is defined in the lookup type PON_AUCTION_STATUS.
NegotiationStatusCode String Abbreviation that uniquely identifies the status of the negotiation. A list of accepted values is defined in the lookup type PON_AUCTION_STATUS.
TimeRemaining String Indicates the time remaining before the seller negotiation closes.
NumberOfActiveBids Long Total number of active bids currently valid in the seller negotiation.
NumberOfBids Long Total number of bids submitted for the seller negotiation.
CurrentDateTime Datetime Current system date and time.
NegotiationTitle String Text that describes the purpose of the negotiation.
Negotiation String Number that identifies the seller negotiation.
AwardStatusCode String Status of the negotiation award.
OwnerId Long Value that uniquely identifies the person who created the negotiation.
Owner String Name of the person who created the negotiation.
ProcurementBUId Long Value that uniquely identifies the procurement business unit that owns the seller negotiation.
ProcurementBU String Name of the procurement business unit that owns the seller negotiation.
CurrencyCode String Abbreviation that identifies the negotiation currency.
Currency String Name of the negotiation currency.
Synopsis String Brief summary of the seller negotiation.
InstructionText String Text that provides instructions for participants in the seller negotiation.
PreviewImmediatelyFlag Bool Contains one of the following values: true, false, or null. If true, then bidders can preview the seller negotiation immediately after it's published. If false, then bidders can preview the negotiation only when it opens at its scheduled start time. If null, then the value hasn't been set. The default value is null.
PreviewDate Datetime Date and time when the seller negotiation becomes available for bidder preview.
CloseDate Datetime Date when the negotiation stops accepting bids from bidders.
OpenImmediatelyFlag Bool Contains one of the following values: true, false, or null. If true, bidders can submit bids immediately after the seller's negotiation is published. If false, bidders can submit bids only when the negotiation opens at its scheduled start time. If null, the value hasn't been set. The default value is null.
OpenDate Datetime Date when the negotiation starts accepting bids from bidders.
AwardByDate Datetime Date when the application awards the negotiation.
AutoExtendFlag Bool Contains one of the following values: true, false, or null. If the value is true, automatic extension on the close date is permitted based on the settings established in the negotiation. If the value is null, it indicates that no value has been assigned. The default setting is null.
AutoExtensionsNumber Decimal Number of times the application can extend the negotiation.
AutoExtendTriggerPeriod Decimal Time period (in minutes) before the negotiation close date during which a submitted bid can trigger an automatic extension.
AutoExtendDuration Decimal Number of minutes the application extends the negotiation when the negotiation meets the extension criteria.
IsPausedFlag Bool Contains one of the following values: true or false. If true, the negotiation is paused, if false, the negotiation isn't paused.
PausedRemarks String Note to bidders provided by the buyer when pausing a seller negotiation.
PausedDate Datetime Date and time when the seller negotiation was paused.
ResumeRemarks String Note to bidders provided by the buyer when resuming a paused seller negotiation.
DraftLockedFlag Bool Contains one of the following values: true, false, or null. If true, the draft negotiation is locked for editing. If false, the negotiation isn't locked for editing. If null, the value hasn't been set. The default value is null.
DraftLockedDate Datetime Date when the draft negotiation was locked.
DraftLockedByPersonId Long Unique identifier for the user who locked the draft negotiation.
DraftLockedBy String Name of the person who locked the draft negotiation.
DraftUnlockedDate Datetime Date when the draft negotiation was unlocked.
DraftUnlockedByPersonId Long Unique identifier for the user who unlocked the draft negotiation.
CreationDate Datetime Date and time when the user created the seller negotiation.
CreatedBy String User who created the seller negotiation.
LastUpdateDate Datetime Date and time when the user most recently updated the seller negotiation.
LastUpdatedBy String User who most recently updated the seller negotiation.
BidderNegotiationStatus String The status of the negotiation as displayed to the bidder.
BidderNegotiationStatusCode String Abbreviation that uniquely identifies the status of the negotiation displayed to the bidder.
CategorySetId Long Collection of items grouped into categories.
InventoryOrganizationId Long Default inventory organization ID for the procurement business unit.
NumberOfExtensionsOccured Decimal Value that identifies the number of extensions that have occurred when Autoextend is enabled.
ProjectedRevenue Decimal Maximum revenue from only the lines where bids meet the reserve price.
NoteToAcceptedBidders String Note for bidders whose bid has been accepted by the auctioneer.
NoteToRejectedBidders String Note for bidders whose bid has been rejected by the auctioneer.
TotalAwardAmount Decimal Award amount for the seller negotiation.
ShareAwardDecisionFlag Bool Contains one of the following values: true, false, or null. If true, then the award decision has been shared with bidders. If false, then the award decision hasn't been shared with bidders. If null, then the value hasn't been set. The default value is null.
Finder String A named finder reference used to filter or locate specific seller negotiations when querying.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770