My Oracle Support Banner

ORA-00936 When Trying to Prepopulate Based on Rules (Doc ID 948645.1)

Last updated on SEPTEMBER 06, 2019

Applies to:

Identity Manager - Version 9.1.0.2 to 9.1.0.2
Information in this document applies to any platform.
***Checked for relevance on 12-Oct-2012***

Symptoms

A pre-populate adapter has to be configured based on a rule defined with attributes from the process form.

This scenario is needed as there is a requirement to prepopulate different fields depending of different ITResources specified for the same Resource Object.

This is ending with the following error:

ERROR [ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' XELLERATE.DATABASE - select UD_ADUSER_AD from UD_ADUSER where orc_key =
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:480)

Changes

 

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
Changes
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.