Deeplinks from BIP Report to Transaction Details

Process:

1.     Creating a BIP Report.

2.     Preparing the Action Link URL.

3.     Adding deeplink from Report

4.     Adding deeplink from RTF

5.     Adding deeplink from Data model

6.     Verifying the results.

 

Example: To add deeplinks from Payables Invoice Number

Step 1: Creating a BIP Report.

 Create Data model with simple SQL Query

Create Report by Moving Required Columns

Step 2: Preparing the Action Link URL.

Replace the Hostname and Invoice ID path in the below URL

https://hostname/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId={/DATA_DS/G_1/INVOICE_ID}

Note: To get all the possible Deeplink URLs, check the Reference section

Step 3: Adding deeplink from Report

Add the link to the URL property of the Invoice Number column.

 

The Invoice Number column on the report will now include a hyperlink that will navigate you to the Payables Invoice UI.

Step 4: Adding deeplink from RTF

Place the Hyperlink prepared in step 2

Add the RTF to the Report and view the Output

Step 5: Adding deeplink from Data model

Prepare the SQL Query as shown:

Select   'https://hostname/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId='||INVOICE_ID INVOICE_URL,

            Invoice_num,

            Invoice_amount

from ap_invoices_all

 

Place the below tag at the Invoice_Num field in the RTF to make it hyperlink

<?if@inlines: INVOICE_URL!='N/A'?>

<fo:basic-link external-destination="{.//INVOICE_URL}" color="blue" text-decoration="underline">

<?INVOICE_NUM?>

</fo:basic-link>

<?end if?>

Add the RTF to the Report and view the Results

 

Common Mistakes:

1.      While Entering URL, ensure it is in single line with no spaces in between

Correct:

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

Incorrect:

https://hostname/fscmUI/faces/ deeplink?

objType=@{1}&action=@{2}&o

 bjKey=InvoiceId=@{3}

 

2.       Enter the correct path for the objKey.

Tip: Refer to the hierarchy displayed under the Data Source section to identify the correct path

Correct:

https://hostname/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId={/DATA_DS/G_1/INVOICE_ID}

Incorrect:

https://hostname/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId={/G_1/INVOICE_ID}

 

Reference:

Oracle support Document - How To Drill Down To Fusion Financial Applications Transactions From OTBI ERP Reports (Doc ID 2603149.1)

For Purchasing Documents:

PRC:PO: Navigate to Purchasing Transactions from Reports (Doc ID 2444555.1)

For Requisitions:

PRC:SSP:Deep Link From OTBI Report To Manage Requisitions Page (Doc ID 2629827.1)