Collections Form is Not Returning Any Data When a Search is Performed with Order Number (Doc ID 1573221.1)

Last updated on JANUARY 11, 2017

Applies to:

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

Symptoms

Attempting to search by a Sales Order in the Customer View By (IEXLSGEN): Transaction form and no results are returned.
The second attempt at the query shows results.
 
Steps to Reproduce:
Responsibility:  Advanced Collections
Navigation:  Collections Agent > Search
IEXLSGEN form opens
Switch to Customer View By: Transaction
Mark Sales Order search option
Enter Order Number
Click Search Button
No Results are returned, although the Order exists
  
Now, mark any other search option in the form (eg. Organization)
Go back by marking again the Sales Order search option
Enter same Order Number again
Click Search
Now data is returned and the Collections workbench opens with transaction that belongs to the Sales Order

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