Hello Experts,
I am looking to build a Transactional Console-style dashboard using OTBI subject areas in Oracle Fusion Applications. Specifically, I need guidance on the following:
- How to extract approval workflow information (e.g., approval status, approvers, workflow stages) from OTBI
- How to include user roles or job roles associated with each transaction/approval step
- Which OTBI subject areas can be leveraged to combine transactional data with workflow and role details
- Any best practices or limitations when replicating Transactional Console insights in OTBI
The objective is to create a consolidated dashboard that provides end-to-end visibility of transactions along with their approval journey and associated roles.
Appreciate any insights, sample approaches, or references.
