My Oracle Support Banner

On Transactions, Second time Query Returns No Results : FRM-40350 (Doc ID 1317448.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


The AR Transaction Form is resulting with no records found error after quering the form for the second time. The first time query is giving results. Now query again and provide the search criteria and now the no data found error is occurring.

User needs to quit the session,change to other responsibility and change back to AR Responsibility to query with second time criteria.Now,it provides results.

Expected Behavior :
Expect that the query is searching and providing the results without quitting the form and responsibility.

Steps To Reproduce :
The issue can be reproduced at will with the following steps: (Please note that the search criteria used here is only example) .
1. Open AR Transaction form and click 'query' button, key the criteria: transaction numbers =XXYY and click on the 'find' button.
2. The query results are displayed.
3. Click 'query' button on the result invoice form and key the criteria as:

GL dates :2010-12-01 to 2010-12-31
Batch Source : ABCD
and then click 'find' button.
4. 'FRM-40350: Query caused no records to be retrieved' is displayed.
While actually ,there are some invoices that meet the criteria specified.
4. Quit this session and change to other Responsibility and then change back to AR
5. Open AR Transaction form and click 'query' button and key the criteria
GL date :2010-12-01 to 2010-12-31
Batch Source : ABCD
and then click 'find' button.
6. Observe that this return several invoices.


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.