Collections Dashboard Search Shows Inactive Parties and Accounts (Doc ID 3012544.1)

Last updated on APRIL 10, 2024

Applies to:

Symptoms

When searching by customer name in the Collections dashboard, the search returns both active an inactive customers.  When searching on the same customer in the Manage Customers form, only one record is returned.

Steps to Reproduce:

Responsibility: Collections

1. Search on customer example 'ABC CUSTOMER', the collections results show two values.
2. Search on the same value in the Manage Customers page, and only one value is returned.
3. Verify from the SQL that two customer exist, but one is in active:
   
   select party_id, party_name, party_type, status
   from hz_parties
   where party_name = 'ABC CUSTOMER'
   
   Results:
   PARTY_ID PARTY_NUMBER PARTY_NAME PARTY_TYPE STATUS
   1 5 ABC CUSTOMER ORGANIZATION I
   2 6 ABC CUSTOMER ORGANIZATION A

Cause

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