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

Last updated on MAY 09, 2023

Applies to:

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

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