Register to the Data Intelligence Summit Mexico City Register today to the Oracle Analytics Data Intelligence Summit in Mexico City on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Transactional Business Intelligence

To Extract Order Header and Line details using OTBI

Views

Comments

Shalindra Singh Rank 3 - Community Apprentice

November 2018 in Oracle Transactional Business Intelligence

Summary

looking for Sample query that works to get Header and line details of available orders using OTBI

Content

Hi,

Can someone please provide me working sample query for OTBI. I am sure I am missing something because when I provide below query I do not get error but I also do not get any records while I know for the facts that orders do exits in the application as I also created few of them.

select_physical

headerId, OrderNumber

from "FscmTopModelAM.DooTopAM.Header"

Tagged:

Oracle Transactional Business Intelligence

Welcome!

Quick Links

Categories

To Extract Order Header and Line details using OTBI

Summary

Content

Welcome!