My Oracle Support Banner

Concurrent accesses to static pick list give error SBL-DAT-00225 in Workflow Process Manager (Doc ID 535385.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel System Software - Version SIA [19221] and later
Oracle Solaris on SPARC (64-bit)


Here is the problem encountered :-

Assume a workflow process that does and EAI Siebel Adpater, method Upsert.  The process is executed in the WfProcMgr component.  Just after the start up of the component, while the LOV have not been yet loaded, several tasks are started simultaneously. If there are concurrent accesses to the same pick list, one is failing with the error below.

SBL-EAI-04186: Picklist validation of field '%1' in integration component '%2' did not find any matches satisfying the query '%3', and an attempt to create a new record through the picklist failed.

SBL-DAT-00225: The value entered in field %2 of buscomp %3 does not match any value in the bounded pick list %1.

However, the value does exist in the database and is successfully used in other case without any changes.




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

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