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
Link between 2 subject ares
link between
CRM interactions real time and order management - order headers real time
CRM interactions real time and Receivables transactions real time
Answers
-
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).
0 -
Hi @Ani_tha,
Welcome to the Oracle Analytics Community!
Quick Question: Do you have any matching keys between those 2 subject areas?
If Yes, then you can join those subject area using the Logical SQL Approach.
Please find below posts which might be useful for the initial starting point and the understanding.
OTBI Resources — Cloud Customer Connect
OTBI Logical SQL complex query assembler - Updated to 10 subject areas — Oracle
Hope this help.
Thank you.
0
