Oracle Forms Personalization Interview Questions

--> 1) 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 fiedls, make fields mandatory, create zoom functionality, change lov dynamically e.t.c

--> 2) 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

--> 3) 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 fucntions linked to them.

--> 4) Can you use global variables in forms personalization? If so How?

Yes.

--> 5) Can you hide a text field using personalization? How?

Yes. In the actions set DISPLAYED property to false.

--> 7) Can you transfer the data from one form to another form using personalization?

Yes. Using global Variables.

--> 8) How do you move personalization from one instance/database to other?

Form Personalizations can be moved easily through FNDLOAD from one instance to other. Refer to the Article FNDLOAD for more details: http://www.erpschools.com/Apps/oracle-applications/articles/General/FNDLOAD-to-transfer-the-menus-concurrent-programs-personalization-from-one-instance-to-other/index.aspx

--> 9) 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

--> 12) At what level you can restrict personalization code?

FORM level and FUNCTION level

--> 13) 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

--> 14) How to do implement ZOOM Functionality using personalization?

Refer to the Forms Personalization Tutorial article: http://erpschools.com/articles/forms-personalization-tutorial

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

Advantages: Personalizations 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.

--> 16) 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.