Opportunity Auto Quote Crashes or Fails for a Specific Product (Doc ID 1272783.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 7.8.2.11[19244] and later
Information in this document applies to any platform.

Symptoms


In the customer environment with Siebel dedicated client or SSEObjMgr thin client v7.8.2.11 [19244] ENU, the following is observed when the user tries to generate a quote from a specific opportunity, using a call to standard Business Service 'ISS Revenue Synchronization Service' method 'Quote' from a custom applet called 'H_RF Opty Quote List Applet':

1. The product in the opportunity cannot be retrieved for the current user's organization, and therefore the line item cannot be generated. This leads to an UndoRecord call for the new quote item.

2. The application crashes during the cleanup for the UndoRecord operation.

3. The crash information is:
Exception 0xc0000005 at 0xfffffff9
Thread: 0x0000053c, Process 0x00000f40
:
- CALL STACK -
<invalid> 0xfffffff9
sscfcmn +0x17962 = CSSObjectBase::ClearErrorMsg() +0x12
sscfom +0x4003c = CSSBusComp::ValidateRelatedSiblings() +0x103c
sscfom +0x416cb = CSSBusComp::OnDeleteRecord() +0x7b
sscfom +0x39a54 = CSSBusComp::DeleteRecord() +0x9b4
sscfom +0x3bb35 = CSSBusComp::UndoRecord() +0x165
sscfom +0x3cebf = CSSBusComp::PrepareForDelete() +0x14f
sscfom +0x4491e = CSSBusComp::~CSSBusComp() +0xee
SSCACMBC +0x14457 = CSSBCBase::~CSSBCBase() +0x7a7
SSCAOMBC +0x48b7 = CSSBCOrderMgmtBase::~CSSBCOrderMgmtBase() +0x407
SSCAOMBC +0x19886 = CSSBCOrderMgmtItem::~CSSBCOrderMgmtItem() +0x56
SSCAOMBC +0x1d58d = CSSBCOrderMgmtPriceableItem::~CSSBCOrderMgmtPriceableItem() +0x8d
SSCAOMBC +0x24c85 = CSSBCOrderMgmtQuoteItem::CreateObject() +0xd5
sscfom +0x183a2 = CSSBusComp::Release() +0x22
SSCAORDMGMTSV +0xd892 = CSSISSRevenueSyncService::Quote() +0x72
SSCAORDMGMTSV +0xd7c9 = CSSISSRevenueSyncService::DoInvokeMethod() +0x49
sscfom +0x12e9d = CSSService::InvokeMethod() +0x1bd
sscactxtsvc +0xb520 = CSSISSContextService::InvokeService() +0x250
sscactxtsvc +0xe2d5 = CSSISSContextService::RaiseSignal() +0x375
SSCAOMBC +0x52a9 = CSSBCOrderMgmtBase::DoInvokeMethod() +0x9d9
SSCAOMBC +0x8828 = CSSBCOrderMgmtHeader::DoInvokeMethod() +0xd8
SSCAOMBC +0x168da = CSSBCOrderMgmtQuote::DoInvokeMethod() +0xaa
sscfom +0x21ff2 = CSSBusComp::InvokeMethod() +0xc2
sscaswbc +0x2f2d3 = CSSSWEFrame::DoInvokeMethod() +0x6f3
sscaswbc +0x934a9 = CSSSWEFrameList::DoInvokeMethod() +0x299
swcacmfr +0x78f1 = CSSSWEFrameListBase::DoInvokeMethod() +0x481
SWCAQFFR +0x10477 = CSSSWEFrameListDoc::DoInvokeMethod() +0xe7
SWCAQFFR +0x4366 = CSSSWEFrameListQuote::DoInvokeMethod() +0x66
sscaswbc +0x2940a = CSSSWEFrame::InvokeMethod() +0xda
sscaswbc +0xbb459 = CSSSWEFrameMgrInternal::InvokeAppletMethod() +0x9f9
sscaswbc +0x99353 = CSSSWECmdProcessor::InvokeMethod() +0x4f3
sscaswbc +0x9d46c = CSSSWECmdProcessor::_ProcessCommand() +0x5cc
sscaswbc +0x9e56c = CSSSWECmdProcessor::ProcessCommand() +0x91c
sscaswbc +0x9eaf4 = CSSSWECmdProcessor::ProcessCommand() +0x34
sscaswbc +0x1bb0d1 = CSSServiceSWEIface::Request() +0x2e1
sscaswbc +0x1bbc0b = CSSServiceSWEIface::DoInvokeMethod() +0x69b
sscfom +0x12e9d = CSSService::InvokeMethod() +0x1bd
siebel +0x202f0 = CSSViewWebTemplateItemDef::AddChild() +0x168d0
siebel +0x21350 = CSSViewWebTemplateItemDef::AddChild() +0x17930
siebel +0x77b5
MFC70U +0x21916 = Ordinal5316() +0x3f

REPLICATION STEPS:
==================
1. Login to the customized Siebel Application, connecting to the Siebel Server Database.
2. Navigate to custom view RF Opportunity Quote View and select the opportunity with Row Id 1-1CH08X.
3. Click on the button, which invokes method 'Quote'.

EXPECTED BEHAVIOUR:
===================
A quote with quote items is generated corresponding to the opportunity and its associated products.

ACTUAL BEHAVIOR:
================
When tested with custom SRF, a quote is generated corresponding to the opportunity, but when trying to generate the quote item for one of the associated products the application crashes.
When tested with standard SRF, a quote is generated corresponding to the opportunity, but although there is no error message the new quote does not include any quote items.

THE LOG FILE SHOWS THE FOLLOWING:
=================================
. ***RaiseSignal*** Buscomp: Quote, Signal: Quote, Mode: Quote.
. -> Signal Business Service: ISS Revenue Synchronization Service method: Quote
. Begin: Business Service 'ISS Revenue Synchronization Service' invoke method: 'Quote' at 78996a0
- inserting records for a quote header
- creating a new record in business component 'Quote Item'
- querying for an active product
o with Row Id '1-18WWUY',
o visible to BU '1-14A53Q', and
o where the intersection record S_PROD_INT_BU holds the product name 'BROADBAND ETHERNET RADIO, 4.4-5.0 GHZ pn:RF-7800W-OU440'.
. => SQL Cursor with ID BEDC208 Fetch Rows: 0
. => Error message:
ObjMgrBusCompLog Error 1 0 2010-07-30 10:58:37 (buscomp.cpp (31556)) SBL-DAT-00225: The value entered in field Product of buscomp Quote Item does not match any value in the bounded pick list PickList Internal Orderable Product.
- undoing a new quote item:
. DELETE FROM SIEBEL.S_QUOTE_ITEM WHERE ROW_ID = :1
. Bind variable 1: 1-1U9HBO (Note: this row had not been inserted yet)
. Call Stack shows that this is indeed from an UndoRecord:
sscfdm +0xd1496 = CSSSqlObj::DeleteRecord() +0x4a6
sscfdm +0xd247c = CSSSqlObj::UndoRecord() +0xec
sscfom +0x1b274 = CSSBusComp::SqlUndoRecord() +0x14
sscfom +0x3bb35 = CSSBusComp::UndoRecord() +0x165
sscfom +0x3cebf = CSSBusComp::PrepareForDelete() +0x14f
sscfom +0x4491e = CSSBusComp::~CSSBusComp() +0xee
SSCACMBC +0x14457 = CSSBCBase::~CSSBCBase() +0x7a7
SSCAOMBC +0x48b7 = CSSBCOrderMgmtBase::~CSSBCOrderMgmtBase() +0x407
SSCAOMBC +0x19886 = CSSBCOrderMgmtItem::~CSSBCOrderMgmtItem() +0x56
SSCAOMBC +0x1d58d = CSSBCOrderMgmtPriceableItem::~CSSBCOrderMgmtPriceableItem() +0x8d
SSCAOMBC +0x24c85 = CSSBCOrderMgmtQuoteItem::CreateObject() +0xd5
sscfom +0x183a2 = CSSBusComp::Release() +0x22
SSCAORDMGMTSV +0xd892 = CSSISSRevenueSyncService::Quote() +0x72
SSCAORDMGMTSV +0xd7c9 = CSSISSRevenueSyncService::DoInvokeMethod() +0x49
sscfom +0x12e9d = CSSService::InvokeMethod() +0x1bd
:
- ending with a query for all line items of the new quote with Row Id = 1-1U9HBD, followed by a crash:
. query for all line items of the new quote with Row Id = 1-1U9HBD
. cleanup business components and SQL Cursor objects
. crash:
Exception 0xc0000005 at 0xfffffff9
Thread: 0x0000053c, Process 0x00000f40
:
- CALL STACK -
<invalid> 0xfffffff9
sscfcmn +0x17962 = CSSObjectBase::ClearErrorMsg() +0x12
sscfom +0x4003c = CSSBusComp::ValidateRelatedSiblings() +0x103c
sscfom +0x416cb = CSSBusComp::OnDeleteRecord() +0x7b
sscfom +0x39a54 = CSSBusComp::DeleteRecord() +0x9b4
sscfom +0x3bb35 = CSSBusComp::UndoRecord() +0x165
sscfom +0x3cebf = CSSBusComp::PrepareForDelete() +0x14f
sscfom +0x4491e = CSSBusComp::~CSSBusComp() +0xee
SSCACMBC +0x14457 = CSSBCBase::~CSSBCBase() +0x7a7
SSCAOMBC +0x48b7 = CSSBCOrderMgmtBase::~CSSBCOrderMgmtBase() +0x407
SSCAOMBC +0x19886 = CSSBCOrderMgmtItem::~CSSBCOrderMgmtItem() +0x56
SSCAOMBC +0x1d58d = CSSBCOrderMgmtPriceableItem::~CSSBCOrderMgmtPriceableItem() +0x8d
SSCAOMBC +0x24c85 = CSSBCOrderMgmtQuoteItem::CreateObject() +0xd5
sscfom +0x183a2 = CSSBusComp::Release() +0x22
SSCAORDMGMTSV +0xd892 = CSSISSRevenueSyncService::Quote() +0x72
SSCAORDMGMTSV +0xd7c9 = CSSISSRevenueSyncService::DoInvokeMethod() +0x49
sscfom +0x12e9d = CSSService::InvokeMethod() +0x1bd
sscactxtsvc +0xb520 = CSSISSContextService::InvokeService() +0x250
sscactxtsvc +0xe2d5 = CSSISSContextService::RaiseSignal() +0x375
SSCAOMBC +0x52a9 = CSSBCOrderMgmtBase::DoInvokeMethod() +0x9d9
SSCAOMBC +0x8828 = CSSBCOrderMgmtHeader::DoInvokeMethod() +0xd8
SSCAOMBC +0x168da = CSSBCOrderMgmtQuote::DoInvokeMethod() +0xaa
sscfom +0x21ff2 = CSSBusComp::InvokeMethod() +0xc2
sscaswbc +0x2f2d3 = CSSSWEFrame::DoInvokeMethod() +0x6f3
sscaswbc +0x934a9 = CSSSWEFrameList::DoInvokeMethod() +0x299
swcacmfr +0x78f1 = CSSSWEFrameListBase::DoInvokeMethod() +0x481
SWCAQFFR +0x10477 = CSSSWEFrameListDoc::DoInvokeMethod() +0xe7
SWCAQFFR +0x4366 = CSSSWEFrameListQuote::DoInvokeMethod() +0x66
sscaswbc +0x2940a = CSSSWEFrame::InvokeMethod() +0xda
sscaswbc +0xbb459 = CSSSWEFrameMgrInternal::InvokeAppletMethod() +0x9f9
sscaswbc +0x99353 = CSSSWECmdProcessor::InvokeMethod() +0x4f3
sscaswbc +0x9d46c = CSSSWECmdProcessor::_ProcessCommand() +0x5cc
sscaswbc +0x9e56c = CSSSWECmdProcessor::ProcessCommand() +0x91c
sscaswbc +0x9eaf4 = CSSSWECmdProcessor::ProcessCommand() +0x34
sscaswbc +0x1bb0d1 = CSSServiceSWEIface::Request() +0x2e1
sscaswbc +0x1bbc0b = CSSServiceSWEIface::DoInvokeMethod() +0x69b
sscfom +0x12e9d = CSSService::InvokeMethod() +0x1bd
siebel +0x202f0 = CSSViewWebTemplateItemDef::AddChild() +0x168d0
siebel +0x21350 = CSSViewWebTemplateItemDef::AddChild() +0x17930
siebel +0x77b5
MFC70U +0x21916 = Ordinal5316() +0x3f

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