My Oracle Support Banner

Negotiation Advance Search Page Getting Into Exception When Using Multiple Search Parameters (Doc ID 2703181.1)

Last updated on AUGUST 21, 2020

Applies to:

Oracle Sourcing - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

When attempting to Advanced Search with criteria: Category/ Project Number in sourcing,
the following error occurs.

Error
oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoSuchMethodError, msg=oracle.apps.pon.negotiation.inquiry.server.ItemBuyerSearchVOImpl.getWhereClause(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/Integer;Loracle/jbo/domain/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1102)
at oracle.apps.pon.negotiation.inquiry.webui.BuyerSearchResultTableCO.processRequest(BuyerSearchResultTableCO.java:1125)

## Detail 0 ##
java.lang.NoSuchMethodError: oracle.apps.pon.negotiation.inquiry.server.ItemBuyerSearchVOImpl.getWhereClause(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/Integer;Loracle/jbo/domain/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;

at oracle.apps.pon.negotiation.inquiry.server.ItemBuyerProjSearchVOImpl.getWhereClause(ItemBuyerProjSearchVOImpl.java:104)
at oracle.apps.pon.negotiation.inquiry.server.ItemBuyerProjSearchVOImpl.initQueryForCLM(ItemBuyerProjSearchVOImpl.java:203)


Actual Behavior
Advanced Search with criteria: Category/ Project Number in sourcing returns error


Expected Behavior
Advanced Search with criteria: Category/ Project Number in sourcing should not return any error


Steps to Reproduce:

The issue can be reproduced at will with the following steps:
        1. Navigate to PON > Negotiation Tab > Advanced Search
        2. Enter Criteria Category and Project Number
        3. Go

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
References


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