Timestamp that shows when data is updated in OAC reports

Question

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?

Silvio Garber-Oracle · Answer

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.

User_AYOKV · Answer

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?

Sumanth V -Oracle · Answer

@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.