Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
To Extract Order Header and Line details using OTBI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

To Extract Order Header and Line details using OTBI



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



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.


headerId, OrderNumber

from "FscmTopModelAM.DooTopAM.Header"

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!