Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

Timestamp that shows when data is updated in OAC reports

Received Response
15
Views
3
Comments
User_AYOKV
User_AYOKV Rank 4 - Community Specialist
in Oracle Fusion AI Data Platform Forum

It would be good service if all reports have a timestamp that shows when data is updated in OAC.

'Current_timestamp' simply tells the exact time it opened or refreshed the browser page. It reflects the "now" of the report, not the "age" of the data in the database or the file/dataset.

How can I show when the data was actually last updated/loaded in OAC reports?

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics & AI Strategist

    @User_AYOKV - Thank you for using the Oracle Community.

    As you may know, OAC is purely an analytics application. If your requirement is to determine when a table was last updated, you should rely on columns such as last update date within the table instead of using the current timestamp to track data refresh times.

    Alternatively, you can add a dedicated column to populate the timestamp after each ETL operation.

  • User_AYOKV
    User_AYOKV Rank 4 - Community Specialist

    Do you mean the last_update_date in the Oracle Fusion where the data is sourced from? If we don't have the column available in OTBI/OAC dataset, what can be done?

  • Silvio Garber-Oracle
    Silvio Garber-Oracle Rank 6 - Analytics & AI Lead

    Pretty much every object in Fusion has a system column for Last_Update_Date. FDI pipelines work based on this information. You may want to revisit your data extract and include those columns.