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:

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

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