My Oracle Support Banner

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

Last updated on OCTOBER 21, 2019

Applies to:

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

Goal

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:

https://docs.oracle.com/cd/B31104_02/books/AssignMgrAdm/AssignMgrAdm_BasicConfig12.html#wp1005490:

"
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.
"
 

Solution

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
Goal
Solution
References


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