Using ProductItemDescription Attribute In REST API Payload Gives "Applying List binding LOV_ProductItemDescription with given set of values leads to multiple matching rows" error (Doc ID 2859465.1)

Last updated on APRIL 01, 2022

Applies to:

Symptoms

Create service request via REST Api failing due to duplicate item descriptions in sales catalog

For creating service request item must be present in Sales Catalog. If the item provided in the payload has same description as other item present in the sales catalog then service request creation API fails.

POST:
https://<pod url>.oraclecloud.com/crmRestApi/resources/11.13.18.05/serviceRequests

{
  "Title":"testItemDesc2",
  "ProductItemNumber":"90000080",
  "InventoryItemId":"300000000011111",
  "InventoryOrgId":"300000002222222"
  "ProductItemDescription":"HHH Test 10 Item"
}

 

ERROR
-----------------------
Request returns Error  "Applying List binding LOV_ProductItemDescription with given set of values leads to multiple matching rows for a row of type:ServiceRequestRest, key oracle.jbo.Key[30000003333333]

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Make POST call with REST api - https://<pod url>.oraclecloud.com/crmRestApi/resources/11.13.18.05/serviceRequests

Payload

{
  "Title":"testItemDesc2",
  "ProductItemNumber":"90000080",
  "InventoryItemId":"300000000011111",
  "InventoryOrgId":"300000002222222"
  "ProductItemDescription":"HHH Test 10 Item"
}

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create service requests

Changes

Cause

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