Custom Report in FCCS Task Manager Not Displaying Day Labels in Date Columns

While generating a Custom Report in Oracle FCCS Task Manager, the Start Date column (as well as other date columns) displays only the date and time format.

However, when exporting Schedule Tasks directly from the application, the output includes the Day label (e.g., Day -1, Day 1, Day 2) along with the corresponding date.

Currently, the following syntax is being used in the Custom Report query for the Start Date column:

TO_CHAR(TaskEO.SCHEDULED_START_DATE, 'YYYY-MM-DD"T"hh24:mi:ss') AS "Start Date"

Custom Report Start Date column output     

                                             

 

 

 

 

 

 

 

 

 

 

 Schedule Task Export Start Date column

We would like to understand how to modify the query so that the Custom Report displays the date in the same format as the Schedule Tasks export, including the relative Day label along with the formatted date and time.