Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

How to navigate to fusion Sales Order page from otbi analysis aggregated field

Received Response
31
Views
2
Comments
saurabh.dixit
saurabh.dixit Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

We are trying to develop an OTBI report showing past due orders as a bar graph with range of days and count of orders in that range. Requirement is to click on 'count of orders' bar for a range and it should take to fusion page listing all those orders so user can open any of those orders and take action on it.

Tagged:

Answers

  • Dimple-Nagesh-Support-Oracle
    Dimple-Nagesh-Support-Oracle Rank 6 - Analytics & AI Lead

    Hello saurabh.dixit ,
    You can try using Deep linking to SUI pages :
    Please refer the following : URL Pattern of Deep Link: https://<pod-name>/fndSetup/faces/deeplink?objType=<objID>&objKey=<name1=value1;name2=value2>&action=<action>&returnApp=<returnappURL>&returnAppParams=<returnAppParameter>

    To direct users to a product-specific action page,you need to add specific parameters to the deep link URL. This tabledescribes the parameters and gives you some examples of parametervalues.

    Parameter

    Description

    Example of Parameter Values

    pod-name

    The host name.

    pod.oraclecloud.com

    objType

    The object type, such as work areas.

    SUPPLIER

    objKey

    The object identifier.

    SupplierNumber

    action

    The action that users can do on the page that theURL opens up, for example to edit something.

    Here are a few things to know:

    • If you don't add any value forthe action parameter, this value is considered as NONE by default. So users will be taken to a high-levelpage, such as an overview page or a search page.
    • If the value you added for theaction parameter doesn't match with any action on the UI, or the userdoesn't have the privileges to access that action, they will be takento a high-level page.

    NONE

    VIEW

    CREATE

    EDIT

    returnAppURL

    The application URL where users will be automaticallyredirected to when they try to return to the previous page, or afterthey complete their task.

    If you're using a third party URL, make sure theapplication name is registered using the Manage Integration of AdditionalApplications page in the Setup and Maintenance work area.

    MyOracle

    returnAppParams

    Parameters for the return application URL.

    type=photo

    Try this and let me know if that helps.


    More details : https://docs.oracle.com/en/cloud/saas/applications-common/24d/oaext/deep-links.html#Where-to-Find-Information-About-Product-Specific-Deep-Links
    https://docs.oracle.com/en/cloud/saas/subscription-management/fasmq/how-can-i-create-a-deep-link-to-the-order-creation-page.html
    More ref: https://community.oracle.com/customerconnect/discussion/593191/how-to-open-sales-order-view-page-from-shipment-lines-by-using-deep-links

    Thanks,
    Dimple N


  • saurabh.dixit
    saurabh.dixit Rank 1 - Community Starter

    Thanks for responding. However please elaborate how would I pass key values in deep link when user clicks on a bar graph with count N.

    If bar graph shows order count N, clicking on it should open OM page with those N orders listed.