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:

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