Ability to use Leading Wildcard in Territory Management with Seeded Qualifiers (Doc ID 2302541.1)

Last updated on AUGUST 30, 2017

Applies to:

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

Goal

On : 12.1.3 version, Territory Assignment

In territory management, it does not allow the use of a leading wildcard when using the seeded qualifiers such as Customer Name Range.

For example >

When the customer name is Business World and we use Contain operator and the value of World%, it does NOT work.

When the customer name is Business World and we use Contain operator and the value of Business%, it works.


When the customer name is Business World Inc and we use Contain operator and the value of Business World%, it works.

Basically, we have a need to use %World%, to pull up Business World as well as World of Business as well as Out of This World.

But as the leading wild card is not working, we can't use %World%.

But if we create a CMA (Customer Matching Attribute), it does allow us to use leading wildcards and the territories assign correctly.

 


 

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