Issue while updating through Web-service "Applying List binding with given set of values leads to no matching row for a row of type"
(Doc ID 2137588.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Issue while updating the Activity through Web-service
- Customer not facing any issue with Create / update of activity through UI.
- Customer facing the issue while doing an create / update of activity through web-service.
- Their create payload include
and in the response they get an error "The value of the attribute StatusCode is not valid"
- And once they removed 'LogisticsRail_c' and tested, the result was successful.
How removing 'LogisticsRail_c' from the request payload, get rid of the the error "The value of the attribute StatusCode is not valid"?
Customer create a custom Fixed choice List 'Type_Copy', where they are using Standard Lookup type
Meaning : Activity Category Type values
Lookup Type : ZMM_ACTIVITY_TYPE
Under Lookup 'ZMM_ACTIVITY_TYPE' Customer create a new Lookup code on 2016-03-29
Meaning : Quote Request
Lookup Code : Quote Request (customer changed it from QUOTE_REQUEST to Quote Request)
In the request they were passing
In the response customer were getting
JBO-25072: Applying List binding LOV_For_Type_copy_c with given set of values leads to no matching row for a row of type :Activity, key oracle.jbo.Key[300000401444254 ]
What the root cause? and what is the solution?
NOTE : These rule apply to all the object and module with web services with dependent lovs, and not just Activity only.
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