My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.