Power BI Connector for Oracle Fusion Cloud Financials

Build 26.0.9770

SupplierNegotiationPurchasingDocumentsLineAllocationsSummaryLineAllocationsByResponse

Returns the line allocation amounts for supplier negotiation purchasing documents broken down by supplier response.

Columns

Name Type SupportedFinders Description
SupplierNegotiationPurchasingDocumentsAuctionHeaderId [KEY] Long Value that finds purchasing document header details using the AuctionHeaderId as the primary key.
LineAllocationsSummaryAuctionHeaderId [KEY] Long Value that finds line allocation summary data using the Auction Header ID as the primary key.
LineAllocationsSummaryLineNumber [KEY] Decimal Value that finds line allocation summary data using the Awarded Line as the primary key.
RequisitionNumber String Requisition number that the negotiation line references.
RequisitionLineNumber Decimal Requisition line number that the negotiation line references.
UnitOfMeasure String Abbreviation that identifies the unit of measure for the item in the negotiation.
UnitOfMeasureCode String Code for the unit of measure for the item in the negotiation.
RequisitionQuantity Decimal Quantity of the requisition line items.
AllocatedAwardQuantity Decimal Award quantity allocated to requisition demand.
AvailableAwardQuantity Decimal Award quantity that isn't yet allocated to requisition demand.
AwardQuantity Decimal Total quantity of line items awarded in a supplier negotiation.
BidNumber [KEY] Long Value that uniquely identifies a negotiation response.
PartyName String Name of the supplier company that the application invited in response to the negotiation.
SupplierSiteCode String Unique identifier of the supplier site.
SupplierContact String Name of the supplier's employee who represents the supplier in communication with the buying organization.
RequestedDeliveryDate Date Date when the application requests to deliver the item that the negotiation line references.
RequestedShipDate Date Date when the application requests to ship the item that the negotiation line references.
PromisedDeliveryDate Date Date on which the supplier has promised to deliver the goods to the buying organization.
PromisedShipDate Date Date on which the supplier has promised to ship the goods to the buying organization if the Buyer Managed transportation is checked in negotiation terms.
NegotiationDisplayLineNumber String Value that identifies the line number of the negotiation line. For an alternate line, the value refers to the line number of the original negotiation line for which the alternate was created.
AlternateLineFlag Bool Contains one of the following values: true or false. If true, the alternate lines are displayed. If false, the alternate lines aren't displayed.
AlternateLineDescription String Description of the alternate line item that the supplier is offering to provide in response to a negotiation line.
AuctionHeaderId Long PrimaryKey Value that uniquely identifies a negotiation.
BidLineNumber [KEY] Decimal Bid line item number.
RequisitionLineId [KEY] Long Get one negotiation detail
RequisitionHeaderId Long Value that uniquely identifies a requisition.
VendorId Long Value that uniquely identifies the supplier.
Finder String A named finder reference used to filter or locate specific line allocations by response for supplier negotiation purchasing documents when querying.

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