CountRecords BC Method - Incorrect SQL Generated When Running On Oracle DB - Errors SBL-DBC-00108 and ORA-00920

(Doc ID 1513686.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.0.0.13 [20448] and later
Information in this document applies to any platform.
Checked for Relevance on 19-May-2014
Checked for Relevance on 11-Jan-2016

Symptoms

After an upgrade from Siebel 8.0.0.6 and Oracle 10g to Siebel 8.0.0.13 and Oracle 11g we experience a scripting issue when using the CountRecords() BC method with a customized BC ('Asset Mgmt - Asset - Header'). We have isolated how to reproduce this error: using a simple BS that execute a query followed by a count record Siebel build in a wrong way the count query totally different from the previous select statement. We have two different behaviors when using ExecuteQuery:

* ForwardOnly mode --> when executing the CountRecord() the exception of bad formatted query is displayed in the UI and the count is NOT performed,
* ForwardBackward mode --> when executing the CountRecord() the exception of bad formatted query is NOT displayed in the UI, the count is performed but the error 1 is logged.

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