My Oracle Support Banner

Huge amount of records in S_ESCL_REQ caused by multiple wf policies using AND condition. (Doc ID 786914.1)

Last updated on JANUARY 03, 2023

Applies to:

Siebel Workflow - Version [63161] Comm/Energy to [21225] [Release V6 to V8]
Information in this document applies to any platform.


We have a group of policies for Service request, we read in the bookshelf that for a multiple conditions in a policy, an "AND" operator is evaluated for all of them. But when we analyze the trigger that Siebel has generated in Oracle Data Base, we didn't see that the operator AND is evaluated.

For this reason we are having trouble with too many records insert in table S_ESCL_REQ ( we have 2 000 000 record pending). In TOADWF image we see the result of a query that demonstrates that one record apply for all rules of one group, we have 6 records inserted at the same time, this behavior does not seems to be normal.

The question is if this behavior is normal?? We attached the trigger and one image for the policy that is generating multiple records in the table that I mentioned


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

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