Incorrect SQL Generated by Siebel - Error SBL-DBC-00108 - BC Order Entry - Orders (Doc ID 520357.1)

Last updated on MARCH 02, 2017

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

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

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