Upgrade From 8.1.1.4 To 16.12 With BI Publisher In Place Keeps 2 Dock Objects

(Doc ID 2312488.1)

Last updated on OCTOBER 03, 2017

Applies to:

Siebel Consumer Goods - Version 8.1.1.7 [21238] and later
Siebel CRM - Version 8.1.1.7 [21238] and later
Siebel Remote - Version 8.1.1.7 [21238] and later
Information in this document applies to any platform.

Symptoms

In Siebel 8.1.1.3-8.1.1.6  in order to fix the issue described in Doc ID 1273500.1 Oracle Engineering provided a sif file which added the new Dock Object 'CX_XMLP Report Template by Pos'. At some point later as part of a Siebel CRM 8.1.1.7 ACR 719B and later releases, this moved to Standard Repository, but with a different name, 'XMLP Report Template by Postn'. When upgrading from Siebel 8.1.1.3-8.1.1.6 to 8.1.1.7 or above the New Custom Repository will contain both Dock Objects as expected.  Since both Dock Objects are active for the same primary table DbXtract would extract records twice for S_REP_TMPL_PSTN. The outcome of that would be that for all Remote users, LOCAL_XE db initialization would fail with error: ORA-00001: unique constraint (SIEBEL.S_REP_TMPL_PSTN_U1) violated.

Changes

 

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