Oracle Transactional Business Intelligence

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

42
Views
0
Comments

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"