Question

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

  • 11 June 2024
  • 1 reply
  • 25 views
V
Rank
Badge +2

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 [ProbabilityToWin] 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

Bob Blansett

1 reply

V
Rank
Badge +2

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.

Bob Blansett

Reply


Terms & ConditionsCookie settings