My Oracle Support Banner

Using Sales Person In Lead Search Causes Page Error (Doc ID 2740871.1)

Last updated on DECEMBER 31, 2020

Applies to:

Oracle Sales - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version

When attempting to execute a search in the Leads Summary page, any search that includes or excludes the Sales Person field will cause an exception.


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


The following error stack is displayed.
java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:470)
at oracle.apps.asn.lead.server.ASNLeadQryAMImpl.initLeadQuery(ASNLeadQryAMImpl.java:117)
at sun.reflect.GeneratedMethodAccessor1467.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.asn.lead.webui.ASNLeadLstCO.executeLeadsQuery(ASNLeadLstCO.java:537)
at oracle.apps.asn.lead.webui.ASNLeadLstCO.processRequest(ASNLeadLstCO.java:94)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1  Sales User -> Leads -> Simple Search ->
2. Add the Sales Person as an additional search criteria
3. Sales User -> Leads -> Simple Search -> select sales person -> Go
4. The page exception occurs.



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
References


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