Forms Personalization: How To Pass Function Parameters

To continue with my last post on adding a new icon to the menu bar, the ultimate goal of my personalization was to launch a form with dynamic parameters that are named. Launching a form is no problem with Forms Personalization, you simply have a ‘Built-In’ action with the type ‘Launch a Function’.

Knowing what to put in the parameter field is where I got a little lost. I needed to pass through multiple NAMED parameters consisting of information from the form itself (block.item) and SQL Statements. For example:

PARAM1=<value1> PARAM2=<value2>
Where:
value1 is a field on the current form I was personalizing
value2 is the result of a SQL statement

The documentation for Forms Personalization did not really have too much meat as to how to do this, so through some trial and error, the documentation, some forum postings and a My Oracle Support note (429604.1)… I found the following to be true.

1. You can pass form field values as named parameters using the following syntax:
‘PARAM1=’ || ${item.<block>.<item>.value} || ‘ PARAM2=’ || ${item.<block>.<item>.value}

2. Additionally, you can pass form field values as named parameters using the following syntax:
=’PARAM1=’ || :block.item || ‘ PARAM2=’ || :block.item

3. You can pass the value returned from a select statement as a named parameter using the following syntax:
=select ‘PARAM1=’ || <column> A from <table> where <x> = <:block.item>

4. And finally you can combine 2 & 3 above to pass both form field values and the result of a SQL statement at the same time using the following syntax:
==select ‘PARAM1=’ || <:block.item> || ‘ PARAM2=’ || <column> A from <table> where x = &lt:block.item>

Hope this helps!

Other content you may find interesting:

• How to Send Sales Order Acknowledgements Faster from Oracle EBS
• Email, Fax and Print Reports from Any EBS Form – Extending Native BIP Functionality
• 12 Questions to Ask When Building a Fax and Email Delivery Solution for Oracle EBS