URL to Open Invoice in Oracle Core Applciations

Requirement: Provide a URL from an Invoice Report that will open the invoice in Oracle Core Applications

Pre-Requisites: Using a view based reporting solution, the idea is that when an Accounts Payables runs a report, is able to launch a link that opens the invoice in the Core Application.

Oracle APIs Used:

1. FND_RUN_FUNCTION.GET_RUN_FUNCTION_URL – This allows the generation of the URL based on a FUNCTION_ID, APPLICATION_ID, RESPONSIBILITY_ID, SECURITY_GROUP_ID. This function has other parameters that can be used as required.
2. To gather the required parameters:
   1. FUNCTION_ID; the FND_FUNCTION.GET_FUNCTION_ID – This API gets the function_id for ‘AP_APXINWKB_SUMMARY_VIEW’ function.
   2. APPLICATION_ID, RESPONSIBILITY_ID, SECURITY_GROUP_ID – Please refer to the security initialization blog post to see how to gather these details.
3. To view a list of all the available functions:

1 2 3 4 5

SELECT function_id, function_name, application_id, parameters from fnd_form_functions;

Final Solution – created a basic invoices query:

1	SELECT invoice_num from ap_invoices_all

Now adding the API to generate the URL:

1 2 3 4 5 6 7 8 9 10 11 12

SELECT invoice_num, '<a href="' || apps.FND_RUN_FUNCTION. get_run_function_url ( apps.fnd_function. get_function_id ('AP_APXINWKB_SUMMARY_VIEW'), 200, 50554, 0, 'INVOICE_ID=' || api.invoice_id) || '"> view_inv</a>' view_inv FROM ap_invoices_All aia;

Make sure you pass the correct parameters into each API to view the result. Click on the URL and it will launch the respective invoice in Oracle Core Applications. You can now reference this API call in any query that has invoice_id available to be passed.