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

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms