My Oracle Support Banner

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

Last updated on JULY 13, 2020

Applies to:

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


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


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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