Oracle Fusion AI Data Platform

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion AI Data Platform

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Query error when joining two Procurement SAs: Purchase Order with Receipts

Accepted answer
21
Views
2
Comments
bhargabanerjee1234
bhargabanerjee1234 Rank 4 - Community Specialist
in Oracle Fusion AI Data Platform
query error.txt

The attached error is seen when any field from Procurement - Receipts is being added to fields from Procurement - Purchase Order

Best Answer

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics & AI Strategist
    Answer ✓

    @User_3512R - Make sure you include at least one fact / measure column from both the subject areas.
    If you do not want to display both the measures, then you can hide them by dragging and dropping them in Tooltip section.

    Or

    Create two different datasets - one for each subject area with the required dimensional attributes and facts / measures and then use these two datasets in creating the workbook.

Answers