Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Link between 2 subject ares

Received Response
6
Views
1
Comments

link between

CRM interactions real time and order management - order headers real time

CRM interactions real time and Receivables transactions real time

Answers

  • RVohra
    RVohra Rank 6 - Analytics Lead

    I do not think you can directly join Sales – CRM Interactions Real Time with Receivables – Transactions Real Time.

    Each subject area pulls from separate transactional schemas within Fusion (Sales Cloud vs. Financials Cloud), and OTBI doesn’t have a shared join key across them (like Opportunity ID to AR Invoice ID).