Sales Manager > Quoting > Search And Select Opportunity Name Returns No Rows

(Doc ID 2132921.1)

Last updated on MARCH 27, 2017

Applies to:

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


On : 12.2.4 version, Installation

R12 - Search and Select: Opportunity Name returns no rows when trying to link a quote to an existing opportunity.

The same search in database returns more than 5000 counts

Search results should return the expected opportunities

The issue can be reproduced at will with the following steps:
1. Resp Sales manager > Quotes Link
2. Search for an existing quote in status Draft
3. Open quote header
4. Enter search string 'CVT%' and press search button
5. No rows returned

But if I run a query in the DB, it returns the expected results >

select count(*) from
where 1=1
and org_id= 42
and description like 'CVT%'

over 5000 Opportunities are returned with this query

The issue has the following business impact:
Due to this issue, users cannot link Quotes to the Opportunities




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms