Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI 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.
2 -
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 -
Looks like it was browser cache, able to see query in OTBI using different browser
0
