Discoverer Workbook Fails With 'Cannot join tables.Item dependency " " not found in EUL' After EUL Migration, Importing Or Cloning

(Doc ID 267476.1)

Last updated on MARCH 28, 2018

Applies to:

Oracle Discoverer - Version 4.1.37 to 11.1.1.7.0 [Release 4.1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 28-Mar-2018***

Symptoms

 

Opening a workbook migrated from one instance to another results in the following errors:

 

If using the workbook dump utility, you may notice:



It seems that items are matched by internal item identifiers (IDs) and not by developer keys and names.

Changes

This is caused by migrating EUL from one environment to another.

For example, you may have performed a database export / import of the EUL schema from DEV to TEST

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