Oracle Fusion Data Intelligence Idea Lab

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

FDI OOTB Auditing for pipeline execution

Needs Votes
11
Views
0
Comments
neeraj bisht
neeraj bisht Rank 3 - Community Apprentice

FDI OOTB provides DW_WH_REFRESH_SUMMARY, DW_WH_REFRESH_DETAILS tables which doesn't provide enough information, we would like to have below info added to log tables.

  1. count of records processed by DA job, will be useful for visibility and tracking change in job delay due to data volume.
  2. Actual time taken for individual DA jobs, currently all DA jobs gets populated with same timestamp.
  3. W$_INSERT_DT, W$_UPDATE_DT columns to accurately not DA job start and end time, currently both columns have same timestamp.

3
3 votes

Needs Votes · Last Updated