Hi everyone,
I’m new to Oracle Fusion Applications and BI Publisher (BIP). My work involves building SQL queries for BIP data models, but I often struggle to identify:
- Which module a report belongs to (e.g., Timecard report in HCM)
- Which tables/views to use
- Which columns contain the needed data
- How tables are related/joined
- How to properly debug joins and filters
Could anyone guide me on:
- The best tools or screens in Oracle Fusion to explore tables, columns, and relationships.
- Proven debugging practices for BIP SQL queries.
- Any official documentation, tutorials, or learning resources for Fusion data models.
Any guidance, tips, or examples would be greatly appreciated. Thank you!
- BI Publisher
- Oracle Fusion
- SQL
- Data model
- Tables and columns
- Debugging