My Oracle Support Banner

When "Use timestamp in query" Setting Is Unchecked In UDR Setup, The Expectation Was That Report Query Parameters Would List Dates Only and Not Date/Time (Doc ID 2768161.1)

Last updated on SEPTEMBER 23, 2021

Applies to:

Primavera Unifier Cloud Service - Version 20.12 and later
Primavera Unifier - Version and later
Information in this document applies to any platform.


When running a UDR in any environment when that UDR contains a "Creation Date" data element, at run time in the Report Query Parameters, instead of displaying only the Date, the parameters are displaying the Date and the Time, thus the user must enter a time for that day and often this data is not known by the user. Users reported that when the environment was at version 19.12.7, this was only displayed as a Date field. Since upgrade to 20.12.x, both the Date & Time must be entered.

It was expected that if the "Use timestamp in query" was unchecked in the UDR settings, then at run time the user would only need to enter a Date and not a time as well in the Report Query Parameters.

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

  1. Log into the Unifier environment.
  2. Navigate to the Project/Shell where the issue has been observed > User Mode > Reports > User-Defined > Find "UDR1" > Edit
  3. Query Tab > "Creation Date" from a BP Data Element is one of the Query Conditions > "Use Timestamp in query" is not checked.
  4. From the same Project/Shell Run the same UDR report > In the "Report Query Parameters", when the Unifier version was still 19.12.7, this "Creation Date" field would only display a "Date" and NOT a timestamp too. The customer does not want the time stamp to be displayed as this causes confusion for users as it is not required for the data they are trying to retrieve.


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

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