My Oracle Support Banner

Committing Inventory Transaction Fails with SBL-DAT-00225 Error Due to ROW_ID LIKE Query Condition (Doc ID 2690153.1)

Last updated on JULY 15, 2020

Applies to:

Siebel Field Service - Version 16.19 [IP2016] and later
Information in this document applies to any platform.

Symptoms


The following issue was reported with a custom workfow created for committing inventory transactions:

One of the workflow steps consisted in an Update siebel operation on "FS Inventory Transaction" business component.
During this step, an sql with  a where clause  (T1.ROW_ID LIKE :2)  was generated against  'FS Product Inventory Category'  business component.




Condition   (T1.ROW_ID LIKE :2)  cause more records to be retrieved and this cause the following error to occur:

SBL-DAT-00225: The value entered in field Product Inventory Category ID of buscomp FS Bucket does not match any value in the bounded pick list FS PickList bucket Category.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.