Oracle EBS and APEX

Oracle E Business Suite

Beezapps #orclapex have recently been working with a client to generate dashboards on Oracle E-Business suite data using Oracle APEX to display the data. Linking the underlying data and single sign on is easy and well documented (Oracle EBS Extensions) , the client was looking for a way to link the reports in APEX back to the data in Oracle E-Business Suite.

In our case we wanted to launch the invoice workbench page from the report so we used a combination of these handy functions to generate the URL

This function returns the id of the function form in EBS

fnd_function.get_function_id('AP_APXINWKB')

Then using this function which returns the link to the EBS form.

function get_run_function_url ( p_function_id in number,
p_resp_appl_id in number,
p_resp_id in number,
p_security_group_id in number,
p_parameters in varchar2 default null,
p_override_agent in varchar2 default null,
p_org_id in number default null,
p_lang_code in varchar2 default null,
p_encryptParameters in boolean default true )

Put this all together with the parameters needed and you will have a call like this.

FND_RUN_FUNCTION.get_run_function_url(fnd_function.get_function_id('AP_APXINWKB'), 200, 20639, 0,'INVOICE_ID='||p_invoice_id)

 

References :

http://piotrbelter.blogspot.co.uk/2015/07/calling-oracle-forms-documents-form-non.html

 

No Comments Yet.

Leave a comment