Opportunities Are Not Being Assigned According To Assignment Rule Setup Eventhough Candidates Are Available, Error "Rule failed because no candidate passed" (Doc ID 1600055.1)

Last updated on AUGUST 01, 2016

Applies to:

Siebel CRM - Version 8.1.1.3[21219] and later
Information in this document applies to any platform.
*** Checked for currency AUG-01-2016 ***

Symptoms

SIEBEL VERSION:
---------------
Siebel 8.1.1.3

ISSUE STATEMENT:
----------------

Customer created many assignment rules to assign Opportunity object to positions. When executing the assignment on a particular opportunity, customer expected a particular rule to pass, this rule:

Rule: LiveTransfer-RouteToRep [5-A5QEI-43]

However, the 'Rule: LiveTransfer-RouteToRep [5-A5QEI-43]' did not pass and returned 'Rule failed because no candidate passed.'

Yet, another rule 'Rule: Error - No Valid Rep Found [5-A5QEI-50]' passed and was used to do the assignment to SADMIN position instead.

The expected rule "LiveTransfer-RouteToRep [5-A5QEI-43]" uses dynamic candidate, the dynamic candidate SQL issued/seen in the log file is the following:

2013-10-03 13:47:57 -------------------- END CRITERIA EVALUATION -----------------------
Match Object 2 0000d1c0524d0b7c:0 2013-10-03 13:47:57 Sql after substitute Parameters for Dynamica Candidate: SELECT A2.ROW_ID FROM SIEBEL.S_OPTY A1, SIEBEL.S_POSTN A2 WHERE A1.ROW_ID = ? AND A2.PR_EMP_ID = A1.X_ASSIGN_TO_REP AND X_ASSIGN_TO_REP IS NOT NULL

SQLSlowQuery Statement 4 0000d1c0524d0b7c:0 2013-10-03 13:47:57 SELECT A2.ROW_ID FROM SIEBEL.S_OPTY A1, SIEBEL.S_POSTN A2 WHERE A1.ROW_ID = ? AND A2.PR_EMP_ID = A1.X_ASSIGN_TO_REP AND X_ASSIGN_TO_REP IS NOT NULL
SQLSlowQuery Bind Variables 4 0000d1c0524d0b7c:0 2013-10-03 13:47:57 01:5-14GA0TL
...
...
Match Rule 3 0000d1c0524d0b7c:0 2013-10-03 13:47:57 Rule failed because no candidate passed.
Match Rule 3 0000d1c0524d0b7c:0 2013-10-03 13:47:57 Rule failed
Match Rule 3 0000d1c0524d0b7c:0 2013-10-03 13:47:57 ++++++++++++++++++++ END RULE EVALUATION +++++++++++++++++++++++++++++
...
...

When customer ran this SQL against the database server with all the bind variables, it actually returned a record with the position.  However, it does not appear to be seen/passing when issued by assignment manager.

Cause

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