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.
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.
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