Strange select statement in picklist hierarchical

Hi All,

I am trouble shoot an Inbound Web service which failed to upsert a record in Action BC. I checked that the Intergation Object as well as the underlay business component objects are not changed on the latest relase. However, I found a strange SQL in the log and it is because SQL unable to find the record in S_LST_OF_VAL, therefore, it cannot upsert a record in Action BC. Please look into below SQL, the strange setup is impossible to find a record in the table. The first line under the WHERE cause is causing record not found.