Reporting and Analytics for SCM Cloud

Get Involved. Join the Conversation.

Topic

    Soumya Parhi
    Sales Order Report Customization
    Topic posted May 30, 2019 by Soumya ParhiGold Trophy: 10,000+ Points, tagged BI Publisher, BI Publisher Reports, Order Management, Tip 
    49 Views, 4 Comments
    Title:
    Sales Order Report Customization
    Content:

    Good People,

    Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM .

    Any one customized it ?

    Thanks,

    Soumya

    Comment

     

    • Pratiq Daya

      Hi Soumya,

      I had a similar requirement - so I raised an SR with Oracle support.

      Response from them is: the current seeded sales order data model is not customizable as it runs off view objects. To get the view objects you will need to raise an SR.

      The following Doc IDs on Oracle Support maybe of assistance:

      2344954.1

      2282054.1

      2293659.1

       

      Regards

      Pratiq

      • Soumya Parhi

        Hi Pratiq,

        Thanks for the kind response. Created the service request to request for the Data Model XML but indeed they affix the same note without helping with the data model.

        If you have the seeded data model, can you please share ?

        Thanks,

        Soumya

        • Pratiq Daya

          Hi Soumya,

          You can find the seeded data model in the shared folder under supply chain management > order management.

          Kind Regards

          Pratiq

          • Soumya Parhi

            Hi Pratiq,

            Unfortunately you won’t be able to open or download the definition of data model. If you have the view object lists or the data model definition that will certainly help.

            Thanks

            Soumya