API call to add line to Sales Quotation returns error ORA-20124: Error.NULLVALUE: Field [ProbabilityToWin] is mandatory

Question

Hello,

I am trying to add a line to a Sales Quotation using a REST API from C# and I am always receiving the following error:
ORA-20124: Error.NULLVALUE: Field dProbabilityToWin] is mandatory for Order Quotation Line and requires a value.

I DO have ProbabilityToWin in my payload and have tried several iterations of a value (100, 1, 0, 0.1, 0.9). I have also written many API integrations with IFS so I’m not new to this.

Here is a snippit of the payload:
"UnitPriceInclTax": 0.00,
"ProbabilityToWin": 100,
"OrderSupplyType": "InventOrder",

and the API URL is:

/main/ifsapplications/projection/v1/SalesQuotationHandling.svc/OrderQuotationSet(QuotationNo='{1}')/OrderQuotationLinesArray

This happens in both 23R1 SU10 and 23R2 SU3.

Any help would be greatly appreciated.

Regards,

Robert Blansett

Page 1 / 1

We ended up digging through Order_Quotation_Line_API package. It turns out if you set LineItemNo to anything > 0 this changes the functionality of the API which effectively replaces some of the values passed in. In some cases, it sets them to NULL. If you don’t set LineItemNo, it functions as expected.

Reply

VenatorInc · Accepted Answer

We ended up digging throughOrder_Quotation_Line_API package. It turns out if you setLineItemNo to anything > 0 this changes the functionality of the API which effectively replaces some of the values passed in. In some cases, it sets them to NULL. If you don’t setLineItemNo, it functions as expected.

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded