My Oracle Support Banner

Workflow Policy Program fails with error 'ORA-00911: invalid character' Since Upgrade To 19.1 (Doc ID 2543311.1)

Last updated on JULY 21, 2020

Applies to:

Siebel CRM - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

On : 19.1 version, Siebel Workflow

Workflow Policy Program issue since upgrade to 19.1

Since we have upgraded a Test region from 16.17 to 19.1 we notice workflow policy programs which contain SQL Statements error out with ORA-00911: invalid character.
Its like the substitution for the ? is not being done.
I have not found any similar issue in support web.


ERROR
-----------------------

SQLError Statement 0 000000035cb028d0:0 2019-04-12 14:59:53 SQL Statement:
select OC.OPTY_ID,OC.PER_ID,replace(C.X_FULL_NAME,'---','') N1, to_char(O.X_TOT_LOAN_AMT,'FM999G999G999G999D00') VAL2 ,replace(C.X_FULL_NAME,'---','') N2

from SIEBEL.S_OPTY_CON OC, SIEBEL.S_CONTACT C, SIEBEL.S_OPTY O

where OC.PER_ID = C.ROW_ID (+)

and OC.OPTY_ID = O.ROW_ID (+)

and OC.ROW_ID=?

SQLError Bind Variables 1 000000035cb028d0:0 2019-04-12 14:59:53 01:2-VMIDES


DBCLog DBCLogError 1 000000035cb028d0:0 2019-04-12 14:59:53 [tp][ODBC Oracle driver][Oracle]ORA-00911: invalid character


GenericLog GenericError 1 000000035cb028d0:0 2019-04-12 14:59:53 Message: Error: An ODBC error occurred,
Additional Message: 37000: [tp][ODBC Oracle driver][Oracle]ORA-00911: invalid character



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.