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.

Symptoms

On : 12.2.4 version, Installation

ACTUAL BEHAVIOR
---------------
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

EXPECTED BEHAVIOR
-----------------------
Search results should return the expected opportunities

STEPS
-----------------------
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
as_leads_all
where 1=1
and org_id= 42
and description like 'CVT%'

over 5000 Opportunities are returned with this query

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

Changes

 

Cause

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