Workflow Process Batch Manager log doesn't show where/when parts of search spec are applied. (Doc ID 1946846.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Universal Customer Master - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Goal

A Workflow Process Batch Manager task is being started to execute a workflow and Search specification is set to the following:

(([UCM Type Code] = 'Queued') or ([UCM Type Code] = 'Processing' and [Updated] <= Timestamp() - 0.002)) AND (Right([UCM External Id],1)='4' OR Right([UCM External Id],1)='5')

WfProcBatchMgr_0010_10487790.log shows that the following WHERE clause is included in the generated select statement:

  WHERE
  T3.X_STORE_ID = T1.SYSTEM_NUM (+) AND
  T3.PR_PER_ADDR_ID = T2.ROW_ID (+) AND
  ((T3.UCM_TYPE_CD IN ( :2 ) OR T3.UCM_TYPE_CD IN ( :3 ) AND T3.LAST_UPD   ORDER BY
  T3.UCM_UID

15:39:37 Bind variable 1: WfProcBatchMgr,CCRDEVSR01,10485789,SADMIN,0000001754570e9c:0,,UCM Contact Source Data and History,
15:39:37 Bind variable 2: Queued
15:39:37 Bind variable 3: Processing
15:39:37 Bind variable 4: 11/05/2014 14:39:37

15:39:37 User search spec: (([UCM Type Code] = 'Queued') or ([UCM Type Code] = 'Processing' and [Updated] <= Timestamp() - 0.002)) AND (Right([UCM External Id],1)='4' OR Right([UCM External Id],1)='5')


The select statement shown in the log doesn’t include (Right([UCM External Id],1)='4' OR Right([UCM External Id],1)='5'). The question is whether only the records that meet the complete search specification are being processed as expected.
 

Solution

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