Cross Schema Table Reference After Migration to Oracle Commerce 11.1 (Doc ID 2002699.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Commerce Platform - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

After migrating to Oracle Commerce 11.1, there are a number of tables that have cross-schema references (foreign keys to tables that live in different schemas).  

Source Schema(s)Source TableReferenced Schema(s)Referenced Table
Switching Catalog A, Switching Catalog B

dcs_product_rltd_media

Core wcm_media_content
Switching Catalog A, Switching Catalog B dcs_product_rltd_article Core wcm_article
Core dcs_wcm_media_rltd_prod  Switching Catalog A, Switching Catalog B  dcs_product

This is only a problem if you are currently using switching datasources. 

Changes

Upgraded to Oracle Commerce 11.1 using the SQL migration scripts. 

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