BI Publisher (MOSC)

MOSC Banner

BI PUBLISHER SCHEDULER TABLES

edited Mar 5, 2014 1:45PM in BI Publisher (MOSC) 15 commentsAnswered ✓

Hello All

We are using BiPublisher with OBIEE 11.1.1.7

For monitoring purposes for a scheduled report , we were checking the below tables

XMLP_SCHED_JOBS and XMLP_SCHED_OUTPUT

and querying the columns status and status_detail

This instance was recently upgraded from 11.1.1.6.1 to 11.1.1.7

Before upgrade in the table XMLP_SCHED_OUTPUT if the report is run successful and delivered successful the

status_detail in XMLP_SCHED_OUTPUT will be as

"::DOCUMENT_PROCESSING_SUCCESSFUL::[INSTANCE_ID=hostname.1392283280045]"

Now after the upgrade it is

"::RENDERING_REPORT_DOCUMENT::[INSTANCE_ID=hostname.1392283280045]"

and status column is "S"

Below patches were applied part of upgrade

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