Incorrect SQL Generated by Siebel - Error SBL-DBC-00108 - BC Order Entry - Orders
(Doc ID 520357.1)
Last updated on NOVEMBER 22, 2019
Applies to:Siebel Tools - Version 184.108.40.206 SIA  to 220.127.116.11 SIA  [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Database: Oracle 18.104.22.168
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
Checked for Relevance on 02-Nov-2018
- - -
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.
- - -
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