Reporting and Analytics for SCM Cloud

Get Involved. Join the Conversation.

Comments

  • 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

  • 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,

    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,

    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

  • Nidhi Chhajed

    Hi,

    I was able to find table to join RMA and SO , and below is SQL if someone else also come across same requirement:

     

    SELECT

    dha.order_number "Original Sales Order"

    ,dla.line_number "Original Order Line"

    , dhr.order_number "RMA Order"

    FROM

    doo_headers_all dha

    , doo_lines_all dla

    , doo_document_references ddr

    , doo_headers_all dhr

    WHERE ddr.doc_id = dha.header_id

    --AND dha.order_number = 'XXXX'  -- Enter your Sales Order Here

    AND dhr.order_number ='XXXX' --Enter your RMA Here

    AND dhr.header_id = ddr.header_id

    AND doc_ref_type = 'ORIGINAL_SALES_ORDER'

    AND dla.header_id = ddr.doc_id

    AND dla.line_id = ddr.doc_line_id

     

  • Sanoj Sudheera

    Hi,

    Check ERP Report Sharing Center 

    https://cloudcustomerconnect.oracle.com/pages/17668b0b6c#messages

    There are few reports which you can cover your requirement. Update as per your requirement.

    Regards,

    Sanoj

  • sai sudheer

    Hi Can you be more specific on your requirement!!

  • Nishanth B Jain

    Hi Tam,

    Check this note

    Oracle Fusion Sourcing Reports: Where To Find Samples Of Oracle Fusion Sourcing/Negotiation Xmls And The Explanation For Their Tags? (Doc ID 2242731.1)

    Thanks,

    Nishanth

  • Chandra Yerra

    Welcome :)

  • Kiran Kumar

    Thank You Chandra.

  • Chandra Yerra

    Hi,

    You need to use /xmlpserver to see the customize option instead of /analytics in the instance URL.

    Thanks,

    Chandra.

  • mona mathur

    Thank you for the update. We recently started exploring this tool. We need to extract big data sets from cloud and running query on cloud itself is taking too much time to extract big data sets

    Can Data sync tool be used to run queries against big data sets on cloud and extract data from cloud. if there is any documentation around it please let us know. it will be very helpful 

     

    Thanks and regards

    Mona 

  • Chandra Yerra

    Hi Shavul,

    You can use the "Issue SQL" option from Administration tab by taking the Logical SQL from Advanced tab of BI Answers.

    Thanks.

  • Roy Amozeg

    If  I understand the question correctly then this is available in Mange Serial Number 

  • Sanin Thulapparumban

    Hope this will work for point# 1

    select "DOO_HEADERS_ALL"."ORDER_NUMBER" as "ORDER_NUMBER",
    "DOO_HEADERS_ALL"."ORDERED_DATE" as "ORDERED_DATE",
    "INV_PICK_SLIP_NUMBERS"."PICK_SLIP_NUMBER" as "PICK_SLIP_NUMBER",
    "INV_PICK_SLIP_NUMBERS"."CREATION_DATE" as "PICK_SLIP_CREATION_DATE",
    "WSH_NEW_DELIVERIES_1"."DELIVERY_NAME" as "DELIVERY_NAME",
    "WSH_NEW_DELIVERIES_1"."CONFIRM_DATE" as "DELIVERY_CONFIRM_DATE"
     from "FUSION"."INV_PICK_SLIP_NUMBERS" "INV_PICK_SLIP_NUMBERS",
    "FUSION"."WSH_NEW_DELIVERIES" "WSH_NEW_DELIVERIES_1",
    "FUSION"."WSH_DELIVERY_ASSIGNMENTS" "WSH_DELIVERY_ASSIGNMENTS_1",
    "FUSION"."WSH_DELIVERY_DETAILS" "WSH_DELIVERY_DETAILS",
    "FUSION"."DOO_HEADERS_ALL" "DOO_HEADERS_ALL",
    "FUSION"."DOO_LINES_ALL" "DOO_LINES_ALL",
    "FUSION"."DOO_FULFILL_LINES_ALL" "DOO_FULFILL_LINES_ALL"
    where   1=1
     and "DOO_FULFILL_LINES_ALL"."LINE_ID"="DOO_LINES_ALL"."LINE_ID"
     and "DOO_LINES_ALL"."HEADER_ID"="DOO_HEADERS_ALL"."HEADER_ID"
     and "DOO_FULFILL_LINES_ALL"."FULFILL_LINE_ID"="WSH_DELIVERY_DETAILS"."SOURCE_SHIPMENT_ID"(+)
     and     "WSH_DELIVERY_DETAILS"."RELEASED_STATUS" (+) <> 'B'
     and "WSH_DELIVERY_DETAILS"."DELIVERY_DETAIL_ID"="WSH_DELIVERY_ASSIGNMENTS_1"."DELIVERY_DETAIL_ID"(+)
     and "WSH_DELIVERY_ASSIGNMENTS_1"."DELIVERY_ID"="WSH_NEW_DELIVERIES_1"."DELIVERY_ID"(+)
     and "WSH_DELIVERY_DETAILS"."BATCH_ID"="INV_PICK_SLIP_NUMBERS"."PICK_SLIP_BATCH_ID"(+)