Is there a way to create a deep link from OAC into the invoice attachments in ERP?

Steven Woods

We've created a dashboard in OAC for invoice details. Users are able to click a deep link in that dashboard that will open an invoice in ERP. They are then able to click on the attachments in the invoice to view those attachments. But is there a way to create a deep link directly into those attachments from OAC?

SteveF-Oracle

Hi Steven,

I recently came across this potential solution for a URL, if it is useful to you.

If the attachment is a file (PDF, spreadsheet, image etc.), then I don't think it is possible and an always raise an Idea Lab request.

1. Bind each filter that you want to pass external values to, to a parameter.
2. Use the Context Passing URL API to pass in values for those parameters.

The API works like this:

• Use a base URL like https://host.com/ui/dv/project.jsp?pageid=visualAnalyzer&reportmode=full&reportpath=<workbookpath>
• For each parameter you want to pass a value for, you need to provide two URL parameters:
• p1n: The name of the parameter you want to send a value for
• p1v: The value you want to give to that parameter.
• Increment the number in the URL parameter names for each subsequent parameter you want to pass.
• The API works with GET and POST but due to URL length limits imposed by many browsers, proxies and servers, GET can become unreliable when you have a lot of context to pass. For this reason, we recommend using POST.

For example:

• Workbook: /shared/Users/<username./Test Failure Rate
• Parameters:
• Search: %Filters%
• Max Number of Weeks Shown: 2
• HTTP Method: GET

https://host.com/ui/dv/project.jsp?pageid=visualAnalyzer&reportmode=full&reportpath=%2F%40Catalog%2Fshared%2FUsers%2FSteve%20Corbett%2FTest%20Failure%20Rate&p1n=Search&p1v=%25Filter%25&p2n=Max%20Number%20of%20Weeks%20Shown&p2v=2

Other comments, welcomed.

Mallikarjuna Kuppauru-Oracle

Hi @Steven Woods

Fusion Application Deep Links - 

In order to see a complete list of the available Deep Links, use the Deep Links work area (Navigator > Tools > Deeps Links).

Refer below MOS doc -

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

Regards,

Arjun

Chere-Oracle

Here is one method of providing a column, in analysis results, that provides a link with column value embedded in the link. I like this method because the downloaded analysis will not give the URL as the column value, but will only give the intended column value. NOTE: This method may not be possible if html option is turned off in system settings.

On Criteria tab (while editing the analysis) . . .

1. Ensure that the column formula returns a character string. If necessary, use the CAST() function to convert the formula into CHAR or VARCHAR data type.
2. Open the column's Column Properties dialog.
3. Go to the Data Format tab.
4. Select the "Override Default Data Format" checkbox.
5. Change "Treat Text As" to "Custom Text Format."
6. Change "Custom Text Format" text area to: @[html]<a href=yourURL target="_blank" >@H</a>
7. Replace "yourURL" with your own URL, but use the variable name, @H, instead of a specific invoice identifier (e.g., @[html]<a href=https:\\www.myInvoiceERP.com\app?invoice:@H) target="_blank">@H</a> ).