R12 Performance Issues In Package PA_ENDECA_INTEGRATION Due To Missing Joins (Doc ID 2272317.1)

Last updated on MAY 31, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Performance issues in package PA_ENDECA_INTEGRATION due to missing join.
When running Project related Full loads from Endeca we see performance issues with some SQL's that have cartesian joins in them.
The SQL's in question are in package body PA_ENDECA_INTEGRATION.


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