Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Why time stamp is empty on OTBI reports

Received Response
237
Views
4
Comments
55Chevy
55Chevy Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

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):

Tagged:

Answers

  • ravikiran goda-Oracle
    ravikiran goda-Oracle Rank 6 - Analytics Lead

    Try using CAST function to get the timestamp

  • 55Chevy
    55Chevy Rank 2 - Community Beginner

    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.

  • Sahithi Kolasani-Oracle
    Sahithi Kolasani-Oracle Rank 5 - Community Champion

    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.

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    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,