Is Orders data available through the OTBI layer in Order Management / SCM?

Shalindra Singh

Summary

Is Orders data available through the OTBI layer in Order Management / SCM?

Content

Is Orders data available through the OTBI layer in Order Management / SCM?

Reason I am asking because when I querying direct table (doo_header_all) via BI Publisher, I get the data from this table.

But when I use 'Issue SQL' on OTBI Administration section and write following query - 

select_physical

headerId, OrderNumber

from "FscmTopModelAM.DooTopAM.Header"

I don't get any records. 

I need your help as I was asked not to use BI Publisher for data extraction (where I want order and line data to be extracted in every 10 minutes) hence evaluating data sync tool but I do not get any data when I used above query.

Shalindra Singh

Can someone please suggest what am I missing here? This is important.