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 to
Information in this document applies to any platform.
***Checked for relevance on 12-Oct-2012***


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(
at oracle.jdbc.driver.DatabaseError.newSQLException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.executeForDescribe(
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeQuery(
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(
at weblogic.jdbc.wrapper.Statement.executeQuery(




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

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