Warehouse Refresh Statistics

Description

The Warehouse Refresh Statistics subject area provides valuable information on pipeline activity and performance. You can use this subject area to create analytics on data refreshes, pipeline jobs, job failures, and details on rejected records. Together with data validation, this subject area helps reconcile data between the Oracle Fusion Cloud Applications source module and , and improve data quality over time.

Business Questions

This subject area can answer the following business questions:

• When was the warehouse last refreshed, by each module?
• Which modules have high percentage of rejected records?
• What are the specific records that have been rejected for a certain module?
• What errors did the pipeline encounter, by specific jobs?
• Which jobs fail most frequently?
• What are the cascading effects, for example what other related records also fail due to a certain failure of a job?

Duty Roles

The Data Warehouse Refresh Analysis Duty role secures access to this subject area. See .

Primary Navigation

Folder: /Shared Folders/Common/Warehouse Refresh Statistics

Workbook: Warehouse Refresh Statistics

Special Considerations

None.