My Oracle Support Banner

Unable To Schedule The Report With Date Parameter Dynamically (Doc ID 2531605.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 12c version, Enterprise : Scheduler

ACTUAL BEHAVIOR
---------------
Passed {$SYSDATE()$} to the required parameter in data model. When we are trying to schedule this report, the date parameter not getting changed dynamically. The value for the date parameter of the report is remains same for every execution of the report jobs.

EXPECTED BEHAVIOR
-----------------------
Date parameter should change for every execution of the report job

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Data model created
2.Passed {$SYSDATE$} expression to date parameter in data model
3.Report is created
4.Schduled the report on minutes based
5.For every job execution, the parameter values remains same.

Changes

 

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


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