Creating Revenue Lines Passing The ItemNumber Instead Of The InventoryItemId Using Rest Web Services (Doc ID 2364305.1)

Last updated on DECEMBER 22, 2020

Applies to:

Symptoms

On : 11.12.1.0.0 version, Opportunities

Creating Revenue Lines passing the ItemNumber instead of the InventoryItemId



Using the REST API, we are creating revenue lines but are unable to create revenue lines without passing the InventoryItemId - we had hoped to just pass the ItemNumber, which is unique.

We get 500 - Internal server error when doing so.

e.g. this will go through fine:
POST https://gbn.crm.em2.oraclecloud.com/salesApi/resources/11.1.11/opportunities/401314/child/ChildRevenue
{
  "InventoryOrgId":300000001738147,
  "EstimatedDeliveryDate_c":"2018-08-20T00:00:00+01:00",
  "ProductType":"Item",
  "InventoryItemId":300000077782712,
  "Quantity":1,
  "UnitPrice":200,
  "RevnAmount":200,
  "WinProb":10,
  "ActionPlanFlag_c":false,
  "Comments":"TEST 1"
}

e.g. this will NOT go through fine:
POST https://gbn.crm.em2.oraclecloud.com/salesApi/resources/11.1.11/opportunities/401314/child/ChildRevenue
{
"EstimatedDeliveryDate_c":"2018-08-20T00:00:00+01:00",
  "ProductType":"Item",
  "ItemNumber": "FZ-G130PENDJ",
  "Quantity":1,
  "UnitPrice":200,
  "RevnAmount":200,
  "WinProb":10,
  "ActionPlanFlag_c":false,
  "Comments":"TEST 2"
}

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.