My Oracle Support Banner

Cleanup Of Non-scheduled BIP Report Jobs From BI Publisher 12c Enviornment (Doc ID 2849932.1)

Last updated on FEBRUARY 28, 2022

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Symptoms

You noticed that there are few BIP report jobs that keeps executing every day but those jobs are not visible in BI Publisher console.
When you execute following query, you get several records.

select *
from (
select a.user_job_name, a.report_url, a.job_group, a.job_id sched_job_id,a.start_date job_start_date,a.end_date job_end_date,a.schedule_description, a.last_updated, a.created, a.status, b.job_id output_job_id
from XMLP_SCHED_JOB a left outer join XMLP_SCHED_OUTPUT b on a.job_id = b.job_id
where 1=1
--and a.user_job_name ='<job_name>'
and a.end_date is not null and a.end_date > sysdate
and a.last_updated > sysdate-15
and a.status !='H'
order by 1 desc) where output_job_id is null
order by status, user_job_name, job_group


You want to disable and remove these unwanted BIP jobs from the environment.

Changes

 You migrated from obiee 11g to obiee 12.2.1.4

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
Changes
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.