Script to find Form Personlizations

SELECT FORM_NAME,
  FUNCTION_NAME,
  Description,
  SEQUENCE,
  CONDITION
FROM FND_FORM_CUSTOM_RULES
WHERE ENABLED = 'Y';

Submit concurrent Program from standard Oracle Form using Form personalization

To launch a concurrent program directly from core forms ( without going to SRS window), we can use oracle form –

 

>Create a custom PL/SQL package.

>>Call the concurrent program

>>>Add accustom menu using form personalization – Click here

>>>>Create a new form personalization

Event – SPECIAL[n]

Action –Built In 

                Execute a procedure

                                                     

 

>>>>>How to execute procedure using form personalization – Click here

 

 
 

How to show message dynamically in Oracle Forms

Using form personalization we can show custom message on defined actions.

To show the different message content based on the form data, we can use form personalization.

Create a PL/SQL function

>> Return different message based on predefined rules (conditions)

Function –

xxx_pkg.getmessage(param1 VARCHAR2) return VARCHAR2

IS

BEGIN

If param1 = 1 THEN return ‘Sandeep’ end if;

If param1 =2 THEN return ‘OAL’ END IF;

EXCEPTION

Return ‘Exception in custom program’

END ;

>>> Create a form personalization to display message

= select xxx_pkg.getmessage(Paramaer) from dual

 
 

 

Inventory organization Check using Form Personalization

This is for Inventory related core forms. Oracle inventory pops us change organization form to pick an organization before launching any form.

Based on the selection only forms are appearing and are applicable only for selected organization.

 

Change organization set the organization value in

Block – PARAMETER

Field – ORG_CODE

 

Using form personalization, we can check if we are in expected organization or not.

 

While opening the form below message will pop up -

 

Org check condition will not work for WHEN-NEW-FORM-INSTANCE trigger.

We should use this at WHEN-NEW-BLOCK-INSTANCE.

 
 

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.