Oracle Forms Personalization FAQ

How to implement different logic in oracle forms through forms personalization?

Useful docs:

Note: 279034.1 - Information About the Oracle Applications Form Personalization Feature in 11i

Note: 468657.1 - How To Do Forms Personalization

Note: 395117.1 - Form Personalization in Oracle E-Business Suite (Release 12)

Note: 420518.1 - Limitations of Forms Personalization
 

What is Forms Personalization? Where it is used? What For?

Forms Personalization is a standard feature provided by oracle and supported by oracle to customize the forms. With Forms personalization you can hide fields, make fields mandatory, create zoom functionality, change lov dynamically etc.
 

What are different triggers that can be used in personalization?

WHEN-NEW-FORM-INSTANCE WHEN-NEW-BLOCK-INSTANCE WHEN-NEW-RECORD-INSTANCE WHEN-NEW-ITEM-INSTANCE WHEN-VALIDATE-RECORD MENUS SPECIAL EVENTS
 

What is the difference between having personalization at function level rather than form level?

A Form can have multiple functions. Having the personalization at function level limits the scope of the personalization. For example in Inventory for both “Master Item form” and “Organization Item form” uses same form named INVIDITM where as both have different functions linked to them.
 

Can you use global variables in forms personalization? If so How?

Yes.
 

Can you hide a text field using personalization? How?

Yes. In the actions set DISPLAYED property to false.
 

Can you transfer the data from one form to another form using personalization?

Yes. Using global Variables.
 

How do you move personalization from one instance/database to other?

Form Personalization can be moved easily through FNDLOAD from one instance to other. 
 

What is personalization and what features can be achieved through personalization?

Personalization gives us the ability to customize Forms in a very easy manner. The below customizations are possible through Personalization: Zoom from one form to another Pass data from one form to another through global variables Change LOV values dynamically Enable/Disable/Hide fields dynamically Display user friendly messages when required Launch URL directly from oracle form Execute PL/SQL programs through FORM_DDL package Call custom libraries dynamically
 

At what level you can restrict personalization code?

FORM level and FUNCTION level
 

What can be implemented through Forms Personalization?

The below can be done using Personalization: Zoom from one form to another Pass data from one form to another through global variables Change LOV values dynamically Enable/Disable/Hide fields dynamically Display user friendly messages when required Launch URL directly from oracle form Execute PL/SQL programs through FORM_DDL package Call custom libraries dynamically
 

What are the advantages/disadvantages of Forms Personalization when compared to CUSTOM.pll?

Advantages: Personalization are stored in tables rather than files Will not have a bigger impact when you upgrade or apply patches to the environment Can be moved easily through FNDLOAD from one instance to other Can be restricted at site/responsibility/user level Easy to disable/enable with click of a button. Personalization will store who columns with which we have the ability to track who created/modified it where as in CUSTOM.PLL we don’t have that ability. Disadvantages: Not all can be customized using Personalization.
 

When you display a error message at WHEN-VALIDATE Trigger will the data will be saved into database?

No. If it is normal message or warning data will be saved but not for error message.

Oracle Application

See Also
Default Value In Text Filed Through Personalization

Have a Oracle Question
Do you have an Oracle Question?

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.