How to Use Parameters in Forms Personalizations? (Doc ID 429604.1)

Goal

How to Use Parameters in Forms Personalization?
- You want to generate menu entries dynamically, depending on the content of the form.
- This does not work as only static information are selectable.
- Forms content specific values (parameters) cannot be selected.

This should be possible as follows:

"Parameters: You can manually enter parameters or use the ‘Add Parameter…’ button.
The ‘Add Parameter…’ button displays an LOV listing currently defined parameters for the Function Name, by querying other functions for that same form. It is possible that other parameters exist that will not be displayed in the LOV. The only way to see all parameters that a function has is to open the form in the Oracle Forms Builder. Oracle makes no warranties that any function provides the specific input parameters that you may desire, nor that any existing parameter and its behavior will remain unchanged after a patch."

Do not use:

PARTY_ID=<:CUSTOMER_HEADER_BLK.CUST_PARTY_ID>

This is syntactically wrong. It fails as it doesn't replace the:

CUSTOMER_HEADER_BLK.CUST_PARTY_ID with the correct value at runtime.

Please use:

='PARTY_ID=' || :CUSTOMER_HEADER_BLK.CUST_PARTY_ID

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.