Summary
BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud
Content
Hi Experts,
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
DOO_HEADERS_ALL, DOO_LINES_ALL I realized that last_update_date is not indexed. What should my model query look like for these delta extracts?
Thanks
Shalindra Singh
Version
Release 13
