Performance Issue With ODI Mapping "SDE_ORA_GLLINKAGEINFORMATION_DERIVE_ NONTRANSFERRED"

(Doc ID 1581747.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

BI Apps 11.1.1.7.1 with ODI and EBS R12.1.3 as source and database Oracle DB version 11.2.0.3

"SDE_ORA_GLLINKAGEINFORMATION_DERIVE_ NONTRANSFERRED" is taking so long to run and complete even in a incremental load. Tt has been running for more than 3 hours under incremental load.
The sq in the mapping it just returned 62 rows and the Data extract rate is 4mb/sec

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