Why you cannot search for Customer Phone Number On Sales Order Form?

(Doc ID 2031633.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Why you cannot search for Customer Phone Number on Sales Order form?

Business wants to see phone number of customer on sales order form.
Go to folder -> show field and add this hidden field on SO form to show phone number (It always comes up blank).
When you put customer name in this field, a LOV pops up and then you can search the phone number with customer name.

It works for some customers when customer name is short but for most of the customers it shows error.

When Customer name is not too long

Keep cursor on Location field and then go to folder->show field->Phone number.
Copy customer name and put that in phone no field and press tab.

It will show all customers’ phone number but just put the customer name% and press enter and you can see all phone numbers for this customer site.

When Customer name is long you will get error message:

"Search by partial Phone Number not allowed"
 

Solution

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