Oracle Fusion Data Intelligence

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

How to create deep link for Purchase Order number in FDI

Received Response
228
Views
17
Comments
Gamal
Gamal Rank 3 - Community Apprentice

I'm using the standard subject area (Procurement - Purchase Orders) to build reports.
One of the report columns is Purchase Order Number. I need to create a deep link to show Purchase Order number as in FAW. Once I click on the number, Purchase Order page opens in fusion.

«1

Answers

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    edited August 2024

    @Gamal Please refer the below document

    FAW: How to Implement Deep Link To Drill down to Asset Depreciation Fusion Screen (Doc ID 2960828.1)

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Gamal

    In order to see a complete list of the available Deep Links, use the Deep Links work area (Navigator > Tools > Deeps Links).  In order to access this work area, you will need to have the View Administration Link (FND_VIEW_ADMIN_LINK_PRIV) privilege.

    You can refer below MOS -

    FAW: How to Implement Deep Link To Drill down to Asset Depreciation Fusion Screen (Doc ID 2960828.1)

    Regards,

    Arjun

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Gamal - If you are creating a workbook and planning to implement this requirement, please consider using the data actions feature.

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/use-data-actions.html

    In case of Classic reports, you can explore Action Links to achieve the same.

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/add-actions-analyses.html

  • Gamal
    Gamal Rank 3 - Community Apprentice

    Thank you all for your reply.

    can you please let me know if the below expression is wrong because it gives me error when it opens the URL.

    Regards,

    Gamal

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach
    edited August 2024

    @Gamal Are you using the right Deep Link for PO number and in the right format as mentioned in the (Doc ID 2960828.1)?

    For example: From my internal FA instance I could find the Deep link for "Purchase Order" View like below,

    https://xxxxxxx/fscmUI/faces/deeplink?objType=PURCHASE_ORDER&action=VIEW

    So, the final url to be used in Data Action→Url Navigation should be something like below,

    https://xxxxxxx/fscmUI/faces/deeplink?objType=PURCHASE_ORDER&action=VIEW&objKey=${keyValuesForColumn: Purchase Order Number}

  • Gamal
    Gamal Rank 3 - Community Apprentice

    Hi @Ashish-Oracle ,

    Now it's working but the page opens with no data as shown below. Could you please advise if I missed any step?

    Thanks,

    Gamal

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach

    @Gamal Does the objKey value pass correctly with the Purchase Order number after you click on the New Data Action? If yes, then I would advise you to Open a SR with FDI Support and have this investigated further.

  • Gamal
    Gamal Rank 3 - Community Apprentice

    Hi @Ashish-Oracle , Once I click on the new data action, it opens the below page.

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach

    @Gamal Got it. Does the objKey value pass correctly in the deep link url with the Purchase Order Number value in FDI? For example: If you click New Data Action for Purchase Order number =102 then the url being fired should have objKey=102 in the url.

  • Gamal
    Gamal Rank 3 - Community Apprentice

    @Ashish-Oracle the deep link url doesn't have the PO number that I selected.