R12 Endeca Project Search ORA-04063: view "APPS.PA_ENDECA_EXPENDITEMS_V" has errors

(Doc ID 2222147.1)

Last updated on MARCH 08, 2017

Applies to:

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


No data / output for Endeca Project Search page.

Errors visible on portlets
- An error occurred while attempting to apply security filters
- Unable to execute the EQL query that generates the chart data. See the application log for details, or contact a system administrator.

The full load was in error even after patch 21473745:R12.PA.B was applied per Doc ID 2070025.1.
prj-pjt graph/LoadDataFull.grf errored out with following log messages when
viewed in clover admin pages


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