My Oracle Support Banner

Searching For Customers In The Collections Form Retrieves Both Customers And Suppliers (Doc ID 1547138.1)

Last updated on FEBRUARY 19, 2019

Applies to:

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


Need the ability to limit the Organization field in IEXRCALL to Customers only and not suppliers.

The Organization field List of Values (LOV) will show parties which do not have accounts. This was narrowed down to multiple rows in HZ_Parties.
For example:
Find Fidxxx% brings back 2 rows for each entry
1) Fidxxx Xxxx Xxxx,
    - party number 31279 with address
    - party number 53110 with no address since no account was ever defined.

In the AR Customer form, this was also occurring but has been resolved by patch 6703782 R12.AR.B which supplied profile option: AR: Show Parties Without Accounts In DQM. When this profile is set to NO, parties with no accounts will not show in the Customer form.

Advanced Collections is still showing parties with no accounts, even when the profile option, AR: Show Parties Without Accounts is set to No.
Basically, if this profile is set to NO, then parties with no accounts should not show in the LOV.


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.