Search By Account Number Doesn't Show Some Customer But Search By Party Number Does
(Doc ID 1529680.1)
Last updated on APRIL 18, 2025
Applies to:
Oracle Trading Community - Version 12.1.3 and laterOracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
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.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |