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 [Release 4.1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 28-Mar-2018***



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.


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


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