FDI Value-Add Proposal: Unified Validation Reports in OTBI and FDI

Ketul Patel

I would like to propose an idea to enhance data validation between FDI and OTBI. While FDI already provides a data validation utility, in practice client teams rarely engage with it, and based on my experience, they are often reluctant to rely on the high-level outputs it generates. In addition, there are situations where functional support teams are not available to assist in this process of data validation as they exit after their deployment.

To address this, we could introduce a catalog of tabular reports for common subject areas—one set in OTBI and a corresponding folder in the FDI catalog. These reports would contain the most commonly required functional fields, making it easier to compare and validate data across the two tools.

I believe this approach would provide significant value and I hope the Oracle team will consider taking it forward.

Himanshu Dosi

This is a thoughtful and pragmatic proposal. Enhancing data validation between FDI and OTBI through a curated catalog of tabular reports would bridge a critical gap many client teams face post-deployment.

DarshShah08

I think this is a better way to efficiently perform Data Validation in FDI without relying too much on the functional team. Many clients currently use this path indirectly to validate data. I think Oracle should provide this as an official method for Data Validation.

Ketul Patel

we are facing significant delays due to overall data validation process in project as client is not pleased with Data Validation utility. To start with, we recommend key subject areas to be available at first for validation using above approach.

Gopal Chopperla

Yes , it surely helps the reconciliation process from fusion to FDI when we move to FDI

Ketul Patel

https://community.oracle.com/products/oracleanalytics/discussion/comment/71182#Comment_71182

Agree with you, My client is not ready to see the data validation screen in FDI Admin Console, He is now asking us to create OTBI reports for data validation with FDI.