Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud

Received Response
182
Views
1
Comments
Shalindra Singh
Shalindra Singh Rank 3 - Community Apprentice
in Oracle Analytics Forum

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

Tagged:

Answers