Product: Applying List Binding LOV_Description With Given Set Of Values Leads To Multiple Matching using REST API

(Doc ID 2341346.1)

Last updated on DECEMBER 20, 2017

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

Product: Applying List binding LOV_Description with given set of values leads to multiple matching

We loaded products into OSC as part of data migration. Some of the products have duplicates descriptions. For example, we loaded part number “SD_000_U 23-OPT10D” with a description of “Accessories”. We also loaded part number “SD_000_U 27-OPT10D”, also with a description of “Accessories”.
 
In the REST API, if we try to set the InventoryItemId of a revenue item to either of the products with a description of “Accessories”, we get an error message

This is 100% reproducible with any product that has a duplicate description (I tested it for a dozen different records with duplicate descriptions). It works for all products with a unique description.


 
ERROR
-----------------------

“Product: Applying List binding LOV_Description with given set of values leads to multiple matching rows for a row of type:OpportunityEO_ChildRevenue_OpportunityVOToRevenueVO_RevenueVO, key oracle.jbo.Key[300000155699755 ]”.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In REST, try to update an Opportunity Line Item with a product that has a duplicate description
2. error appears


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update the Line item using the inventoryItemID

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