Incorrect SQL Generated by Siebel - Error SBL-DBC-00108 - BC Order Entry - Orders
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 18.104.22.168 SIA  to 22.214.171.124 SIA  [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Database: Oracle 126.96.36.199
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: IBM AIX 5L 5.2
This document was previously published as Siebel SR 38-3458499025.
Checked for Relevance on 07-Jul-2014
Checked for Relevance on 11-Jan-2016
- - -
While working on order entry BC, we have found the following SQL being generated by Siebel:
T4.INVC_TYPE_CD = T3.NAME AND T3.TYPE = 'FS_INVOICE_TYPE' AND T3.LANG_ID = :1 AND
SIEBEL.S_ORG_EXT.PR_POSTN_ID = T2.POSITION_ID (+) AND SIEBEL.S_ORG_EXT.ROW_ID = T2.OU_EXT_ID (+) AND
T2.POSITION_ID = T1.ROW_ID (+) AND
(T3.VAL = :2) AND
(T4.ORDER_ID = :3
Bind variable 1: ENU
Bind variable 2: Order invoice
Bind variable 3: 1-7OYR1
This query is incorrect.
An error has occurred preparing a Sql statement.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00108)
When executed in Toad, it says:
23:54:05 Error: ORA-00904: "SIEBEL"."S_ORG_EXT"."ROW_ID": invalid identifier
We have reviewed the whole configuration of Order Entry Order BC as well as applet configuration and we were not able to find the root cause of that issue?
It does not generate an error which can be seen by user but it does not seem very clean especially from a performance point of view.
- - -
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