Add Negotiation Lines and Lots
You can use the Supplier Negotiations child Lines resource to create, query, and update lines, lots, and groups in a draft negotiation. Additionally, you can add attributes, price tiers and price breaks when creating lots and lines.
Here's a typical application processing flow for the scenarios:
- You create a negotiation line with price tiers and lot lines.
- You get the lot line
- You update the line
Add a Negotiation Line and Lot
In this scenario, you create a negotiation line with price tiers and lot lines with attributes. You can provide a unique sequence number to negotiation line, lot, and lot lines. You can add reference from lot line to parent lot's sequence number as the parent sequence number.
Example URL
Use this resource URL format.
POST
curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.batch+json" -d 'request payload' "https://servername/fscmRestApi/resources/version"
Example Request
Here's an example of the request body in JSON format.
Path: /supplierNegotiations/AuctionHeaderId/child/lines
{
"parts": [
{
"id": "part1",
"path": "/supplierNegotiations/300100194904133/child/lines/",
"operation": "create",
"payload": {
"SequenceNumber": 1,
"LineType": "Goods",
"LineDescription": "Chair",
"ItemId": 300100121356766,
"ItemRevision": "A",
"UOM": "Each",
"CategoryId": 1,
"GroupTypeCode": "LINE",
"TargetPrice": 100,
"Quantity": 100,
"CurrentPrice": "120",
"StartPrice": "119",
"NoteToSuppliers": "Black, preferred",
"ShipToLocation": "Swiss HQ",
"RequestedDeliveryDate": "2021-04-05",
"RequisitioningBUId": 204,
"DisplayTargetPriceFlag": true,
"priceTiers": [
{
"MinimumQuantity": 95,
"MaximumQuantity": 105,
"TargetPrice": 95
},
{
"MinimumQuantity": 75,
"MaximumQuantity": 94,
"TargetPrice": 105
}
]
}
},
{
"id": "part2",
"path": "/supplierNegotiations/300100194904133/child/lines/",
"operation": "create",
"payload": {
"SequenceNumber": 2,
"GroupType": "Lot",
"LineType": "Goods",
"CategoryId": 1,
"LineDescription": "Ergonomic Desks",
"Quantity": 100,
"CurrentPrice": 300,
"StartPrice": 280,
"TargetPrice": 250,
"ShipToLocation": "SN_Service_EFF",
"RequisitioningBUId": 204
}
},
{
"id": "part3",
"path": "/supplierNegotiations/300100194904133/child/lines/",
"operation": "create",
"payload": {
"SequenceNumber": 3,
"ParentSequenceNumber": 2,
"GroupType": "Lot line",
"LineType": "Goods",
"CategoryId": 1,
"LineDescription": "Automatic Desks",
"ShipToLocation": "SN_Service_EFF",
"Quantity": 100,
"CurrentPrice": 350,
"StartPrice": 320,
"TargetPrice": 300,
"DisplayTargetPriceFlag": true,
"RequisitioningBUId": 204,
"lineAttributeGroups": [
{
"GroupName": "Durability",
"lineAttributes": [
{
"AttributeName": "Material Thickness",
"ResponseType": "Required",
"ValueType": "Number",
"TargetNumberValue": 100,
"DisplayTargetFlag": true
},
{
"AttributeName": "Material Type",
"ResponseType": "Required",
"ResponseTypeCode": "REQUIRED",
"ValueType": "Text"
}
]
}
]
}
},
{
"id": "part4",
"path": "/supplierNegotiations/300100194904133/child/lines/",
"operation": "create",
"payload": {
"SequenceNumber": 4,
"ParentSequenceNumber": 2,
"GroupType": "Lot line",
"LineType": "Goods",
"CategoryId": 1,
"LineDescription": "Automatic Desks",
"ShipToLocation": "SN_Service_EFF",
"Quantity": 100,
"CurrentPrice": 350,
"StartPrice": 320,
"TargetPrice": 300,
"DisplayTargetPriceFlag": true,
"RequisitioningBUId": 204,
"lineAttributeGroups": [
{
"GroupName": "Durability",
"lineAttributes": [
{
"AttributeName": "Material Thickness",
"ResponseType": "Required",
"ValueType": "Number",
"TargetNumberValue": 100,
"DisplayTargetFlag": true
},
{
"AttributeName": "Material Type",
"ResponseType": "Required",
"ResponseTypeCode": "REQUIRED",
"ValueType": "Text"
}
]
}
]
}
}
]
}
Example Response
Here's an example of the response body in JSON format.
{
"parts": [
{
"id": "part1",
"path": "https://servername/fscmRestApi/resources/version/supplierNegotiations/300100194904133/child/lines",
"operation": "create",
"payload": {
"AuctionHeaderId": 300100194904133,
"LineId": 17,
"GroupTypeCode": "LINE",
"GroupType": "Line",
"Line": "9",
"LineCloseDate": null,
"RequisitioningBU": "Vision Operations",
"RequisitioningBUId": 204,
"LineTypeId": 1,
"LineType": "Goods",
"ItemId": 300100121356766,
"Item": "SPARC_SERVER4",
"ItemRevision": "A",
"LineDescription": "Chair",
"CategoryId": 1,
"CategoryName": "Miscellaneous_1",
"Quantity": 100,
"UOMCode": "Ea",
"UOM": "Each",
"EstimatedTotalAmount": null,
"MinimumReleaseAmount": null,
"ShipToLocationId": 11303,
"ShipToLocation": "Swiss HQ",
"RequestedShipDate": null,
"RequestedDeliveryDate": "2021-04-05",
"PriceAndQuantityEnabledFlag": true,
"CurrentPrice": 120,
"StartPrice": 119,
"TargetPrice": 100,
"DisplayTargetPriceFlag": true,
"UnitTargetPrice": null,
"DisplayUnitTargetPriceFlag": null,
"NoteToSuppliers": "Black, preferred",
"AllowAlternateLinesFlag": false,
"PriceBreakTypeCode": null,
"PriceBreakType": null,
"SuppliersCanModifyPriceBreaksFlag": null,
"Requisition": null,
"RequisitionLine": null,
"SourceAgreement": null,
"SourceAgreementLine": null,
"CreationDate": "2020-05-21T00:25:43+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.598+00:00",
"LastUpdatedBy": "CLARE.JONES",
"SequenceNumber": null,
"ParentSequenceNumber": null,
"ParentLine": null,
"EstimatedQuantity": null,
"priceTiers": {
"items": [
{
"AuctionHeaderId": 300100194904133,
"LineId": 17,
"PriceTierId": 1,
"MinimumQuantity": 95,
"MaximumQuantity": 105,
"TargetPrice": 95,
"CreatedBy": "CLARE.JONES",
"CreationDate": "2020-05-21T00:25:43.180+00:00",
"LastUpdatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.601+00:00",
"links": [
{
...
}
]
},
{
"AuctionHeaderId": 300100194904133,
"LineId": 17,
"PriceTierId": 2,
"MinimumQuantity": 75,
"MaximumQuantity": 94,
"TargetPrice": 105,
"CreatedBy": "CLARE.JONES",
"CreationDate": "2020-05-21T00:25:44.631+00:00",
"LastUpdatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.612+00:00",
"links": [
{
...
}
]
}
],
"count": 2,
"hasMore": false,
"limit": 9,
"offset": 0,
"links": [
{
...
}
]
},
"links": [
{
...
}
]
}
},
{
"id": "part2",
"path": "https://servername/fscmRestApi/resources/version/supplierNegotiations/300100194904133/child/lines",
"operation": "create",
"payload": {
"AuctionHeaderId": 300100194904133,
"LineId": 18,
"GroupTypeCode": "LOT",
"GroupType": "Lot",
"Line": "10",
"LineCloseDate": null,
"RequisitioningBU": "Vision Operations",
"RequisitioningBUId": 204,
"LineTypeId": 1,
"LineType": "Goods",
"ItemId": null,
"Item": null,
"ItemRevision": null,
"LineDescription": "Ergonomic Desks",
"CategoryId": 1,
"CategoryName": "Miscellaneous_1",
"Quantity": 100,
"UOMCode": "Ea",
"UOM": "Each",
"EstimatedTotalAmount": null,
"MinimumReleaseAmount": null,
"ShipToLocationId": 300100032293499,
"ShipToLocation": "SN_Service_EFF",
"RequestedShipDate": null,
"RequestedDeliveryDate": null,
"PriceAndQuantityEnabledFlag": true,
"CurrentPrice": 300,
"StartPrice": 280,
"TargetPrice": 250,
"DisplayTargetPriceFlag": false,
"UnitTargetPrice": null,
"DisplayUnitTargetPriceFlag": null,
"NoteToSuppliers": null,
"AllowAlternateLinesFlag": false,
"PriceBreakTypeCode": null,
"PriceBreakType": null,
"SuppliersCanModifyPriceBreaksFlag": null,
"Requisition": null,
"RequisitionLine": null,
"SourceAgreement": null,
"SourceAgreementLine": null,
"CreationDate": "2020-05-21T00:25:44.744+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.614+00:00",
"LastUpdatedBy": "CLARE.JONES",
"SequenceNumber": null,
"ParentSequenceNumber": null,
"ParentLine": null,
"EstimatedQuantity": null,
"links": [
{
...
}
]
}
},
{
"id": "part3",
"path": "https://servername/fscmRestApi/resources/version/supplierNegotiations/300100194904133/child/lines",
"operation": "create",
"payload": {
"AuctionHeaderId": 300100194904133,
"LineId": 19,
"GroupTypeCode": "LOT_LINE",
"GroupType": "Lot line",
"Line": "10.1",
"LineCloseDate": null,
"RequisitioningBU": "Vision Operations",
"RequisitioningBUId": 204,
"LineTypeId": 1,
"LineType": "Goods",
"ItemId": null,
"Item": null,
"ItemRevision": null,
"LineDescription": "Automatic Desks",
"CategoryId": 1,
"CategoryName": "Miscellaneous_1",
"Quantity": 100,
"UOMCode": "Ea",
"UOM": "Each",
"EstimatedTotalAmount": null,
"MinimumReleaseAmount": null,
"ShipToLocationId": 300100032293499,
"ShipToLocation": "SN_Service_EFF",
"RequestedShipDate": null,
"RequestedDeliveryDate": null,
"PriceAndQuantityEnabledFlag": true,
"CurrentPrice": 350,
"StartPrice": 320,
"TargetPrice": 300,
"DisplayTargetPriceFlag": true,
"UnitTargetPrice": null,
"DisplayUnitTargetPriceFlag": null,
"NoteToSuppliers": null,
"AllowAlternateLinesFlag": false,
"PriceBreakTypeCode": null,
"PriceBreakType": null,
"SuppliersCanModifyPriceBreaksFlag": null,
"Requisition": null,
"RequisitionLine": null,
"SourceAgreement": null,
"SourceAgreementLine": null,
"CreationDate": "2020-05-21T00:25:45.046+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.616+00:00",
"LastUpdatedBy": "CLARE.JONES",
"SequenceNumber": null,
"ParentSequenceNumber": null,
"ParentLine": null,
"EstimatedQuantity": null,
"lineAttributeGroups": {
"items": [
{
"AuctionHeaderId": 300100194904133,
"LineId": 19,
"GroupId": 300100194904280,
"GroupName": "Durability",
"CreationDate": "2020-05-21T00:25:45.129+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.547+00:00",
"LastUpdatedBy": "CLARE.JONES",
"lineAttributes": {
"items": [
{
"AuctionHeaderId": 300100194904133,
"LineId": 19,
"GroupId": 300100194904280,
"AttributeId": 10,
"AttributeName": "Material Thickness",
"ResponseType": "Required",
"ResponseTypeCode": "REQUIRED",
"ValueType": "Number",
"ValueTypeCode": "NUM",
"TargetDateValue": null,
"TargetNumberValue": 100,
"TargetTextValue": null,
"DisplayTargetFlag": true,
"Weight": null,
"CreationDate": "2020-05-21T00:25:45.142+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.548+00:00",
"LastUpdatedBy": "CLARE.JONES",
"links": [
{
...
}
]
},
{
"AuctionHeaderId": 300100194904133,
"LineId": 19,
"GroupId": 300100194904280,
"AttributeId": 20,
"AttributeName": "Material Type",
"ResponseType": "Required",
"ResponseTypeCode": "REQUIRED",
"ValueType": "Text",
"ValueTypeCode": "TXT",
"TargetDateValue": null,
"TargetNumberValue": null,
"TargetTextValue": null,
"DisplayTargetFlag": null,
"Weight": null,
"CreationDate": "2020-05-21T00:25:45.176+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.551+00:00",
"LastUpdatedBy": "CLARE.JONES",
"links": [
{
...
}
]
}
],
"count": 2,
"hasMore": false,
"limit": 9,
"offset": 0,
"links": [
{
...
}
]
}
],
"count": 1,
"hasMore": false,
"limit": 9,
"offset": 0,
"links": [
{
...
}
]
},
"links": [
{
...
}
]
}
},
{
"id": "part4",
"path": "https://servername/fscmRestApi/resources/version/supplierNegotiations/300100194904133/child/lines",
"operation": "create",
"payload": {
"AuctionHeaderId": 300100194904133,
"LineId": 20,
"GroupTypeCode": "LOT_LINE",
"GroupType": "Lot line",
"Line": "10.2",
"LineCloseDate": null,
"RequisitioningBU": "Vision Operations",
"RequisitioningBUId": 204,
"LineTypeId": 1,
"LineType": "Goods",
"ItemId": null,
"Item": null,
"ItemRevision": null,
"LineDescription": "Automatic Desks",
"CategoryId": 1,
"CategoryName": "Miscellaneous_1",
"Quantity": 100,
"UOMCode": "Ea",
"UOM": "Each",
"EstimatedTotalAmount": null,
"MinimumReleaseAmount": null,
"ShipToLocationId": 300100032293499,
"ShipToLocation": "SN_Service_EFF",
"RequestedShipDate": null,
"RequestedDeliveryDate": null,
"PriceAndQuantityEnabledFlag": true,
"CurrentPrice": 350,
"StartPrice": 320,
"TargetPrice": 300,
"DisplayTargetPriceFlag": true,
"UnitTargetPrice": null,
"DisplayUnitTargetPriceFlag": null,
"NoteToSuppliers": null,
"AllowAlternateLinesFlag": false,
"PriceBreakTypeCode": null,
"PriceBreakType": null,
"SuppliersCanModifyPriceBreaksFlag": null,
"Requisition": null,
"RequisitionLine": null,
"SourceAgreement": null,
"SourceAgreementLine": null,
"CreationDate": "2020-05-21T00:25:45.306+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.619+00:00",
"LastUpdatedBy": "CLARE.JONES",
"SequenceNumber": null,
"ParentSequenceNumber": null,
"ParentLine": null,
"EstimatedQuantity": null,
"lineAttributeGroups": {
"items": [
{
"AuctionHeaderId": 300100194904133,
"LineId": 20,
"GroupId": 300100194904281,
"GroupName": "Durability",
"CreationDate": "2020-05-21T00:25:45.391+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.558+00:00",
"LastUpdatedBy": "CLARE.JONES",
"lineAttributes": {
"items": [
{
"AuctionHeaderId": 300100194904133,
"LineId": 20,
"GroupId": 300100194904281,
"AttributeId": 10,
"AttributeName": "Material Thickness",
"ResponseType": "Required",
"ResponseTypeCode": "REQUIRED",
"ValueType": "Number",
"ValueTypeCode": "NUM",
"TargetDateValue": null,
"TargetNumberValue": 100,
"TargetTextValue": null,
"DisplayTargetFlag": true,
"Weight": null,
"CreationDate": "2020-05-21T00:25:45.401+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.558+00:00",
"LastUpdatedBy": "CLARE.JONES",
"links": [
{
...
}
]
},
{
"AuctionHeaderId": 300100194904133,
"LineId": 20,
"GroupId": 300100194904281,
"AttributeId": 20,
"AttributeName": "Material Type",
"ResponseType": "Required",
"ResponseTypeCode": "REQUIRED",
"ValueType": "Text",
"ValueTypeCode": "TXT",
"TargetDateValue": null,
"TargetNumberValue": null,
"TargetTextValue": null,
"DisplayTargetFlag": null,
"Weight": null,
"CreationDate": "2020-05-21T00:25:45.431+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:25:45.561+00:00",
"LastUpdatedBy": "CLARE.JONES",
"links": [
{
...
}
]
}
],
"count": 2,
"hasMore": false,
"limit": 9,
"offset": 0,
"links": [
{
...
}
]
},
"links": [
{
...
}
]
}
],
"count": 1,
"hasMore": false,
"limit": 9,
"offset": 0,
"links": [
{
...
}
]
},
"links": [
{
... }
]
}
}
]
}Get a Lot Line
In this scenario, you query a lot line to review its details.
Example URL
Use this resource URL format.
GET
curl -u username:password "https://servername/fscmRestApi/resources/version/supplierNegotiations/AuctionHeaderId/child/lines/LineId"
For example:
curl -u username:password "https://servername/fscmRestApi/resources/version/supplierNegotiations/300100194904133/child/lines/16"
Example Response
Here's an example of the response body in JSON format.
{
"AuctionHeaderId": 300100194904133,
"LineId": 16,
"GroupTypeCode": "LOT_LINE",
"GroupType": "Lot line",
"Line": "8.2",
"LineCloseDate": null,
"RequisitioningBU": "Vision Operations",
"RequisitioningBUId": 204,
"LineTypeId": 1,
"LineType": "Goods",
"ItemId": null,
"Item": null,
"ItemRevision": null,
"LineDescription": "Automatic Desks",
"CategoryId": 1,
"CategoryName": "Miscellaneous_1",
"Quantity": 100,
"UOMCode": "Ea",
"UOM": "Each",
"EstimatedTotalAmount": null,
"MinimumReleaseAmount": null,
"ShipToLocationId": 300100032293499,
"ShipToLocation": "SN_Service_EFF",
"RequestedShipDate": null,
"RequestedDeliveryDate": null,
"PriceAndQuantityEnabledFlag": true,
"CurrentPrice": 350,
"StartPrice": 320,
"TargetPrice": 300,
"DisplayTargetPriceFlag": true,
"UnitTargetPrice": null,
"DisplayUnitTargetPriceFlag": null,
"NoteToSuppliers": null,
"AllowAlternateLinesFlag": false,
"PriceBreakTypeCode": null,
"PriceBreakType": null,
"SuppliersCanModifyPriceBreaksFlag": null,
"Requisition": null,
"RequisitionLine": null,
"SourceAgreement": null,
"SourceAgreementLine": null,
"CreationDate": "2020-05-20T22:30:06.728+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-20T22:30:07.035+00:00",
"LastUpdatedBy": "CLARE.JONES",
"SequenceNumber": null,
"ParentSequenceNumber": null,
"ParentLine": null,
"EstimatedQuantity": null,
"links": [
{
...
}
]
}Update a Lot Line
In this scenario, you update the quantity and target price for a lot line.
Example URL
Use this resource URL format.
PATCH
curl -X PATCH -u "username:password" -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/supplierNegotiations/AuctionHeaderId/child/lines/LineId"
For example:
curl -X PATCH -u "username:password" -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/supplierNegotiations/300100194904133/child/lines/16"
Example Request
Here's an example of the request body in JSON format.
{
"Quantity": 110,
"TargetPrice": "290"
} Example Response
Here's an example of the response body in JSON format.
{
"AuctionHeaderId": 300100194904133,
"LineId": 16,
"GroupTypeCode": "LOT_LINE",
"GroupType": "Lot line",
"Line": "8.2",
"LineCloseDate": null,
"RequisitioningBU": "Vision Operations",
"RequisitioningBUId": 204,
"LineTypeId": 1,
"LineType": "Goods",
"ItemId": null,
"Item": null,
"ItemRevision": null,
"LineDescription": "Automatic Desks",
"CategoryId": 1,
"CategoryName": "Miscellaneous_1",
"Quantity": 110,
"UOMCode": "Ea",
"UOM": "Each",
"EstimatedTotalAmount": null,
"MinimumReleaseAmount": null,
"ShipToLocationId": 300100032293499,
"ShipToLocation": "SN_Service_EFF",
"RequestedShipDate": null,
"RequestedDeliveryDate": null,
"PriceAndQuantityEnabledFlag": true,
"CurrentPrice": 350,
"StartPrice": 320,
"TargetPrice": 290,
"DisplayTargetPriceFlag": true,
"UnitTargetPrice": null,
"DisplayUnitTargetPriceFlag": null,
"NoteToSuppliers": null,
"AllowAlternateLinesFlag": false,
"PriceBreakTypeCode": null,
"PriceBreakType": null,
"SuppliersCanModifyPriceBreaksFlag": null,
"Requisition": null,
"RequisitionLine": null,
"SourceAgreement": null,
"SourceAgreementLine": null,
"CreationDate": "2020-05-20T22:30:06.728+00:00",
"CreatedBy": "CLARE.JONES",
"LastUpdateDate": "2020-05-21T00:18:41+00:00",
"LastUpdatedBy": "CLARE.JONES",
"SequenceNumber": null,
"ParentSequenceNumber": null,
"ParentLine": null,
"EstimatedQuantity": null,
"links": [
{
...
}
]
}