When the EnablePersonanizationFlag is Set to FALSE Persistent User Profile Attributes are NOT Loaded using the EAI OM. (Doc ID 2008747.1)

Last updated on MAY 21, 2015

Applies to:

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

Symptoms

On : 8.1.1.11 [23030] version, Siebel EAI

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

Web Service based on LOY member Workflow works in DEV but not in QA using the same SRF and DB schema.

query which returns no data in QA and returns data in DEV:

Query QA
SIEBEL.S_PARTY.ROW_ID = SIEBEL.S_POSTN_CON.CON_ID (+) AND SIEBEL.S_POSTN_CON.POSTN_ID (+) = 0-5220 AND
SIEBEL.S_PARTY.ROW_ID = SIEBEL.S_POSTN_CON.CON_ID (+) AND SIEBEL.S_POSTN_CON.POSTN_ID IS NULL AND

Query DEV
SIEBEL.S_PARTY.ROW_ID = SIEBEL.S_POSTN_CON.CON_ID (+) AND SIEBEL.S_POSTN_CON.POSTN_ID (+) = 0-5220 AND
SIEBEL.S_PARTY.ROW_ID = SIEBEL.S_POSTN_CON.CON_ID (+) AND SIEBEL.S_POSTN_CON.POSTN_ID (+) = 0-5220 AND

In Des, theres a condition like this:

 T10.ROW_ID = T68.CON_ID (+) AND T68.POSTN_ID (+) = :3 AND
  T10.ROW_ID = T42.CON_ID (+) AND T42.POSTN_ID (+) = :4 AND

and it works while in QA:

 T10.ROW_ID = T68.CON_ID (+) AND T68.POSTN_ID (+) = :3 AND
  T10.ROW_ID = T42.CON_ID (+) AND T42.POSTN_ID IS NULL AND

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