My Oracle Support Banner

12c: Scheduling BI Publisher Reports With A Dynamic Date Parameter Like {$SYSDATE()$} Does Not Generate Output Sometimes (Doc ID 2390167.1)

Last updated on JUNE 27, 2022

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c to 12c [Release 12.0]
Information in this document applies to any platform.
Reviewed for relevance 28 Oct 18.


On BI Publisher Enterprise version,

Scheduled jobs are not sending content in the output and edit jobs goes to new job page.

After After upgrading from to BI Publisher (BIP), facing issues with scheduled jobs.

The two main issues are:-

1) Some of the scheduled jobs fail to generate output for user parameters. But when the same report is run directly with the same parameters again, the output is generated.
2) Next, upon clicking on Edit button in report jobs page on an existing scheduled job, instead of redirecting to the edit scheduled job page it goes to the page for scheduling a new scheduled job .


The issue can be reproduced at will with the following steps:
1. Log into EBS enterprise.
2. In BI Publisher report, try to use $SYSDATE()$ in the parameter default value and try to schedule the report.
3. Output is generated with no data.

The issue has the following business impact:
Due to this issue, users cannot generate desired output from reports.


 No Changes.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.