Product: Applying List Binding LOV_Description With Given Set Of Values Leads To Multiple Matching using REST API
Last updated on DECEMBER 20, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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.
“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 ]”.
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
The issue has the following business impact:
Due to this issue, users cannot update the Line item using the inventoryItemID
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