Opportunities Are Not Being Assigned According To Assignment Rule Setup Eventhough Candidates Are Available, Error "Rule failed because no candidate passed"
Last updated on AUGUST 01, 2016
Applies to:Siebel CRM - Version 220.127.116.11 and later
Information in this document applies to any platform.
*** Checked for currency AUG-01-2016 ***
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.
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