Create custom Menu in forms

As OAF provides adding new items and flexibility to change the code on any button press, Oracle form is not flexible enough to accommodate such requirement.

But instead of extending the action logic of existing forms, oracle form offers to disable the existing button (removed option to perform standard action) and execute custom logic from menu.

 

For any to- do action from core forms, using form personalization we can add custom menus (Menu >> Tools>>) and instruct any action as per requirement.

 

Steps to add new menu –

Form >> Menu >> Help >> Diagnostics >>Custom Code >> Personalize>> Create a new personalization at form/function level

 

Event – WHEN NEW FORM INSTANCE

Action – Menu >> Select Special options from LOV (SPECIAL1) >> Give user defined name >> Save and Exit

 

 

Go To form >> Menu >> Tools >> This will show you new menu

 

We can add any action for custom menu –

Create a new personalization

 

Event – SPECIAL1

Action – Message

                 “This is custom menu helpful to execute custom actions”           

 

 

 

 

  

 
 

Procedure Call using Form Personalization

How to Launch a procedure using form personalization ?

 

Form >> Menu >> Help >> Diagnostics >>Custom Code >> Personalize

 

Create a personalization

Event–        Any trigger

Action –               Built in >> Execute procedure >>

 

 

Syntex –

 

='begin

xxxxx_pkg.call_program('''||${item.<BLOCK_NAME>.<FILED_NAME>.value}||''', '''||${item.<BLOCK_NAME>.<FILED_NAME>.value}||''',1,’Test’);

end'

 

 

Description –

Procedure declaration

XXXX_PKG.call_program(pramaetr1 VARCHAR2,

   parameter2 VARCHAR2,

  parameter3 NUMBER,

  parameter4 VARCHAR2);

 

Parameter1 & 2 , value will be passed form form field.

Parameter3, constant value 1 is being passed.

Parameter4, constant value ‘Test’ is being passed.

                                 

 

LOV in WebADI - Component

Interface property can be used to set the value set. This will provide list option in excel sheet and will have limitation on values.

Usages of component will provide standard EBS LOV option. Steps are as below -

 

 

1)      Desktop Integration Manager (R) >> Manage Component >> Create Component

Provide display name, internal name and application.

Component Type:

LOV-Table -  

Ø  SQL details will be provided into interface column properties

Ø  Component name should be provided in interface column properties

 

LOV-JAVA (Please click here)

Complete component details and apply.

Table_column-alias – Interface column name

Table_column – Value set column name (Meaning)

Table-select-column - Interface column name

 

 

Go to interface >> properties window and provide the component created.