BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud
SummaryBIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud
I have requirement to pull Sales Orders information for analytics purpose where I need to show total numbers of Sales Orders grouped by Statuses, customers, type of items, regions etc.
I am looking for if there is any existing data model that I can use for this? If not, can someone suggest me the query that I would need to build a model?
I also need to extract delta Sales Orders from ERP Cloud in scheduled intervals. After looking into Tables like