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

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
ARXTWMAI
FRM-40350

Symptoms

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
Responsibility.
5. Open AR Transaction form and click 'query' button and key the criteria
as:
GL date :2010-12-01 to 2010-12-31
Batch Source : ABCD
and then click 'find' button.
6. Observe that this return several invoices.

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