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

(Doc ID 2390167.1)

Last updated on APRIL 30, 2018

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c to 12c [Release 12.0]
Information in this document applies to any platform.

Symptoms

On BI Publisher Enterprise 12.2.1.3.0 version,

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

After installing BI Publisher (BIP) 12.2.1.3.0 version (which is an upgrade from BIP 11.1.1.7) 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 .

 

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

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

Changes

 No Changes.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms