My Oracle Support Banner

Not Able To Use Date Parameter In Event Trigger In Data Model (Doc ID 2828340.1)

Last updated on FEBRUARY 01, 2022

Applies to:

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

Symptoms

On : Oracle BI Publisher 12.2.1.3.0 version

BI Publisher job fails on schedule event trigger.
Job status is shown as 'Failed' with the following error.


 

WHAT IS WORKING?
-----------------------------

Job completes successfully for the following scenarios.

• If all the dates are populated then it is works fine but if any one of the date values are not passed, then it fails with above error.
• If all the date parameters are removed then it works perfectly fine without any error.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create data model with schedule trigger with date parameters.
2. Execute the report job.
3. Job fails and shows above mentioned error.


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