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 laterInformation 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 |