Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

OTBI Deeplink for Invoice view

Received Response
40
Views
3
Comments
Sandipan Pal
Sandipan Pal Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Hi All,

We are trying to add deep link in an OTBI report.

Subject Area: Payable Invoices - Transaction Real time

Columns: Invoice Number, Invoice ID from general information.

We are trying to call below Action Link in Invoice ID values as below:

https://<saasURL>/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId={INVOICEID}

The same link in BIP report template ,once mapped works fine and open exact invoice in View mode.

However, same doesn't work in OTBI. OTBI it is opening a blank page everytime.

Is there anything else needs to be passed in OTBI?

Regards,

Sandipan

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi,

    Are you using the same user? Does your user have the required role with privileges to go to this page to view a payables transacction. Does the link work if you just cut paste it into a browser for this user?

    For comparison here is my known good version we have on our custom dashboard. Looks same to me.

    We are using relative link so it works on all any environment but I do not think that makes a difference.

    https:/../fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=InvoiceId=@{3}

    1 = AP_VIEWINVOICE

    2 = VIEW

    3 = "General Information"."Invoice ID" from "Payables Invoices - Transactions Real Time"

  • Sandipan Pal
    Sandipan Pal Rank 1 - Community Starter

    Hi Nathan,

    Thanks for the details.

    Per our security team, the user has right roles and same user can access same link via BIP report.
    Additionally, I did try copy pasting the url, it didn't work and shows blank response.

    Regards,

    Sandipan

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi Sandipan, What function privilege in which role did your security team tell you was required to go to this page? What data security have was implemented for this transaction on page Manage Data access for Users? If the link does not work in a users browser then assume your security team have not understood what privilege in a role is required by that user to go to this page or what data security is required for that transaction. A blank page is the expected result for users who do not have the required privileges for the target page or do not have the required data security for that transaction.