My Oracle Support Banner

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

Last updated on FEBRUARY 12, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.