My Oracle Support Banner

SEARCH BY ACCOUNT NAME DOESN'T SHOW SOME CUSTOMER BUT SEARCH BY PARTY NUMBER DOES (Doc ID 1529680.1)

Last updated on JUNE 15, 2018

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.

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!


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