SEARCH BY ACCOUNT NAME DOESN'T SHOW SOME CUSTOMER BUT SEARCH BY PARTY NUMBER DOES

(Doc ID 1529680.1)

Last updated on NOVEMBER 24, 2017

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Oracle Receivables - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Attempting to search an Account Name, using DQM search, and it fails to return the record.
When the same is performed, using the Party Number, the results display correctly.

HZ_STAGED_PARTIES table stores the Account Name in one single column (HZ_PARTIES.TX32) and space is used as delimited.

The size of this field is 2000 chars.

If the party has more than 250 accounts under it, then field is not big enough to fold all the account names.
It seems to hold whatever accounts it can hold and the rest are not saved in the field.

This causes issues with a Party with large number of accounts.

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