Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Shalindra Singh
    BIP Reports to Extract Sales Order and related fields from...
    Topic posted October 28, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, last edited September 11, 2019, tagged Reporting 
    44 Views, 1 Comment
    Title:
    BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud
    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

    Comment