My Oracle Support Banner

Assignment Manager Composite Criteria With 1:1 Join Field (Doc ID 2521494.1)

Last updated on JULY 20, 2021

Applies to:

Siebel CRM - Version 16.19 [IP2016] and later
Information in this document applies to any platform.


Is it possible to have an Assignment Criteria being composed of Assignment Criteria Attributes that are NOT part of the same Base Table?

According to the Assignment Guide, it is not possible, however, tests reveal that this works fine when having a field based on a table other than the main base Table of the Assignment Object:

Composite Criteria
Assignment criteria attributes make it possible for a single assignment criterion to consist of multiple attributes, known as composite criteria.

For composite criteria, all the attributes must have a 1:1 relationship and should refer to the same base table record. For example, the Account City-State-Country is a good composite criterion because San Mateo (city) resides in the state of California (state) and California resides in the USA (country). All of these attributes are stored on the same record in the same table.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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