Workflow Monitor Agent not recognizing Table Owner (Doc ID 2055266.1)

Last updated on SEPTEMBER 11, 2015

Applies to:

Siebel Workflow - Version 8.1.1.14.8 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.14.7 [IP2014] version, Siebel Marketing

ACTUAL BEHAVIOR
---------------

Workflow Monitor Agent not recognizing the table owner while querying the policy condition and deletes the record from S_ESCL_REQ table without doing policy action

SELECT T0.ROW_ID

               FROM

                              &Table_Owner.S_SRC_EVT_REG T0 ,

                              &Table_Owner.S_SRC T1 

               WHERE

                              T1.SUB_TYPE = 'EVENT' AND

                              T0.EVT_REG_STATUS_CD = 'Invited' AND

                              T0.PERSON_ID IS NOT NULL  AND

                              T0.ROW_ID = ? AND

                              T1.ROW_ID = T0.SRC_EVT_ID

 



EXPECTED BEHAVIOR
-----------------------
Workflow Monitor Agent should query with right table owner

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