My Oracle Support Banner

Workflow For Rules Assignment Having Issue (Doc ID 2101859.1)

Last updated on JULY 21, 2020

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 production database and load it into standby.

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

We created a 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, the WorkMon task failed with the following error:

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:(Custom name 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





Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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