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 22, 2020
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document