Workflow For Rules Assignment Having Issue

(Doc ID 2101859.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Assignment Manager - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.9 [23016] version, Assignment Manager

The production had a problem and went down, and there is a Standby environment.

We took prroduction database and load it into standby.

We are running Dynamic Assignment with an assignment policy for Assignment Object 'Product Defect'.

We created few auto assignment rules. Where in Product Defect will be auto assigned to the respective owner based on selection of Product Defect Area and product Defect Subarea. We see the rules are not getting executed properly and it is being assigned to the owner or some random user(employee).

The dynamic assignment is not working.

ERROR

SQLParseAndExecute Statement 4 000000025678141c:0 2015-12-21 11:45:02

  select rle.NAME, rle.OBJECT_NAME, rle.ROW_ID,

  rle.RULE_DURATION, rle.QUALIFY_COUNT, rle.SUB_TYPE_CD, rle.ASGN_OBJECT_NAME,

  rle.ACTIVATE_DT, rle.EXPIRE_DT, {fn ifnull (rle.BATCH_FLG, 'N')}

  from dbo.S_ESCL_RULE rle,

  dbo.S_ESCL_GROUP grp

  where grp.NAME = ? and

  rle.GROUP_ID = grp.ROW_ID

SQLParseAndExecute Bind Vars 4 000000025678141c:0 2015-12-21 11:45:02 01:YB Assignment Rules


SQLParseAndExecute Prepare + Execute 4 000000025678141c:0 2015-12-21 11:45:02 Time: 0s, Rows: 0, Avg. Time: 0s [Row count does not apply to SELECT statements]

ProcReq GenericFatal 0 000000025678141c:0 2015-12-21 11:45:02 YB Assignment Rules in LoadRules

GenericLog GenericError 1 000000025678141c:0 2015-12-21 11:45:02 Message: ESCL-30,
Additional Message: YB Assignment Rules


ProcReq GenericFatal 0 000000025678141c:0 2015-12-21 11:45:02 Error in LoadRules

GenericLog GenericError 1 000000025678141c:0 2015-12-21 11:45:02 Message: ESCL-16,
Additional Message: Error


GenericLog GenericError 1 000000025678141c:0 2015-12-21 11:45:02 (esclmain.cpp (332) err=458805 sys=126) SBL-ESC-00053: Error loading rule definitions





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