Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

In OTBI, timestamp is not visible for few date attributes

Declined
11
Views
2
Comments
LavanyaGM
LavanyaGM Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

In OTBI "Product Management - Change Order Real Time" Subject area, timestamp is not visible for "Change Order Approval Date" attribute. If we change the data format to include timestamp, every timestamp is rounded off to 12AM of that particular date which is incorrect. Please let us know if there are any ways to get timestamp in this date field.

Tagged:
1
1 votes

Declined · Last Updated

Please post in the Fusion Cloud Product Life Cycle Management Idea Lab.

Comments

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics & AI Strategist

    Hi @LavanyaGM,

    Welcome to the Oracle Analytics Community!

    Quick question: Have you raised this as a question in the community to see if any body has any potential solution?

  • RVohra
    RVohra Mod

    I cannot recall but do you know it has timestamp component for this column, you can simply query the db table

    If yes, you might need to consider custom reporting e.g. BI Publisher to get underlying timestamp from database. Hope it helps!