Creating Revenue Lines Passing The ItemNumber Instead Of The InventoryItemId Using Rest Web Services

(Doc ID 2364305.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms