My Oracle Support Banner

Opportunities Created Using Webservice Fails with Error SBL-EAI-04401: Cannot find entry 'Quote' in the bounded picklist for the field 'Sales Stage' in integration component 'Opportunity' (Doc ID 3049657.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

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

Symptoms

On : 24.2 version, Siebel EAI

Opportunity creation using webservice and integration objects fails despite of passing correct Sales method and Sales stage.
EAI logs show it is pointing to a seed data ACAPS application instead of the Sales Method provided in the request payload.
Rerunning same request works after an hour or so.
Siebel seems randomizes the Sales Method and use default Sales method "ACAPS Application" to search for the Sales Stage.

SELECT
  T1.CONFLICT_ID,
  CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),
  CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8),
  T1.LAST_UPD_BY,
  T1.CREATED_BY,
  T1.MODIFICATION_NUM,
  T1.ROW_ID,
  T1.PHASE_CD,
  T1.NAME,
  T1.STG_ORDER,
  T1.STAGE_STATUS_CD,
  T1.RCMND_WIN_PROB,
  T2.BU_ID,
  CAST(? AS VARCHAR(128))
  FROM
  dbo.S_STG T1
  LEFT OUTER JOIN dbo.S_SALES_METHOD T2 ON T1.SALES_METHOD_ID = T2.ROW_ID
  WHERE
  (T1.SALES_METHOD_ID = ?) AND
  (T1.NAME = ?)
  ORDER BY
  T1.STG_ORDER

ObjMgrSqlLog Detail 4 0000003a66ce2408:0 2024-08-30 15:14:27 Bind variable 1: EAIObjMgr_enu,SiebelACPT3,27263011,SVCBIZTALKACPT,0000003a66ce2408:0,,Sales Cycle Def,

ObjMgrSqlLog Detail 4 0000003a66ce2408:0 2024-08-30 15:14:27 Bind variable 2: 0V-X8J1F

ObjMgrSqlLog Detail 4 0000003a66ce2408:0 2024-08-30 15:14:27 Bind variable 3: Quote

ObjMgrSqlLog Debug 5 0000003a66ce2408:0 2024-08-30 15:14:27 User search spec: [Sales Cycle Stage] = "Quote"

ObjMgrSqlLog Debug 5 0000003a66ce2408:0 2024-08-30 15:14:27 Named search [PickListSearch]: [Parent Sales Method Id] = "0V-X8J1F" <=== this is related to Sales Method "ACAPS application"

ObjMgrSqlLog Debug 5 0000003a66ce2408:0 2024-08-30 15:14:27 User sort spec: Sales Stage Order



The issue can be reproduced at will with the following steps:
1. Execute an upsert to Opportunity using webservice call
2. Fails with error:

ObjMgrLog Error 1 0000003a66ce2408:0 2024-08-30 15:14:27 (adptutils.cpp (3582)) SBL-EAI-04401: Cannot find entry 'Quote' in the bounded picklist for the field 'Sales Stage' in integration component 'Opportunity'





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
Symptoms
Cause
Solution
References


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