Oracle Form Personalization - Launch a Function Parameters

Calling one form to another form using form personalization needs parameters to be passed.

Skip below steps if you have already created Menu and directly go for parameters.

Create new form personalization with Menu Type

Create another row to and use  Special4 menu for action to be performed


Launch a function with parameters
 


Parameters value should be defined as below. Make sure they are case sensitive and in single line.
Replace the parameters with the form parameters you are calling to.

'P_ORGANIZATION_ID='||${item.line.org_id.value}||' P_INVENTORY_ITEM_ID='||${item.line.inventory_item_id.value}||' P_SUBINV_CODE='||NVL(${item.line.subinv.value},'ABC')

DEFAULT WHERE Forms Personalization

At times custom query has to be executed at run time to limit the data visible to users. It can be achieved  by forms personalization.

In forms personalization

Under the condition tab

Trigger-Event : WHEN-NEW-BLOCK-INSTANCE
Trigger-Object: Block name where condition has to be executed.
Processing Mode: Not in Enter-Query Mode

You can limit personalization to site/resp/user.

Under Actions

Type: Propery
Object Type: Block
Target Object: Block you selected for  Trigger-Object
Property Name: DEFAULT_WHERE
Value: Enter your custom query.
Sample Value: customer_trx_id IN  (select customer_trx_id FROM temp_table WHERE customer_trx_id=:GLOBAL.XX_CUST_TRX_ID).

No need for quotes. Probably you might have to enter a value in double quotes if you have a string value to compare like --> valid_flag = ''Y''

Calling Procedure Forms Personalization

Calling procedure in forms personalization can be done using argument in below format.

='declare v_field_value VARCHAR2(500);begin scheme.procedure('''||${item.tolines_blk.header_id.value}||''',
'''||${item.tolines_blk.line_id.value}||''','''||fnd_global.user_id||''','''||fnd_global.org_id||''');
end'