My Oracle Support Banner

Insert a Second Price List Item Instance (New Effective Date) with EAI Siebel Adapter Generates an Additional Query Without Parameters and SBL-DAT-00215 (Doc ID 1273957.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel CRM - Version 8.0 SIA [20405] and later
Information in this document applies to any platform.


On : SIA[21219] version, EAI Siebel Adapter BS

Implementation consists of a WF with a step using EAI Siebel Adapter BS / Upsert method, receiving an input SiebelMessage based on 'Admin Price List' BC. The goal of this process is to insert a new Price List Item instance for a Product. The same functionality is provided in Siebel UI, by using button 'New Effective Date'.

Same implementation based on the WF process was working fine in Siebel 8.1.1.

In, the call to EAI Siebel Adapter BS is generating the following error message:

Error invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Upsert Price'.(SBL-BPR-00162)
This operation is not allowed when there are no records displayed. Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215) "


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.