nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

DATA PIPELINES CAPABILITY FOR NON FUSION SOURCES IN ORACLE FUSION DATA INTELIGENCE

Govardhana Gurumal

hi All,

The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level.

For example, we have a BI Publisher report returning approximately 1M rows, but the corresponding FDI Data Augmentation fetches/loads only around 2K rows and still shows Completed. From the status alone, it is difficult to identify where the remaining records were excluded or lost.

As an FDI administrator, it would help to have one consolidated execution view showing:

DA Start → Source Rows Fetched → Rows Processed → Rows Rejected/Skipped → Rows Committed → DA End → Duration → Status/Error

I referred to Oracle's warehouse refresh statistics documentation and have also used the pre-built Common Subject Areas for reload/refresh information.

The key question is: Do we have an Oracle-supported FDI/ADW object, subject area, or telemetry that provides this complete DA execution trace? If not, what exact diagnostic information should we request from Oracle Support when raising an SR for cases such as the 1M-vs-2K discrepancy?

Regards,

Guru

Find more posts tagged with

Submitted

Oracle Fusion Analytics

Fusion Data Intelligence

Oracle Analytics Cloud

Status: Submitted

Comments

mgoswami

@Govardhana Gurumal upvoted. This area does need further enhancements for finer details and controls.

Top Leaders

mgoswami 45

Govardhana Gurumal 34

Bhavin Desai 17

Victor H 16

Andrew at MKL 2

Top Ideas

Enhancement Request: Data Role and Security Lineage in FDI Query Execution
Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager, Regional Manager, Country, Area of Responsibility (AOR), Organization, and other business-specific access rules. One of the…
Enhancement Request: Data Role and Security Lineage in FDI Query Execution
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager,…
Enable Public Access to Reports and Dashboards in Oracle Fusion Data Intelligence (FDI)
Idea / Enhancement Request Oracle Analytics Cloud (OAC) has introduced the capability to provide public access to analytics content using the BI Public Role, allowing reports and dashboards to be shared with users without requiring authentication. I would like to propose extending similar functionality to Oracle Fusion…
DATA PIPELINES CAPABILITY FOR NON FUSION SOURCES IN ORACLE FUSION DATA INTELIGENCE
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
Enable the Option to Hide Fusion SCM Content in FDI Reporting Configuration
In Fusion Data Intelligence (FDI) release 26.R3.P4, Reporting Configuration provides options to hide Human Capital Management (HCM) and Enterprise Resource Planning (ERP) content. However, an equivalent option is not available for Fusion Supply Chain Management (SCM) content. SCM content remains visible in the catalog…