BI PUBLISHER SCHEDULER TABLES
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