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 MAY 13, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


Issue while updating the Activity through Web-service

Problem 1

- 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"?

Problem 2

Step 1
Customer create a custom Fixed choice List 'Type_Copy', where they are using Standard Lookup type

Meaning : Activity Category Type values

Step 2
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)

Step 3

In the request they were passing

<ns3:Type_copy_c>Quote Request

Step 4

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.


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