My Oracle Support Banner

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:

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


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:

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

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




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

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