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 7.7.2.8 SIA [18379] to 8.1.1.5 SIA [21229] [Release V7 to V8]z*OBSOLETE: Microsoft Windows Server 2003
Database: Oracle 9.2.0.6
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
Symptoms
The issue:
- - -
While working on order entry BC, we have found the following SQL being generated by Siebel:
SELECT
COUNT (*)
FROM
SIEBEL.S_PARTY T1,
SIEBEL.S_ACCNT_POSTN T2,
SIEBEL.S_LST_OF_VAL T3,
SIEBEL.S_INVOICE T4
WHERE
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.
- - -
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 |