How to Use Parameters in Forms Personalizations?

(Doc ID 429604.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 03-Oct-2016***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms