Using data Validation feature, when there is a mismatch of counts how to get the OTBI query

Question

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.

User_MN734 · Answer

Looks like it was browser cache, able to see query in OTBI using different browser

User_MN734 · Answer

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?

Sumanth V -Oracle · Answer

@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:

https://www.youtube.com/watch?v=WrduV2Uw9z0

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.