SEARCH BY ACCOUNT NAME DOESN'T SHOW SOME CUSTOMER BUT SEARCH BY PARTY NUMBER DOES
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.
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.
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