My Oracle Support Banner

Search By Account Number Doesn't Show Some Customer But Search By Party Number Does (Doc ID 1529680.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


Attempting to search an Account Number 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 Number in one single column (HZ_PARTIES.TX35) 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 hold all the account numbers.
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.




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

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