Telesales - Universal Search - Error APP-AST-207295: Query Caused No Records To Be Retrieved when using Quick Seach (Doc ID 2532279.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

On : 12.2.7 version, Universal Search

The TeleSales "Quick Search" for organization found no records, although the LOV finds some records.

Records are also returned if using Expanded Search instead of Quick Search

When using "Quick Search" the following error occurs:

ERROR
-----------------------
APP-AST-207295: Query Caused No Records To Be Retrieved


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigation path: Telesales Resp > Universal Search > Find "Organization" > Tab "Quick Search" > Select "Organization"

2. Enter first characters of organization name with % at the end

3. Click on "..." (to open LOV)

4. The Organization LOV displays some results

5. Select one result with status active and click OK

6. Click "Search"

7. No result are displayed and the reported error occurs

Changes

Cause

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