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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms