Non-DQM Customer Search on Postal Code in R12.1.3 Does Not Work Like Release 11i (Doc ID 1522858.1)

Last updated on JULY 15, 2016

Applies to:

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

Symptoms

Non DQM Search on Postal Code is not working in Release12.  Receive the following error:

Error
Please fill in search criteria values in at least one of the following fields: Customer, Registry ID, Account Number,
Account Description, Tax Registration Number, Taxpayer ID, D-U-N-S Number, Contact First Name, Contact Last
Name, Contact Phone Number, Address Line 1. Note that the search criteria values should not begin with a
"%" or "_" for at least one of the listed fields.

Set profile option "HZ: Enable DQM Party Search" to No.
Search on Postal Code field only generates the error.

Check the hz_locations table, there is only less than 40 records with that postal code:

COUNT(*)
----------
  38

Searching by postal_code alone works in Release 11i.

What are the minimum fields needed to search in Release 12 non-DQM search screen?

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