Why time stamp is empty on OTBI reports
Summary:
Content (required):
Hello: Does anyone know how to get the time stamp to populate for an event date? We have custom format selected of M/d/yy HH.mm.ss, and we get the date. This is in the subject area of Expenses - Expenses Transactions Real Time.
Thanks for any help!
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications 22C (11.13.22.07.0)
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Try using CAST function to get the timestamp
0 -
Can you explain how this is done? We selected the Event Date Column for data format and entered custom date format of dd-MMM-yy h:mm:ss tt. The result was the correct date with the same hour minute for every transaction of 12:00:00AM.
0 -
CAST("Expense Report History"."Event Date" as TIMESTAMP)
But, I'm afraid it will show 12:00:00AM for all records as the data type must be selected as DATE instead of TIMESTAMP in the RPD, which we will not have control to change.
0 -
Hi 55Chevy,
Firstly print the column without any formatting and then check if you can see distinct values in the timestamp or not.
If all the values are same in timestamp part then probably the column is not holding the correct Timestamp values and there's no point of doing the formatting.
If it does hold unique values then you can do the following.
Hope this help.
Cheers,
0
