Siebel SQL Workload Tagging Not Functioning (OCI SQL Tagging Event)

(Doc ID 2316132.1)

Last updated on OCTOBER 10, 2017

Applies to:

Siebel CRM - Version 16.9 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.9 [IP2016] version, System Admin

ACTUAL BEHAVIOR
---------------
Siebel SQL Workload tagging not functioning (OCI SQL Tagging event)

The following events have been set for OM components:

ObjMgrSqlLog=2
ObjMgrSqlTag= 4


But unable to see bind :1 data on DB side as seen below:

SELECT

T26.CONFLICT_ID, T26.LAST_UPD,

....
ROW_ID, :1

FROM...

WHERE

T21.AMS_ACT_ID = T13.ROW_ID (+) AND T26.TARGET_OU_ID = T19.ROW_ID (+) AND

....

(T26.TARGET_OU_ID = :4)

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