Error SBL-BPR-00162/SBL-EAI-04186 With Siebel Inbound Service And EAIOBJMGR Task Showing Incorrect Sql Statement Randomly After IRR (Doc ID 2920256.1)

Last updated on FEBRUARY 28, 2023

Applies to:

Siebel CRM - Version 22.7 and later
Information in this document applies to any platform.

Symptoms

Siebel 22.7 version

Siebel Inbound service is failing randomly 20% to 30% with below error after IRR in OM log file

Error
-----------------------
Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Insert SR Note'.(SBL-BPR-00162)
--
Picklist validation of field 'SR Number' in integration component 'INS SR Note' did not find any matches satisfying the query '[SR Number] = "1-454442121521"', and an attempt to create a new record through the picklist failed.(SBL-EAI-04186)

Steps to reproduce the issue
-----------------------
1.From SOAPUI/POSTMAN try to trigger respective inbound webservice
2.Perform IRR (Incremental Repository Migration) and it fails with the above error

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

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

Error SBL-BPR-00162/SBL-EAI-04186 With Siebel Inbound Service And EAIOBJMGR Task Showing Incorrect Sql Statement Randomly After IRR (Doc ID 2920256.1)

Applies to:

Symptoms

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!