Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
To Extract Order Header and Line details using OTBI

Shalindra Singh
Rank 3 - Community Apprentice
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:
0