Workflow For Rules Assignment Having Issue (Doc ID 2101859.1)

Last updated on MARCH 19, 2024

Applies to:

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

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