Enterprise Manager Generic (MOSC)

MOSC Banner

BI Publisher Enterprise Reports not working

edited Dec 21, 2019 4:01AM in Enterprise Manager Generic (MOSC) 2 commentsAnswered

We're having issues with BI Publisher Enterprise Reports after upgrading from OEM 12CR5 to 13CR3. The below error message is being encountered when attempting to run any of the canned reports.

Parameter name: param_target_type oracle.xdo.servlet.data.DataException: ORA-00942: table or view does not exist ; Data source: EMREPOS; Query: SELECT DISTINCT type_display_name FROM mgmt$TARGET ORDER BY type_display_name ASC

A similar error message is being displayed in the BI Server logs.

Data source: EMREPOS;

Query: SELECT DISTINCT type_display_name

FROM mgmt$TARGET

ORDER BY type_display_name ASC

        at oracle.xdo.servlet.data.server.QueryCall.get(QueryCall.java:544)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center