Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 221 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Using data Validation feature, when there is a mismatch of counts how to get the OTBI query

Newly configured Data validation feature and we are successfully able to get Detailed validation and scheduled validations. For some of the metrics when we were doing Detailed validation there was a mismatch and I am able to get the FDI SQL query in session log but , when we login to source HCM OTBI not able to see query related to this data validation in session log. Is there another way to get OTBI query for the detailed or scheduled data validation done? We are using HCM analytics on Oracle HCM application and are trying to validate Core HR module.
Answers
-
@User_MN734 - Welcome to Oracle Analytics Community!
Please refer to the video below, which explains how to access the OTBI session log generated as part of the Data Validation feature:
Hope this helps! We also encourage you to keep exploring and engaging in the community — it’s a great place to learn and share experiences.
0 -
Thank you for your reply, In manage sessions I do not see any SOAP type sessions in source OTBI after I run the detailed Validation I go to OTBI manage sessions and it does not show any soap sessions. We have Dev1,Dev2,Dev3 Test instances of OTBI and 1 FDI non prod instance that connects to Dev3 for Data and Test Identity domain for Security. Iam new to the company andhas been given this information. How do i dentify the integrated FDI. I do not see anything in OCI under Environments—>Integrations?
0