You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to pass date to ESS Job for Oracle BI report

edited Aug 19, 2024 11:09PM in Reporting & Analytics for Fusion Service 1 comment

Summary:

We have created a report that takes start and end date as mandatory parameters in the format (MM-dd-yyyy). When we run this report from Analytics Catalog page the report runs successfully.

We have created a ESS Job so that users can enter the date parameters and run the report. The Job on the backend is not accepting the date correctly and thus report runs successfully but there is no output. On checking the xml file we found the below which is not correct:

<PSTARTDATE>0169-05-08T00:00:00.000+00:00</PSTARTDATE><PENDDATE>0198-05-08T00:00:00.000+00:00</PENDDATE>


Content (required):

Please let us know what is the step that we are missing.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!